Name: outputLayer

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 12551241.8439908
YMin: 222942.326302558
XMax: 12562044.1393153
YMax: 236932.122797981
Spatial Reference: 102690 (102690)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,129,189,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[54,93,141,255],"width":1}}}}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 16, nullable: false, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• parcelnumb (type: esriFieldTypeString, alias: Parcel Number, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• vacant (type: esriFieldTypeInteger, alias: Vacant, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• abandoned (type: esriFieldTypeInteger, alias: Abandoned, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• owner2 (type: esriFieldTypeString, alias: Owner2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• utilmaterial (type: esriFieldTypeSmallInteger, alias: Utility Material, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• NewUtilmaterial (type: esriFieldTypeInteger, alias: New Utility Material, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• utilverified (type: esriFieldTypeInteger, alias: Utility Side Verified, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• utilverifdate (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• utilinstalldate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• utilsource (type: esriFieldTypeSmallInteger, alias: Utility Source, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• utilstatus (type: esriFieldTypeSmallInteger, alias: Utility Status, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• custmaterial (type: esriFieldTypeSmallInteger, alias: Customer Material, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• NewCustmaterial (type: esriFieldTypeInteger, alias: New Customer Material, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• custverified (type: esriFieldTypeInteger, alias: Customer Side Verified, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• custverifdate (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• custsource (type: esriFieldTypeSmallInteger, alias: Customer Source, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• custstatus (type: esriFieldTypeSmallInteger, alias: Customer Status, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• scheddate (type: esriFieldTypeDate, alias: Scheduled Replacement Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• replacestatus (type: esriFieldTypeSmallInteger, alias: Replacement Status, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• replacereason (type: esriFieldTypeInteger, alias: Reason for Replacement, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InstallMethod (type: esriFieldTypeInteger, alias: Installation Method, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• custnotified (type: esriFieldTypeSmallInteger, alias: Notified Customer of Replacement, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• notifydate (type: esriFieldTypeDate, alias: Replacement Notification Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• PlumberVerif (type: esriFieldTypeSmallInteger, alias: State Plumber Verified, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PlumberVerifDate (type: esriFieldTypeDate, alias: State Plumber Verification Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• intmaterial (type: esriFieldTypeInteger, alias: Interior Material, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• intdiameter (type: esriFieldTypeDouble, alias: Interior Diameter, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• intstatus (type: esriFieldTypeInteger, alias: Interior Status, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• intinstalldate (type: esriFieldTypeDate, alias: Interior Install Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• intverifdate (type: esriFieldTypeDate, alias: Interior Verification Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• intsource (type: esriFieldTypeInteger, alias: Interior Source, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ROE (type: esriFieldTypeInteger, alias: ROE Status, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ROESentDate (type: esriFieldTypeDate, alias: Roe Sent Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• CommentsResolved (type: esriFieldTypeSmallInteger, alias: Comments Resolved, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Zone (type: esriFieldTypeSmallInteger, alias: Zone, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Contractor (type: esriFieldTypeSmallInteger, alias: Contractor, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InspectorApproval (type: esriFieldTypeSmallInteger, alias: Inspector QTY Approval, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InspectNotes (type: esriFieldTypeString, alias: Inspector Notes, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PhotoHouse (type: esriFieldTypeInteger, alias: House Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PhotoCSInspection (type: esriFieldTypeInteger, alias: Valve Inspection Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PhotoBefore (type: esriFieldTypeSmallInteger, alias: Existing Service Photo, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PhotoReplacement (type: esriFieldTypeInteger, alias: Completed Service Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PhotoIntPlumb (type: esriFieldTypeSmallInteger, alias: Interior Plumbing Photo, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PhotoMeter (type: esriFieldTypeSmallInteger, alias: Meter Photo, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PhotoLocSketch (type: esriFieldTypeInteger, alias: Location Sketch Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• QtyROEForm (type: esriFieldTypeDouble, alias: Right of Entry Form (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyWatServInv (type: esriFieldTypeDouble, alias: Water Service Investigation (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPavtRem (type: esriFieldTypeDouble, alias: Pavt, Rem (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtySWRem (type: esriFieldTypeDouble, alias: Sidewalk, Rem (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyCurbRem (type: esriFieldTypeDouble, alias: Curb and Gutter, Rem (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyMatDisp (type: esriFieldTypeDouble, alias: Non-Haz Contaminated Material Handling and Disposal (Cyd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPrivServCut (type: esriFieldTypeDouble, alias: Private Water Service, Cut and Cap (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPubServTren (type: esriFieldTypeDouble, alias: Public Water Service, Trenchless (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPubServ1In (type: esriFieldTypeDouble, alias: Public Water Service, 1 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPubServ15In (type: esriFieldTypeDouble, alias: 5 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPubServ2In (type: esriFieldTypeDouble, alias: Public Water Service, 2 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPrivServTren (type: esriFieldTypeDouble, alias: Private Water Service, Trenchless (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyCurbStop (type: esriFieldTypeDouble, alias: Curb Stop and Box (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyWatMetRepl (type: esriFieldTypeDouble, alias: Water Meter Replacement (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyPrivWatServCon (type: esriFieldTypeDouble, alias: Private Water Service, Connection to Residence (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyWatServComp (type: esriFieldTypeDouble, alias: Water Service, Complete (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtySubbase (type: esriFieldTypeDouble, alias: Subbase, CIP (Cyd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyAgBase (type: esriFieldTypeDouble, alias: Aggregate Base, 8 inch, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyConcPavt (type: esriFieldTypeDouble, alias: Conc Pavt, Misc, Nonreinf, 6 inch, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyHndPtch (type: esriFieldTypeDouble, alias: Hand Patching (440 Lb/Syd) (Ton), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyCurb (type: esriFieldTypeDouble, alias: Curb and Gutter, Conc, Det C4 (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtyDrivewy (type: esriFieldTypeDouble, alias: Driveway, Nonreinf, Conc, 6 inch (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtySW (type: esriFieldTypeDouble, alias: Sidewalk, 4 inch (Sft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• QtySlpRest (type: esriFieldTypeDouble, alias: Slope Restoration, Type B (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspROEForm (type: esriFieldTypeDouble, alias: Right of Entry Form (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspWatServInv (type: esriFieldTypeDouble, alias: Water Service Investigation (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPavtRem (type: esriFieldTypeDouble, alias: Pavt, Rem (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspSWRem (type: esriFieldTypeDouble, alias: Sidewalk, Rem (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspCurbRem (type: esriFieldTypeDouble, alias: Curb and Gutter, Rem (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspMatDisp (type: esriFieldTypeDouble, alias: Non-Haz Contaminated Material Handling and Disposal (Cyd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPrivServCut (type: esriFieldTypeDouble, alias: Private Water Service, Cut and Cap (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPubServTren (type: esriFieldTypeDouble, alias: Public Water Service, Trenchless (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPubServ1In (type: esriFieldTypeDouble, alias: Public Water Service, 1 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPubServ15In (type: esriFieldTypeDouble, alias: 5 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPubServ2In (type: esriFieldTypeDouble, alias: Public Water Service, 2 inch (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPrivServTren (type: esriFieldTypeDouble, alias: Private Water Service, Trenchless (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspCurbStop (type: esriFieldTypeDouble, alias: Curb Stop and Box (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspWatMetRepl (type: esriFieldTypeDouble, alias: Water Meter Replacement (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspPrivWatServCon (type: esriFieldTypeDouble, alias: Private Water Service, Connection to Residence (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspWatServComp (type: esriFieldTypeDouble, alias: Water Service, Complete (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspSubbase (type: esriFieldTypeDouble, alias: Subbase, CIP (Cyd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspAgBase (type: esriFieldTypeDouble, alias: Aggregate Base, 8 inch, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspConcPavt (type: esriFieldTypeDouble, alias: Conc Pavt, Misc, Nonreinf, 6 inch, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspHndPtch (type: esriFieldTypeDouble, alias: Hand Patching (440 Lb/Syd) (Ton), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspCurb (type: esriFieldTypeDouble, alias: Curb and Gutter, Conc, Det C4 (Ft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspDrivewy (type: esriFieldTypeDouble, alias: Driveway, Nonreinf, Conc, 6 inch (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspSW (type: esriFieldTypeDouble, alias: Sidewalk, 4 inch (Sft), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspSlpRest (type: esriFieldTypeDouble, alias: Slope Restoration, Type B (Syd), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• TapMathod (type: esriFieldTypeInteger, alias: Tap Method, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PhotoMain (type: esriFieldTypeInteger, alias: Connection at Water Main Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DepthCS (type: esriFieldTypeDouble, alias: Depth at Curb Stop, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• DepthMain (type: esriFieldTypeDouble, alias: Depth at Water Main, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• DepthHouse (type: esriFieldTypeDouble, alias: Depth at House, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• Newintmaterial (type: esriFieldTypeInteger, alias: New Interior Material, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PhotoCompletionLetter (type: esriFieldTypeInteger, alias: Completion Letter Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ROEReceivedContractor (type: esriFieldTypeDate, alias: ROE Received by Contractor Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ROEReceivedOthers (type: esriFieldTypeDate, alias: ROE Received by Others Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ContactName (type: esriFieldTypeString, alias: Contact Person, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ContactPhone (type: esriFieldTypeString, alias: Contact Phone Number, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ContactEmail (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PhotoRestoration (type: esriFieldTypeInteger, alias: Restoration Photo, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PlumbPermitNum (type: esriFieldTypeString, alias: State Plumbing Permit Number, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• QtyFittings (type: esriFieldTypeDouble, alias: Private Water Service, Internal Fittings (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• InspFittings (type: esriFieldTypeDouble, alias: Private Water Service, Internal Fittings (Ea), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACIIntInsp (type: esriFieldTypeString, alias: ACI Internal Inspection, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• aciQAQC (type: esriFieldTypeString, alias: QAQC, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• aciQAQCnotes (type: esriFieldTypeString, alias: QAQC Notes, SQL Type: sqlTypeNVarchar, length: 1000, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• address_1 (type: esriFieldTypeString, alias: Address 1, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• sensitivepop (type: esriFieldTypeString, alias: Type of Sensitive Population, SQL Type: sqlTypeNVarchar, length: 15, nullable: true, editable: true)
• property_assessed_value (type: esriFieldTypeInteger, alias: Property Assessed Value, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• is_below_value_limit (type: esriFieldTypeSmallInteger, alias: Is Below Property Value Limit?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_historic_site (type: esriFieldTypeSmallInteger, alias: Is Historic Site?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• has_high_lead_test (type: esriFieldTypeSmallInteger, alias: Has High Lead Test Results?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_sensitive_pop (type: esriFieldTypeSmallInteger, alias: Is Sensitive Population?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_disadvantaged_com (type: esriFieldTypeSmallInteger, alias: Is Disadvantaged Community?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• has_children_under_six (type: esriFieldTypeSmallInteger, alias: Has Children Under 6?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_on_capital_project (type: esriFieldTypeSmallInteger, alias: Is on Capital Project?, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• final_score (type: esriFieldTypeDouble, alias: Final Score, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• is_in_uap (type: esriFieldTypeInteger, alias: Is in Utility Assistance Program?, SQL Type: sqlTypeInteger, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• GlobalID: {00000000-0000-0000-0000-000000000000}

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/11/2025 3:02:08 PM

Schema Last Edit Date: 2/11/2025 3:02:08 PM

Data Last Edit Date: 2/11/2025 3:02:08 PM

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