View In:
ArcGIS Online Map Viewer
Name: Street Lights
Display Field: Owner_Name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>2015 bob</SPAN></P><P STYLE="text-indent:20;"><SPAN>Created by Geocoding excel spreadsheet form Centerpoint ( Found they only use Block numbering in many cases )</SPAN></P><P STYLE="text-indent:20;"><SPAN>Re-Geocoded several times to get better results from Geocoding</SPAN></P><P STYLE="text-indent:20;"><SPAN>This file is te result of the geocoding and has sinse been correct numerous times when street light requests come in.</SPAN></P><P STYLE="text-indent:20;"><SPAN>May never be perfect but better than nothing considering Centerpoint will not give me a shape file. </SPAN></P><P STYLE="text-indent:20;"><SPAN>Centerpoint did not give me streetlights in the county islands, outside city limits but in ETJ boundary, private street lights for example mobile home parks and apartment complexs. </SPAN></P><P STYLE="text-indent:20;"><SPAN>Also the industrial area to our east is also left out. So as this file is updated these will be added to our file. </SPAN></P><P STYLE="text-indent:20;"><SPAN>Fixing as I go</SPAN></P><P><SPAN>20150712 - Bob _Corrected Airhart area and East side of town</SPAN></P><P><SPAN>20190725 - Bob - Review of Street lights for LED replacement of heads</SPAN></P><P STYLE="text-indent:20;margin:1 1 1 60;"><SPAN>populated the field (Status) with the following for labeling purposes</SPAN></P><P STYLE="text-indent:20;margin:1 1 1 60;"><SPAN>Populated the (Type) field with Review information</SPAN></P><P STYLE="text-indent:20;margin:1 1 1 60;"><SPAN>the field (User_fld) is populated identifying if the location of the light has been verified by who, if blank the light location may be incorrect.</SPAN></P><P><SPAN>2019-11-12 Bob As of this date the reults so far are:</SPAN></P><P STYLE="text-indent:20;"><SPAN>0 = 974 - To be Reviewed</SPAN></P><P STYLE="text-indent:20;"><SPAN>1 = 458 - Reviewed still HPS</SPAN></P><P STYLE="text-indent:20;"><SPAN>2 = 1 - Reviewed Security light</SPAN></P><P STYLE="text-indent:20;"><SPAN>3 = </SPAN></P><P STYLE="text-indent:20;"><SPAN>4 = 37 - Other non-standard private poles and fixtures </SPAN></P><P STYLE="text-indent:20;"><SPAN>5 = 309 - Private lights (City of Baytown Park lights, City owned streets with city lights, Private lights)</SPAN></P><P STYLE="text-indent:20;"><SPAN>6 = LED = 2252 - Reviewed and found LED fixtures</SPAN></P><P STYLE="text-indent:20;"><SPAN>8 = LED = 9 - Reviewed and found LED fixtures</SPAN></P><P STYLE="text-indent:20;"><SPAN>9 = 8 - New requested lights State streets</SPAN></P><P><SPAN /></P><P><SPAN /></P><P><SPAN /></P></DIV></DIV></DIV>
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.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: 3216919.6637475
YMin: 1.38215440849153E7
XMax: 3284565.5570328087
YMax: 1.387728247854431E7
Spatial Reference: 102740
(2278)
VCSWkid(115702)
LatestVCSWkid(115702)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [0, 112, 255, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
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
)
-
Ref_ID
(
type: esriFieldTypeInteger, alias: Ref_ID, editable: true, nullable: true, defaultValue: null, modelName: Ref_ID
)
-
LIGHT
(
type: esriFieldTypeDouble, alias: LIGHT, editable: true, nullable: true, defaultValue: null, modelName: LIGHT
)
-
ESI
(
type: esriFieldTypeString, alias: ESI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ESI
)
-
PREFIX
(
type: esriFieldTypeString, alias: PREFIX, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PREFIX
)
-
STREET
(
type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET
)
-
SUFFIX
(
type: esriFieldTypeString, alias: SUFFIX, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SUFFIX
)
-
STYLE
(
type: esriFieldTypeString, alias: STYLE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STYLE
)
-
TYPE
(
type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE
)
-
LAMPS
(
type: esriFieldTypeDouble, alias: LAMPS, editable: true, nullable: true, defaultValue: null, modelName: LAMPS
)
-
PLACEMENT
(
type: esriFieldTypeString, alias: PLACEMENT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PLACEMENT
)
-
WIRING
(
type: esriFieldTypeString, alias: WIRING, editable: true, nullable: true, length: 254, defaultValue: null, modelName: WIRING
)
-
Owner_Name
(
type: esriFieldTypeString, alias: Owner_Name, editable: true, nullable: true, length: 70, defaultValue: null, modelName: Owner_Name
)
-
MAINT_PROV
(
type: esriFieldTypeString, alias: MAINT_PROV, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAINT_PROV
)
-
Status
(
type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Status
)
-
Score
(
type: esriFieldTypeDouble, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score
)
-
Match_type
(
type: esriFieldTypeString, alias: Match_type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Match_type
)
-
Match_addr
(
type: esriFieldTypeString, alias: Match_addr, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Match_addr
)
-
Side
(
type: esriFieldTypeString, alias: Side, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Side
)
-
User_fld
(
type: esriFieldTypeString, alias: User_fld, editable: true, nullable: true, length: 120, defaultValue: null, modelName: User_fld
)
-
Addr_type
(
type: esriFieldTypeString, alias: Addr_type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Addr_type
)
-
ARC_Street
(
type: esriFieldTypeString, alias: ARC_Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ARC_Street
)
-
ARC_City
(
type: esriFieldTypeString, alias: ARC_City, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ARC_City
)
-
ARC_State
(
type: esriFieldTypeString, alias: ARC_State, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ARC_State
)
-
ARC_ZIP
(
type: esriFieldTypeString, alias: ARC_ZIP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ARC_ZIP
)
-
BLOCK
(
type: esriFieldTypeDouble, alias: BLOCK, editable: true, nullable: true, defaultValue: null, modelName: BLOCK
)
-
ZIP
(
type: esriFieldTypeDouble, alias: ZIP, editable: true, nullable: true, defaultValue: null, modelName: ZIP
)
-
PROVIDER
(
type: esriFieldTypeString, alias: PROVIDER, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROVIDER
)
-
Tre
(
type: esriFieldTypeString, alias: Tre, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Tre
)
-
TPCheck
(
type: esriFieldTypeString, alias: TPCheck, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TPCheck
)
-
F16
(
type: esriFieldTypeString, alias: F16, editable: true, nullable: true, length: 254, defaultValue: null, modelName: F16
)
-
order_
(
type: esriFieldTypeDouble, alias: order_, editable: true, nullable: true, defaultValue: null, modelName: order_
)
-
Address
(
type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Address
)
-
BT_Num
(
type: esriFieldTypeString, alias: BT_Num, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BT_Num
)
-
BT_Address
(
type: esriFieldTypeString, alias: BT_Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BT_Address
)
-
Condition
(
type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Condition
)
-
Condition2
(
type: esriFieldTypeString, alias: Condition2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition2
)
-
Addr_Num
(
type: esriFieldTypeString, alias: Addr_Num, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Addr_Num
)
-
Addr_Pref
(
type: esriFieldTypeString, alias: Addr_Pref, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Addr_Pref
)
-
Addr_Name
(
type: esriFieldTypeString, alias: Addr_Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Addr_Name
)
-
Addr_Typ
(
type: esriFieldTypeString, alias: Addr_Typ, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Addr_Typ
)
-
FACILITY
(
type: esriFieldTypeString, alias: FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITY
)
-
LT_PURPOSE
(
type: esriFieldTypeString, alias: LT_PURPOSE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LT_PURPOSE
)
-
Unique_ID
(
type: esriFieldTypeString, alias: Unique_ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Unique_ID
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
DateInstalled
(
type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled
)
Templates:
-
Name: BaytownGIS.SDE.Traffic_Street_Lights
Description:
Prototype:
DateInstalled: null
Ref_ID: null
LIGHT: null
ESI: null
PREFIX: null
STREET: null
SUFFIX: null
STYLE: null
TYPE: null
LAMPS: null
PLACEMENT: null
WIRING: null
Owner_Name: null
MAINT_PROV: null
Status: null
Score: null
Match_type: null
Match_addr: null
Side: null
User_fld: null
Addr_type: null
ARC_Street: null
ARC_City: null
ARC_State: null
ARC_ZIP: null
BLOCK: null
ZIP: null
PROVIDER: null
Tre: null
TPCheck: null
F16: null
order_: null
Address: null
BT_Num: null
BT_Address: null
Condition: null
Condition2: null
Addr_Num: null
Addr_Pref: null
Addr_Name: null
Addr_Typ: null
FACILITY: null
LT_PURPOSE: null
Unique_ID: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: true
Supports Rollback On Failure: false
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
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata