Cadastral fabrics in a geodatabase in PostgreSQL
Cadastral fabrics in a geodatabase in PostgreSQL
|
| Release 9.3 |
   |
NOTE: Requires ArcGIS Survey Analyst extension
Cadastral fabrics are parcel datasets that are created and maintained using data from survey plans. Fabric editing tools in Survey Analyst facilitate the creation of parcels from recorded boundary line measurements from plans or plats.
A cadastral fabric is a continuous, integrated surface of connected parcels, representing the complete survey record for an area of land.
Dimensions in the cadastral fabric are edited in response to a change in the survey record; for example, a parcel split or resurvey. Parcel boundary line dimensions in the cadastral fabric match the dimensions on the survey record. Parcels that are edited or replaced by new survey records are retained as historic, thus always preserving the original survey record. Parcel polygons are also linked to each other by connection lines. Because every parcel is either linked or connected, a seamless network of connected parcel boundaries, or cadastral fabric, is formed. Parcel lines have endpoints, which are the parcel corners. Parcel corner points are common between adjacent parcel boundaries, establishing connectivity and maintaining topological integrity in the network.
For more information on cadastral fabrics and the cadastral editor, start with the topic An overview of Survey Analyst - Cadastral Editor.
Cadastral fabrics in ArcCatalog
In the Catalog tree, feature datasets containing cadastral fabrics in a PostgreSQL database management system (DBMS) look like any other feature dataset. The difference is the feature datasets contain a cadastral fabric element.
The following is an example of a cadastral fabric in a feature dataset.
Top of page
Cadastral fabrics in a PostgreSQL DBMS
Several tables are created in the database to track information about cadastral fabrics. Tables are created in the schema of the user who creates a cadastral fabric. The tables are as follows:
cadastralfabric_accuracyThe cadastralfabric_accuracy table stores the accuracy categories and statistics, which are used in least-squares adjustments. This table is not versioned when the cadastral fabric is registered as versioned.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
The unique identifier of the record
NOT NULL |
| brgsd |
numeric |
The standard deviation of bearings |
| distsd |
numeric |
The standard deviation of distances |
| ppm |
numeric |
Parts per million value |
| category |
integer |
Indicates the accuracy level |
| description |
varchar(256) |
A description of the category |
cadastralfabrics_adjustmentsThe cadastralfabrics_adjustments table stores adjustment levels (sequence IDs) and their corresponding adjustment dates.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the feature
NOT NULL |
| adjustmentdate |
timestamp |
Date the adjustment was inserted |
| vectorcount |
integer |
Number of vectors produced by the adjustment |
| adjlevel |
integer |
Sequential number (ordering) of adjustment relative to other adjustments |
| jobid |
integer |
ID of the job that contained the adjustment |
| shape |
integer |
|
cadastralfabric_controlThe cadastralfabric_control table stores information about control points on the cadastral fabric.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the control point
NOT NULL |
| x |
numeric |
The x-coordinate of the control point; fixed
NOT NULL |
| y |
numeric |
The y-coordinate of the control point; fixed
NOT NULL |
| z |
numeric |
The z-coordinate of the control point; fixed |
| name |
varchar(50) |
The name of the control point |
| pointid |
integer |
The ID of the corresponding fabric point |
| accuracyxy |
numeric |
The horizontal positional accuracy of the control point; for reference only |
| accuracyz |
numeric |
The vertical accuracy of the control point; for reference only |
| surveydate |
timestamp |
The date the control point was established |
| active |
integer |
Indicates whether or not a control point is active in an adjustment |
| type |
integer |
Used for custom subtyping |
| shape |
st_point |
The geometry of the control point |
cadastralfabric_historyThe cadastralfabric_history table stores nonspatial parcel lineage information. This table supports textual lineage tracking through the legal and system dates.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the record
NOT NULL |
| childparcelid |
integer |
The child parcel ID or the ID of the child of this parent |
| parentparcelid |
integer |
Parcel ID of the parent parcel (or parcels) of this child |
| systemstartdate |
timestamp |
The date of the system transaction that created the child |
| legalstartdate |
timestamp |
The date of the legal transaction that created the child |
cadastralfabric_idsequencerThe cadastralfabric_idsequencer table is used internally to ensure unique IDs are used across all tables in the cadastral fabric.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the record |
cadastralfabric_jobobjects The cadastralfabric_jobobjects table contains information needed to manage database locks held on objects by jobs. This table is not versioned when the cadastral fabric is registered as versioned.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the feature
NOT NULL |
| jobid |
integer |
ID of the job holding the lock |
| objecttype |
integer |
Type of object that is locked |
| jobfeatureid |
integer |
The object ID of the feature that is locked |
| role |
integer |
Type of lock held—optimistic or pessimistic; edit parcels use pessimistic locks |
| Edit |
integer |
|
cadastralfabric_jobsThe cadastralfabric_jobs table stores information about the cadastral jobs operating on the cadastral fabric. This table is not versioned when the cadastral fabric is registered as versioned.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the feature
NOT NULL |
| name |
varchar(64) |
The cadastral job identifier or name |
| description |
varchar(64) |
User-defined description of the cadastral job |
| locked |
integer |
Indicates the presense of locked parcels in the job parcels list |
| createdate |
timestamp |
The date the job was created |
| modifieddate |
timestamp |
The date the job was last modified |
| commitdate |
timestamp |
The date the job was committed to the database |
| owner |
varchar(64) |
The owner of the job |
| status |
integer |
The status of the job |
| systemstate |
integer |
The system-maintained status of a job |
| version |
varchar(64) |
The geodatabase version holding the job |
| lockmachine |
varchar(128) |
Name of the machine currently editing the job |
| lockpid |
integer |
System field containing the lock process ID; maintains single-use editing on the job |
cadastralfabric_levelsThe cadastralfabric_levels table stores information about associations between cadastral fabrics and their associated feature classes.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the record |
| featureclassid |
integer |
The ID of the associated feature class |
| adjlevel |
integer |
The adjustment level last applied to the feature class |
| cfid |
integer |
The source cadastral fabric ID |
cadastralfabric_linepointsThe cadastralfabric_linepoints table stores information on points in one parcel that are constrained to lie on the boundary of another parcel without a shared point on that boundary.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the point
NOT NULL |
| parcelid |
integer |
The ID of the parcel that has the boundary line |
| frompointid |
integer |
The ID of the FromPoint of the boundary line |
| topointid |
integer |
The ID of the ToPoint of the boundary line |
| linepointid |
integer |
ID of the point that must lie on the boundary |
| shape |
st_point |
Duplicate of the point to improve drawing performance |
cadastralfabric_linesThe cadastralfabric_lines table stores information on all lines of a cadastral fabric, such as boundary, easements, and connections.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the line
NOT NULL |
| calculated |
integer |
Indicates whether dimensions inversed from shape geometry (true/1) or not (false/0) |
| parcelid |
integer |
The ID of the parcel that contains the line
NOT NULL |
| sequence |
integer |
A number indicating the order in which the line was entered in the parcel traverse
NOT NULL |
| frompointid |
integer |
The ID of the fabric point where the line begins
NOT NULL |
| topointid |
integer |
The ID of the fabric point where the line ends
NOT NULL |
| bearing |
numeric |
The bearing of the line from record or compilation
NOT NULL |
| distance |
numeric |
The length of the line from record or compilation
NOT NULL |
| type |
integer |
Used for custom subtyping |
| category |
integer |
High-level system category for line
NOT NULL |
| radius |
numeric |
The distance from the center point to the arc of the circular curve |
| arclength |
numeric |
The length of the arc of a circular curve |
| delta |
numeric |
The angle between the tangents or the angle at the center of a curve |
| centerpointid |
integer |
The ID of the center point of a circular arc |
| historical |
integer |
True (1) if the line's associated parcel is historic; otherwise, false (0) |
| radialbearing |
numeric |
The bearing of the radius of the circular curve |
| tangentbearing |
numeric |
The bearing of the tangent starting at the from point |
| lineparameters |
integer |
The curve parameters |
| accuracy |
integer |
The accuracy category of the line; can be inherited from the plan or overridden |
| computedminusobserved |
numeric |
The computed measurements (such as bearing and distance) compared with the field observation |
| internalangle |
numeric |
Based on a backsight bearing or basis of bearing |
| referenceobject |
integer |
The reference object for a particular point |
| shape |
st_geometry |
Line geometry |
cadastralfabric_parcels The cadastralfabric_parcels table stores information about the cadastral fabric land units, which are referred to as parcels. These may be subtyped for modeling heirarchical land categories.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the feature
NOT NULL |
| joined |
integer |
Join status; if not joined, not part of the fabric
1 = joined
NOT NULL |
| planid |
integer |
Identifier of the plan containing the parcel record
NOT NULL |
| name |
varchar(50) |
User-assigned name of the parcel |
| type |
integer |
Used for custom subtypes to support categories of land units |
| statedarea |
varchar(50) |
The area of the parcel stated on the plan or legal record |
| compiled |
integer |
Indicates if a parcel is compiled (true/1) or not (false/0) |
| historical |
integer |
Indicates whether a parcel has been retired (true/1) or not (false/2) |
| systemstartdate |
timestamp |
The date of the system transaction that created the parcel
NOT NULL |
| systemenddate |
timestamp |
The date of the system transaction that retired the parcel |
| legalstartdate |
timestamp |
The date of the legal transaction that created the parcel |
| legalenddate |
timestamp |
The date of the legal transaction that retired the parcel |
| groupid |
integer |
This number set if part of an unjoined group |
| accuracy |
integer |
The accuracy category of measurements, usually taken from the plan |
| rotation |
numeric |
Rotation from join process |
| scale |
numeric |
Scale from join process |
| unclosed |
integer |
Indicates whether a parcel is a closed traverse (true/1) or not (false/0)
NOT NULL |
| miscloseratio |
numeric |
Ration of misclose distance to parcel perimeter |
| misclosedistance |
numeric |
Distance necessary to close the parcel |
| misclosebearing |
numeric |
Bearing necessary to close the parcel |
| construction |
integer |
Indicates whether the parcel is a construction (true/1) or not (false/0) |
| shapestderrore |
numeric |
Overall parcel distortion (easting) |
| shapestderrorn |
numeric |
Overall parcel distortion (northing) |
| backsightbearing |
numeric |
Direction of line to backsight point |
| shape |
st_geometry |
Parcel geometry |
cadastralfabric_plansThe cadastralfabric_plans table stores the information from the document of record submitted in evidence of land transactions.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the record
NOT NULL |
| name |
varchar(128) |
The name of the plan or legal document |
| description |
varchar(1024) |
A description of the document |
| surveyor |
varchar(50) |
Name of the surveyor of record |
| company |
varchar(50) |
The survey company or organization of record |
| surveydate |
timestamp |
Date of survey |
| legaldate |
timestamp |
Date survey or document was recorded |
| angleunits |
integer |
Bearing units of record |
| areaunits |
integer |
Area units of record |
| distanceunits |
integer |
Distance units of record |
| directionformat |
integer |
Direction format of record |
| lineparameters |
integer |
Line definition parameters from record |
| distanceatground |
integer |
Indicates if record distances are ground (true/1) or grid (false/0) |
| combinedgridfactor |
numeric |
Scale factor of grid |
| truemidbrg |
integer |
Indicates if astronomic azimuths are used (true/1) or not (false/0) |
| accuracy |
integer |
Spatial accuracy of plan, set to an accuracy category |
| internalangles |
integer |
Indicates whether or not internal angles are used
1 = true
2 = false |
cadastral_fabric_pointsThe cadastral_fabric_points table stores information about the set of points that exists for each fabric and the center points of curves.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the point
NOT NULL |
| x |
numeric |
X-coordinate from join and least-squares adjustment
NOT NULL |
| y |
numeric |
Y-coordinate from join and least-squares adjustment
NOT NULL |
| z |
numeric |
Z-coordinate from join and least-squares adjustment |
| type |
integer |
Used for custom subtyping |
| category |
integer |
Enumeration of the system categories |
| name |
varchar(32) |
Point name |
| historical |
integer |
Indicates whether the parcel lines are historic (true/1) or not (false/0) |
| systemstartdate |
timestamp |
Date of the system transaction that created the point
NOT NULL |
| systemenddate |
timestamp |
Date of the system transaction that retired the point |
| legalstartdate |
timestamp |
Date of the legal transaction that created the point; usually from legal record |
| legalenddate |
timestamp |
Date of legal transaction that retired the point |
| centerpoint |
integer |
Set to true (1) if the point is a center point |
| maxdn |
numeric |
Maximum northing shift |
| maxde |
numeric |
Maximum easting shift |
| shape |
st_point |
Point geometry |
cadastralfabric_vectorsThe cadastralfabric_vectors table stores displacement vectors between the old and new coordinates of an adjusted point. Vectors are grouped logically by an adjustment level that corresponds to an adjustment date.
| Field name |
Field type |
Description |
|---|
| objectid |
integer |
Unique identifier of the feature
NOT NULL |
| fromx |
numeric |
The x-coordinate of the point before adjusting |
| fromy |
numeric |
The y-coordinate of the point before adjusting |
| tox |
numeric |
The x-coordinate of the point after adjusting |
| toy |
numeric |
The y-coordinate of the point after adjusting |
| pointid |
integer |
Unique identifier of the point adjusted |
| adjlevel |
integer |
Adjustment level that contains the vector |
Top of page
Cadastral fabrics in an XML workspace document
Within an XML workspace document, cadastral fabrics are denoted with a data element tag indicating the object is a cadastral fabric, as in the following example:
<DataElement xsi:type="esri:DECadastralFabric">
<DSID>-1</DSID>
<Versioned>false</Versioned>
<CanVersion>false</CanVersion>
<Extent xsi:type="esri:EnvelopeN">
<XMin>6183000.00012755</XMin>
<YMin>2278000.00003956</YMin>
<XMax>6188999.99993855</XMax>
<YMax>2281999.99991356</YMax>
<SpatialReference xsi:type="esri:ProjectedCoordinateSystem">
<WKT>PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192]]</WKT>
<XOrigin>-118608811.296</XOrigin>
<YOrigin>-91259488.671</YOrigin>
<XYScale>3048.00609601219</XYScale>
<ZOrigin>-100000</ZOrigin>
<ZScale>10000</ZScale>
<MOrigin>-100000</MOrigin>
<MScale>10000</MScale>
<XYTolerance>3.28083333333333E-03</XYTolerance>
<ZTolerance>0.001</ZTolerance>
<MTolerance>0.001</MTolerance>
<HighPrecision>true</HighPrecision>
</SpatialReference>
</Extent>
<SpatialReference xsi:type="esri:ProjectedCoordinateSystem">
<WKT>PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192]]</WKT>
<XOrigin>-118608811.296</XOrigin>
<YOrigin>-91259488.671</YOrigin>
<XYScale>3048.00609601219</XYScale>
<ZOrigin>-100000</ZOrigin>
<ZScale>10000</ZScale>
<MOrigin>-100000</MOrigin>
<MScale>10000</MScale>
<XYTolerance>3.28083333333333E-03</XYTolerance>
<ZTolerance>0.001</ZTolerance>
<MTolerance>0.001</MTolerance>
<HighPrecision>true</HighPrecision>
</SpatialReference>
<ConfigurationKeyword>DEFAULTS</ConfigurationKeyword>
<DefaultAccuracy>4</DefaultAccuracy>
<CadastralFieldEditsCollection xsi:type="esri:ArrayOfCadastralFieldEdits" />
</DataElement>
Top of page
