{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "geodata.DBO.TYLER_Address_1", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "PROP_USE", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943620.09373316914, "ymin" : 883638.98112200212, "xmax" : 971930.02563025057, "ymax" : 902675.65006958693, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[178,178,178,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_12", "uniqueIdField" : { "name" : "OBJECTID_12", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_12", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_12", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROP_USE", "type" : "esriFieldTypeString", "alias" : "PROP_USE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROADBASE_S", "type" : "esriFieldTypeDouble", "alias" : "ROADBASE_S", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUILDING_N", "type" : "esriFieldTypeString", "alias" : "BUILDING_N", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOOR", "type" : "esriFieldTypeString", "alias" : "FLOOR", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ID_EN", "type" : "esriFieldTypeString", "alias" : "USER_ID_EN", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_ENT", "type" : "esriFieldTypeDate", "alias" : "DT_ENT", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "USER_ID_CH", "type" : "esriFieldTypeString", "alias" : "USER_ID_CH", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS_SE", "type" : "esriFieldTypeDouble", "alias" : "ADDRESS_SE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NO", "type" : "esriFieldTypeString", "alias" : "STREET_NO", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_PRE", "type" : "esriFieldTypeString", "alias" : "STREET_PRE", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeString", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_POS", "type" : "esriFieldTypeString", "alias" : "STREET_POS", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITUS_SEQ", "type" : "esriFieldTypeDouble", "alias" : "SITUS_SEQ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "APARTMENT", "type" : "esriFieldTypeString", "alias" : "APARTMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITY", "type" : "esriFieldTypeString", "alias" : "CITY", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CODE", "type" : "esriFieldTypeString", "alias" : "ZIP_CODE", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CITY", "type" : "esriFieldTypeString", "alias" : "ZIP_CITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDR_TYPE", "type" : "esriFieldTypeString", "alias" : "ADDR_TYPE", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR1", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALID", "type" : "esriFieldTypeInteger", "alias" : "SPATIALID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR2", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR2", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__6F32A04C662C87EC", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_ADDRESS_1_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Address_1", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "SPATIALID" : null, "FULL_ADDR2" : null, "OBJECTID_1" : null, "PROP_USE" : null, "ROADBASE_S" : null, "BUILDING_N" : null, "FLOOR" : null, "STATUS" : null, "OBJECTID" : null, "USER_ID_EN" : null, "DT_ENT" : null, "USER_ID_CH" : null, "DT_CHG" : null, "PCN" : null, "ADDRESS_SE" : null, "STREET_NO" : null, "STREET_PRE" : null, "STREET_NAM" : null, "STREET_SUF" : null, "STREET_POS" : null, "SITUS_SEQ" : null, "APARTMENT" : null, "CITY" : null, "ZIP_CODE" : null, "ZIP_CITY" : null, "ADDR_TYPE" : null, "FULL_ADDR" : null, "FULL_ADDR1" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "geodata.DBO.TYLER_Centerline_2", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652728951, "schemaLastEditDate" : 1521652728951, "dataLastEditDate" : 1521652728951 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943436.73419174564, "ymin" : 883514.3652294873, "xmax" : 971715.08642758068, "ymax" : 902843.02735949308, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,76,0,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_1", "uniqueIdField" : { "name" : "OBJECTID_1", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_1", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FNUM", "type" : "esriFieldTypeDouble", "alias" : "FNUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPCITY", "type" : "esriFieldTypeString", "alias" : "ZIPCITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SEGMENTID", "type" : "esriFieldTypeDouble", "alias" : "SEGMENTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET", "type" : "esriFieldTypeString", "alias" : "STREET", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIX", "type" : "esriFieldTypeString", "alias" : "PREFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUFFIX", "type" : "esriFieldTypeString", "alias" : "SUFFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMLEFT", "type" : "esriFieldTypeDouble", "alias" : "FROMLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOLEFT", "type" : "esriFieldTypeDouble", "alias" : "TOLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMRIGHT", "type" : "esriFieldTypeDouble", "alias" : "FROMRIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TORIGHT", "type" : "esriFieldTypeDouble", "alias" : "TORIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "L_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "R_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_MUNI", "type" : "esriFieldTypeString", "alias" : "L_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_MUNI", "type" : "esriFieldTypeString", "alias" : "R_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RESP_AUTH", "type" : "esriFieldTypeString", "alias" : "RESP_AUTH", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TFARE_ROW", "type" : "esriFieldTypeString", "alias" : "TFARE_ROW", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FUNC_CLASS", "type" : "esriFieldTypeString", "alias" : "FUNC_CLASS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPEED_LIM", "type" : "esriFieldTypeDouble", "alias" : "SPEED_LIM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANES", "type" : "esriFieldTypeDouble", "alias" : "LANES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CFCC", "type" : "esriFieldTypeString", "alias" : "CFCC", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LN2020", "type" : "esriFieldTypeDouble", "alias" : "LN2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_RD_", "type" : "esriFieldTypeDouble", "alias" : "COUNTY_RD_", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONEWAY", "type" : "esriFieldTypeString", "alias" : "ONEWAY", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_code", "type" : "esriFieldTypeString", "alias" : "City_code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__E458E6E78DA2E2A6", "fields" : "OBJECTID_1", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_CENTERLINE_2_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Centerline_2", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ONEWAY" : null, "City_code" : null, "FNUM" : null, "STREET_NAM" : null, "ZIPCITY" : null, "OBJECTID" : null, "SEGMENTID" : null, "STREET" : null, "PREFIX" : null, "NAME" : null, "TYPE" : null, "SUFFIX" : null, "FROMLEFT" : null, "TOLEFT" : null, "FROMRIGHT" : null, "TORIGHT" : null, "L_ZIPCODE" : null, "R_ZIPCODE" : null, "L_MUNI" : null, "R_MUNI" : null, "RESP_AUTH" : null, "TFARE_ROW" : null, "FUNC_CLASS" : null, "SPEED_LIM" : null, "LANES" : null, "CFCC" : null, "DT_CHG" : null, "LN2020" : null, "COUNTY_RD_" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "geodata.DBO.TYLER_Parcel_3", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "propertydata_OWNERNAME1", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652794328, "schemaLastEditDate" : 1521652794328, "dataLastEditDate" : 1521652794328 }, "relationships" : [ { "id" : 0, "name" : "Tyler_CondosforParcel_3", "relatedTableId" : 12, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "Parcels_PARID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943491.04171981278, "ymin" : 883517.19086524844, "xmax" : 972195.05891387537, "ymax" : 902877.36414209008, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,255,190,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_PARID", "type" : "esriFieldTypeString", "alias" : "PARID", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_CTY", "type" : "esriFieldTypeString", "alias" : "CTY", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_RNG", "type" : "esriFieldTypeString", "alias" : "RNG", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_TWP", "type" : "esriFieldTypeString", "alias" : "TWP", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SEC", "type" : "esriFieldTypeString", "alias" : "SEC", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SUBD", "type" : "esriFieldTypeString", "alias" : "SUBD", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_BLK", "type" : "esriFieldTypeString", "alias" : "BLK", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_LOT", "type" : "esriFieldTypeString", "alias" : "LOT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_OID", "type" : "esriFieldTypeInteger", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_AG_USE_VAL", "type" : "esriFieldTypeDouble", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRICE", "type" : "esriFieldTypeDouble", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTMRKVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "type", "type" : "esriFieldTypeString", "alias" : "type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALID", "type" : "esriFieldTypeString", "alias" : "SPATIALID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D85C9AE4068", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_PARCEL_3_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G5Parcels_PARID", "fields" : "Parcels_PARID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Parcel_3", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "type" : null, "SPATIALID" : null, "Parcels_PARID" : null, "Parcels_CTY" : null, "Parcels_RNG" : null, "Parcels_TWP" : null, "Parcels_SEC" : null, "Parcels_SUBD" : null, "Parcels_BLK" : null, "Parcels_LOT" : null, "Parcels_DT_CHG" : null, "propertydata_OID" : null, "propertydata_PCN" : null, "propertydata_ACRES" : null, "propertydata_SITEADDR" : null, "propertydata_OWNERNAME1" : null, "propertydata_OWNERNAME2" : null, "propertydata_EXEMPTION" : null, "propertydata_PADDR1" : null, "propertydata_PADDR2" : null, "propertydata_PADDR3" : null, "propertydata_CITYNAME" : null, "propertydata_STATE" : null, "propertydata_INSTRUMENT" : null, "propertydata_CRA" : null, "propertydata_NBHD" : null, "propertydata_SALEKEY" : null, "propertydata_PROPUSE" : null, "propertydata_AG_USE_VAL" : null, "propertydata_CONFID_FLG" : null, "propertydata_HMSTD_FLG" : null, "propertydata_YEAR_ADDED" : null, "propertydata_SALE_DATE" : null, "propertydata_BOOK" : null, "propertydata_PAGE" : null, "propertydata_STREET_NUM" : null, "propertydata_PRE_DIR" : null, "propertydata_STREETNAME" : null, "propertydata_STREET_SUF" : null, "propertydata_POST_DIR" : null, "propertydata_ZIP1" : null, "propertydata_ZIP2" : null, "propertydata_MUNI" : null, "propertydata_SUBDIVNAM" : null, "propertydata_PRICE" : null, "propertydata_TOTMRKVAL" : null, "propertydata_CAP_ADJVAL" : null, "propertydata_MKT_CAPPED" : null, "propertydata_MKT_NOCAP" : null, "propertydata_ASSESSVAL" : null, "propertydata_LANDVAL" : null, "propertydata_IMPRV_MRKT" : null, "propertydata_TOTALVALUE" : null, "propertydata_TOTTAXVAL" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "geodata.DBO.TYLER_Address_SC_4", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943620.09373316914, "ymin" : 883638.98112200212, "xmax" : 971930.02563025057, "ymax" : 902675.65006958693, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[104,104,104,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_12", "uniqueIdField" : { "name" : "OBJECTID_12", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_12", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_12", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROP_USE", "type" : "esriFieldTypeString", "alias" : "PROP_USE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROADBASE_S", "type" : "esriFieldTypeDouble", "alias" : "ROADBASE_S", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUILDING_N", "type" : "esriFieldTypeString", "alias" : "BUILDING_N", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOOR", "type" : "esriFieldTypeString", "alias" : "FLOOR", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ID_EN", "type" : "esriFieldTypeString", "alias" : "USER_ID_EN", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_ENT", "type" : "esriFieldTypeDate", "alias" : "DT_ENT", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "USER_ID_CH", "type" : "esriFieldTypeString", "alias" : "USER_ID_CH", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS_SE", "type" : "esriFieldTypeDouble", "alias" : "ADDRESS_SE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NO", "type" : "esriFieldTypeString", "alias" : "STREET_NO", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_PRE", "type" : "esriFieldTypeString", "alias" : "STREET_PRE", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeString", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_POS", "type" : "esriFieldTypeString", "alias" : "STREET_POS", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITUS_SEQ", "type" : "esriFieldTypeDouble", "alias" : "SITUS_SEQ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "APARTMENT", "type" : "esriFieldTypeString", "alias" : "APARTMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITY", "type" : "esriFieldTypeString", "alias" : "CITY", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CODE", "type" : "esriFieldTypeString", "alias" : "ZIP_CODE", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CITY", "type" : "esriFieldTypeString", "alias" : "ZIP_CITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDR_TYPE", "type" : "esriFieldTypeString", "alias" : "ADDR_TYPE", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR1", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALID", "type" : "esriFieldTypeInteger", "alias" : "SPATIALID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR2", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR2", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATEDDATE", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__DATA_MAP__6F32A04C8A1A952C", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_ADDRESS_SC_4_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Address_SC_4", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DESCRIPTION" : null, "CREATEDDATE" : null, "OBJECTID_1" : null, "PROP_USE" : null, "ROADBASE_S" : null, "BUILDING_N" : null, "FLOOR" : null, "STATUS" : null, "OBJECTID" : null, "USER_ID_EN" : null, "DT_ENT" : null, "USER_ID_CH" : null, "DT_CHG" : null, "PCN" : null, "ADDRESS_SE" : null, "STREET_NO" : null, "STREET_PRE" : null, "STREET_NAM" : null, "STREET_SUF" : null, "STREET_POS" : null, "SITUS_SEQ" : null, "APARTMENT" : null, "CITY" : null, "ZIP_CODE" : null, "ZIP_CITY" : null, "ADDR_TYPE" : null, "FULL_ADDR" : null, "FULL_ADDR1" : null, "SPATIALID" : null, "FULL_ADDR2" : null, "NAME" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "geodata.DBO.TYLER_Centerline_SC_5", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652811756, "schemaLastEditDate" : 1521652811756, "dataLastEditDate" : 1521652811756 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943436.73419174564, "ymin" : 883514.3652294873, "xmax" : 971715.08642758068, "ymax" : 902843.02735949308, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_1", "uniqueIdField" : { "name" : "OBJECTID_1", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_1", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FNUM", "type" : "esriFieldTypeDouble", "alias" : "FNUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPCITY", "type" : "esriFieldTypeString", "alias" : "ZIPCITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SEGMENTID", "type" : "esriFieldTypeDouble", "alias" : "SEGMENTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET", "type" : "esriFieldTypeString", "alias" : "STREET", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIX", "type" : "esriFieldTypeString", "alias" : "PREFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUFFIX", "type" : "esriFieldTypeString", "alias" : "SUFFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMLEFT", "type" : "esriFieldTypeDouble", "alias" : "FROMLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOLEFT", "type" : "esriFieldTypeDouble", "alias" : "TOLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMRIGHT", "type" : "esriFieldTypeDouble", "alias" : "FROMRIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TORIGHT", "type" : "esriFieldTypeDouble", "alias" : "TORIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "L_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "R_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_MUNI", "type" : "esriFieldTypeString", "alias" : "L_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_MUNI", "type" : "esriFieldTypeString", "alias" : "R_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RESP_AUTH", "type" : "esriFieldTypeString", "alias" : "RESP_AUTH", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TFARE_ROW", "type" : "esriFieldTypeString", "alias" : "TFARE_ROW", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FUNC_CLASS", "type" : "esriFieldTypeString", "alias" : "FUNC_CLASS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPEED_LIM", "type" : "esriFieldTypeDouble", "alias" : "SPEED_LIM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANES", "type" : "esriFieldTypeDouble", "alias" : "LANES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CFCC", "type" : "esriFieldTypeString", "alias" : "CFCC", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LN2020", "type" : "esriFieldTypeDouble", "alias" : "LN2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_RD_", "type" : "esriFieldTypeDouble", "alias" : "COUNTY_RD_", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONEWAY", "type" : "esriFieldTypeString", "alias" : "ONEWAY", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_code", "type" : "esriFieldTypeString", "alias" : "City_code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME_1", "type" : "esriFieldTypeString", "alias" : "NAME_1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATEDDATE", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__E458E6E7F702E5DA", "fields" : "OBJECTID_1", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_CENTERLINE_SC_5_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Centerline_SC_5", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "DESCRIPTION" : null, "CREATEDDATE" : null, "FNUM" : null, "STREET_NAM" : null, "ZIPCITY" : null, "OBJECTID" : null, "SEGMENTID" : null, "STREET" : null, "PREFIX" : null, "NAME" : null, "TYPE" : null, "SUFFIX" : null, "FROMLEFT" : null, "TOLEFT" : null, "FROMRIGHT" : null, "TORIGHT" : null, "L_ZIPCODE" : null, "R_ZIPCODE" : null, "L_MUNI" : null, "R_MUNI" : null, "RESP_AUTH" : null, "TFARE_ROW" : null, "FUNC_CLASS" : null, "SPEED_LIM" : null, "LANES" : null, "CFCC" : null, "DT_CHG" : null, "LN2020" : null, "COUNTY_RD_" : null, "ONEWAY" : null, "City_code" : null, "NAME_1" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 5, "name" : "geodata.DBO.TYLER_Parcel_SC_6", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652855441, "schemaLastEditDate" : 1521652855441, "dataLastEditDate" : 1521652855441 }, "relationships" : [ { "id" : 1, "name" : "Tyler_CondosforParcel_6", "relatedTableId" : 13, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "Parcels_PARID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943491.04171981278, "ymin" : 883517.19086524844, "xmax" : 972195.05891387537, "ymax" : 902877.36414209008, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,255,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_PARID", "type" : "esriFieldTypeString", "alias" : "PARID", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_CTY", "type" : "esriFieldTypeString", "alias" : "CTY", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_RNG", "type" : "esriFieldTypeString", "alias" : "RNG", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_TWP", "type" : "esriFieldTypeString", "alias" : "TWP", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SEC", "type" : "esriFieldTypeString", "alias" : "SEC", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SUBD", "type" : "esriFieldTypeString", "alias" : "SUBD", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_BLK", "type" : "esriFieldTypeString", "alias" : "BLK", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_LOT", "type" : "esriFieldTypeString", "alias" : "LOT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_OID", "type" : "esriFieldTypeInteger", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_AG_USE_VAL", "type" : "esriFieldTypeDouble", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRICE", "type" : "esriFieldTypeDouble", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTMRKVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "type", "type" : "esriFieldTypeString", "alias" : "type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALID", "type" : "esriFieldTypeString", "alias" : "SPATIALID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATEDDATE", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D851ACD5A52", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_PARCEL_SC_6_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G10Parcels_PARID", "fields" : "Parcels_PARID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Parcel_SC_6", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "DESCRIPTION" : null, "CREATEDDATE" : null, "Parcels_PARID" : null, "Parcels_CTY" : null, "Parcels_RNG" : null, "Parcels_TWP" : null, "Parcels_SEC" : null, "Parcels_SUBD" : null, "Parcels_BLK" : null, "Parcels_LOT" : null, "Parcels_DT_CHG" : null, "propertydata_OID" : null, "propertydata_PCN" : null, "propertydata_ACRES" : null, "propertydata_SITEADDR" : null, "propertydata_OWNERNAME1" : null, "propertydata_OWNERNAME2" : null, "propertydata_EXEMPTION" : null, "propertydata_PADDR1" : null, "propertydata_PADDR2" : null, "propertydata_PADDR3" : null, "propertydata_CITYNAME" : null, "propertydata_STATE" : null, "propertydata_INSTRUMENT" : null, "propertydata_CRA" : null, "propertydata_NBHD" : null, "propertydata_SALEKEY" : null, "propertydata_PROPUSE" : null, "propertydata_AG_USE_VAL" : null, "propertydata_CONFID_FLG" : null, "propertydata_HMSTD_FLG" : null, "propertydata_YEAR_ADDED" : null, "propertydata_SALE_DATE" : null, "propertydata_BOOK" : null, "propertydata_PAGE" : null, "propertydata_STREET_NUM" : null, "propertydata_PRE_DIR" : null, "propertydata_STREETNAME" : null, "propertydata_STREET_SUF" : null, "propertydata_POST_DIR" : null, "propertydata_ZIP1" : null, "propertydata_ZIP2" : null, "propertydata_MUNI" : null, "propertydata_SUBDIVNAM" : null, "propertydata_PRICE" : null, "propertydata_TOTMRKVAL" : null, "propertydata_CAP_ADJVAL" : null, "propertydata_MKT_CAPPED" : null, "propertydata_MKT_NOCAP" : null, "propertydata_ASSESSVAL" : null, "propertydata_LANDVAL" : null, "propertydata_IMPRV_MRKT" : null, "propertydata_TOTALVALUE" : null, "propertydata_TOTTAXVAL" : null, "type" : null, "SPATIALID" : null, "NAME" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "geodata.DBO.TYLER_Address_HW_7", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "ModuleName", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943620.09373316914, "ymin" : 883638.98112200212, "xmax" : 971930.02563025057, "ymax" : 902675.65006958693, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_12", "uniqueIdField" : { "name" : "OBJECTID_12", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_12", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_12", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROP_USE", "type" : "esriFieldTypeString", "alias" : "PROP_USE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROADBASE_S", "type" : "esriFieldTypeDouble", "alias" : "ROADBASE_S", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUILDING_N", "type" : "esriFieldTypeString", "alias" : "BUILDING_N", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOOR", "type" : "esriFieldTypeString", "alias" : "FLOOR", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ID_EN", "type" : "esriFieldTypeString", "alias" : "USER_ID_EN", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_ENT", "type" : "esriFieldTypeDate", "alias" : "DT_ENT", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "USER_ID_CH", "type" : "esriFieldTypeString", "alias" : "USER_ID_CH", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS_SE", "type" : "esriFieldTypeDouble", "alias" : "ADDRESS_SE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NO", "type" : "esriFieldTypeString", "alias" : "STREET_NO", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_PRE", "type" : "esriFieldTypeString", "alias" : "STREET_PRE", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeString", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_POS", "type" : "esriFieldTypeString", "alias" : "STREET_POS", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITUS_SEQ", "type" : "esriFieldTypeDouble", "alias" : "SITUS_SEQ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "APARTMENT", "type" : "esriFieldTypeString", "alias" : "APARTMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITY", "type" : "esriFieldTypeString", "alias" : "CITY", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CODE", "type" : "esriFieldTypeString", "alias" : "ZIP_CODE", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP_CITY", "type" : "esriFieldTypeString", "alias" : "ZIP_CITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDR_TYPE", "type" : "esriFieldTypeString", "alias" : "ADDR_TYPE", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR1", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_ADDR2", "type" : "esriFieldTypeString", "alias" : "FULL_ADDR2", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ModuleName", "type" : "esriFieldTypeString", "alias" : "ModuleName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseID", "type" : "esriFieldTypeString", "alias" : "CaseID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseNumber", "type" : "esriFieldTypeString", "alias" : "CaseNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseType", "type" : "esriFieldTypeString", "alias" : "CaseType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkClass", "type" : "esriFieldTypeString", "alias" : "WorkClass", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicationDate", "type" : "esriFieldTypeDate", "alias" : "ApplicationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ProjectID", "type" : "esriFieldTypeString", "alias" : "ProjectID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectName", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GISHistoryQueueID", "type" : "esriFieldTypeString", "alias" : "GISHistoryQueueID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialID", "type" : "esriFieldTypeString", "alias" : "SpatialID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__6F32A04C43CDB90B", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_ADDRESS_HW_7_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Address_HW_7", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "GISHistoryQueueID" : null, "SpatialID" : null, "OBJECTID_1" : null, "PROP_USE" : null, "ROADBASE_S" : null, "BUILDING_N" : null, "FLOOR" : null, "STATUS" : null, "OBJECTID" : null, "USER_ID_EN" : null, "DT_ENT" : null, "USER_ID_CH" : null, "DT_CHG" : null, "PCN" : null, "ADDRESS_SE" : null, "STREET_NO" : null, "STREET_PRE" : null, "STREET_NAM" : null, "STREET_SUF" : null, "STREET_POS" : null, "SITUS_SEQ" : null, "APARTMENT" : null, "CITY" : null, "ZIP_CODE" : null, "ZIP_CITY" : null, "ADDR_TYPE" : null, "FULL_ADDR" : null, "FULL_ADDR1" : null, "FULL_ADDR2" : null, "ModuleName" : null, "CaseID" : null, "CaseNumber" : null, "CaseType" : null, "WorkClass" : null, "ApplicationDate" : null, "ProjectID" : null, "ProjectName" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "geodata.DBO.TYLER_Centerline_HW_8", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652873147, "schemaLastEditDate" : 1521652873147, "dataLastEditDate" : 1521652873147 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943436.73419174564, "ymin" : 883514.3652294873, "xmax" : 971715.08642758068, "ymax" : 902843.02735949308, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,0,0,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_1", "uniqueIdField" : { "name" : "OBJECTID_1", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_1", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FNUM", "type" : "esriFieldTypeDouble", "alias" : "FNUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NAM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NAM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPCITY", "type" : "esriFieldTypeString", "alias" : "ZIPCITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SEGMENTID", "type" : "esriFieldTypeDouble", "alias" : "SEGMENTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET", "type" : "esriFieldTypeString", "alias" : "STREET", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIX", "type" : "esriFieldTypeString", "alias" : "PREFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUFFIX", "type" : "esriFieldTypeString", "alias" : "SUFFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMLEFT", "type" : "esriFieldTypeDouble", "alias" : "FROMLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOLEFT", "type" : "esriFieldTypeDouble", "alias" : "TOLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMRIGHT", "type" : "esriFieldTypeDouble", "alias" : "FROMRIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TORIGHT", "type" : "esriFieldTypeDouble", "alias" : "TORIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "L_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_ZIPCODE", "type" : "esriFieldTypeDouble", "alias" : "R_ZIPCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_MUNI", "type" : "esriFieldTypeString", "alias" : "L_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_MUNI", "type" : "esriFieldTypeString", "alias" : "R_MUNI", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RESP_AUTH", "type" : "esriFieldTypeString", "alias" : "RESP_AUTH", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TFARE_ROW", "type" : "esriFieldTypeString", "alias" : "TFARE_ROW", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FUNC_CLASS", "type" : "esriFieldTypeString", "alias" : "FUNC_CLASS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPEED_LIM", "type" : "esriFieldTypeDouble", "alias" : "SPEED_LIM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANES", "type" : "esriFieldTypeDouble", "alias" : "LANES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CFCC", "type" : "esriFieldTypeString", "alias" : "CFCC", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LN2020", "type" : "esriFieldTypeDouble", "alias" : "LN2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_RD_", "type" : "esriFieldTypeDouble", "alias" : "COUNTY_RD_", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONEWAY", "type" : "esriFieldTypeString", "alias" : "ONEWAY", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_code", "type" : "esriFieldTypeString", "alias" : "City_code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ModuleName", "type" : "esriFieldTypeString", "alias" : "ModuleName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseID", "type" : "esriFieldTypeString", "alias" : "CaseID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseNumber", "type" : "esriFieldTypeString", "alias" : "CaseNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseType", "type" : "esriFieldTypeString", "alias" : "CaseType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkClass", "type" : "esriFieldTypeString", "alias" : "WorkClass", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicationDate", "type" : "esriFieldTypeDate", "alias" : "ApplicationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ProjectID", "type" : "esriFieldTypeString", "alias" : "ProjectID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectName", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GISHistoryQueueID", "type" : "esriFieldTypeString", "alias" : "GISHistoryQueueID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialType", "type" : "esriFieldTypeString", "alias" : "SpatialType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialID", "type" : "esriFieldTypeString", "alias" : "SpatialID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__E458E6E779E8D234", "fields" : "OBJECTID_1", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_CENTERLINE_HW_8_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Centerline_HW_8", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "SpatialType" : null, "SpatialID" : null, "FNUM" : null, "STREET_NAM" : null, "ZIPCITY" : null, "OBJECTID" : null, "SEGMENTID" : null, "STREET" : null, "PREFIX" : null, "NAME" : null, "TYPE" : null, "SUFFIX" : null, "FROMLEFT" : null, "TOLEFT" : null, "FROMRIGHT" : null, "TORIGHT" : null, "L_ZIPCODE" : null, "R_ZIPCODE" : null, "L_MUNI" : null, "R_MUNI" : null, "RESP_AUTH" : null, "TFARE_ROW" : null, "FUNC_CLASS" : null, "SPEED_LIM" : null, "LANES" : null, "CFCC" : null, "DT_CHG" : null, "LN2020" : null, "COUNTY_RD_" : null, "ONEWAY" : null, "City_code" : null, "ModuleName" : null, "CaseID" : null, "CaseNumber" : null, "CaseType" : null, "WorkClass" : null, "ApplicationDate" : null, "ProjectID" : null, "ProjectName" : null, "GISHistoryQueueID" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 8, "name" : "geodata.DBO.TYLER_Parcel_HW_9", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "propertydata_OWNERNAME1", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652914979, "schemaLastEditDate" : 1521652914979, "dataLastEditDate" : 1521652914979 }, "relationships" : [ { "id" : 2, "name" : "Tyler_CondosforParcel_9", "relatedTableId" : 14, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "Parcels_PARID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943491.04171981278, "ymin" : 883517.19086524844, "xmax" : 972195.05891387537, "ymax" : 902877.36414209008, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[230,230,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_PARID", "type" : "esriFieldTypeString", "alias" : "PARID", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_CTY", "type" : "esriFieldTypeString", "alias" : "CTY", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_RNG", "type" : "esriFieldTypeString", "alias" : "RNG", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_TWP", "type" : "esriFieldTypeString", "alias" : "TWP", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SEC", "type" : "esriFieldTypeString", "alias" : "SEC", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_SUBD", "type" : "esriFieldTypeString", "alias" : "SUBD", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_BLK", "type" : "esriFieldTypeString", "alias" : "BLK", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_LOT", "type" : "esriFieldTypeString", "alias" : "LOT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Parcels_DT_CHG", "type" : "esriFieldTypeDate", "alias" : "DT_CHG", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_OID", "type" : "esriFieldTypeInteger", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_AG_USE_VAL", "type" : "esriFieldTypeDouble", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "propertydata_BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_PRICE", "type" : "esriFieldTypeDouble", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTMRKVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "propertydata_TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "type", "type" : "esriFieldTypeString", "alias" : "type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ModuleName", "type" : "esriFieldTypeString", "alias" : "ModuleName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseID", "type" : "esriFieldTypeString", "alias" : "CaseID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseNumber", "type" : "esriFieldTypeString", "alias" : "CaseNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CaseType", "type" : "esriFieldTypeString", "alias" : "CaseType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkClass", "type" : "esriFieldTypeString", "alias" : "WorkClass", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicationDate", "type" : "esriFieldTypeDate", "alias" : "ApplicationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ProjectID", "type" : "esriFieldTypeString", "alias" : "ProjectID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectName", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GISHistoryQueueID", "type" : "esriFieldTypeString", "alias" : "GISHistoryQueueID", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialType", "type" : "esriFieldTypeString", "alias" : "SpatialType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialID", "type" : "esriFieldTypeString", "alias" : "SpatialID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D85DCEF1B74", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_PARCEL_HW_9_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G15Parcels_PARID", "fields" : "Parcels_PARID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Parcel_HW_9", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "SpatialType" : null, "SpatialID" : null, "Parcels_PARID" : null, "Parcels_CTY" : null, "Parcels_RNG" : null, "Parcels_TWP" : null, "Parcels_SEC" : null, "Parcels_SUBD" : null, "Parcels_BLK" : null, "Parcels_LOT" : null, "Parcels_DT_CHG" : null, "propertydata_OID" : null, "propertydata_PCN" : null, "propertydata_ACRES" : null, "propertydata_SITEADDR" : null, "propertydata_OWNERNAME1" : null, "propertydata_OWNERNAME2" : null, "propertydata_EXEMPTION" : null, "propertydata_PADDR1" : null, "propertydata_PADDR2" : null, "propertydata_PADDR3" : null, "propertydata_CITYNAME" : null, "propertydata_STATE" : null, "propertydata_INSTRUMENT" : null, "propertydata_CRA" : null, "propertydata_NBHD" : null, "propertydata_SALEKEY" : null, "propertydata_PROPUSE" : null, "propertydata_AG_USE_VAL" : null, "propertydata_CONFID_FLG" : null, "propertydata_HMSTD_FLG" : null, "propertydata_YEAR_ADDED" : null, "propertydata_SALE_DATE" : null, "propertydata_BOOK" : null, "propertydata_PAGE" : null, "propertydata_STREET_NUM" : null, "propertydata_PRE_DIR" : null, "propertydata_STREETNAME" : null, "propertydata_STREET_SUF" : null, "propertydata_POST_DIR" : null, "propertydata_ZIP1" : null, "propertydata_ZIP2" : null, "propertydata_MUNI" : null, "propertydata_SUBDIVNAM" : null, "propertydata_PRICE" : null, "propertydata_TOTMRKVAL" : null, "propertydata_CAP_ADJVAL" : null, "propertydata_MKT_CAPPED" : null, "propertydata_MKT_NOCAP" : null, "propertydata_ASSESSVAL" : null, "propertydata_LANDVAL" : null, "propertydata_IMPRV_MRKT" : null, "propertydata_TOTALVALUE" : null, "propertydata_TOTTAXVAL" : null, "type" : null, "ModuleName" : null, "CaseID" : null, "CaseNumber" : null, "CaseType" : null, "WorkClass" : null, "ApplicationDate" : null, "ProjectID" : null, "ProjectName" : null, "GISHistoryQueueID" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 9, "name" : "geodata.DBO.TYLER_Zoning_Districts_10", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "FULL_NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652915854, "schemaLastEditDate" : 1521652915854, "dataLastEditDate" : 1521652915854 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943435.28931274638, "ymin" : 883515.11686840653, "xmax" : 972196.5441260786, "ymax" : 902877.36915432662, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[190,210,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_1", "uniqueIdField" : { "name" : "OBJECTID_1", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_1", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZONING", "type" : "esriFieldTypeString", "alias" : "ZONING", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHER", "type" : "esriFieldTypeString", "alias" : "OTHER", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FULL_NAME", "type" : "esriFieldTypeString", "alias" : "FULL_NAME", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATE_", "type" : "esriFieldTypeString", "alias" : "DATE_", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ORDINANCE", "type" : "esriFieldTypeDouble", "alias" : "ORDINANCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Area", "type" : "esriFieldTypeInteger", "alias" : "Area", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape_Leng", "type" : "esriFieldTypeDouble", "alias" : "Shape_Leng", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__E458E6E77F3C2F62", "fields" : "OBJECTID_1", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_ZONING_DISTRICTS_10_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Zoning_Districts_10", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "Area" : null, "Shape_Leng" : null, "OBJECTID" : null, "ID" : null, "ZONING" : null, "OTHER" : null, "FULL_NAME" : null, "DATE_" : null, "ORDINANCE" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 10, "name" : "geodata.DBO.TYLER_Voting_Districts_11", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "DISTRICT", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1613077677579, "schemaLastEditDate" : 1613077677579, "dataLastEditDate" : 1613077677579 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943434.08852774638, "ymin" : 883515.06240656972, "xmax" : 972195.72358966235, "ymax" : 902877.81042640656, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[211,255,190,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISTRICT", "type" : "esriFieldTypeString", "alias" : "DISTRICT", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AT_LARGE_1", "type" : "esriFieldTypeString", "alias" : "AT_LARGE_1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AT_LARGE_2", "type" : "esriFieldTypeString", "alias" : "AT_LARGE_2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D857F1D1C60", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_VOTING_DISTRICTS_11_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_Voting_Districts_11", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "AT_LARGE_1" : null, "AT_LARGE_2" : null, "ID" : null, "DISTRICT" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 11, "name" : "geodata.DBO.TYLER_PSA_Districts_12", "type" : "Feature Layer", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "PSA", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1521652916529, "schemaLastEditDate" : 1521652916529, "dataLastEditDate" : 1521652916529 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 45000, "maxScale" : 1000, "extent" : { "xmin" : 943431.70992358029, "ymin" : 883521.49054332078, "xmax" : 972190.76034499716, "ymax" : 902885.80745765567, "spatialReference" : { "wkid" : 2881, "latestWkid" : 2881 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[232,190,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape_Le_1", "type" : "esriFieldTypeDouble", "alias" : "Shape_Le_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PSA", "type" : "esriFieldTypeString", "alias" : "PSA", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PSA_", "type" : "esriFieldTypeDouble", "alias" : "PSA_", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D85D0F9149E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3616.DATA_MAP_GEODATA_DBO_TYLER_PSA_DISTRICTS_12_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.TYLER_PSA_Districts_12", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "PSA" : null, "PSA_" : null, "OBJECTID_1" : null, "Shape_Le_1" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 12, "name" : "geodata.DBO.Tyler_CondosforParcel_3", "type" : "Table", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "OWNERNAME1", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [ { "id" : 0, "name" : "TYLER_Parcel_3", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CONDO_PCN", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AG_USE_VAL", "type" : "esriFieldTypeString", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRICE", "type" : "esriFieldTypeInteger", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTMRKTVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKTVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDO_PCN", "type" : "esriFieldTypeString", "alias" : "CONDO_PCN", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D857EF476D6", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G6CONDO_PCN", "fields" : "CONDO_PCN", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.Tyler_CondosforParcel_3", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "TOTTAXVAL" : null, "CONDO_PCN" : null, "PCN" : null, "ACRES" : null, "SITEADDR" : null, "OWNERNAME1" : null, "OWNERNAME2" : null, "EXEMPTION" : null, "PADDR1" : null, "PADDR2" : null, "PADDR3" : null, "CITYNAME" : null, "STATE" : null, "INSTRUMENT" : null, "CRA" : null, "NBHD" : null, "SALEKEY" : null, "PROPUSE" : null, "AG_USE_VAL" : null, "CONFID_FLG" : null, "HMSTD_FLG" : null, "YEAR_ADDED" : null, "SALE_DATE" : null, "BOOK" : null, "PAGE" : null, "STREET_NUM" : null, "PRE_DIR" : null, "STREETNAME" : null, "STREET_SUF" : null, "POST_DIR" : null, "ZIP1" : null, "ZIP2" : null, "MUNI" : null, "SUBDIVNAM" : null, "PRICE" : null, "TOTMRKTVAL" : null, "CAP_ADJVAL" : null, "MKT_CAPPED" : null, "MKT_NOCAP" : null, "ASSESSVAL" : null, "LANDVAL" : null, "IMPRV_MRKT" : null, "TOTALVALUE" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 13, "name" : "geodata.DBO.Tyler_CondosforParcel_6", "type" : "Table", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "OWNERNAME1", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [ { "id" : 1, "name" : "TYLER_Parcel_SC_6", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CONDO_PCN", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AG_USE_VAL", "type" : "esriFieldTypeString", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRICE", "type" : "esriFieldTypeInteger", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTMRKTVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKTVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDO_PCN", "type" : "esriFieldTypeString", "alias" : "CONDO_PCN", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D854F66BDD3", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G11CONDO_PCN", "fields" : "CONDO_PCN", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.Tyler_CondosforParcel_6", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "TOTTAXVAL" : null, "CONDO_PCN" : null, "PCN" : null, "ACRES" : null, "SITEADDR" : null, "OWNERNAME1" : null, "OWNERNAME2" : null, "EXEMPTION" : null, "PADDR1" : null, "PADDR2" : null, "PADDR3" : null, "CITYNAME" : null, "STATE" : null, "INSTRUMENT" : null, "CRA" : null, "NBHD" : null, "SALEKEY" : null, "PROPUSE" : null, "AG_USE_VAL" : null, "CONFID_FLG" : null, "HMSTD_FLG" : null, "YEAR_ADDED" : null, "SALE_DATE" : null, "BOOK" : null, "PAGE" : null, "STREET_NUM" : null, "PRE_DIR" : null, "STREETNAME" : null, "STREET_SUF" : null, "POST_DIR" : null, "ZIP1" : null, "ZIP2" : null, "MUNI" : null, "SUBDIVNAM" : null, "PRICE" : null, "TOTMRKTVAL" : null, "CAP_ADJVAL" : null, "MKT_CAPPED" : null, "MKT_NOCAP" : null, "ASSESSVAL" : null, "LANDVAL" : null, "IMPRV_MRKT" : null, "TOTALVALUE" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 14, "name" : "geodata.DBO.Tyler_CondosforParcel_9", "type" : "Table", "serviceItemId" : "58686775f6844282837f8bc1dace020e", "cacheMaxAge" : 30, "displayField" : "OWNERNAME1", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [ { "id" : 2, "name" : "TYLER_Parcel_HW_9", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CONDO_PCN", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PCN", "type" : "esriFieldTypeString", "alias" : "PCN", "sqlType" : "sqlTypeOther", "length" : 17, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SITEADDR", "type" : "esriFieldTypeString", "alias" : "SITEADDR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME1", "type" : "esriFieldTypeString", "alias" : "OWNERNAME1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNERNAME2", "type" : "esriFieldTypeString", "alias" : "OWNERNAME2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EXEMPTION", "type" : "esriFieldTypeString", "alias" : "EXEMPTION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR1", "type" : "esriFieldTypeString", "alias" : "PADDR1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR2", "type" : "esriFieldTypeString", "alias" : "PADDR2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PADDR3", "type" : "esriFieldTypeString", "alias" : "PADDR3", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITYNAME", "type" : "esriFieldTypeString", "alias" : "CITYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATE", "type" : "esriFieldTypeString", "alias" : "STATE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTRUMENT", "type" : "esriFieldTypeString", "alias" : "INSTRUMENT", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CRA", "type" : "esriFieldTypeString", "alias" : "CRA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBHD", "type" : "esriFieldTypeString", "alias" : "NBHD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALEKEY", "type" : "esriFieldTypeDouble", "alias" : "SALEKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROPUSE", "type" : "esriFieldTypeString", "alias" : "PROPUSE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AG_USE_VAL", "type" : "esriFieldTypeString", "alias" : "AG_USE_VAL", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONFID_FLG", "type" : "esriFieldTypeString", "alias" : "CONFID_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMSTD_FLG", "type" : "esriFieldTypeString", "alias" : "HMSTD_FLG", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YEAR_ADDED", "type" : "esriFieldTypeString", "alias" : "YEAR_ADDED", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SALE_DATE", "type" : "esriFieldTypeDate", "alias" : "SALE_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "BOOK", "type" : "esriFieldTypeString", "alias" : "BOOK", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PAGE", "type" : "esriFieldTypeString", "alias" : "PAGE", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_NUM", "type" : "esriFieldTypeDouble", "alias" : "STREET_NUM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRE_DIR", "type" : "esriFieldTypeString", "alias" : "PRE_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET_SUF", "type" : "esriFieldTypeString", "alias" : "STREET_SUF", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POST_DIR", "type" : "esriFieldTypeString", "alias" : "POST_DIR", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP1", "type" : "esriFieldTypeString", "alias" : "ZIP1", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP2", "type" : "esriFieldTypeString", "alias" : "ZIP2", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MUNI", "type" : "esriFieldTypeString", "alias" : "MUNI", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBDIVNAM", "type" : "esriFieldTypeString", "alias" : "SUBDIVNAM", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRICE", "type" : "esriFieldTypeInteger", "alias" : "PRICE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTMRKTVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTMRKTVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAP_ADJVAL", "type" : "esriFieldTypeDouble", "alias" : "CAP_ADJVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_CAPPED", "type" : "esriFieldTypeDouble", "alias" : "MKT_CAPPED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MKT_NOCAP", "type" : "esriFieldTypeDouble", "alias" : "MKT_NOCAP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSESSVAL", "type" : "esriFieldTypeDouble", "alias" : "ASSESSVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LANDVAL", "type" : "esriFieldTypeDouble", "alias" : "LANDVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IMPRV_MRKT", "type" : "esriFieldTypeDouble", "alias" : "IMPRV_MRKT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTALVALUE", "type" : "esriFieldTypeDouble", "alias" : "TOTALVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTTAXVAL", "type" : "esriFieldTypeDouble", "alias" : "TOTTAXVAL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDO_PCN", "type" : "esriFieldTypeString", "alias" : "CONDO_PCN", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DATA_MAP__F4B70D85A7EF248D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G16CONDO_PCN", "fields" : "CONDO_PCN", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "geodata.DBO.Tyler_CondosforParcel_9", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "TOTTAXVAL" : null, "CONDO_PCN" : null, "PCN" : null, "ACRES" : null, "SITEADDR" : null, "OWNERNAME1" : null, "OWNERNAME2" : null, "EXEMPTION" : null, "PADDR1" : null, "PADDR2" : null, "PADDR3" : null, "CITYNAME" : null, "STATE" : null, "INSTRUMENT" : null, "CRA" : null, "NBHD" : null, "SALEKEY" : null, "PROPUSE" : null, "AG_USE_VAL" : null, "CONFID_FLG" : null, "HMSTD_FLG" : null, "YEAR_ADDED" : null, "SALE_DATE" : null, "BOOK" : null, "PAGE" : null, "STREET_NUM" : null, "PRE_DIR" : null, "STREETNAME" : null, "STREET_SUF" : null, "POST_DIR" : null, "ZIP1" : null, "ZIP2" : null, "MUNI" : null, "SUBDIVNAM" : null, "PRICE" : null, "TOTMRKTVAL" : null, "CAP_ADJVAL" : null, "MKT_CAPPED" : null, "MKT_NOCAP" : null, "ASSESSVAL" : null, "LANDVAL" : null, "IMPRV_MRKT" : null, "TOTALVALUE" : null } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }