Layer: ROW Maintenance (ID:6)

View In: Map Viewer

Name: ROW Maintenance

Display Field: UNITID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Fields | Alias | Description or PurposeOBJECTID OBJECTID Field is controlled by Esri logic and is unique within the table.UNITID Unit ID The Unit ID represents what street you are on.UNITID2 Unit ID 2 The Unit ID 2 represents the sectional number of the street. They increment in numerals of 10.COMPTYPE Comptype Required by IPS, hardcoded to 68. This is necessary for syncing GIS to IPS via Geoadmin.COMPKEY Compkey Required by IPS populated by GeoAdministrator extension. This number must not be tampered with.UNITDESC Street Description Describe the asset.From_ID From ID The From ID represents the start point of the Street Segment.FROM_DESC From Description From Street DescriptionTO_ID To ID Unit ID the repres to End point of the Street Segment.TO_DESC To Description To Street Description.FRSTKEY From Street Key Compkey that correlates to the From_ID.TOSTKEY To Street Key Compkey that correlates to the TO_ID.SURFTYPE Surface Type The material the Street Segment is made of. This field has a domain of possible IPS accepted values.SURFWID Width Width of the street surface.SURFDPTH Depth Depth of the surface.SEGLEN Length Length of the street segment.SEGLENUOM Length Unit of Measure Unit of Measure for the length of the segment. This field has a domain of possible IPS accepted values.SURFWIDUOM Width Unit of Measure Unit of Measure for the width of the segment. This field has a domain of possible IPS accepted values.SURFDPTHMUOM Depth Unit of Measure Unit of Measure for the Depth of the segment. This field has a domain of possible IPS accepted values.SCHOOLZONE School Zone Is there a school zone present? This field has a domain of possible IPS accepted values.EVACUATIONROUTE Evacuation Route Is this Street Segment a part of an evacuation route?BUSROUTE Bus Route Are there bus routes on the Street Segment? This field has a domain of possible IPS accepted values.AREASIZE Area Size The area size of the Street Segment.AREAUOM Area Unit of measure Unit of Measure for the area of the Street Segment. This field has a domain of possible IPS accepted values.NUMPARK Number of Parking/Curb Stops The total number of parking/curb stops.CURBEXIST Is there a curb? Establishes if a curb is present. This field has a domain of possible IPS accepted values.CURBLEN Curb Length Length of Curb, if known.CURBQTY Curb Quantity Quantity of Curb, if known.SHOULDER Shoulder Is there a Shoulder? This is a dropdown value. (Paved, Unpaved, None). This field has a domain of possible IPS accepted values.BICYCLELANE Bicycle Lane Is there a Bicycle Lane? (Yes / No / Buffered). This field has a domain of possible IPS accepted values.ASPHALTDEC Is the asphalt decorative? Yes or No.FEDERALAID Federal Aid Federal Aid entity associated with the Street Segment. This field has a domain of possible IPS accepted values.RESOLUTION Resolution Resolution value.FAILINGLOS Failing LOS Yes or No.ACCESSCLASS Access Class Access classification. This field has a domain of possible IPS accepted values.LANDSCAPE Is there landscape? Yes or no value whether there is a landscape asset associated to the Street Segment.XWALKTYPE1 Crosswalk Type 1 Type of crosswalk. This field has a domain of possible IPS accepted values.XWALKTYPE2 Crosswalk Type 2 Type of crosswalk. This field has a domain of possible IPS accepted values.XWALKSURF Crosswalk Surface Type of surface the crosswalk is. This field has a domain of possible IPS accepted values.LANETYPE1 Lane Type 1 What the lane is used for. This field has a domain of possible IPS accepted values.LANEQTY1 Lane 1 Quantity Number of lanes.LANETYPE2 Lane Type 2 What the lane is used for. This field has a domain of possible IPS accepted values.LANEQTY2 Lane 2 Quantity Number of lanes.LANETYPE3 Lane Type 3 What the lane is used for. This field has a domain of possible IPS accepted values.LANEQTY3 Lane 3 Quantity Number of lanes.LANETYPE4 Lane Type 4 What the lane is used for. This field has a domain of possible IPS accepted values.LANEQTY4 Lane 4 Quantity Number of lanes.LANETYPE5 Lane Type 5 What the lane is used for. This field has a domain of possible IPS accepted values.LANEQTY5 Lane 5 Quantity Number of lanes.PARKSPACETYPE1 Parking Space Type 1 The type of Parking Space that a vehicle can occupy. This field has a domain of possible IPS accepted values.PARKSPACEQTY1 Parking Space 1 Quantity The total number of parking spaces.PARKSPACETYPE2 Parking Space Type 2 The type of Parking Space that a vehicle can occupy. This field has a domain of possible IPS accepted values.PARKSPACEQTY2 Parking Space 2 Quantity The total number of parking spaces.PARKSPACETYPE3 Parking Space Type 3 The type of Parking Space that a vehicle can occupy. This field has a domain of possible IPS accepted values.PARKSPACEQTY3 Parking Space 3 Quantity The total number of parking spaces.PARKSPACETYPE4 Parking Space Type 4 The type of Parking Space that a vehicle can occupy. This field has a domain of possible IPS accepted values.PARKSPACEQTY4 Parking Space 4 Quantity The total number of parking spaces.STKEY Street Key TOKEY,FROMKEY Street Key for the Street Segment.SPEEDLIMIT Speed Limit The posted speed limit associated for the Street Segment.SPECINST Comments Free-form field to further describe the Street Segment.MOSQUITOS Is it treated for Mosquitos? Yes or No value as to whether the Street Segment gets mosquito treated.ADDRKEY Address Key value from CAS, this should associate to the closest relevant address point.ADDRQUAL Location Free-form field allows further description of the physical location of the asset.CRAAREA CRA Area Community Redevelopment Area. This value is self-populated from SQL Trigger. If not available it will remain null. This field has a domain of possible IPS accepted values.DISTRICT District The county district. This value is self-populated from SQL Trigger. If not available it will remain null. This field has a domain of possible IPS accepted values.UNITTYPE Classifcation Identification code for the type of Street Segment. This field has a domain of possible IPS accepted values.INSTDATE Installed Date Provide value if construction date is known.SERVSTAT Service Status Operational status of the Traffic Count Station. This field has a domain of possible IPS accepted values.OWN Ownership Ownership Entity that owns the asset. If the asset is county owned it will be 0200 - Administration. No individual County department owns the asset, they all fall under the 0200 umbrella. This field has a domain of possible IPS accepted values.MAINENTITY Maintenance Entity that performs maintenance on the asset. If the asset is county owned; 0200 - Administration. This field will show which department is involved with performing maintenance on the asset and should be set here. This field has a domain of possible IPS accepted values.FINANCEENTITY Finance Entity Entity that is financially responsible for the asset. Similar to Maintenance Entity if county owned the individual department financially responsible should be recorded here. This field has a domain of possible IPS accepted values. BUDGET1 Budget 1 Budget number for the financial entity responsible for the asset. This number must be correct for IPS to accept the value. If it is not. the other asset information will by synced and this number will not be carried over.BUDGETPORTION1 Budget Portion 1 Portion that budget 1 that is responsible. If Budget 1 is solely responsible than it would be 100 to represent 100%. If there are multiple than the numbers need to add up to 100.BUDGET2 Budget 2 Budget number for the financial entity responsible for the asset. This number must be correct for IPS to accept the value. If it is not. the other asset information will by synced and this number will not be carried over.BUDGETPORTION2 Budget Portion 2 Portion that budget 2 that is responsible.BUDGET3 Budget 3 Budget number for the financial entity responsible for the asset. This number must be correct for IPS to accept the value. If it is not. the other asset information will by synced and this number will not be carried over.BUDGETPORTION3 Budget Portion 3 Portion that budget 3 that is responsible.CREATED_USER Created By Editor Tracking is enabled on all IPS related feature classes. This field will capture which user has created the asset.CREATED_DATE Created Date Editor Tracking is enabled on all IPS related feature classes. This field will capture when the user has created the asset.LAST_EDITED_USER Last Edited By Editor Tracking is enabled on all IPS related feature classes. This field will capture which user last edited the asset.LAST_EDITED_DATE Last Edited Date Editor Tracking is enabled on all IPS related feature classes. This field will capture when the user last edited the asset.COMPLETE Complete This field is intended to indicate if the record is ready for it to be synced from GIS to IPS. If the field is not set to 'Y' - 'Yes' it will not be synced. This field only accepts 2 values: 'Y' - 'Yes', 'N' - 'No'.SHAPE SHAPE Required Esri field that stores the geometry information of the record. INSURED Insured? This field indicated whether the asset is insured or not. This field only accepts 2 values: 'Y' - 'Yes', 'N' - 'No'. BILLABLE Billable? This field indicated if the asset is billable. This field only accepts 2 values: 'Y' - 'Yes', 'N' - 'No'.ACCOUNTTYPE1 Account Type 1 Utility Service that is being applied to the asset. This field has a domain of possible IPS accepted values.ACCOUNTNUM1 Account Number 1 Account number for Utility Service related to ACCOUNTTYPE1.METERNUM1 Meter Number 1 Meter associated to Account Number 1.ACCOUNTPORTION1 Account Portion 1 Portion that ACCOUNTNUM1 that is responsible. If ACCOUNTNUM1 is solely responsible than it would be 100 to represent 100%. If there are multiple than the numbers need to add up to 100.ACCOUNTTYPE2 Account Type 2 Utility Service that is being applied to the asset. This field has a domain of possible IPS accepted values.ACCOUNTNUM2 Account Number 2 Account number for Utility Service related to ACCOUNTTYPE2.METERNUM2 Meter Number 2 Meter associated to Account Number 2.ACCOUNTPORTION2 Account Portion 2 Portion that ACCOUNTNUM2 that is responsible.ACCOUNTTYPE3 Account Type 3 Utility Service that is being applied to the asset. This field has a domain of possible IPS accepted values.ACCOUNTNUM3 Account Number 3 Account number for Utility Service related to ACCOUNTTYPE3.METERNUM3 Meter Number 3 Meter associated to Account Number 3.ACCOUNTPORTION3 Account Portion 3 Portion that ACCOUNTNUM3 that is responsible.ACCOUNTTYPE4 Account Type 4 Utility Service that is being applied to the asset. This field has a domain of possible IPS accepted values.ACCOUNTNUM4 Account Number 4 Account number for Utility Service related to ACCOUNTTYPE4.METERNUM4 Meter Number 4 Meter associated to Account Number 4.ACCOUNTPORTION4 Account Portion 4 Portion that ACCOUNTNUM4 that is responsible. EXPIRED Expired? Field to indicate if the asset is to be expired from IPS. This field only accepts 2 values: 'Y' - 'Yes', 'N' - 'No'. If the value is set to Yes during the scheduled sync for this asset type it will be expired from IPS, the asset will then be removed from this layer and moved to the related historical layer for archiving. XCOORD X Coordinate the Longitudinal value for the asset in Coordinate System: NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet. This field is calculated from a SQL trigger automatically, if the asset is moved it will be recalculated during a scheduled procedure.YCOORD Y Coordinate the Latitudinal value for the asset in Coordinate System: NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet.This field is calculated from a SQL trigger automatically, if the asset is moved it will be recalculated during a scheduled procedure.USNG USNG Field indicates the grid the value is located in. This field is calculated from a SQL trigger automatically, if the asset is moved it will not be able to sync this value into IPS due to technical limitations in the Web Service logic. SHAPE.LEN SHAPE.LEN Esri required field.

