View In:
ArcGIS Online Map Viewer
Name: Structure
Display Field: StreetName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount: 30000
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: 1389028.8943367638
YMin: 1135002.41540128
XMax: 1427325.1297520138
YMax: 1191875.9827562794
Spatial Reference: 102717
(2262)
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
StructureID
(
type: esriFieldTypeInteger, alias: Structure ID, editable: true, nullable: true, defaultValue: null, modelName: StructureID
)
-
StructureType
(
type: esriFieldTypeString, alias: Structure Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: StructureType
,
Coded Values:
[B: Building]
,
[BA: Bridge Abutment]
,
[P: Pole]
, ...2 more...
)
-
PoleType
(
type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PoleType
,
Coded Values:
[-: Multilight]
,
[^: Structure Attachment No Arm]
,
[A: 14' FRP, City standard residential Fiberglass reinforced plastic]
, ...24 more...
)
-
PoleManufacturer
(
type: esriFieldTypeString, alias: Pole Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleManufacturer
)
-
PoleMaterial
(
type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PoleMaterial
,
Coded Values:
[Aluminum: Aluminum]
,
[Concrete: Concrete]
,
[Fiberglass: Fiberglass]
, ...7 more...
)
-
PoleHeight
(
type: esriFieldTypeDouble, alias: Pole Height, editable: true, nullable: true, defaultValue: null, modelName: PoleHeight
)
-
AddrNum
(
type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AddrNum
)
-
AddrFrontOf
(
type: esriFieldTypeString, alias: Front Of, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddrFrontOf
)
-
StreetPreDir
(
type: esriFieldTypeString, alias: Street Pre Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: StreetPreDir
,
Coded Values:
[N: N]
,
[E: E]
,
[S: S]
, ...5 more...
)
-
StreetName
(
type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: StreetName
,
Coded Values:
[104: 104]
,
[390: 390]
,
[490: 490]
, ...1636 more...
)
-
StreetType
(
type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: StreetType
,
Coded Values:
[Aly: Alley]
,
[Ave: Avenue]
,
[Blvd: Boulevard]
, ...24 more...
)
-
StreetPostDir
(
type: esriFieldTypeString, alias: Street Post Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: StreetPostDir
,
Coded Values:
[N: N]
,
[E: E]
,
[S: S]
, ...5 more...
)
-
FullAddress
(
type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FullAddress
)
-
StreetSide
(
type: esriFieldTypeString, alias: Side of Street, editable: true, nullable: true, length: 2, defaultValue: null, modelName: StreetSide
,
Coded Values:
[N: North]
,
[E: East]
,
[S: South]
, ...1 more...
)
-
NumericOrder
(
type: esriFieldTypeString, alias: Numeric Order of Lights, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NumericOrder
)
-
CountDirection
(
type: esriFieldTypeString, alias: Direction of Count, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CountDirection
,
Coded Values:
[N: North]
,
[E: East]
,
[S: South]
, ...1 more...
)
-
Opposite
(
type: esriFieldTypeString, alias: Opposite, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Opposite
)
-
CrossStreet
(
type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CrossStreet
,
Coded Values:
[6th Street: 6th Street]
,
[A Place: A Place]
,
[Aab Street: Aab Street]
, ...1794 more...
)
-
LocationSpecifics
(
type: esriFieldTypeString, alias: Location Specifics, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LocationSpecifics
)
-
X
(
type: esriFieldTypeDouble, alias: X (Long), editable: true, nullable: true, defaultValue: null, modelName: X
)
-
Y
(
type: esriFieldTypeDouble, alias: Y (Lat), editable: true, nullable: true, defaultValue: null, modelName: Y
)
-
OverheadWireLength
(
type: esriFieldTypeDouble, alias: Overhead Wire Length (ft), editable: true, nullable: true, defaultValue: null, modelName: OverheadWireLength
)
-
NumLights
(
type: esriFieldTypeSmallInteger, alias: Number Lights Attached, editable: true, nullable: true, defaultValue: null, modelName: NumLights
)
-
ArmPresent
(
type: esriFieldTypeString, alias: Arm Present, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ArmPresent
,
Coded Values:
[1: Yes]
,
[0: No]
)
-
ArmAttachCode
(
type: esriFieldTypeString, alias: Arm Attach Code (wood pole), editable: true, nullable: true, length: 3, defaultValue: null, modelName: ArmAttachCode
,
Coded Values:
[C: City SLOP]
,
[T: RTC/Frontier]
,
[N/A: Not Applicable]
, ...2 more...
)
-
UtilityPoleNumber
(
type: esriFieldTypeString, alias: Utility Pole Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UtilityPoleNumber
)
-
SLOPJoint
(
type: esriFieldTypeString, alias: SLOP or Joint Owned, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SLOPJoint
,
Coded Values:
[SLOP: Street Light Only Pole]
,
[JOINT: Joint Pole Ownership]
,
[SLOP2: Street Light Only Pole 2]
, ...2 more...
)
-
MapNumber
(
type: esriFieldTypeSmallInteger, alias: RGE Map Number, editable: true, nullable: true, defaultValue: null, modelName: MapNumber
)
-
Purchased
(
type: esriFieldTypeString, alias: RGE Purchase, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Purchased
,
Coded Values:
[1: Yes]
,
[0: No]
)
-
ProjectNumber
(
type: esriFieldTypeString, alias: Project Number COR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectNumber
)
-
DateInstalled
(
type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled
)
-
LastServiced
(
type: esriFieldTypeDate, alias: Last Serviced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServiced
)
-
Condition
(
type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Condition
,
Coded Values:
[Good: Good]
,
[Fair: Fair]
,
[Unknown: Unknown]
, ...2 more...
)
-
OwnedBy
(
type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OwnedBy
,
Coded Values:
[City: City of Rochester]
,
[Frontier: Frontier]
,
[Other: Other]
, ...1 more...
)
-
MaintBy
(
type: esriFieldTypeString, alias: Managed By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintBy
,
Coded Values:
[City: City of Rochester]
,
[RGE: Rochester Gas & Electric]
,
[Frontier: Frontier]
, ...1 more...
)
-
SourceFile
(
type: esriFieldTypeString, alias: Source File, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SourceFile
)
-
SourceLink
(
type: esriFieldTypeString, alias: Source Link, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SourceLink
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
Action
(
type: esriFieldTypeString, alias: CityTouch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Action
,
Coded Values:
[Added: Added]
,
[Appended: Appended]
,
[Exists: Exists]
, ...9 more...
)
-
Notes
(
type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes
,
Coded Values:
[Added from COR Excel: Added from COR Excel]
,
[Added from OTM Survey: Added from OTM Survey]
,
[CAD - RG&E Wood Distribution Pole: CAD - RG&E Wood Distribution Pole]
, ...16 more...
)
-
Source
(
type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Source
,
Coded Values:
[CAD: CAD]
,
[CAD and City Touch: CAD and City Touch]
,
[CAD and OTM: CAD and OTM]
, ...9 more...
)
-
AdditionalSourceInformation
(
type: esriFieldTypeString, alias: OTMSurveyLocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditionalSourceInformation
)
-
OTMFeatureCode
(
type: esriFieldTypeString, alias: OTM Feature Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTMFeatureCode
)
-
OTMFeatureDescription
(
type: esriFieldTypeString, alias: OTM Feature Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTMFeatureDescription
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments
)
-
LightID
(
type: esriFieldTypeInteger, alias: LID, editable: true, nullable: true, defaultValue: null, modelName: LightID
)
-
AddedToStreetlightTable
(
type: esriFieldTypeString, alias: Added to Streetlight Table?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddedToStreetlightTable
,
Coded Values:
[Yes: Yes]
,
[No: No]
,
[N/A: N/A]
)
-
Duplicate
(
type: esriFieldTypeString, alias: Duplicate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Duplicate
,
Coded Values:
[1: Yes]
,
[0: No]
)
Templates:
-
Name: Structure
Description:
Prototype:
AddedToStreetlightTable: null
StructureID: null
StructureType: null
PoleType: null
PoleManufacturer: null
PoleMaterial: null
PoleHeight: null
AddrNum: null
AddrFrontOf: null
StreetPreDir: null
StreetName: null
StreetType: null
StreetPostDir: null
FullAddress: null
StreetSide: null
NumericOrder: null
CountDirection: null
Opposite: null
CrossStreet: null
LocationSpecifics: null
X: null
Y: null
OverheadWireLength: null
NumLights: null
ArmPresent: null
ArmAttachCode: null
UtilityPoleNumber: null
SLOPJoint: null
MapNumber: null
Purchased: null
ProjectNumber: null
DateInstalled: null
LastServiced: null
Condition: null
OwnedBy: null
MaintBy: null
SourceFile: null
SourceLink: null
Duplicate: null
Action: null
Notes: null
Source: null
AdditionalSourceInformation: null
OTMFeatureCode: null
OTMFeatureDescription: null
Comments: null
LightID: null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
Capabilities: Query
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata