{ "layers": [ { "currentVersion": 10.61, "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 }, "copyrightText": "City of Dallas", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 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 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2430563.2537443936, "ymin": 6912415.403518811, "xmax": 3320078.214212224, "ymax": 8441728.071921483, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "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": "Job ID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "Permit Business Type", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "Permit Status", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "Issue Date", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "Requested Start Date", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Estimated Completion Date", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "Warranty Expiration Date", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "Reason for Job", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "Improvements/Repairs", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "Emergency Repair Activity", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "Specific Location", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "Work Description", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Representative Name", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Company Name", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "Contractor Names", "length": 254, "domain": null }, { "name": "LEGEND", "type": "esriFieldTypeSmallInteger", "alias": "Map Legend", "domain": { "type": "codedValue", "name": "ROW_PERMIT_MAP_LEGEND", "description": "Right-of-Way Permit Map Legend", "codedValues": [ { "name": "Issued", "code": 1 }, { "name": "In Warranty", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "Location Names", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "Case ID", "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": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.61, "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 }, "copyrightText": "City of Dallas", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 1, 102, 206, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2430574.4079215527, "ymin": 6912294.154089391, "xmax": 2576680.3693179637, "ymax": 7056797.99467431, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "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": "Job ID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "Permit Business Type", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "Permit Status", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "Issue Date", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "Requested Start Date", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Estimated Completion Date", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "Warranty Expiration Date", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "Reason for Job", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "Improvements/Repairs", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "Emergency Repair Activity", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "Specific Location", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "Work Description", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Representative Name", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Company Name", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "Contractor Names", "length": 254, "domain": null }, { "name": "LEGEND", "type": "esriFieldTypeSmallInteger", "alias": "Map Legend", "domain": { "type": "codedValue", "name": "ROW_PERMIT_MAP_LEGEND", "description": "Right-of-Way Permit Map Legend", "codedValues": [ { "name": "Issued", "code": 1 }, { "name": "In Warranty", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "Location Names", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "Case ID", "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 }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "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": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.61, "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": "Job ID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit ID", "length": 100, "domain": null }, { "name": "PERMITTYPE", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 100, "domain": null }, { "name": "COMMERCIALORRESIDENTIAL", "type": "esriFieldTypeString", "alias": "Permit Business Type", "length": 50, "domain": null }, { "name": "STATUSDESCRIPTION", "type": "esriFieldTypeString", "alias": "Permit Status", "length": 50, "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "ISSUEDATE", "type": "esriFieldTypeDate", "alias": "Issue Date", "length": 8, "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "ROWREQUESTEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "Requested Start Date", "length": 8, "domain": null }, { "name": "ROWESTIMATEDCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Estimated Completion Date", "length": 8, "domain": null }, { "name": "WARRANTYEXPIRATION", "type": "esriFieldTypeDate", "alias": "Warranty Expiration Date", "length": 8, "domain": null }, { "name": "ROWREASONFORJOB", "type": "esriFieldTypeString", "alias": "Reason for Job", "length": 255, "domain": null }, { "name": "ROWIMPROVEMENTREPAIR", "type": "esriFieldTypeString", "alias": "Improvements/Repairs", "length": 50, "domain": null }, { "name": "ROWISEMERGENCYREPAIR", "type": "esriFieldTypeString", "alias": "Emergency Repair Activity", "length": 50, "domain": null }, { "name": "SPECIFICLOCATION", "type": "esriFieldTypeString", "alias": "Specific Location", "length": 254, "domain": null }, { "name": "WORKDESCRIPTION", "type": "esriFieldTypeString", "alias": "Work Description", "length": 254, "domain": null }, { "name": "APPLICANTNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Representative Name", "length": 100, "domain": null }, { "name": "APPLICANTCOMPANYNAMESTORED", "type": "esriFieldTypeString", "alias": "Owners Company Name", "length": 100, "domain": null }, { "name": "ALLCONTRACTORSNAME", "type": "esriFieldTypeString", "alias": "Contractor Names", "length": 254, "domain": null }, { "name": "LOCATIONNAMES", "type": "esriFieldTypeString", "alias": "Location Names", "length": 254, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "Case ID", "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": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.61, "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": "Job ID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit ID", "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": "Created Date", "length": 8, "domain": null }, { "name": "REQUESTEDDATE", "type": "esriFieldTypeDate", "alias": "Requested Date", "length": 8, "domain": null }, { "name": "SCHEDULEDSTARTDATE", "type": "esriFieldTypeDate", "alias": "Scheduled Start Date", "length": 8, "domain": null }, { "name": "DATECOMPLETED", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "INSPECTORCOMMENTS", "type": "esriFieldTypeString", "alias": "Inspector Comments", "length": 254, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "Inspection ID", "length": 18, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "Case ID", "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": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.61, "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": "Job ID", "domain": null }, { "name": "EXTERNALFILENUM", "type": "esriFieldTypeString", "alias": "Permit ID", "length": 100, "domain": null }, { "name": "HOUSENUM", "type": "esriFieldTypeInteger", "alias": "House Number", "domain": null }, { "name": "FROMBLOCK", "type": "esriFieldTypeString", "alias": "From Block", "length": 50, "domain": null }, { "name": "TOBLOCK", "type": "esriFieldTypeString", "alias": "To Block", "length": 50, "domain": null }, { "name": "ISBLOCK", "type": "esriFieldTypeString", "alias": "Is Block", "length": 1, "domain": null }, { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "Street Prefix", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 100, "domain": null }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "Street Suffix", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Street Type", "length": 50, "domain": null }, { "name": "LOCATIONNAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 100, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "Location ID", "length": 18, "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "Case ID", "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": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } } ] }