{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Sign Permits Need Attention", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OA_ACCOUNT", "type": "esriFieldTypeString", "alias": "OA_ACCOUNT", "length": 80, "domain": null }, { "name": "ACTIVE_PERMIT", "type": "esriFieldTypeString", "alias": "ACTIVE_PERMIT", "length": 1, "domain": null }, { "name": "AMOUNT_RECIEVED_ON_COS", "type": "esriFieldTypeDouble", "alias": "AMOUNT_RECIEVED_ON_COS", "domain": null }, { "name": "ASSIGNED_DISTRICT", "type": "esriFieldTypeString", "alias": "ASSIGNED_DISTRICT", "length": 1, "domain": null }, { "name": "ASSOCIATED_LICENSE", "type": "esriFieldTypeString", "alias": "ASSOCIATED_LICENSE", "length": 30, "domain": null }, { "name": "BUILDING_PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "BUILDING_PERMIT_NUMBER", "length": 12, "domain": null }, { "name": "CHANGEABLE_VARIABLE_MESSAGE", "type": "esriFieldTypeString", "alias": "CHANGEABLE_VARIABLE_MESSAGE", "length": 1, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 50, "domain": null }, { "name": "CONFORMING_SIGN", "type": "esriFieldTypeString", "alias": "CONFORMING_SIGN", "length": 40, "domain": null }, { "name": "COS_PAYMENT_RECEIVED_DATE", "type": "esriFieldTypeDate", "alias": "COS_PAYMENT_RECEIVED_DATE", "length": 8, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 40, "domain": null }, { "name": "DENIED_DATE", "type": "esriFieldTypeDate", "alias": "DENIED_DATE", "length": 8, "domain": null }, { "name": "INVENTORY_DIRECTION", "type": "esriFieldTypeString", "alias": "INVENTORY_DIRECTION", "length": 40, "domain": null }, { "name": "DISTANCE_TOPOFSIGN", "type": "esriFieldTypeString", "alias": "DISTANCE_TOPOFSIGN", "length": 3, "domain": null }, { "name": "DISTANCE_TO_ROAD", "type": "esriFieldTypeString", "alias": "DISTANCE_TO_ROAD", "length": 50, "domain": null }, { "name": "DISTRICT_ENGINEER", "type": "esriFieldTypeString", "alias": "DISTRICT_ENGINEER", "length": 50, "domain": null }, { "name": "ELECTRICAL_HOOKUP_ATTACHED", "type": "esriFieldTypeString", "alias": "ELECTRICAL_HOOKUP_ATTACHED", "length": 40, "domain": null }, { "name": "FIELD_INSPECTION", "type": "esriFieldTypeString", "alias": "FIELD_INSPECTION", "length": 30, "domain": null }, { "name": "LATLNG", "type": "esriFieldTypeString", "alias": "LATLNG", "length": 40, "domain": null }, { "name": "GROUP_ID_C_SHABOX1", "type": "esriFieldTypeString", "alias": "GROUP_ID_C_SHABOX1", "length": 20, "domain": null }, { "name": "GROUP_ID", "type": "esriFieldTypeString", "alias": "GROUP_ID", "length": 25, "domain": null }, { "name": "ID_SHABOX1", "type": "esriFieldTypeString", "alias": "ID_SHABOX1", "length": 20, "domain": null }, { "name": "INACTIVE_DATE", "type": "esriFieldTypeDate", "alias": "INACTIVE_DATE", "length": 8, "domain": null }, { "name": "ILLUMINATION", "type": "esriFieldTypeString", "alias": "ILLUMINATION", "length": 40, "domain": null }, { "name": "IS_ON_NATIONAL_HIGHWAY_SYSTEM", "type": "esriFieldTypeString", "alias": "IS_ON_NATIONAL_HIGHWAY_SYSTEM", "length": 40, "domain": null }, { "name": "IS_ON_SCENIC_BYWAY", "type": "esriFieldTypeString", "alias": "IS_ON_SCENIC_BYWAY", "length": 40, "domain": null }, { "name": "LAND_OWNER", "type": "esriFieldTypeString", "alias": "LAND_OWNER", "length": 34, "domain": null }, { "name": "LAND_OWNER_ADDRESS", "type": "esriFieldTypeString", "alias": "LAND_OWNER_ADDRESS", "length": 34, "domain": null }, { "name": "LAND_OWNER_CITY", "type": "esriFieldTypeString", "alias": "LAND_OWNER_CITY", "length": 18, "domain": null }, { "name": "LAND_OWNER_STATE", "type": "esriFieldTypeString", "alias": "LAND_OWNER_STATE", "length": 2, "domain": null }, { "name": "LAND_OWNER_TELEPHONE", "type": "esriFieldTypeString", "alias": "LAND_OWNER_TELEPHONE", "length": 50, "domain": null }, { "name": "LAND_OWNER_ZIP", "type": "esriFieldTypeString", "alias": "LAND_OWNER_ZIP", "length": 5, "domain": null }, { "name": "LAND_OWNER_ZIP2", "type": "esriFieldTypeString", "alias": "LAND_OWNER_ZIP2", "length": 5, "domain": null }, { "name": "LATE_FEE", "type": "esriFieldTypeDouble", "alias": "LATE_FEE", "domain": null }, { "name": "LATE_PERMIT_FEE", "type": "esriFieldTypeString", "alias": "LATE_PERMIT_FEE", "length": 1, "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeString", "alias": "LATITUDE", "length": 100, "domain": null }, { "name": "LOG_MILE_POINT", "type": "esriFieldTypeString", "alias": "LOG_MILE_POINT", "length": 50, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeString", "alias": "LONGITUDE", "length": 100, "domain": null }, { "name": "MAP_GRID", "type": "esriFieldTypeString", "alias": "MAP_GRID", "length": 5, "domain": null }, { "name": "PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "PERMIT_NUMBER", "length": 5, "domain": null }, { "name": "MS_ACCESS_ACCOUNT_NUMBER", "type": "esriFieldTypeString", "alias": "MS_ACCESS_ACCOUNT_NUMBER", "length": 20, "domain": null }, { "name": "NOT_PAID_DATE", "type": "esriFieldTypeDate", "alias": "NOT_PAID_DATE", "length": 8, "domain": null }, { "name": "NUMBER_POSTS_POLES", "type": "esriFieldTypeBigInteger", "alias": "NUMBER_POSTS_POLES", "domain": null }, { "name": "OLD_PERMIT", "type": "esriFieldTypeString", "alias": "OLD_PERMIT", "length": 80, "domain": null }, { "name": "ORIGINAL_PERMIT_DATE", "type": "esriFieldTypeDate", "alias": "ORIGINAL_PERMIT_DATE", "length": 8, "domain": null }, { "name": "PARCEL_NO", "type": "esriFieldTypeString", "alias": "PARCEL_NO", "length": 6, "domain": null }, { "name": "PAYMENT_REQUEST_SENT_DATE", "type": "esriFieldTypeDate", "alias": "PAYMENT_REQUEST_SENT_DATE", "length": 8, "domain": null }, { "name": "PAYMENT_UPDATED_DATE", "type": "esriFieldTypeDate", "alias": "PAYMENT_UPDATED_DATE", "length": 8, "domain": null }, { "name": "PERMIT_DATE", "type": "esriFieldTypeDate", "alias": "PERMIT_DATE", "length": 8, "domain": null }, { "name": "PERMIT_COLOR", "type": "esriFieldTypeString", "alias": "PERMIT_COLOR", "length": 40, "domain": null }, { "name": "PERMIT_FEE", "type": "esriFieldTypeDouble", "alias": "PERMIT_FEE", "domain": null }, { "name": "PERMIT_ORIGIN_TYPE", "type": "esriFieldTypeString", "alias": "PERMIT_ORIGIN_TYPE", "length": 50, "domain": null }, { "name": "PERMIT_REMARKS", "type": "esriFieldTypeString", "alias": "PERMIT_REMARKS", "length": 55, "domain": null }, { "name": "PERMIT_STATUS", "type": "esriFieldTypeString", "alias": "PERMIT_STATUS", "length": 40, "domain": null }, { "name": "PERMITTAG_NUMBERS_ISSUED", "type": "esriFieldTypeBigInteger", "alias": "PERMITTAG_NUMBERS_ISSUED", "domain": null }, { "name": "PROCESS_INVOICE", "type": "esriFieldTypeString", "alias": "PROCESS_INVOICE", "length": 1, "domain": null }, { "name": "ZONING_CODE", "type": "esriFieldTypeString", "alias": "ZONING_CODE", "length": 40, "domain": null }, { "name": "PRORATE", "type": "esriFieldTypeString", "alias": "PRORATE", "length": 1, "domain": null }, { "name": "RENEW_DATE", "type": "esriFieldTypeDate", "alias": "RENEW_DATE", "length": 8, "domain": null }, { "name": "ROAD_TYPE", "type": "esriFieldTypeString", "alias": "ROAD_TYPE", "length": 40, "domain": null }, { "name": "STATE_ROUTE_NUMBER", "type": "esriFieldTypeString", "alias": "STATE_ROUTE_NUMBER", "length": 10, "domain": null }, { "name": "SELECT_FOR_PRINTING", "type": "esriFieldTypeString", "alias": "SELECT_FOR_PRINTING", "length": 1, "domain": null }, { "name": "SIGN_CLASSIFICATION", "type": "esriFieldTypeString", "alias": "SIGN_CLASSIFICATION", "length": 40, "domain": null }, { "name": "SIGN_HEIGHT", "type": "esriFieldTypeDouble", "alias": "SIGN_HEIGHT", "domain": null }, { "name": "SIGN_LENGTH", "type": "esriFieldTypeDouble", "alias": "SIGN_LENGTH", "domain": null }, { "name": "SIGN_LOCATION", "type": "esriFieldTypeString", "alias": "SIGN_LOCATION", "length": 63, "domain": null }, { "name": "SIGN_MATERIAL", "type": "esriFieldTypeString", "alias": "SIGN_MATERIAL", "length": 40, "domain": null }, { "name": "SIGN_PHOTOGRAPH", "type": "esriFieldTypeString", "alias": "SIGN_PHOTOGRAPH", "length": 1024, "domain": null }, { "name": "SUPPORT_MATERIAL", "type": "esriFieldTypeString", "alias": "SUPPORT_MATERIAL", "length": 40, "domain": null }, { "name": "SIGN_TOTAL_SQUARE_FEET", "type": "esriFieldTypeDouble", "alias": "SIGN_TOTAL_SQUARE_FEET", "domain": null }, { "name": "SIGN_TYPE", "type": "esriFieldTypeString", "alias": "SIGN_TYPE", "length": 255, "domain": null }, { "name": "UPDATE_SEQUENCE", "type": "esriFieldTypeBigInteger", "alias": "UPDATE_SEQUENCE", "domain": null }, { "name": "TAX_MAP_NUMBER", "type": "esriFieldTypeString", "alias": "TAX_MAP_NUMBER", "length": 6, "domain": null }, { "name": "TYPE_OF_ILLUMINATION", "type": "esriFieldTypeString", "alias": "TYPE_OF_ILLUMINATION", "length": 40, "domain": null }, { "name": "VERIFY_PERMIT", "type": "esriFieldTypeString", "alias": "VERIFY_PERMIT", "length": 1, "domain": null }, { "name": "MS_ACCESS_ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "MS_ACCESS_ACCOUNT_ID", "domain": null }, { "name": "MS_ACCESS_PERMIT_ID", "type": "esriFieldTypeDouble", "alias": "MS_ACCESS_PERMIT_ID", "domain": null }, { "name": "SIGN_IMAGE", "type": "esriFieldTypeString", "alias": "SIGN_IMAGE", "length": 1024, "domain": null }, { "name": "MS_ACCESS_OLD_PERMIT_NAME", "type": "esriFieldTypeString", "alias": "MS_ACCESS_OLD_PERMIT_NAME", "length": 20, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 18, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 80, "domain": null }, { "name": "LAST_MODIFIED_BY", "type": "esriFieldTypeString", "alias": "LAST_MODIFIED_BY", "length": 80, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "length": 80, "domain": null }, { "name": "LAST_MODIFIED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_MODIFIED_DATE", "length": 8, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "IMAGE_LOCATION", "type": "esriFieldTypeString", "alias": "IMAGE_LOCATION", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }