City of Gainesville

Close
Author
City of Gainesville
Description
LED street lights that are installed and maintained by Public Works. This is not a comprehensive list of all Public Works street lights and is currently missing the lights in Innovation Square and on Depot Avenue.
Category
Community Model
Tags
street, lights, led, public works
Rating
Current value: 0 out of 5
Data Provided By
City of Gainesville - Public Works Department
License
Public Domain
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

LAMP
lamp
the_geom
the_geom
SUBTYPE
subtype
OBJECTID_1
objectid_1
MOUNTHEIGH
mountheigh
COLOR
color
OWNER
owner
INSTALLATI
installati
INSTALL_NU
install_nu
STREETADDR
streetaddr
STRUCTUREI
structurei
LED_Type
led_type
Notes
notes
OBJECTID
objectid
CREATIONUS
creationus
DATECREATE
datecreate
DATEMODIFI
datemodifi
LASTUSER
lastuser
NUMBEROFLA
numberofla
ARMLENGTH
armlength
ARMDIRECTI
armdirecti
BILLINGGRO
billinggro
SUPPORTSTR
supportstr
SYMBOLROTA
symbolrota
STATUS
status
WORKREQUES
workreques
DESIGNID
designid
WORKLOCATI
worklocati
WORKFLOWST
workflowst
WORKFUNCTI
workfuncti
UNIT_TYPE
unit_type
AGREEMENT
agreement
GRUGISID
grugisid
GLOBALID
globalid
FACILITYID
facilityid
Project
project
Status_1
status_1
Meter
meter
ProjectIDN
project_idn

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.