Copyright Text: Created by : Frank Veldhuis (fveldhui@martin.fl.us) Updated by: Zach Dickson (zdickson@martin.fl.us) Updated on: 1/11/2021

Min. Scale: 4000.00000000031

Max. Scale: 0

Default Visibility: false

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"MAINENTITY","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,223,255,255],"width":5},"value":"2200","label":"County"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":5},"value":"City","label":"City"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,211,127,255],"width":5},"value":"Private","label":"Private"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":5},"value":"State","label":"State"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,147,100,255],"toColor":[189,147,100,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,125,62,255],"toColor":[250,125,62,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,229,200,255],"toColor":[250,229,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[214,149,45,255],"toColor":[214,149,45,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,103,41,255],"toColor":[179,103,41,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,149,96,255],"toColor":[240,149,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[196,176,155,255],"toColor":[196,176,155,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[232,184,107,255],"toColor":[232,184,107,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,192,156,255],"toColor":[247,192,156,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[186,114,78,255],"toColor":[186,114,78,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,145,71,255],"toColor":[201,145,71,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[235,161,124,255],"toColor":[235,161,124,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,165,138,255],"toColor":[212,165,138,255]}]}}},"scaleSymbols":true,"transparency":60,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: MAINENTITY

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
UNITID (type: esriFieldTypeString, alias: Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
UNITID2 (type: esriFieldTypeString, alias: Unit ID 2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
UNITDESC (type: esriFieldTypeString, alias: Street Description, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
COMPTYPE (type: esriFieldTypeInteger, alias: CompType, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
FROM_ID (type: esriFieldTypeString, alias: From ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FROM_DESC (type: esriFieldTypeString, alias: From Description, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
TO_ID (type: esriFieldTypeString, alias: To ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
TO_DESC (type: esriFieldTypeString, alias: To Description, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
FRSTKEY (type: esriFieldTypeInteger, alias: From Street Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOSTKEY (type: esriFieldTypeInteger, alias: To Street Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRAAREA (type: esriFieldTypeString, alias: CRA Area, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
DISTRICT (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
UNITTYPE (type: esriFieldTypeString, alias: Classifcation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SURFTYPE (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SURFWID (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
SURFDPTH (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEGLEN (type: esriFieldTypeDouble, alias: Legth, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEGLENUOM (type: esriFieldTypeString, alias: Length Unit of Measure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SURFWIDUOM (type: esriFieldTypeString, alias: Width Unit of Measure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SURFDPTHMUOM (type: esriFieldTypeString, alias: Depth Unit of Measure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
INSTDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SERVSTAT (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
OWN (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SCHOOLZONE (type: esriFieldTypeString, alias: School Zone, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
EVACUATIONROUTE (type: esriFieldTypeString, alias: Evacuation Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
BUSROUTE (type: esriFieldTypeString, alias: Bus Route, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
AREASIZE (type: esriFieldTypeInteger, alias: Area Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
AREAUOM (type: esriFieldTypeString, alias: Area Unit of measure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
NUMPARK (type: esriFieldTypeInteger, alias: Number of Parking/Curb Stops, SQL Type: sqlTypeOther, nullable: true, editable: true)
CURBEXIST (type: esriFieldTypeString, alias: Is there a curb?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
CURBLEN (type: esriFieldTypeInteger, alias: Curb Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
CURBQTY (type: esriFieldTypeInteger, alias: Curb Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
SHOULDER (type: esriFieldTypeString, alias: Shoulder, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
BICYCLELANE (type: esriFieldTypeString, alias: Bicycle Lane, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ASPHALTDEC (type: esriFieldTypeString, alias: Is the asphalt decorative?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FEDERALAID (type: esriFieldTypeString, alias: Federal Aid, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
RESOLUTION (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FAILINGLOS (type: esriFieldTypeString, alias: Failing LOS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ACCESSCLASS (type: esriFieldTypeString, alias: Access Class, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANDSCAPE (type: esriFieldTypeString, alias: Is there landscape?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
MAINENTITY (type: esriFieldTypeString, alias: Maintenance Entity, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
FINANCEENTITY (type: esriFieldTypeString, alias: Finance Entity, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
XWALKTYPE1 (type: esriFieldTypeString, alias: Crosswalk Type 1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
XWALKTYPE2 (type: esriFieldTypeString, alias: Crosswalk Type 2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
XWALKSURF (type: esriFieldTypeString, alias: Crosswalk Surface, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANETYPE1 (type: esriFieldTypeString, alias: Lane Type 1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANEQTY1 (type: esriFieldTypeInteger, alias: Lane 1 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANETYPE2 (type: esriFieldTypeString, alias: Lane Type 2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANEQTY2 (type: esriFieldTypeInteger, alias: Lane 2 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANETYPE3 (type: esriFieldTypeString, alias: Lane Type 3, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANEQTY3 (type: esriFieldTypeInteger, alias: Lane 3 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANETYPE4 (type: esriFieldTypeString, alias: Lane Type 4, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANEQTY4 (type: esriFieldTypeInteger, alias: Lane 4 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANETYPE5 (type: esriFieldTypeString, alias: Lane Type 5, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LANEQTY5 (type: esriFieldTypeInteger, alias: Lane 5 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARKSPACETYPE1 (type: esriFieldTypeString, alias: Parking Space Type 1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PARKSPACEQTY1 (type: esriFieldTypeInteger, alias: Parking Space 1 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARKSPACETYPE2 (type: esriFieldTypeString, alias: Parking Space Type 2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PARKSPACEQTY2 (type: esriFieldTypeInteger, alias: Parking Space 2 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARKSPACETYPE3 (type: esriFieldTypeString, alias: Parking Space Type 3, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PARKSPACEQTY3 (type: esriFieldTypeInteger, alias: Parking Space 3 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARKSPACETYPE4 (type: esriFieldTypeString, alias: Parking Space Type 4, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PARKSPACEQTY4 (type: esriFieldTypeInteger, alias: Parking Space 4 Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
BUDGET1 (type: esriFieldTypeString, alias: Budget 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BUDGETPORTION1 (type: esriFieldTypeInteger, alias: Budget Portion 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
BUDGET2 (type: esriFieldTypeString, alias: Budget 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BUDGETPORTION2 (type: esriFieldTypeInteger, alias: Budget Portion 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
BUDGET3 (type: esriFieldTypeString, alias: Budget 3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BUDGETPORTION3 (type: esriFieldTypeInteger, alias: Budget Portion 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
CREATED_USER (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_EDITED_USER (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LAST_EDITED_DATE (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ACCOUNTTYPE1 (type: esriFieldTypeString, alias: Account Type 1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ACCOUNTNUMBER1 (type: esriFieldTypeString, alias: Account Number 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ACCOUNTTYPE2 (type: esriFieldTypeString, alias: Account Type 2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ACCOUNTNUMBER2 (type: esriFieldTypeString, alias: Account Number 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ACCOUNTTYPE3 (type: esriFieldTypeString, alias: Account Type 3, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ACCOUNTNUMBER3 (type: esriFieldTypeString, alias: Account Number 3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ACCOUNTTYPE4 (type: esriFieldTypeString, alias: Account Type 4, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ACCOUNTNUMBER4 (type: esriFieldTypeString, alias: Account Number 4, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ACCOUNTPORTION1 (type: esriFieldTypeInteger, alias: Account Portion 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACCOUNTPORTION2 (type: esriFieldTypeInteger, alias: Account Portion 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACCOUNTPORTION3 (type: esriFieldTypeInteger, alias: Account Portion 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACCOUNTPORTION4 (type: esriFieldTypeInteger, alias: Account Portion 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
INSURED (type: esriFieldTypeString, alias: Insured, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
BILLABLE (type: esriFieldTypeString, alias: Billable, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
STKEY (type: esriFieldTypeInteger, alias: Street Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPEEDLIMIT (type: esriFieldTypeSmallInteger, alias: Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPECINST (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
MOSQUITOS (type: esriFieldTypeString, alias: Is it treated for Mosquitos?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
XCOORD (type: esriFieldTypeDouble, alias: X Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
YCOORD (type: esriFieldTypeDouble, alias: Y Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
USNG (type: esriFieldTypeString, alias: USNG, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
EXPIRED (type: esriFieldTypeString, alias: Expired?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

MAINENTITY: 2200
INSURED: Y
BILLABLE: Y

MAINENTITY: City
INSURED: Y
BILLABLE: Y

MAINENTITY: Private
INSURED: Y
BILLABLE: Y

MAINENTITY: State
INSURED: Y
BILLABLE: Y

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/20/2023 5:50:54 PM

Schema Last Edit Date: 11/20/2023 5:50:54 PM

Data Last Edit Date: 11/20/2023 5:50:54 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat