trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4077 102546 9 1 409 Illinois St 7 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015961.34604 2107137.76144 37.7666949900978 -122.388030764508 (37.7666949900978, -122.388030764508) 14 3 9 310 20
5864 189275 9 1 409 Illinois St 5 Sidewalk: Curb side : Cutout Tree 2     4 Width 5ft   6015964.59668 2107087.77889 37.7665579289401 -122.388016032733 (37.7665579289401, -122.388016032733) 14 3 9 310 20
6900 102545 9 1 409 Illinois St 6 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015962.79104 2107111.95809 37.7666242197475 -122.38802396564 (37.7666242197475, -122.38802396564) 14 3 9 310 20
9264 188788 9 1 409 Illinois St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 5ft   6015967.32751 2107012.0323 37.7663500965054 -122.388001300914 (37.7663500965054, -122.388001300914) 14 3 9 310 20
13982 189273 9 1 409 Illinois St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 5ft   6015966.51086 2107036.5181 37.7664172839651 -122.388005834417 (37.7664172839651, -122.388005834417) 14 3 9 310 20
14181 188787 9 1 409 Illinois St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 5ft   6015968.04519 2106982.6549 37.7662694722874 -122.387996768362 (37.7662694722874, -122.387996768362) 14 3 9 310 20
18169 189274 9 1 409 Illinois St 4 Sidewalk: Curb side : Cutout Tree 2     4 Width 5ft   6015965.43281 2107064.27168 37.7664934295578 -122.388011500129 (37.7664934295578, -122.388011500129) 14 3 9 310 20
585 75271 9 1 499 Illinois St 6 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015975.8041 2106880.05369 37.7659881814233 -122.387962771269 (37.7659881814233, -122.387962771269) 14 3 9 310 20
2007 188784 9 1 499 Illinois St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 6ft   6015979.83831 2106803.95395 37.7657794514949 -122.387943506912 (37.7657794514949, -122.387943506912) 14 3 9 310 20
5551 74240 9 1 499 Illinois St 8 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015971.85212 2106927.76687 37.7661189725478 -122.387979770277 (37.7661189725478, -122.387979770277) 14 3 9 310 20
7177 74026 9 1 499 Illinois St 9 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015970.5058 2106958.46215 37.7662031805546 -122.387986569137 (37.7662031805546, -122.387986569137) 14 3 9 310 20
9799 188783 9 1 499 Illinois St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 6ft   6015981.68348 2106781.73126 37.7657185350155 -122.387935573977 (37.7657185350155, -122.387935573977) 14 3 9 310 20
10795 188785 9 1 499 Illinois St 4 Sidewalk: Curb side : Cutout Tree 2     5 Width 6ft   6015978.05896 2106829.43815 37.7658493270204 -122.38795143981 (37.7658493270204, -122.38795143981) 14 3 9 310 20
13110 188782 9 1 499 Illinois St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 6ft   6015982.12636 2106754.96915 37.7656450765832 -122.387932174526 (37.7656450765832, -122.387932174526) 14 3 9 310 20
17556 75105 9 1 499 Illinois St 7 Sidewalk: Curb side : Cutout Tree 2   07/15/2016 12:00:00 AM 3 5x5   6015973.99843 2106904.23323 37.7660544731729 -122.387970704195 (37.7660544731729, -122.387970704195) 14 3 9 310 20
17659 188786 9 1 499 Illinois St 5 Sidewalk: Curb side : Cutout Tree 2     5 Width 6ft   6015977.25571 2106854.57611 37.7659183059205 -122.387955972402 (37.7659183059205, -122.387955972402) 14 3 9 310 20