Parcel fabrics in a geodatabase in Oracle

This topic applies to ArcGIS for Desktop Standard and ArcGIS for Desktop Advanced only.

Parcel fabrics are a type of dataset in the geodatabase that are created and maintained using data from survey plans. Parcel editing tools in ArcMap facilitate the creation of parcels from recorded boundary line measurements from plans or plats.

A parcel fabric is a continuous, integrated surface of connected parcels, representing the complete survey record for an area of land. The fabric itself is made up of several feature classes. These feature classes represent the boundaries, endpoints, and other physical attributes of parcels.

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 is formed.

Parcels that are edited or replaced by new survey records are retained as historic, thus always preserving the original survey record.

LegacyLegacy:

In ArcGIS releases prior to 10, parcel fabrics were called cadastral fabrics and required the Survey Analyst extension to use.

Parcel fabrics in ArcGIS for Desktop

In the Catalog tree, parcel fabrics can be present in feature datasets and are represented with the following icon:

Parcel fabric icon

The name of a parcel fabric in a geodatabase in Oracle contains the name of the owner of the parcel fabric and the name of the cadastral fabric itself.

For example, a parcel fabric, coparcels, owned by user base, in an assessor geodatabase would be listed as BASE.coparcels in the Catalog tree.

Parcel fabrics in an Oracle database

Several tables are created in the database to track information about parcel fabrics. Tables are created in the schema of the user who creates a parcel fabric. The tables contain the name of the parcel fabric, <parcel_fabric>, followed by the specific table. They are as follows:

<PARCEL_FABRIC>_ACCURACY

The <PARCEL_FABRIC>_ACCURACY table stores the accuracy categories and statistics, which are used in least-squares adjustments. This table is not versioned when the parcel fabric is registered as versioned.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

BRGSD

NUMBER(38,20)

The standard deviation of bearings

NOT NULL

DISTSD

NUMBER(38,20)

The standard deviation of distances

NOT NULL

PPM

NUMBER(38,20)

Parts per million value

NOT NULL

CATEGORY

NUMBER

Indicates the accuracy level

NOT NULL

DESCRIPTION

NVARCHAR2(256)

A description of the category

NOT NULL

<PARCEL_FABRIC>_ADJUSTMENTS

The <PARCEL_FABRIC>_ADJUSTMENTS table stores adjustment levels (sequence IDs) and their corresponding adjustment dates.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

ADJUSTMENTDATE

DATE

Date the adjustment was inserted

VECTORCOUNT

NUMBER

Number of vectors produced by the adjustment

NOT NULL

ADJLEVEL

NUMBER

Sequential number (ordering) of adjustment relative to other adjustments

NOT NULL

JOBID

NUMBER

ID of the job that contained the adjustment

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

The adjusted area

<PARCEL_FABRIC>_CONTROL

The <PARCEL_FABRIC>_CONTROL table stores information about control points on the parcel fabric.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the control point

NOT NULL

X

NUMBER(38,20)

The x-coordinate of the control point; fixed

NOT NULL

Y

NUMBER(38,20)

The y-coordinate of the control point; fixed

NOT NULL

Z

NUMBER(38,20)

The z-coordinate of the control point; fixed

NAME

NVARCHAR2(50)

The name of the control point

POINTID

NUMBER

The ID of the corresponding fabric point

ACCURACYXY

NUMBER(38,20)

The horizontal positional accuracy of the control point; for reference only

ACCURACYZ

NUMBER(38,20)

The vertical accuracy of the control point; for reference only

SURVEYDATE

DATE

The date the control point was established

ACTIVE

NUMBER

Indicates whether or not a control point is active in an adjustment

TYPE

NUMBER

Used for custom subtyping

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

The geometry of the control point

CONSTRUCTIONDATA

BLOB

Stores links between unjoined points and control points; when a parcel is rejoined to the fabric, parcel points joined to any linked control

<PARCEL_FABRIC>_HISTORY

The <PARCEL_FABRIC>_HISTORY table stores nonspatial parcel lineage information. This table supports textual lineage tracking through the legal and system dates.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

CHILDPARCELID

NUMBER

The child parcel ID or the ID of the child of this parent

PARENTPARCELID

NUMBER

Parcel ID of the parent parcel (or parcels) of this child

SYSTEMSTARTDATE

DATE

The date of the system transaction that created the child

NOT NULL

LEGALSTARTDATE

DATE

The date of the legal transaction that created the child

<PARCEL_FABRIC>_IDSEQUENCER

The <PARCEL_FABRIC>_IDSEQUENCER table is used internally to ensure unique IDs are used across all tables in the parcel fabric.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

