9.7.3 Parameters of Address Directory - LUPMISManual

Go to content

Main menu:

9. Databases > 9.7 Address Database
9.7.3 Parameters of Address Directory

Currently, there is only 1 table: 'address1'.
The current status of the Address Database can be seen in LUPMIS on Settings > Database statistics



Table structure of 'address1' of the Address Database:
FieldTypeRemarks
idinteger
upncharacter (13)
subupncharacter (20)
streetnamecharacter (50)
streetname_prv
character (50)
housenumbercharacter (30)
towncharacter (30)
locplcharacter (30)
Local Plan, sector layout (GIS dra file)
utm_xinteger
x in UTM 30 (m) of any point in the parcel (from GIS)
utm_yinteger
y in UTM 30 (m) of any point in the parcel (from GIS)
utm_x_bldginteger
x in UTM 30 (m) of a building / property (if SubUPN)
utm_y_bldginteger
y in UTM 30 (m) of a building / property (if SubUPN)
flooorinteger
Observe the 3 o (to avoid conflict with the computer command 'floor')
area_m2integer
 (from GIS)
remarkscharacter (100)
lastenry_personcharacter (10)
lastentry_datedate


Technical note: It is envisaged, that a table 'history' with logs of all parcels/properties/businesses will be installed in future.


  



 
Back to content | Back to main menu