trees

Custom SQL query returning 18 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
9272 245113 1 90 265 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   5999808.2851 2109439.1163 37.7721057759535 -122.444066643429 (37.7721057759535, -122.444066643429) 15 5 11 29492 9
33803 247397 1 90 313 Scott St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6002217.7088 2109675.3523 37.7728915755216 -122.435749167904 (37.7728915755216, -122.435749167904) 15 5 11 29492 9
46049 244486 1 90 267 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   5999805.9584 2109458.3944 37.7721585760078 -122.444076077102 (37.7721585760078, -122.444076077102) 15 5 11 29492 9
60442 246062 1 90 644 Clayton St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   5998535.261 2108439.0074 37.7692870283806 -122.448398084106 (37.7692870283806, -122.448398084106) 15 5 11 29492 9
64002 245168 7 90 233 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/21/1974 12:00:00 AM 20 Width 0ft Permit Number 14310 5999825.2365 2109323.448 37.7717891470569 -122.443999694963 (37.7717891470569, -122.443999694963) 15 5 11 29492 9
70997 137835 1 90 2275 CALIFORNIA ST 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6003493.4112 2115546.0928 37.7890835426752 -122.431755607924 (37.7890835426752, -122.431755607924) 13 9 1 29490 27
71452 142122 1 90 16 HEMWAY TER 1 Sidewalk: Curb side : Yard Tree 2     12 Width 0ft   5998654.7965 2110846.2756 37.7759036047997 -122.448157977873 (37.7759036047997, -122.448157977873) 15 6 2 29492 16
79211 244487 1 90 255 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999812.606 2109402.2221 37.772004720305 -122.444049045701 (37.772004720305, -122.444049045701) 15 5 11 29492 9
96819 245114 1 90 257 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   5999810.2794 2109420.503 37.7720547823085 -122.444058407339 (37.7720547823085, -122.444058407339) 15 5 11 29492 9
100336 246061 1 90 644 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5998536.4724 2108422.6546 37.7692421970101 -122.448392716164 (37.7692421970101, -122.448392716164) 15 5 11 29492 9
111522 245133 1 90 247 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   5999815.2651 2109384.2736 37.7719555899544 -122.444038557826 (37.7719555899544, -122.444038557826) 15 5 11 29492 9
116824 247477 1 90 864 Page St 1 Sidewalk: Curb side : Yard Tree 2     14 Width 0ft   6002445.2342 2109547.3008 37.7725528991659 -122.434952972157 (37.7725528991659, -122.434952972157) 15 5 11 29492 9
117355 182966 1 90 2430 21st Ave 1 Sidewalk: Curb side : Yard Tree 2     9 Width 0ft   5989858.6972 2098819.7917 37.7423753326027 -122.477706327536 (37.7423753326027, -122.477706327536) 1 8 3 29491 35
133175 162236 1 90 403 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6008707.08373 2087980.38348 37.7136884504429 -122.411768311455 (37.7136884504429, -122.411768311455) 9 7 8 309 39
133875 142911 1 90 478 GREEN ST 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6010646.636 2119298.6482 37.7997900351201 -122.407270886324 (37.7997900351201, -122.407270886324) 3 1 10 308 23
136970 245134 1 90 245 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999817.9241 2109365.3279 37.7719037215376 -122.444027998646 (37.7719037215376, -122.444027998646) 15 5 11 29492 9
143612 141065 1 90 193 Cook St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5997591.6366 2112595.3291 37.7806452152507 -122.451961919026 (37.7806452152507, -122.451961919026) 15 6 2 54 16
146118 245157 1 90 241 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5999819.9184 2109349.706 37.771860941516 -122.444019977581 (37.771860941516, -122.444019977581) 15 5 11 29492 9