Name: Sign Permits Need Attention

Display Field: NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OA_ACCOUNT ( type: esriFieldTypeString, alias: OA_ACCOUNT, length: 80 )
• ACTIVE_PERMIT ( type: esriFieldTypeString, alias: ACTIVE_PERMIT, length: 1 )
• AMOUNT_RECIEVED_ON_COS ( type: esriFieldTypeDouble, alias: AMOUNT_RECIEVED_ON_COS )
• ASSIGNED_DISTRICT ( type: esriFieldTypeString, alias: ASSIGNED_DISTRICT, length: 1 )
• ASSOCIATED_LICENSE ( type: esriFieldTypeString, alias: ASSOCIATED_LICENSE, length: 30 )
• BUILDING_PERMIT_NUMBER ( type: esriFieldTypeString, alias: BUILDING_PERMIT_NUMBER, length: 12 )
• CHANGEABLE_VARIABLE_MESSAGE ( type: esriFieldTypeString, alias: CHANGEABLE_VARIABLE_MESSAGE, length: 1 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• CONFORMING_SIGN ( type: esriFieldTypeString, alias: CONFORMING_SIGN, length: 40 )
• COS_PAYMENT_RECEIVED_DATE ( type: esriFieldTypeDate, alias: COS_PAYMENT_RECEIVED_DATE, length: 8 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 40 )
• DENIED_DATE ( type: esriFieldTypeDate, alias: DENIED_DATE, length: 8 )
• INVENTORY_DIRECTION ( type: esriFieldTypeString, alias: INVENTORY_DIRECTION, length: 40 )
• DISTANCE_TOPOFSIGN ( type: esriFieldTypeString, alias: DISTANCE_TOPOFSIGN, length: 3 )
• DISTANCE_TO_ROAD ( type: esriFieldTypeString, alias: DISTANCE_TO_ROAD, length: 50 )
• DISTRICT_ENGINEER ( type: esriFieldTypeString, alias: DISTRICT_ENGINEER, length: 50 )
• ELECTRICAL_HOOKUP_ATTACHED ( type: esriFieldTypeString, alias: ELECTRICAL_HOOKUP_ATTACHED, length: 40 )
• FIELD_INSPECTION ( type: esriFieldTypeString, alias: FIELD_INSPECTION, length: 30 )
• LATLNG ( type: esriFieldTypeString, alias: LATLNG, length: 40 )
• GROUP_ID_C_SHABOX1 ( type: esriFieldTypeString, alias: GROUP_ID_C_SHABOX1, length: 20 )
• GROUP_ID ( type: esriFieldTypeString, alias: GROUP_ID, length: 25 )
• ID_SHABOX1 ( type: esriFieldTypeString, alias: ID_SHABOX1, length: 20 )
• INACTIVE_DATE ( type: esriFieldTypeDate, alias: INACTIVE_DATE, length: 8 )
• ILLUMINATION ( type: esriFieldTypeString, alias: ILLUMINATION, length: 40 )
• IS_ON_NATIONAL_HIGHWAY_SYSTEM ( type: esriFieldTypeString, alias: IS_ON_NATIONAL_HIGHWAY_SYSTEM, length: 40 )
• IS_ON_SCENIC_BYWAY ( type: esriFieldTypeString, alias: IS_ON_SCENIC_BYWAY, length: 40 )
• LAND_OWNER ( type: esriFieldTypeString, alias: LAND_OWNER, length: 34 )
• LAND_OWNER_ADDRESS ( type: esriFieldTypeString, alias: LAND_OWNER_ADDRESS, length: 34 )
• LAND_OWNER_CITY ( type: esriFieldTypeString, alias: LAND_OWNER_CITY, length: 18 )
• LAND_OWNER_STATE ( type: esriFieldTypeString, alias: LAND_OWNER_STATE, length: 2 )
• LAND_OWNER_TELEPHONE ( type: esriFieldTypeString, alias: LAND_OWNER_TELEPHONE, length: 50 )
• LAND_OWNER_ZIP ( type: esriFieldTypeString, alias: LAND_OWNER_ZIP, length: 5 )
• LAND_OWNER_ZIP2 ( type: esriFieldTypeString, alias: LAND_OWNER_ZIP2, length: 5 )
• LATE_FEE ( type: esriFieldTypeDouble, alias: LATE_FEE )
• LATE_PERMIT_FEE ( type: esriFieldTypeString, alias: LATE_PERMIT_FEE, length: 1 )
• LATITUDE ( type: esriFieldTypeString, alias: LATITUDE, length: 100 )
• LOG_MILE_POINT ( type: esriFieldTypeString, alias: LOG_MILE_POINT, length: 50 )
• LONGITUDE ( type: esriFieldTypeString, alias: LONGITUDE, length: 100 )
• MAP_GRID ( type: esriFieldTypeString, alias: MAP_GRID, length: 5 )
• PERMIT_NUMBER ( type: esriFieldTypeString, alias: PERMIT_NUMBER, length: 5 )
• MS_ACCESS_ACCOUNT_NUMBER ( type: esriFieldTypeString, alias: MS_ACCESS_ACCOUNT_NUMBER, length: 20 )
• NOT_PAID_DATE ( type: esriFieldTypeDate, alias: NOT_PAID_DATE, length: 8 )
• NUMBER_POSTS_POLES ( type: esriFieldTypeBigInteger, alias: NUMBER_POSTS_POLES )
• OLD_PERMIT ( type: esriFieldTypeString, alias: OLD_PERMIT, length: 80 )
• ORIGINAL_PERMIT_DATE ( type: esriFieldTypeDate, alias: ORIGINAL_PERMIT_DATE, length: 8 )
• PARCEL_NO ( type: esriFieldTypeString, alias: PARCEL_NO, length: 6 )
• PAYMENT_REQUEST_SENT_DATE ( type: esriFieldTypeDate, alias: PAYMENT_REQUEST_SENT_DATE, length: 8 )
• PAYMENT_UPDATED_DATE ( type: esriFieldTypeDate, alias: PAYMENT_UPDATED_DATE, length: 8 )
• PERMIT_DATE ( type: esriFieldTypeDate, alias: PERMIT_DATE, length: 8 )
• PERMIT_COLOR ( type: esriFieldTypeString, alias: PERMIT_COLOR, length: 40 )
• PERMIT_FEE ( type: esriFieldTypeDouble, alias: PERMIT_FEE )
• PERMIT_ORIGIN_TYPE ( type: esriFieldTypeString, alias: PERMIT_ORIGIN_TYPE, length: 50 )
• PERMIT_REMARKS ( type: esriFieldTypeString, alias: PERMIT_REMARKS, length: 55 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 40 )
• PERMITTAG_NUMBERS_ISSUED ( type: esriFieldTypeBigInteger, alias: PERMITTAG_NUMBERS_ISSUED )
• PROCESS_INVOICE ( type: esriFieldTypeString, alias: PROCESS_INVOICE, length: 1 )
• ZONING_CODE ( type: esriFieldTypeString, alias: ZONING_CODE, length: 40 )
• PRORATE ( type: esriFieldTypeString, alias: PRORATE, length: 1 )
• RENEW_DATE ( type: esriFieldTypeDate, alias: RENEW_DATE, length: 8 )
• ROAD_TYPE ( type: esriFieldTypeString, alias: ROAD_TYPE, length: 40 )
• STATE_ROUTE_NUMBER ( type: esriFieldTypeString, alias: STATE_ROUTE_NUMBER, length: 10 )
• SELECT_FOR_PRINTING ( type: esriFieldTypeString, alias: SELECT_FOR_PRINTING, length: 1 )
• SIGN_CLASSIFICATION ( type: esriFieldTypeString, alias: SIGN_CLASSIFICATION, length: 40 )
• SIGN_HEIGHT ( type: esriFieldTypeDouble, alias: SIGN_HEIGHT )
• SIGN_LENGTH ( type: esriFieldTypeDouble, alias: SIGN_LENGTH )
• SIGN_LOCATION ( type: esriFieldTypeString, alias: SIGN_LOCATION, length: 63 )
• SIGN_MATERIAL ( type: esriFieldTypeString, alias: SIGN_MATERIAL, length: 40 )
• SIGN_PHOTOGRAPH ( type: esriFieldTypeString, alias: SIGN_PHOTOGRAPH, length: 1024 )
• SUPPORT_MATERIAL ( type: esriFieldTypeString, alias: SUPPORT_MATERIAL, length: 40 )
• SIGN_TOTAL_SQUARE_FEET ( type: esriFieldTypeDouble, alias: SIGN_TOTAL_SQUARE_FEET )
• SIGN_TYPE ( type: esriFieldTypeString, alias: SIGN_TYPE, length: 255 )
• UPDATE_SEQUENCE ( type: esriFieldTypeBigInteger, alias: UPDATE_SEQUENCE )
• TAX_MAP_NUMBER ( type: esriFieldTypeString, alias: TAX_MAP_NUMBER, length: 6 )
• TYPE_OF_ILLUMINATION ( type: esriFieldTypeString, alias: TYPE_OF_ILLUMINATION, length: 40 )
• VERIFY_PERMIT ( type: esriFieldTypeString, alias: VERIFY_PERMIT, length: 1 )
• MS_ACCESS_ACCOUNT_ID ( type: esriFieldTypeDouble, alias: MS_ACCESS_ACCOUNT_ID )
• MS_ACCESS_PERMIT_ID ( type: esriFieldTypeDouble, alias: MS_ACCESS_PERMIT_ID )
• SIGN_IMAGE ( type: esriFieldTypeString, alias: SIGN_IMAGE, length: 1024 )
• MS_ACCESS_OLD_PERMIT_NAME ( type: esriFieldTypeString, alias: MS_ACCESS_OLD_PERMIT_NAME, length: 20 )
• ID ( type: esriFieldTypeString, alias: ID, length: 18 )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 80 )
• LAST_MODIFIED_BY ( type: esriFieldTypeString, alias: LAST_MODIFIED_BY, length: 80 )
• CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, length: 80 )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• IMAGE_LOCATION ( type: esriFieldTypeString, alias: IMAGE_LOCATION, length: 255 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata