View In:   ArcGIS Online Map Viewer

Name: Water Service Connection

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 576246.043957645
YMin: 1739540.4873293191
XMax: 636726.450252786
YMax: 1781668.02103729
Spatial Reference: PROJCS["NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAD_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETSTAT ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Asset_Status , Coded Values: [Removed: Removed] , [AF: Abandoned Filled] , [ALAI: Abandoned Left as is] , ...5 more... )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS_ )
• BUSINESSUNIT ( type: esriFieldTypeString, alias: Buisness Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Buisness_Unit )
• SPID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SPID_ )
• PREMISID ( type: esriFieldTypeString, alias: Location ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Premis_ID )
• EMPTYMETERBOX ( type: esriFieldTypeString, alias: Empty Meter Box, editable: true, nullable: true, length: 20, defaultValue: No, modelName: Empty_Meter_Box , Coded Values: [Yes: Yes] , [No: No] )
• PROJECTNAME ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Name )
• PROJECTDESC ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Description )
• SERVICELINEDIA ( type: esriFieldTypeDouble, alias: Service Line Diameter, editable: true, nullable: true, defaultValue: null, modelName: Service_Line_Diameter , Coded Values: [0.5: 1/2"] , [0.625: 5/8"] , [0.75: 3/4"] , ...32 more... )
• METERCUSTTYPE ( type: esriFieldTypeString, alias: Service Category, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Meter_Customer_Type , Coded Values: [Water: Water] , [Sewer: Sewer] , [Reuse: Reuse] )
• BILLINGMETERTYPE ( type: esriFieldTypeString, alias: Meter Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Billing_Meter_Type , Coded Values: [Commercial Meter: Commercial Meter] , [Master Meter: Master Meter] , [Monitoring Well: Monitoring Well] , ...5 more... )
• NORTHING ( type: esriFieldTypeString, alias: Northing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeString, alias: Easting, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EASTING )
• LAT ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAT )
• LONG ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONG )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Data_Source , Coded Values: [As-Built Documents: As-Built Documents] , [As-Built Survey: As-Built Survey] , [Construction Drawings: Construction Drawings] , ...17 more... )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Asset Owner, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: City of Ocala] , [2: Windstream Utilities] , [3: Marion Utilities] , ...4 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: City of Ocala] , [2: Windstream Utilities] , [3: Marion Utilities] , ...4 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity, editable: true, nullable: true, defaultValue: null, modelName: INLUCITY )
• LUCITYLINK ( type: esriFieldTypeInteger, alias: Lucity Link, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINK )
• LOCATIONID ( type: esriFieldTypeString, alias: Location Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LOCATIONID , Coded Values: [I/S: Inside] , [O/S: Outside] , [C/I: Close In] , ...14 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments/Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ROUTES ( type: esriFieldTypeString, alias: Water Meter Routes, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ROUTES )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITDYIDNEW )
• PROJECTNUM ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PROJECTNUMNEW )
• LASTSYNCH ( type: esriFieldTypeDate, alias: LASTSYNCH, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSYNCH )
• UMROUTEID ( type: esriFieldTypeString, alias: Route ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UMROUTEID , Coded Values: [MD01: MD01] , [MD02: MD02] , [MD03: MD03] , ...17 more... )

Templates:

• Name: Water Service Connection
  Description:
  Prototype:
  LASTSYNCH: null
  PROJECTNUM: null
  ASSETSTAT: null
  ADDRESS: null
  BUSINESSUNIT: null
  SPID: null
  PREMISID: null
  EMPTYMETERBOX: No
  PROJECTNAME: null
  PROJECTDESC: null
  SERVICELINEDIA: null
  METERCUSTTYPE: null
  BILLINGMETERTYPE: null
  NORTHING: null
  EASTING: null
  LAT: null
  LONG: null
  DATASOURCE: null
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  POINT_Y: null
  INLUCITY: null
  LUCITYLINK: null
  LOCATIONID: null
  COMMENTS: null
  UMROUTEID: null
  ROUTES: null
  POINT_X: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata