{ "currentVersion" : 12, "id" : 4, "name" : "AssetManagementDataStandard_Geometry", "type" : "Table", "serviceItemId" : "f955c118272b462e9ce757405890b87f", "cacheMaxAge" : 30, "displayField" : "", "description" : "<div style=\"text-align:Left;\"><div><div><p><span>The Asset Management Data Standard (AMDS) Network Model Geometry dataset contains the Geometry attribution as part of the base network model data for New Zealand, sourced from various Road Controlling Authority (RCA) Asset Management Systems, Land Information New Zealand (LINZ) and KiwiRail.</span></p><p><span>The Geometry table records the following relative to the base network model segment geometry:</span></p><p><span>- The coordinate system, accuracy, data capture date and method used , of both the two dimensional (2D) plane (X, Y) and the third dimension (3D) elevation (Z).</span></p><p><span>- The extents (X, Y, Z coordinates) of both the Start and End location (or points).</span></p><p><span>- The 3D length of the geometry. This is derived from the 3D shape of the geometry.</span></p><p><span>- The measured length (eg driven length) of the segment. Note, this attribute is intended for data migration only to support existing reporting, and is expected to be deprecated in future releases.</span></p><p><span>This table is related to the AMDS Network Model Segment table as a one to one (1:1).</span></p><p style=\"margin:0;\"><span><strong>Data/Schema Update Frequency</strong></span></p><p style=\"margin:0;\"><span>Data Update Frequency: Dependent on Data Managing Organisation</span></p><p style=\"margin:0;\"><span>Schema Revised: October 2025</span></p><p style=\"margin:0;\"><span>Published: October 2025</span></p></div></div></div>", "copyrightText" : "New Zealand Transport Agency Waka Kotahi, KiwiRail, Land Information New Zealand and Controlling Authorities.", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "created_date", "creatorField" : "created_user", "editDateField" : "last_edited_date", "editorField" : "last_edited_user" }, "editingInfo" : { "lastEditDate" : 1767753168419, "schemaLastEditDate" : 1762312584054, "dataLastEditDate" : 1762237921062 }, "relationships" : [ { "id" : 5, "name" : "AMDS_NetworkModel_AMDS_Geometry", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleDestination", "keyField" : "amdsIDNetworkModel", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "", "required" : true }, { "name" : "amdsIDGeometry", "type" : "esriFieldTypeString", "alias" : "AMDS ID Geometry", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "amdsIDNetworkModel", "type" : "esriFieldTypeString", "alias" : "AMDS ID Network Element", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "measuredLength", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "length3D", "type" : "esriFieldTypeDouble", "alias" : "Length 3D", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "xStart", "type" : "esriFieldTypeDouble", "alias" : "X Start", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "xEnd", "type" : "esriFieldTypeDouble", "alias" : "X End", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "yStart", "type" : "esriFieldTypeDouble", "alias" : "Y Start", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "yEnd", "type" : "esriFieldTypeDouble", "alias" : "Y End", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "zStart", "type" : "esriFieldTypeDouble", "alias" : "Z Start", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "zEnd", "type" : "esriFieldTypeDouble", "alias" : "Z End", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "dateCaptureMethodXY", "type" : "esriFieldTypeDate", "alias" : "XY Date Captured", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "", "precision" : 1 }, { "name" : "xYAccuracy", "type" : "esriFieldTypeString", "alias" : "XY Accuracy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryTierAccuracyXYZ", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "To what LINZ tier were the data captured? LINZ tiers are used to describe network accuracy. When no tier is appropriate, undefined is to be used.", "codedValues" : [ { "name" : "Undefined", "code" : "Undefined" }, { "name" : "\u003c0.05 m", "code" : "A" }, { "name" : "\u003c0.10 m", "code" : "B" }, { "name" : "\u003c0.15 m", "code" : "C" }, { "name" : "\u003c0.20 m", "code" : "D" }, { "name" : "\u003c0.25 m", "code" : "E" }, { "name" : "\u003c0.35 m", "code" : "F" }, { "name" : "\u003c0.50 m", "code" : "G" }, { "name" : "\u003c1 m", "code" : "H" }, { "name" : "\u003c2 m", "code" : "J" }, { "name" : "\u003c5 m", "code" : "K" }, { "name" : "\u003c10 m", "code" : "M" }, { "name" : "\u003c20 m", "code" : "N" }, { "name" : "\u003c50 m", "code" : "P" }, { "name" : "\u003c100 m", "code" : "R" } ] }, "defaultValue" : "" }, { "name" : "xYAccuracyMethodUsed", "type" : "esriFieldTypeSmallInteger", "alias" : "XY Capture Method Used", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryMethod", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What method of capture was used to record the position of the XYZ coordinates?", "codedValues" : [ { "name" : "Derived", "code" : 1 }, { "name" : "LiDAR", "code" : 2 }, { "name" : "Surveyed", "code" : 3 } ] }, "defaultValue" : "" }, { "name" : "xYCoordinateSystem", "type" : "esriFieldTypeSmallInteger", "alias" : "XY Coordinate System", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryXYCoordinateSystem", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What coordinate system are the XY coordinates recorded in?", "codedValues" : [ { "name" : "NZTM 2000", "code" : 2193 } ] }, "defaultValue" : "" }, { "name" : "dateCaptureMethodZ", "type" : "esriFieldTypeDate", "alias" : "Z Date Captured", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "", "precision" : 1 }, { "name" : "zAccuracy", "type" : "esriFieldTypeString", "alias" : "Z Accuracy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryTierAccuracyXYZ", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "To what LINZ tier were the data captured? LINZ tiers are used to describe network accuracy. When no tier is appropriate, undefined is to be used.", "codedValues" : [ { "name" : "Undefined", "code" : "Undefined" }, { "name" : "\u003c0.05 m", "code" : "A" }, { "name" : "\u003c0.10 m", "code" : "B" }, { "name" : "\u003c0.15 m", "code" : "C" }, { "name" : "\u003c0.20 m", "code" : "D" }, { "name" : "\u003c0.25 m", "code" : "E" }, { "name" : "\u003c0.35 m", "code" : "F" }, { "name" : "\u003c0.50 m", "code" : "G" }, { "name" : "\u003c1 m", "code" : "H" }, { "name" : "\u003c2 m", "code" : "J" }, { "name" : "\u003c5 m", "code" : "K" }, { "name" : "\u003c10 m", "code" : "M" }, { "name" : "\u003c20 m", "code" : "N" }, { "name" : "\u003c50 m", "code" : "P" }, { "name" : "\u003c100 m", "code" : "R" } ] }, "defaultValue" : "" }, { "name" : "zAccuracyMethodUsed", "type" : "esriFieldTypeSmallInteger", "alias" : "Z Capture Method Used", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryMethod", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What method of capture was used to record the position of the XYZ coordinates?", "codedValues" : [ { "name" : "Derived", "code" : 1 }, { "name" : "LiDAR", "code" : 2 }, { "name" : "Surveyed", "code" : 3 } ] }, "defaultValue" : "" }, { "name" : "zCoordinateSystem", "type" : "esriFieldTypeSmallInteger", "alias" : "Z Coordinate System", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlGeometryZCoordinateSystem", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What coordinate system are the Z coordinates recorded in?", "codedValues" : [ { "name" : "NZVD2016", "code" : 1169 } ] }, "defaultValue" : "" }, { "name" : "effectiveFrom", "type" : "esriFieldTypeDate", "alias" : "Effective From Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -2208988800000, "precision" : 1 }, { "name" : "effectiveTo", "type" : "esriFieldTypeDate", "alias" : "Effective To Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 253402214400000, "precision" : 1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "Created User", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "" }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "Created Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "", "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "Last Edited User", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "" }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "Last Edited Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "", "precision" : 1 } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G390amdsIDNetwor", "fields" : "amdsIDNetworkModel", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__AMDS_NET__F4B70D8545E89D0D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "created_dateIndex", "fields" : "created_date", "isAscending" : true, "isUnique" : false, "description" : "created_date Field index", "indexType" : "Attribute" }, { "name" : "created_userIndex", "fields" : "created_user", "isAscending" : false, "isUnique" : false, "description" : "created_user Field index", "indexType" : "Attribute" }, { "name" : "last_edited_dateIndex", "fields" : "last_edited_date", "isAscending" : true, "isUnique" : false, "description" : "last_edited_date Field index", "indexType" : "Attribute" }, { "name" : "last_edited_userIndex", "fields" : "last_edited_user", "isAscending" : false, "isUnique" : false, "description" : "last_edited_user Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }