{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Structures", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 189, 252, 248, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.01913367684E7, "ymin": -10.668099999427795, "xmax": 1.5240000002086163, "ymax": 5932836.9899, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ParcelID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 10, "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "Width", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null }, { "name": "SquareFootage", "type": "esriFieldTypeDouble", "alias": "Square Footage", "domain": null }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "ExpectedStakeDate", "type": "esriFieldTypeDate", "alias": "Expected stake date", "length": 8, "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeInteger", "alias": "Number of bedrooms", "domain": null }, { "name": "InspectionStatus", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 50, "domain": { "type": "codedValue", "name": "InspectionStatus", "description": "Inspection status", "codedValues": [ { "name": "Incomplete Inspection", "code": "Incomplete Inspection" }, { "name": "Inspected", "code": "Inspected" }, { "name": "Needs Inspection", "code": "Needs Inspection" }, { "name": "Survey Required", "code": "Survey Required" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 700, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Connection ID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project Type", "length": 50, "domain": null }, { "name": "ProjectDesp", "type": "esriFieldTypeString", "alias": "Project Description", "length": 500, "domain": null }, { "name": "Stories", "type": "esriFieldTypeString", "alias": "Stories", "length": 10, "domain": null }, { "name": "StoriesDesp", "type": "esriFieldTypeString", "alias": "Stories Description", "length": 500, "domain": null }, { "name": "Structure", "type": "esriFieldTypeString", "alias": "Structure Placed On", "length": 50, "domain": null }, { "name": "StructureDesp", "type": "esriFieldTypeString", "alias": "Structure Placed On Description", "length": 500, "domain": null }, { "name": "Duration", "type": "esriFieldTypeString", "alias": "Duration", "length": 25, "domain": null }, { "name": "Sanitary", "type": "esriFieldTypeString", "alias": "Sanitary on Property", "length": 10, "domain": null }, { "name": "SanitaryType", "type": "esriFieldTypeString", "alias": "Sanitary Type", "length": 50, "domain": null }, { "name": "SanitaryTypeDesp", "type": "esriFieldTypeString", "alias": "Sanitary Type Description", "length": 500, "domain": null }, { "name": "WaterSource", "type": "esriFieldTypeString", "alias": "Water Source", "length": 50, "domain": null }, { "name": "WaterDesp", "type": "esriFieldTypeString", "alias": "Water Source Description", "length": 500, "domain": null }, { "name": "FirstStructure", "type": "esriFieldTypeString", "alias": "First Structure", "length": 10, "domain": null }, { "name": "PropUseCategory", "type": "esriFieldTypeString", "alias": "Use Category", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "Comments2", "type": "esriFieldTypeString", "alias": "Additional Comments", "length": 255, "domain": null }, { "name": "BunkCooking", "type": "esriFieldTypeString", "alias": "Bunk House Cooking", "length": 10, "domain": null }, { "name": "BunkSleeping", "type": "esriFieldTypeString", "alias": "Bunk House Sleeping", "length": 10, "domain": null }, { "name": "BunkSanitary", "type": "esriFieldTypeString", "alias": "Bunk House Sanitary", "length": 10, "domain": null }, { "name": "Manufacture_date", "type": "esriFieldTypeDate", "alias": "Mobile Home Manufacture Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "BunkPlumbing", "type": "esriFieldTypeString", "alias": "BunkPlumbing", "length": 10, "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "OutsideParcelExpl", "type": "esriFieldTypeString", "alias": "Outside Parcel Explanation", "length": 255, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R43_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_43", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I93ConnectID", "fields": "ConnectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S8_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Setbacks", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1E534791-50C9-4A4C-A350-12FE2697A851}" }, { "id": 1, "name": "Permits", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20510730-F078-4D0C-A516-C48BA8622907}" }, { "id": 0, "name": "Components", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A02F6D46-5C56-42CF-9B63-FB3FBC48B9DA}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Components", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 240, 181, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Length", "type": "esriFieldTypeInteger", "alias": "Length", "domain": null }, { "name": "Width", "type": "esriFieldTypeInteger", "alias": "Width", "domain": null }, { "name": "SquareFootage", "type": "esriFieldTypeInteger", "alias": "Square Footage", "domain": null }, { "name": "Height", "type": "esriFieldTypeInteger", "alias": "Height", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Connect ID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R44_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_44", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G94RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Structures", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A02F6D46-5C56-42CF-9B63-FB3FBC48B9DA}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Permit Points", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 173, 111, 57, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.01908902929E7, "ymin": 5809100.7326000035, "xmax": -1.0107159118E7, "ymax": 5923359.052000001, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "structureType", "type": "esriFieldTypeString", "alias": "structureType", "length": 255, "domain": null }, { "name": "relGUID", "type": "esriFieldTypeGUID", "alias": "relGUID", "length": 38, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R45_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_45", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_103_relGUID", "fields": "relGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S10_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "zoning.WEBUSER.Permits", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "relGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DD08E640-8EF6-47E8-A98E-17F3AD2936D8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Fees", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RefundAmount", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "RefundAmount", "type": "esriFieldTypeDouble", "alias": "Refunded amount", "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "FeeType", "type": "esriFieldTypeString", "alias": "Fee Type", "length": 20, "domain": null }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "Fee Amount", "domain": null }, { "name": "DatePaid", "type": "esriFieldTypeDate", "alias": "Date Paid", "length": 8, "domain": null }, { "name": "PaymentMethod", "type": "esriFieldTypeString", "alias": "Payment Method", "length": 50, "domain": null }, { "name": "AmountPaid", "type": "esriFieldTypeDouble", "alias": "Amount Paid", "domain": null } ], "indexes": [ { "name": "R39_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_39", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G88RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Permits", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{971ADA23-4471-4E4C-B6AE-161458C97DD7}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Permits", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OwnerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "Permit number", "length": 50, "domain": null }, { "name": "AppType", "type": "esriFieldTypeString", "alias": "Application Type", "length": 25, "domain": null }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 50, "domain": { "type": "codedValue", "name": "PermitType", "description": "Permit Type", "codedValues": [ { "name": "Land Use", "code": "Land Use" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PermitStatus", "type": "esriFieldTypeString", "alias": "Permit status", "length": 50, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit status", "codedValues": [ { "name": "Administrative Review", "code": "Administrative Review" }, { "name": "Approved for Inspection", "code": "Approved for Inspection" }, { "name": "Approved for Issuance", "code": "Approved for Issuance" }, { "name": "Field Inspection in Progress", "code": "Field Inspection in Progress" }, { "name": "Inspector Application Review", "code": "Inspector Application Review" }, { "name": "Permit Denied", "code": "Permit Denied" }, { "name": "Permit Issued", "code": "Permit Issued" }, { "name": "Permit Revoked", "code": "Permit Revoked" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AppDate", "type": "esriFieldTypeDate", "alias": "Application Date", "length": 8, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "InspectionDate2", "type": "esriFieldTypeDate", "alias": "Second Inspection Date", "length": 8, "domain": null }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date of the Inspection", "length": 8, "domain": null }, { "name": "DateInspected2", "type": "esriFieldTypeDate", "alias": "Second Inspection Date", "length": 8, "domain": null }, { "name": "InspectedBy", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 50, "domain": { "type": "codedValue", "name": "People", "description": "People", "codedValues": [ { "name": "Robert Schierman", "code": "Robert Schierman" }, { "name": "Jennifer Croonborg-Murphy", "code": "Jennifer Croonborg-Murphy" }, { "name": "Josh Rowley", "code": "Josh Rowley" }, { "name": "Mckenzie Slack", "code": "Mckenzie Slack" }, { "name": "Tracy Pooler", "code": "Tracy Pooler" }, { "name": "Scott Galetka", "code": "Scott Galetka" }, { "name": "Erica Meulemans", "code": "Erica Meulemans" }, { "name": "Ruth Hulstrom", "code": "Ruth Hulstrom" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateApproved", "type": "esriFieldTypeDate", "alias": "Date Approved", "length": 8, "domain": null }, { "name": "DateApproved2", "type": "esriFieldTypeDate", "alias": "Second Date Approved", "length": 8, "domain": null }, { "name": "ApprovedBy", "type": "esriFieldTypeString", "alias": "Approved By", "length": 50, "domain": { "type": "codedValue", "name": "People", "description": "People", "codedValues": [ { "name": "Robert Schierman", "code": "Robert Schierman" }, { "name": "Jennifer Croonborg-Murphy", "code": "Jennifer Croonborg-Murphy" }, { "name": "Josh Rowley", "code": "Josh Rowley" }, { "name": "Mckenzie Slack", "code": "Mckenzie Slack" }, { "name": "Tracy Pooler", "code": "Tracy Pooler" }, { "name": "Scott Galetka", "code": "Scott Galetka" }, { "name": "Erica Meulemans", "code": "Erica Meulemans" }, { "name": "Ruth Hulstrom", "code": "Ruth Hulstrom" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateDenied", "type": "esriFieldTypeDate", "alias": "Date Denied", "length": 8, "domain": null }, { "name": "IssuanceDate", "type": "esriFieldTypeDate", "alias": "Date the permit was issued", "length": 8, "domain": null }, { "name": "RefundDate", "type": "esriFieldTypeDate", "alias": "Permit Refund Date", "length": 8, "domain": null }, { "name": "DeadlineDate", "type": "esriFieldTypeDate", "alias": "Deadline Date", "length": 8, "domain": null }, { "name": "DeadlineDate2", "type": "esriFieldTypeDate", "alias": "Second Deadline Date", "length": 8, "domain": null }, { "name": "Citation", "type": "esriFieldTypeString", "alias": "Citation", "length": 10, "domain": null }, { "name": "CitationDate", "type": "esriFieldTypeDate", "alias": "Date of cititation", "length": 8, "domain": null }, { "name": "TownInputDate", "type": "esriFieldTypeDate", "alias": "Town input date", "length": 8, "domain": null }, { "name": "StatePermit", "type": "esriFieldTypeString", "alias": "State permit number", "length": 15, "domain": null }, { "name": "Conditions", "type": "esriFieldTypeString", "alias": "Conditions", "length": 2000, "domain": null }, { "name": "ForDescription", "type": "esriFieldTypeString", "alias": "ForDescription", "length": 255, "domain": null }, { "name": "UserId", "type": "esriFieldTypeString", "alias": "User ID", "length": 25, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 10, "domain": null }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "Owners Name", "length": 255, "domain": null }, { "name": "OwnerFirstName", "type": "esriFieldTypeString", "alias": "OwnerFirstName", "length": 40, "domain": null }, { "name": "OwnerLastName", "type": "esriFieldTypeString", "alias": "OwnerLastName", "length": 100, "domain": null }, { "name": "PropertyAddress", "type": "esriFieldTypeString", "alias": "Property Address", "length": 250, "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "agentId", "type": "esriFieldTypeGUID", "alias": "agentId", "length": 38, "domain": null }, { "name": "ownerId", "type": "esriFieldTypeGUID", "alias": "ownerId", "length": 38, "domain": null }, { "name": "contractorId", "type": "esriFieldTypeGUID", "alias": "contractorId", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Temp Connect ID", "domain": null }, { "name": "AdditionalLegal", "type": "esriFieldTypeString", "alias": "Additional Legal Description", "length": 1000, "domain": null }, { "name": "conversion", "type": "esriFieldTypeString", "alias": "Conversion of of non-residential to residential", "length": 5, "domain": null }, { "name": "CSM", "type": "esriFieldTypeString", "alias": "CSM Number", "length": 25, "domain": null }, { "name": "SiteCityState", "type": "esriFieldTypeString", "alias": "Site City State Zip", "length": 100, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 10, "domain": null }, { "name": "DeededAcres", "type": "esriFieldTypeInteger", "alias": "Deeded Acres", "domain": null }, { "name": "STR", "type": "esriFieldTypeString", "alias": "Section Townhip Range", "length": 15, "domain": null }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 5, "domain": null }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "length": 5, "domain": null }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "length": 5, "domain": null }, { "name": "SanitaryPermitNumber", "type": "esriFieldTypeString", "alias": "Sanitary Permit Number", "length": 25, "domain": null }, { "name": "SignPermitNumber", "type": "esriFieldTypeString", "alias": "Sign Permit Number", "length": 25, "domain": null }, { "name": "SpecialPermitNumber", "type": "esriFieldTypeString", "alias": "Special Permit Number", "length": 25, "domain": null }, { "name": "ConditionalPermitNumber", "type": "esriFieldTypeString", "alias": "Conditional Permit Number", "length": 25, "domain": null }, { "name": "BOAPermitNumber", "type": "esriFieldTypeString", "alias": "BOA Permit Number", "length": 25, "domain": null }, { "name": "VarianceBOA", "type": "esriFieldTypeString", "alias": "Granted by Variance (BOA)", "length": 5, "domain": null }, { "name": "PreviousBOA", "type": "esriFieldTypeString", "alias": "Previously Granted by Variance (BOA)", "length": 5, "domain": null }, { "name": "RevokeReason", "type": "esriFieldTypeString", "alias": "Reason for revocation", "length": 255, "domain": null }, { "name": "Pin", "type": "esriFieldTypeString", "alias": "PIN", "length": 100, "domain": null }, { "name": "Volume", "type": "esriFieldTypeString", "alias": "Volume", "length": 50, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page(s)", "length": 50, "domain": null }, { "name": "govLots", "type": "esriFieldTypeString", "alias": "Govt. Lots", "length": 100, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Lot(s)", "length": 50, "domain": null }, { "name": "Block", "type": "esriFieldTypeString", "alias": "Block", "length": 50, "domain": null }, { "name": "SubdCondo", "type": "esriFieldTypeString", "alias": "Subdivision", "length": 255, "domain": null }, { "name": "quarterQuarter", "type": "esriFieldTypeString", "alias": "1/4, 1/4", "length": 255, "domain": null }, { "name": "SanitaryDate", "type": "esriFieldTypeDate", "alias": "Sanitary Date", "length": 8, "domain": null }, { "name": "MitigationRequired", "type": "esriFieldTypeString", "alias": "Mitigation Required", "length": 5, "domain": null }, { "name": "MitigationAttached", "type": "esriFieldTypeString", "alias": "Mitigation Attached", "length": 5, "domain": null }, { "name": "SubStandard", "type": "esriFieldTypeString", "alias": "Sub-Standard Lot", "length": 5, "domain": null }, { "name": "CommonOwner", "type": "esriFieldTypeString", "alias": "Common Ownership", "length": 5, "domain": null }, { "name": "NonConform", "type": "esriFieldTypeString", "alias": "Non-Conforming", "length": 5, "domain": null }, { "name": "AffidavitRequired", "type": "esriFieldTypeString", "alias": "Affidavit Required", "length": 5, "domain": null }, { "name": "AffidavitAttached", "type": "esriFieldTypeString", "alias": "Affidavit Attached", "length": 5, "domain": null }, { "name": "LegallyCreated", "type": "esriFieldTypeString", "alias": "Parcel Legally Created", "length": 5, "domain": null }, { "name": "Surveyed", "type": "esriFieldTypeString", "alias": "Property Surveyed", "length": 5, "domain": null }, { "name": "ConditionsAttached", "type": "esriFieldTypeString", "alias": "Conditions Attached", "length": 5, "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeString", "alias": "Bedrooms", "length": 2, "domain": null }, { "name": "DeedOfRecord", "type": "esriFieldTypeString", "alias": "Deed of Record", "length": 500, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning District", "length": 5, "domain": null }, { "name": "PreviousBOAPermitNumber", "type": "esriFieldTypeString", "alias": "Previous BOA Permit Number", "length": 25, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "LakesClass", "type": "esriFieldTypeString", "alias": "Lakes Classification", "length": 5, "domain": null }, { "name": "ConstructionCost", "type": "esriFieldTypeDouble", "alias": "ConstructionCost", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1500, "domain": null }, { "name": "ConstCost", "type": "esriFieldTypeDouble", "alias": "Construction Cost", "domain": null }, { "name": "CommonOwnerComments", "type": "esriFieldTypeString", "alias": "Common Ownership Comments", "length": 255, "domain": null }, { "name": "SurveyComments", "type": "esriFieldTypeString", "alias": "Survey Comments", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 50, "domain": null }, { "name": "SanitaryRequired", "type": "esriFieldTypeString", "alias": "SanitaryRequired", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NoSanitaryReqReason", "type": "esriFieldTypeString", "alias": "NoSanitaryReqReason", "length": 50, "domain": { "type": "codedValue", "name": "NoSanitaryReqReason", "description": "NoSanitaryReqReason", "codedValues": [ { "name": "No System on Property", "code": "No System on Property" }, { "name": "No Record on File", "code": "No Record on File" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NoSanitaryReqExplain", "type": "esriFieldTypeString", "alias": "NoSanitaryReqExplain", "length": 1000, "domain": null }, { "name": "IsFloodplainZone", "type": "esriFieldTypeString", "alias": "IsFloodplainZone", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FloodplainZoneName", "type": "esriFieldTypeString", "alias": "FloodplainZoneName", "length": 255, "domain": null }, { "name": "WetlandsOnProperty", "type": "esriFieldTypeString", "alias": "WetlandsOnProperty", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WetlandsGreaterThanTwoAcres", "type": "esriFieldTypeString", "alias": "WetlandsGreaterThanTwoAcres", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SanitaryReqHistory", "type": "esriFieldTypeString", "alias": "SanitaryReqHistory", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R41_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_41", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G90agentId", "fields": "agentId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G90ownerId", "fields": "ownerId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G90RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G90contractorId", "fields": "contractorId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "globalid", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Fees", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{971ADA23-4471-4E4C-B6AE-161458C97DD7}" }, { "id": 3, "name": "zoning.WEBUSER.permitPoints", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DD08E640-8EF6-47E8-A98E-17F3AD2936D8}" }, { "id": 7, "name": "Permits", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "contractorId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0917775C-DFAB-449C-B5C9-1815DFECA983}" }, { "id": 5, "name": "Agents", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "agentId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BDB6493C-F5DB-4632-B641-46D9FC76883C}" }, { "id": 6, "name": "Owners", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ownerId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BEB34BE3-8F6F-4655-A641-B1B190BD3374}" }, { "id": 1, "name": "Structures", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20510730-F078-4D0C-A516-C48BA8622907}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Setbacks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Setback Type", "length": 50, "domain": { "type": "codedValue", "name": "SetbackType", "description": "Setback Type", "codedValues": [ { "name": "Road", "code": "Road" }, { "name": "ROW", "code": "ROW" }, { "name": "Parcel North", "code": "Parcel North" }, { "name": "Parcel West", "code": "Parcel West" }, { "name": "Parcel South", "code": "Parcel South" }, { "name": "Parcel East", "code": "Parcel East" }, { "name": "River", "code": "River" }, { "name": "Bank", "code": "Bank" }, { "name": "Wetland", "code": "Wetland" }, { "name": "Sanitary", "code": "Sanitary" }, { "name": "Well", "code": "Well" }, { "name": "Drainfield", "code": "Drainfield" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InitialMeasurement", "type": "esriFieldTypeDouble", "alias": "Initial Measurement", "domain": null }, { "name": "FinalMeasurement", "type": "esriFieldTypeDouble", "alias": "Final Measurement", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "SetbackStatus", "description": "Setback status", "codedValues": [ { "name": "Confirmed", "code": "Confirmed" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Corrected", "code": "Corrected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Compliance", "type": "esriFieldTypeString", "alias": "Compliance", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Temp Connect ID", "domain": null } ], "indexes": [ { "name": "R36_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_36", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G85RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Structures", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1E534791-50C9-4A4C-A350-12FE2697A851}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Agents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FirstName", "type": "esriFieldTypeString", "alias": "First Name", "length": 20, "domain": null }, { "name": "LastName", "type": "esriFieldTypeString", "alias": "Last Name", "length": 30, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 40, "domain": null }, { "name": "Address2", "type": "esriFieldTypeString", "alias": "Address 2", "length": 40, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 10, "domain": null }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 13, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email Address", "length": 50, "domain": null }, { "name": "AltPhone", "type": "esriFieldTypeString", "alias": "Alternate Phone Number", "length": 25, "domain": null }, { "name": "BusinessName", "type": "esriFieldTypeString", "alias": "Business Name", "length": 100, "domain": null }, { "name": "contactId", "type": "esriFieldTypeString", "alias": "Contact ID", "length": 100, "domain": null }, { "name": "permitId", "type": "esriFieldTypeGUID", "alias": "permitId", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Connect ID", "domain": null }, { "name": "BusiAddress", "type": "esriFieldTypeString", "alias": "Business Address", "length": 50, "domain": null } ], "indexes": [ { "name": "R37_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_37", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I86ConnectID", "fields": "ConnectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Permits", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BDB6493C-F5DB-4632-B641-46D9FC76883C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Contractors", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FirstName", "type": "esriFieldTypeString", "alias": "First Name", "length": 20, "domain": null }, { "name": "LastName", "type": "esriFieldTypeString", "alias": "Last Name", "length": 30, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 40, "domain": null }, { "name": "Address2", "type": "esriFieldTypeString", "alias": "Address 2", "length": 40, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 10, "domain": null }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 13, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email Address", "length": 50, "domain": null }, { "name": "AltAgent", "type": "esriFieldTypeString", "alias": "Agent Business Name", "length": 40, "domain": null }, { "name": "AltName", "type": "esriFieldTypeString", "alias": "Legal Owners from Tax Statement", "length": 150, "domain": null }, { "name": "AltAddress", "type": "esriFieldTypeString", "alias": "Alternate Address", "length": 50, "domain": null }, { "name": "AltPhone", "type": "esriFieldTypeString", "alias": "Alternate Phone Number", "length": 25, "domain": null }, { "name": "AltNameNotListed", "type": "esriFieldTypeString", "alias": "Additional Legal Owners Not Listed", "length": 150, "domain": null }, { "name": "BusinessName", "type": "esriFieldTypeString", "alias": "Business Name", "length": 100, "domain": null }, { "name": "contactId", "type": "esriFieldTypeString", "alias": "Contact ID", "length": 100, "domain": null }, { "name": "permitId", "type": "esriFieldTypeGUID", "alias": "permitId", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Connect ID", "domain": null } ], "indexes": [ { "name": "R38_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_38", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I87ConnectID", "fields": "ConnectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Contractors", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0917775C-DFAB-449C-B5C9-1815DFECA983}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Owners", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FirstName", "type": "esriFieldTypeString", "alias": "First Name", "length": 150, "domain": null }, { "name": "LastName", "type": "esriFieldTypeString", "alias": "Last Name", "length": 150, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 150, "domain": null }, { "name": "Address2", "type": "esriFieldTypeString", "alias": "Address 2", "length": 150, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 10, "domain": null }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 13, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email Address", "length": 50, "domain": null }, { "name": "AltAgent", "type": "esriFieldTypeString", "alias": "Agent Business Name", "length": 150, "domain": null }, { "name": "AltName", "type": "esriFieldTypeString", "alias": "Legal Owners from Tax Statement", "length": 150, "domain": null }, { "name": "AltAddress", "type": "esriFieldTypeString", "alias": "Alternate Address", "length": 150, "domain": null }, { "name": "AltPhone", "type": "esriFieldTypeString", "alias": "Alternate Phone Number", "length": 25, "domain": null }, { "name": "AltNameNotListed", "type": "esriFieldTypeString", "alias": "Additional Legal Owners Not Listed", "length": 150, "domain": null }, { "name": "BusinessName", "type": "esriFieldTypeString", "alias": "Business Name", "length": 100, "domain": null }, { "name": "contactId", "type": "esriFieldTypeString", "alias": "Contact ID", "length": 100, "domain": null }, { "name": "permitId", "type": "esriFieldTypeGUID", "alias": "permitId", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Connect ID", "domain": null } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_40", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I89ConnectID", "fields": "ConnectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Permits", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BEB34BE3-8F6F-4655-A641-B1B190BD3374}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "74e79fb482ee439784fa0f6d096d1311" } ] }