{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "ROW Permits - Points", "type": "Feature Layer", "description": "Right-of-way permits associated with a specific street address. A permit is expected to have only one GIS feature (line or point), but the data may have some anomalies.A permit is required to perform any construction work within the public right-of-way or any construction work outside of the public right-of-way that will cut, break, or otherwise damage the public right-of-way. The authoritative source for permit information is the Right-of-Way Management System (https://rowmanagement.dallascityhall.com/Login.aspx).", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Dallas", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 1, 102, 206, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 255, 255, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2430563.2537443936, "ymin": 6912415.403518811, "xmax": 3320078.214212224, "ymax": 8441728.071921483, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "APPLICANTNAMESTORED", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JOBID", "type": "esriFieldTypeInteger", "alias": "JOBID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "PERMITTYPE", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "COMMERCIALORRESIDENTIAL", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "STATUSDESCRIPTION", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "ISSUEDATE", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "COMPLETEDDATE", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "EXPIRATIONDATE", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "ROWREQUESTEDSTARTDATE", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "ROWESTIMATEDCOMPLETIONDATE", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "WARRANTYEXPIRATION", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "ROWREASONFORJOB", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "ROWIMPROVEMENTREPAIR", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "ROWISEMERGENCYREPAIR", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "SPECIFICLOCATION", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "WORKDESCRIPTION", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTNAMESTORED", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTCOMPANYNAMESTORED", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "ALLCONTRACTORSNAME", "length": 254, "domain": null }, { "name": "LEGEND", "type": "esriFieldTypeSmallInteger", "alias": "LEGEND", "domain": null }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "LOCATIONNAMES", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 18, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "COUNCIL_DISTRICTS", "type": "esriFieldTypeString", "alias": "COUNCIL_DISTRICTS", "length": 40, "domain": null }, { "name": "INSPECTION_DISTRICTS", "type": "esriFieldTypeString", "alias": "INSPECTION_DISTRICTS", "length": 20, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R658_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1525CASEID", "fields": "CASEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1525EXTERNALFIL", "fields": "EXTERNALFILENUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1525JOBID", "fields": "JOBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SIdx_row_permit_points_shape", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "ROW Permits - Lines", "type": "Feature Layer", "description": "Right-of-way-permits that span one or more street blocks. A permit is expected to have only one GIS feature (line or point), but the data may have some anomalies.A permit is required to perform any construction work within the public right-of-way or any construction work outside of the public right-of-way that will cut, break, or otherwise damage the public right-of-way. The authoritative source for permit information is the Right-of-Way Management System (https://rowmanagement.dallascityhall.com/Login.aspx).", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Dallas", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 1, 102, 206, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2430574.4079215527, "ymin": 6912294.154089391, "xmax": 2576680.3693179637, "ymax": 7056797.99467431, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "APPLICANTNAMESTORED", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JOBID", "type": "esriFieldTypeInteger", "alias": "JOBID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "PERMITTYPE", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "COMMERCIALORRESIDENTIAL", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "STATUSDESCRIPTION", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "ISSUEDATE", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "COMPLETEDDATE", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "EXPIRATIONDATE", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "ROWREQUESTEDSTARTDATE", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "ROWESTIMATEDCOMPLETIONDATE", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "WARRANTYEXPIRATION", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "ROWREASONFORJOB", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "ROWIMPROVEMENTREPAIR", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "ROWISEMERGENCYREPAIR", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "SPECIFICLOCATION", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "WORKDESCRIPTION", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTNAMESTORED", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTCOMPANYNAMESTORED", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "ALLCONTRACTORSNAME", "length": 254, "domain": null }, { "name": "LEGEND", "type": "esriFieldTypeSmallInteger", "alias": "LEGEND", "domain": null }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "LOCATIONNAMES", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 18, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "COUNCIL_DISTRICTS", "type": "esriFieldTypeString", "alias": "COUNCIL_DISTRICTS", "length": 40, "domain": null }, { "name": "INSPECTION_DISTRICTS", "type": "esriFieldTypeString", "alias": "INSPECTION_DISTRICTS", "length": 20, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R660_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1527CASEID", "fields": "CASEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1527EXTERNALFIL", "fields": "EXTERNALFILENUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1527JOBID", "fields": "JOBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SIdx_row_permit_lines_shape", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Permit Detail", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EXTERNALFILENUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JOBID", "type": "esriFieldTypeInteger", "alias": "JOBID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "EXTERNALFILENUM", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "PERMITTYPE", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "COMMERCIALORRESIDENTIAL", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "STATUSDESCRIPTION", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "ISSUEDATE", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "COMPLETEDDATE", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "EXPIRATIONDATE", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "ROWREQUESTEDSTARTDATE", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "ROWESTIMATEDCOMPLETIONDATE", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "WARRANTYEXPIRATION", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "ROWREASONFORJOB", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "ROWIMPROVEMENTREPAIR", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "ROWISEMERGENCYREPAIR", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "SPECIFICLOCATION", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "WORKDESCRIPTION", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTNAMESTORED", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "APPLICANTCOMPANYNAMESTORED", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "ALLCONTRACTORSNAME", "length": 254, "domain": null }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "LOCATIONNAMES", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 18, "domain": null }, { "name": "COUNCIL_DISTRICTS", "type": "esriFieldTypeString", "alias": "COUNCIL_DISTRICTS", "length": 40, "domain": null }, { "name": "INSPECTION_DISTRICTS", "type": "esriFieldTypeString", "alias": "INSPECTION_DISTRICTS", "length": 20, "domain": null } ], "indexes": [ { "name": "R662_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1529JOBID", "fields": "JOBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1529CASEID", "fields": "CASEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "Permit Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EXTERNALFILENUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JOBID", "type": "esriFieldTypeInteger", "alias": "JOBID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "EXTERNALFILENUM", "length": 100, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 100, "domain": null }, { "name": "OUTCOME", "type": "esriFieldTypeString", "alias": "OUTCOME", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "length": 8, "domain": null }, { "name": "REQUESTEDDATE", "type": "esriFieldTypeDate", "alias": "REQUESTEDDATE", "length": 8, "domain": null }, { "name": "SCHEDULEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "SCHEDULEDSTARTDATE", "length": 8, "domain": null }, { "name": "DATECOMPLETED", "type": "esriFieldTypeDate", "alias": "DATECOMPLETED", "length": 8, "domain": null }, { "name": "INSPECTORCOMMENTS", "type": "esriFieldTypeString", "alias": "INSPECTORCOMMENTS", "length": 254, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 18, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 18, "domain": null } ], "indexes": [ { "name": "R661_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1528JOBID", "fields": "JOBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1528ID", "fields": "ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1528CASEID", "fields": "CASEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Permit Location", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EXTERNALFILENUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JOBID", "type": "esriFieldTypeInteger", "alias": "JOBID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "EXTERNALFILENUM", "length": 100, "domain": null }, { "name": "HOUSENUM", "type": "esriFieldTypeInteger", "alias": "HOUSENUM", "domain": null }, { "name": "FROMBLOCK", "type": "esriFieldTypeString", "alias": "FROMBLOCK", "length": 50, "domain": null }, { "name": "TOBLOCK", "type": "esriFieldTypeString", "alias": "TOBLOCK", "length": 50, "domain": null }, { "name": "ISBLOCK", "type": "esriFieldTypeString", "alias": "ISBLOCK", "length": 1, "domain": null }, { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "PREFIX", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 100, "domain": null }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "SUFFIX", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": null }, { "name": "LOCATIONNAME", "type": "esriFieldTypeString", "alias": "LOCATIONNAME", "length": 100, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 18, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 18, "domain": null } ], "indexes": [ { "name": "R659_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1526JOBID", "fields": "JOBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1526ID", "fields": "ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1526CASEID", "fields": "CASEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }