Spatial Data Fields
Spatial Data points can be used to represent additional information in your network, such as Burst reports. These points can then be automatically allocated to appropriate pipes in the network using a set of rules. See Processing Spatial Data for more details on importing and allocating spatial data points.
Information relating to spatial data points can be viewed and edited on the Spatial Data Grid or on the Spatial Data Property Sheet.
Most data can be edited on the grid, but some fields cannot be displayed in the grid format. To view and edit all spatial data point data, use the property sheet.
The following table describes all the data required to define a spatial data point.
Further information, including units details, about all the Network Object fields stored in the Master Database can be found in the data fields topics listed in the Network Data Fields topic.
Fields that are common to the majority of objects can be found in the Common Data Fields topic.
The Property Page column shows which page of the property sheet displays the data. The pages are:
-
Definition Page
-
Parameters Page
-
User Page - see Common Data Fields topic for details of user fields
-
Notes Page - see Common Data Fields topic for details of notes fields
The Grid column tells you if the data item is available for editing in the grid view.
Spatial Data
Database Table Name: wn_incident_report
|
Field Name |
Help Text |
Flag |
Grid |
Property Page |
Size |
Precision |
Database Field |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
|||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Key |
If you leave this field blank, InfoWorks will generate a field name using the values in the X and Y fields. In order to ensure that points with generated keys do not overwrite existing points with the same key, use the Make Generated Keys Unique option |
YES |
YES |
1 |
30 |
0 |
|
identifier |
Text |
|
|
|
|
|
|||||||||||||||||||||
|
Reference |
Any reference value you may have for the spatial data item |
YES |
YES |
1 |
25 |
0 |
|
reference |
Text |
|
|
|
|
|
|||||||||||||||||||||
|
X |
The X coordinate of the point |
YES |
YES |
1 |
|
2 |
XY |
x |
Double |
|
|
|
|
|
|||||||||||||||||||||
|
Y |
The Y coordinate of the point |
YES |
YES |
1 |
|
2 |
XY |
y |
Double |
|
|
|
|
|
|||||||||||||||||||||
|
Date & Time |
The time of the occurrence or information represented by the spatial data point |
YES |
YES |
2 |
|
0 |
|
date_time |
|
|
|
|
|
|
|||||||||||||||||||||
|
Type |
The type of occurrence or information represented by the spatial data point. Built in types are:
|
YES |
YES |
2 |
30 |
0 |
|
type |
Text |
|
|
|
|
|
|||||||||||||||||||||
|
Details |
A fuller description of the occurrence |
YES |
YES |
2 |
32 |
0 |
|
details |
Text |
|
|
|
|
|
|||||||||||||||||||||
|
Allocation Run |
The allocation run (using the Spatial Data Analysis Wizard) that resulted in the current setting of the Allocated Pipe ID field |
YES |
YES |
2 |
|
0 |
|
allocation_run |
|
|
|
|
|
|
|||||||||||||||||||||
|
Allocated Pipe Id |
The pipe to which this point has been allocated when you ran the Spatial Data Analysis Wizard |
YES |
YES |
2 |
63 |
0 |
|
allocated_pipe_id |
Text |
|
|
|
|
|
|||||||||||||||||||||
|
Status |
The current status of the spatial data point with regard to allocation. The status field will be blank if the spatial data point has not yet been through the allocation process.
|
YES |
YES |
2 |
|
0 |
|
status |
Integer |
|
|
|
|
|
|||||||||||||||||||||
|
Saved |
This field indicates whether a spatial data point has been allocated manually or by use of the Spatial Data Analysis Wizard.
|
NO |
YES |
NO |
|
0 |
|
saved |
Boolean |
|
|
|
|
|