<PARCEL_FABRIC>_JOBOBJECTS

The <PARCEL_FABRIC>_JOBOJBECTS table contains information needed to manage database locks held on objects by jobs. This table is not versioned when the parcel fabric is registered as versioned.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

JOBID

NUMBER

ID of the job holding the lock

NOT NULL

OBJECTTYPE

NUMBER

Type of object that is locked

NOT NULL

JOBFEATUREID

NUMBER

The object ID of the feature that is locked

NOT NULL

ROLE

NUMBER

Type of lock held—optimistic or pessimistic (Edit parcels use pessimistic locks.)

NOT NULL

EDIT

NUMBER

Indicates whether the attributes of the job object can be edited

NOT NULL

<PARCEL_FABRIC>_JOBS

The <PARCEL_FABRIC>_JOBS table stores information about the cadastral jobs operating on the parcel fabric. This table is not versioned when the parcel fabric is registered as versioned.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

NAME

NVARCHAR2(64)

The cadastral job identifier or name

NOT NULL

DESCRIPTION

NVARCHAR2(64)

User-defined description of the cadastral job

LOCKED

NUMBER

Indicates the presence of locked parcels in the job parcels list

NOT NULL

CREATEDATE

DATE

The date the job was created

MODIFIEDDATE

DATE

The date the job was last modified

COMMITDATE

DATE

The date the job was committed to the database

OWNER

NVARCHAR2(64)

The owner of the job

NOT NULL

STATUS

NUMBER

The status of the job

NOT NULL

SYSTEMSTATE

NUMBER

The system-maintained status of a job

NOT NULL

VERSION

NVARCHAR2(64)

The geodatabase version holding the job

LOCKMACHINE

NVARCHAR2(128)

Name of the client computer currently editing the job

NOT NULL

LOCKPID

NUMBER

System field containing the lock process ID; maintains single-use editing on the job

NOT NULL

COMMITTEDOBJ

BLOB

Stores parcel ObjectIDs that are no longer in the Job Objects table because the job has been committed or posted to the default version; values maintained for historical purposes

<PARCEL_FABRIC>_LEVELS

The <PARCEL_FABRIC>_LEVELS table stores information about relationships between parcel fabrics and their associated feature classes.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

FEATURECLASSID

NUMBER

The ID of the associated feature class

NOT NULL

ADJLEVEL

NUMBER

The adjustment level last applied to the feature class

NOT NULL

CFID

NUMBER

The source parcel fabric ID

NOT NULL

<PARCEL_FABRIC>_LINEPOINTS

The <PARCEL_FABRIC>_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

Null?

OBJECTID

NUMBER

Unique identifier of the point

NOT NULL

PARCELID

NUMBER

The ID of the parcel that has the boundary line

NOT NULL

FROMPOINTID

NUMBER

The ID of the from point of the boundary line

NOT NULL

TOPOINTID

NUMBER

The ID of the to point of the boundary line

NOT NULL

LINEPOINTID

NUMBER

ID of the point that must lie on the boundary

NOT NULL

FLEXPOINT

NUMBER

Indicates whether the straight lines adjacent to the line point are to be bent (flexed) to the location of the line point.

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

Duplicate of the point to improve drawing performance

<PARCEL_FABRIC>_LINES

The <PARCEL_FABRIC>_LINES table stores information on all lines of a parcel fabric, such as boundary, easements, and connections.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the line

NOT NULL

CALCULATED

NUMBER

Indicates whether dimensions inverted from shape geometry (true/1) or not (false/0)

PARCELID

NUMBER

The ID of the parcel that contains the line

NOT NULL

SEQUENCE

NUMBER

A number indicating the order in which the line was entered in the parcel traverse

NOT NULL

FROMPOINTID

NUMBER

The ID of the fabric point where the line begins

NOT NULL

TOPOINTID

NUMBER

The ID of the fabric point where the line ends

NOT NULL

BEARING

NUMBER(38,20)

The bearing of the line from record or compilation

NOT NULL

DISTANCE

NUMBER(38,20)

The length of the line from record or compilation

NOT NULL

TYPE

NUMBER

Used for custom subtyping

CATEGORY

NUMBER

High-level system category for line

NOT NULL

RADIUS

NUMBER(38,20)

The distance from the center point to the arc of the circular curve

ARCLENGTH

NUMBER(38,20)

The length of the arc of a circular curve

DELTA

NUMBER(38,20)

The angle between the tangents or the angle at the center of a curve

CENTERPOINTID

NUMBER

The ID of the center point of a circular arc

HISTORICAL

NUMBER

True (1) if the line's associated parcel is historic; otherwise, false (0)

RADIALBEARING

NUMBER(38,20)

The bearing of the radius of the circular curve

TANGENTBEARING

NUMBER(38,20)

The bearing of the tangent starting at the from point

LINEPARAMETERS

NUMBER

The curve parameters

ACCURACY

NUMBER

The accuracy category of the line; can be inherited from the plan or overridden

COMPUTEDMINUSOBSERVED

NUMBER(38,20)

The computed measurements (such as bearing and distance) compared with the field observation

INTERNALANGLE

NUMBER(38,20)

Based on a backsight bearing or basis of bearing

REFERENCEOBJECT

NUMBER

The reference object for a particular point

ISMAJOR

NUMBER

Supports curves greater than 180 degrees; value is either 1, greater than 180 degrees, or 0, 180 degrees or lower

HIDE

NUMBER

If marked true (1), hides line annotation

SYSTEMSTARTDATE

DATE

The date of the system transaction that created the parent parcel

NOT NULL

SYSTEMENDDATE

DATE

The date the parent parcel was retired

LEGALSTARTDATE

DATE

The date of the legal transaction that created the parent parcel; should be the same as the date on the legal plan

LEGALENDDATE

DATE

The date of the legal transaction that retired the parent parcel

DENSIFYTYPE

NUMBER

Stores the reason code for densifying the linestring: Normal, GCS, Curve, Linestring

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

Line geometry

<PARCEL_FABRIC>_PARCELS

The <PARCEL_FABRIC>_PARCELS table stores information about the parcel fabric land units, which are referred to as parcels. These may be subtyped for modeling hierarchical land categories.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

JOINED

NUMBER

Join status; if not joined, not part of the fabric; 1 = joined

NOT NULL

PLANID

NUMBER

Identifier of the plan containing the parcel record

NOT NULL

NAME

NVARCHAR2(50)

User-assigned name of the parcel

TYPE

NUMBER

Used for custom subtypes to support categories of land units

STATEDAREA

NVARCHAR2(50)

The area of the parcel stated on the plan or legal record

COMPILED

NUMBER

Indicates whether a parcel is compiled (true/1) or not (false/0)

NOT NULL

HISTORICAL

NUMBER

Indicates whether a parcel has been retired (true/1) or not (false/2)

SYSTEMSTARTDATE

DATE

The date of the system transaction that created the parcel

NOT NULL

SYSTEMENDDATE

DATE

The date of the system transaction that retired the parcel

LEGALSTARTDATE

DATE

The date of the legal transaction that created the parcel

LEGALENDDATE

DATE

The date of the legal transaction that retired the parcel

GROUPID

NUMBER

This number set if part of an unjoined group

ACCURACY

NUMBER

The accuracy category of measurements, usually taken from the plan

ROTATION

NUMBER(38,20)

Rotation from join process

SCALE

NUMBER(38,20)

Scale from join process

UNCLOSED

NUMBER

Indicates whether a parcel is a closed traverse (true/1) or not (false/0)

NOT NULL

MISCLOSURERATIO

NUMBER(38,20)

Ratio of misclose distance to parcel perimeter

MISCLOSEDISTANCE

NUMBER(38,20)

Distance necessary to close the parcel

MISCLOSEBEARING

NUMBER(38,20)

Bearing necessary to close the parcel

CONSTRUCTION

NUMBER

Indicates whether the parcel is a construction (true/1) or not (false/0)

SHAPESTDERRORE

NUMBER(38,20)

Overall parcel distortion (easting)

SHAPESTDERRORN

NUMBER(38,20)

Overall parcel distortion (northing)

BACKSIGHTBEARING

NUMBER(38,20)

Direction of line to backsight point

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

Parcel geometry

CONSTRUCTIONDATA

BLOB

Populated for unjoined parcels (those without a shape value) only

<PARCEL_FABRIC>_PLANS

The <PARCEL_FABRIC>_PLANS table stores the information from the document of record submitted in evidence of land transactions.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

NAME

NVARCHAR2(128)

The name of the plan or legal document

NOT NULL

DESCRIPTION

NVARCHAR2(1024)

A description of the document

SURVEYOR

NVARCHAR2(50)

Name of the surveyor of record

COMPANY

NVARCHAR2(50)

The survey company or organization of record

SURVEYDATE

DATE

Date of survey

LEGALDATE

DATE

Date survey or document was recorded

ANGLEUNITS

NUMBER

Bearing units of record

AREAUNITS

NUMBER

Area units of record

DISTANCEUNITS

NUMBER

Distance units of record

DIRECTIONFORMAT

NUMBER

Direction format of record

LINEPARAMETERS

NUMBER

Line definition parameters from record

DISTANCEATGROUND

NUMBER

Indicates whether record distances are ground (true/1) or grid (false/0)

COMBINEDGRIDFACTOR

NUMBER(38,20)

Scale factor of grid

TRUEMIDBRG

NUMBER

Indicates whether astronomic azimuths are used (true/1) or not (false/0)

ACCURACY

NUMBER

Spatial accuracy of plan, set to an accuracy category

INTERNALANGLES

NUMBER

Indicates whether or not internal angles are used; 1 = true, 2 = false

SYSTEMSTARTDATE

DATE

The date of system transaction that created the plan

NOT NULL

<PARCEL_FABRIC>_POINTS

The <PARCEL_FABRIC>_POINTS table stores information about the set of points that exists for each fabric and the centerpoints of curves.

Field name

Field type

Description

Null?

OBJECTID

NUMBER

Unique identifier of the point

NOT NULL

X

NUMBER(38,20)

X-coordinate from join and least-squares adjustment

NOT NULL

Y

NUMBER(38,20)

Y-coordinate from join and least-squares adjustment

NOT NULL

Z

NUMBER(38,20)

Z-coordinate from join and least-squares adjustment

TYPE

NUMBER

Used for custom subtyping

CATEGORY

NUMBER

Enumeration of the system categories

NAME

NVARCHAR2(32)

Point name

HISTORICAL

NUMBER

Indicates whether the parcel lines are historic (true/1) or not (false/0)

SYSTEMSTARTDATE

DATE

Date of the system transaction that created the point

NOT NULL

SYSTEMENDDATE

DATE

Date of the system transaction that retired the point

LEGALSTARTDATE

DATE

Date of the legal transaction that created the point; usually from legal record

LEGALENDDATE

DATE

Date of legal transaction that retired the point

CENTERPOINT

NUMBER

Set to true (1) if the point is a center point

MAXDN

NUMBER(38,20)

Maximum northing shift

MAXDE

NUMBER(38,20)

Maximum easting shift

SHAPE

ST_GEOMETRY

BLOB

SDO_GEOMETRY

Point geometry

<PARCEL_FABRIC>_VECTORS

The <PARCEL_FABRIC>_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

Null?

OBJECTID

NUMBER

Unique identifier of the record

NOT NULL

FROMX

NUMBER(38,20)

The x-coordinate of the point before adjusting

NOT NULL

FROMY

NUMBER(38,20)

The y-coordinate of the point before adjusting

NOT NULL

TOX

NUMBER(38,20)

The x-coordinate of the point after adjusting

TOY

NUMBER(38,20)

The y-coordinate of the point after adjusting

POINTID

NUMBER

Unique identifier of the point adjusted

NOT NULL

ADJLEVEL

NUMBER

Adjustment level that contains the vector

NOT NULL

View a diagram of a parcel fabric in Oracle.

NoteNote:

You need Adobe Acrobat Reader to open the file.

Dashed lines indicate implicit relationships between columns.

Parcel fabrics in an XML document

Within an XML workspace document, parcel fabrics are denoted with a data element and dataset type of CadastralFabric, as in the following example:

<DataElement xsi:type="esri:DECadastralFabric">
<CatalogPath>/V=sde.DEFAULT/FD=assess.tech1.landbase/CF=assess.tech1.co_parcels</CatalogPath> 
<Name>assess.tech1.co_parcels</Name>
  <DatasetType>esriDTCadastralFabric</DatasetType>
  <DSID>265</DSID> 
  <Versioned>false</Versioned> 
  <CanVersion>false</CanVersion>
  <ConfigurationKeyword>DEFAULTS</<ConfigurationKeyword> 
  <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> 
  <UseDefaultAccuracies>true</UseDefaultAccuracies>
  <CompiledAccuracy>3</CompiledAccuracy>
  <BufferDistanceForAdjustment>50</BufferDistanceForAdjustment>
  <CadastralFabricType>0</CadastralFabricType>>
  <SurrogateVersion />
  <Version>2</Version>
  <MaximumShiftThreshold>0.0098424999999999988</MaximumShiftThreshold> 
  <MultiGenerationEditing>false</MultiGenerationEditing>
  <MultiLevelReconcile>false</MultiLevelReconcile>
  <MinorVersion>3</MinorVersion>
</DataElement>

Related Topics

6/12/2015