Click to Home
Go To Search
Department of Transportation
San Jose Home
Streetlight Location Data Download

Streetlight Location Data in Excel and ESRI shapefile format 

  1. Excel Table (with lat/long)
  2. Shapefile (.zip shapefile folder)
The two .zip files on this page contain the location and other key information for city owned and operated street lights within San Jose. 

You may download by selecting/clicking on either file and the download should automatically begin - or you can right-click and choose "Save target as..." to download the file.  Once downloaded, the files must be unzipped in order to be used.

The following information is included for each streetlight location:

  • street light’s badge ID
  • address
  • item_code (pre LED)
  • pole type
  • suspension
  • pole use
  • latitude and longitude
  • LED model type 
  • LED manufature 
  • pole install date
  • LED install date
  • LED status