Cadastral fabrics in a geodatabase in SQL Server
Cadastral fabrics in a geodatabase in SQL Server
|
| 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 that contain cadastral fabrics in a SQL Server database management system (DBMS) look like any other feature dataset. The difference is they 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 SQL Server 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 tablesare 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 |
int |
The unique identifier of the record |
| BrgSD |
numeric |
The standard deviation of bearings |
| DistSD |
numeric |
The standard deviation of distances |
| PPM |
numeric |
Parts per million value |
| Category |
int |
Indicates the accuracy level |
| Description |
nvarchar(256) |
A description of the category
Nulls allowed |
CADASTRALFABRIC_ADJUSTMENTSThe CADASTRALFABRIC_ADJUSTMENTS table stores adjustment levels (sequence IDs) and their corresponding adjustment dates.
| Field name |
Field type |
Description |
|---|
| OBJECTID |
int |
Unique identifier of the feature |
| AdjustmentDate |
datetime |
Date the adjustment was inserted
Nulls allowed |
| VectorCount |
int |
Number of vectors produced by the adjustment |
| AdjLevel |
int |
Sequential number (ordering) of adjustment relative to other adjustments |
| JobID |
int |
ID of the job that contained the adjustment
Nulls allowed |
| Shape |
int |
Nulls allowed |
CADASTRALFABRIC_CONTROLThe CADASTRALFABRIC_CONTROL table stores information about control points on the cadastral fabric.
| Field name |
Field type |
Description |
|---|
| OBJECTID |
int |
Unique identifier of the control point |
| X |
numeric |
The x-coordinate of the control point; fixed |
| Y |
numeric |
The y-coordinate of the control point; fixed |
| Z |
numeric |
The z-coordinate of the control point; fixed
Nulls allowed |
| Name |
nvarchar(50) |
The name of the control point
Nulls allowed |
| PointID |
int |
The ID of the corresponding fabric point
Nulls allowed |
| AccuracyXY |
numeric |
The horizontal positional accuracy of the control point; for reference only
Nulls allowed |
| AccuracyZ |
numeric |
The vertical accuracy of the control point; for reference only
Nulls allowed |
| SurveyDate |
datetime |
The date the control point was established
Nulls allowed |
| Active |
int |
Indicates whether or not a control point is active in an adjustment
Nulls allowed |
| Type |
int |
Used for custom subtyping
Nulls allowed |
| Shape |
int |
The geometry of the control point
Nulls allowed |
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 |
int |
Unique identifier of the record |
| ChildParcelID |
int |
The child parcel ID or the ID of the child of this parent
Nulls allowed |
| ParentParcelID |
int |
Parcel ID of the parent parcel (or parcels) of this child
Nulls allowed |
| SystemStartDate |
datetime |
The date of the system transaction that created the child |
| LegalStartDate |
datetime |
The date of the legal transaction that created the child
Nulls allowed |
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 |
int |
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 |
int |
Unique identifier of the feature |
| JobID |
int |
ID of the job holding the lock |
| ObjectType |
int |
Type of object that is locked |
| JobFeatureID |
int |
The object ID of the feature that is locked |
| Role |
int |
Type of lock held—optimistic or pessimistic; edit parcels use pessimistic locks |
| Edit |
int |
|
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 |
int |
Unique identifier of the feature |
| Name |
nvarchar(64) |
The cadastral job identifier or name |
| Description |
nvarchar(64) |
User-defined description of the cadastral job
Nulls allowed |
| Locked |
int |
Indicates the presense of locked parcels in the job parcels list |
| CreateDate |
datetime |
The date the job was created
Nulls allowed |
| ModifiedDate |
datetime |
The date the job was last modified
Nulls allowed |
| CommitDate |
datetime |
The date the job was committed to the database
Nulls allowed |
| Owner |
nvarchar(64) |
The owner of the job |
| Status |
int |
The status of the job |
| SystemState |
int |
The system-maintained status of a job |
| Version |
nvarchar(64) |
The geodatabase version holding the job
Nulls allowed |
| LockMachine |
nvarchar(128) |
Name of the machine currently editing the job |
| LockPID |
int |
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 |
int |
Unique identifier of the record |
| FeatureClassID |
int |
The ID of the associated feature class |
| AdjLevel |
int |
The adjustment level last applied to the feature class |
| CFID |
int |
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 |
int |
Unique identifier of the point |
| ParcelID |
int |
The ID of the parcel that has the boundary line |
| FromPointID |
int |
The ID of the FromPoint of the boundary line |
| ToPointID |
int |
The ID of the ToPoint of the boundary line |
| LinePointID |
int |
ID of the point that must lie on the boundary |
| Shape |
int |
Duplicate of the point to improve drawing performance
Nulls allowed |
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 |
int |
Unique identifier of the line |
| Calculated |
int |
Indicates whether dimensions inversed from shape geometry (true/1) or not (false/0)
Nulls allowed |
| ParcelID |
int |
The ID of the parcel that contains the line |
| Sequence |
int |
A number indicating the order in which the line was entered in the parcel traverse |
| FromPointID |
int |
The ID of the fabric point where the line begins |
| ToPointID |
int |
The ID of the fabric point where the line ends |
| Bearing |
numeric |
The bearing of the line from record or compilation |
| Distance |
numeric |
The length of the line from record or compilation |
| Type |
int |
Used for custom subtyping
Nulls allowed |
| Category |
int |
High-level system category for line |
| Radius |
numeric |
The distance from the center point to the arc of the circular curve
Nulls allowed |
| ArcLength |
numeric |
The length of the arc of a circular curve
Nulls allowed |
| Delta |
numeric |
The angle between the tangents or the angle at the center of a curve
Nulls allowed |
| CenterPointID |
int |
The ID of the center point of a circular arc
Nulls allowed |
| Historical |
int |
True (1) if the line's associated parcel is historic; otherwise, false (0)
Nulls allowed |
| RadialBearing |
numeric |
The bearing of the radius of the circular curve
Nulls allowed |
| TangentBearing |
numeric |
The bearing of the tangent starting at the from point
Nulls allowed |
| LineParameters |
int |
The curve parameters
Nulls allowed |
| Accuracy |
int |
The accuracy category of the line; can be inherited from the plan or overridden
Nulls allowed |
| ComputedMinusObserved |
numeric |
The computed measurements (such as bearing and distance) compared with the field observation
Nulls allowed |
| InternalAngle |
numeric |
Based on a backsight bearing or basis of bearing
Nulls allowed |
| ReferenceObject |
int |
The reference object for a particular point
Nulls allowed |
| Shape |
int |
Line geometry
Nulls allowed |
CADASTRALFABRICS_PARCELSThe CADASTRALFABRICS_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 |
int |
Unique identifier of the feature |
| Joined |
int |
Join status; if not joined, not part of the fabric
1 = joined |
| PlanID |
int |
Identifier of the plan containing the parcel record |
| Name |
nvarchar(50) |
User-assigned name of the parcel
Nulls allowed |
| Type |
int |
Used for custom subtypes to support categories of land units
Nulls allowed |
| StatedArea |
nvarchar(50) |
The area of the parcel stated on the plan or legal record
Nulls allowed |
| Compiled |
int |
Indicates if a parcel is compiled (true/1) or not (false/0) |
| Historical |
int |
Indicates whether a parcel has been retired (true/1) or not (false/2)
Nulls allowed |
| SystemStartDate |
datetime |
The date of the system transaction that created the parcel |
| SystemEndDate |
datetime |
The date of the system transaction that retired the parcel
Nulls allowed |
| LegalStartDate |
datetime |
The date of the legal transaction that created the parcel
Nulls allowed |
| LegalEndDate |
datetime |
The date of the legal transaction that retired the parcel
Nulls allowed |
| GroupID |
int |
This number set if part of an unjoined group
Nulls allowed |
| Accuracy |
int |
The accuracy category of measurements, usually taken from the plan
Nulls allowed |
| Rotation |
numeric |
Rotation from join process
Nulls allowed |
| Scale |
numeric |
Scale from join process
Nulls allowed |
| Unclosed |
int |
Indicates whether a parcel is a closed traverse (true/1) or not (false/0) |
| MiscloseRatio |
numeric |
Ration of misclose distance to parcel perimeter
Nulls allowed |
| MiscloseDistance |
numeric |
Distance necessary to close the parcel
Nulls allowed |
| MiscloseBearing |
numeric |
Bearing necessary to close the parcel
Nulls allowed |
| Construction |
int |
Indicates whether the parcel is a construction (true/1) or not (false/0)
Nulls allowed |
| ShapeStdErrorE |
numeric |
Overall parcel distortion (easting)
Nulls allowed |
| ShapeStdErrorN |
numeric |
Overall parcel distortion (northing)
Nulls allowed |
| BacksightBearing |
numeric |
Direction of line to backsight point
Nulls allowed |
| Shape |
int |
Parcel geometry
Nulls allowed |
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 |
int |
Unique identifier of the record |
| Name |
nvarchar(128) |
The name of the plan or legal document |
| Description |
nvarchar(1024) |
A description of the document
Nulls allowed |
| Surveyor |
nvarchar(50) |
Name of the surveyor of record
Nulls allowed |
| Company |
nvarchar(50) |
The survey company or organization of record
Nulls allowed |
| SurveyDate |
datetime |
Date of survey
Nulls allowed |
| LegalDate |
datetime |
Date survey or document was recorded
Nulls allowed |
| AngleUnits |
int |
Bearing units of record
Nulls allowed |
| AreaUnits |
int |
Area units of record
Nulls allowed |
| DistanceUnits |
int |
Distance units of record
Nulls allowed |
| DirectionFormat |
int |
Direction format of record
Nulls allowed |
| LineParameters |
int |
Line definition parameters from record
Nulls allowed |
| DistanceAtGround |
int |
Indicates if record distances are ground (true/1) or grid (false/0)
Nulls allowed |
| CombinedGridFactor |
numeric |
Scale factor of grid
Nulls allowed |
| TrueMidBrg |
int |
Indicates if astronomic azimuths are used (true/1) or not (false/0)
Nulls allowed |
| Accuracy |
int |
Spatial accuracy of plan, set to an accuracy category
Nulls allowed |
| InternalAngles |
int |
Indicates whether or not internal angles are used
1 = true
2 = false |
CADASTRALFABRIC_POINTSThe CADASTRALFABRIC_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 |
int |
Unique identifier of the point |
| X |
numeric |
X-coordinate from join and least-squares adjustment |
| Y |
numeric |
Y-coordinate from join and least-squares adjustment |
| Z |
numeric |
Z-coordinate from join and least-squares adjustment
Nulls allowed |
| Type |
int |
Used for custom subtyping
Nulls allowed |
| Category |
int |
Enumeration of the system categories
Nulls allowed |
| Name |
nvarchar(32) |
Point name
Nulls allowed |
| Historical |
int |
Indicates whether the parcel lines are historic (true/1) or not (false/0)
Nulls allowed |
| SystemStartDate |
datetime |
Date of the system transaction that created the point |
| SystemEndDate |
datetime |
Date of the system transaction that retired the point
Nulls allowed |
| LegalStartDate |
datetime |
Date of the legal transaction that created the point; usually from legal record
Nulls allowed |
| LegalEndDate |
datetime |
Date of legal transaction that retired the point
Nulls allowed |
| CenterPoint |
int |
Set to true (1) if the point is a center point
Nulls allowed |
| MaxDN |
numeric |
Maximum northing shift
nulls allowed |
| MaxDE |
numeric |
Maximum easting shift
Nulls allowed |
| Shape |
int |
Point geometry
Nulls allowed |
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 |
int |
Unique identifier of the feature |
| 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
Nulls allowed |
| ToY |
numeric |
The y-coordinate of the point after adjusting
Nulls allowed |
| PointID |
int |
Unique identifier of the point adjusted |
| AdjLevel |
int |
Adjustment level that contains the vector |
Top of page
Cadastral fabrics in an XML document
Within an XML workspace document, cadastral fabrics are denoted with a data lement 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
