trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
46414 112583 10 6 3400x WAWONA ST 1 Sidewalk: Property side : Cutout Tree 2     1 4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
43905 103465 10 33 890X Sansome St 1 Sidewalk: Curb side : Cutout Tree 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
43321 108260 10 37 45 Belcher St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.54469 37.7686143220373 -122.430103370918 (37.7686143220373, -122.430103370918) 7 9 5 28862 3
43092 85452 10 17 275 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138 2107427 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748) 8 4 7 28853 19
43048 98285 10 136 300 Mangels Ave 1 Sidewalk: Property side : Yard Tree 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
42613 85457 10 17 265 Guerrero St 3 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
42158 43568 10 22 601 29TH ST 2 Sidewalk: Curb side : Cutout Tree 2   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
41654 112585 10 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
41644 109948 10 39 400x CLEMENTINA ST 8 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
41083 101926 10 39 1099X Hyde St 3 Sidewalk: Curb side : Cutout Tree 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
38713 113610 10 9 595 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
38343 85458 10 17 265 Guerrero St 4 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
37646 110789 10 15 850x SANCHEZ ST 3 Front Yard : Cutout Tree 2       3x3   6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
34396 116471 10 177 882 Carolina St   Sidewalk: Curb side : Cutout Tree 2   04/04/2016 12:00:00 AM 3 3x3   6012399.9 2103853.8 37.757480004392 -122.400118621436 (37.757480004392, -122.400118621436) 10 3 8 28856 29
33280 110797 10 146 440 29th St 1 Sidewalk: Curb side : Cutout Tree 2   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.7436064433062 -122.429866615733 (37.7436064433062, -122.429866615733) 2 7 5 63 22
26043 100060 10 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
25414 109115 10 22 2036x 15TH ST 1 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
23848 114246 10 19 54 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
23235 109950 10 39 400x CLEMENTINA ST 10 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
23173 109936 10 11 260 05th St 5 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
22900 103469 10 33 799X Battery St 2 Sidewalk: Curb side : Cutout Tree 2           6012272.7 2118721.6 37.7982964705447 -122.401603488036 (37.7982964705447, -122.401603488036) 3 1 10 28860 6
21125 109116 10 22 2036x 15TH ST 2 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
20563 109121 10 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
20128 103466 10 33 890X Sansome St 2 Sidewalk: Curb side : Cutout Tree 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
15934 113606 10 9 2900 18TH ST 4 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
13217 109951 10 39 400x CLEMENTINA ST 11 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
12295 108536 10 11 1036X Mission St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009831.24398 2112235.16984 37.7803497589148 -122.409593644194 (37.7803497589148, -122.409593644194) 14 2 9 28853 34
6989 109119 10 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
6326 117138 10 8 2203x NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
4156 221064 10 14 2 Page St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6006466.14931 2110109.21502 37.7743232636311 -122.421084097148 (37.7743232636311, -122.421084097148) 7 9 11 28852 10
963 109935 10 11 260 05th St 4 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34