trees

Custom SQL query returning 35 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1242 125338 1 180 943 Green St 13 Side Yard : Yard Tree 2     7     6008681.05502 2118993.3413 37.7988415354762 -122.414050937395 (37.7988415354762, -122.414050937395) 5 1 10 308 21
2998 261600 8 180 451X Jersey St 1 Back Yard : Yard Tree 12       3x3   6002237 2101405 37.7501842910814 -122.435090813874 (37.7501842910814, -122.435090813874) 2 4 5 28862 22
7911 221663 1 180 355 Masonic Ave 15 Front Yard : Yard Tree 2     8 Width 3ft   6000243.57338 2106889.96572 37.7651312687056 -122.442377910911 (37.7651312687056, -122.442377910911) 15 5 5 28862 3
9386 221661 1 180 332 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 5ft   6006177.94117 2101108.79634 37.7495939748898 -122.421441743156 (37.7495939748898, -122.421441743156) 2 4 5 28859 19
14314 101224 4 180 1X Trainor St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008353.8 2108315.6 37.7695046482274 -122.414427404273 (37.7695046482274, -122.414427404273) 8 4 7 28853 19
32822 221658 1 180 619 28th St 1 Sidewalk: Curb side : Yard Tree 2     10 Width 2ft   6001870.44358 2099404.83716 37.7446714960931 -122.436215264321 (37.7446714960931, -122.436215264321) 2 7 5 63 22
42868 221654 1 180 2 Trainor St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6008310.98632 2108259.27286 37.7693475818501 -122.414571509075 (37.7693475818501, -122.414571509075) 8 4 7 28853 19
44309 125336 1 180 943 Green St 8 Side Yard : Yard Tree 2     13     6008636.03175 2118982.55728 37.7988093963818 -122.414205969747 (37.7988093963818, -122.414205969747) 5 1 10 308 21
58922 221659 1 180 619 28th St 2 Sidewalk: Curb side : Yard Tree 2     11 Width 2ft   6001877.83925 2099406.20223 37.7446756644454 -122.43618978925 (37.7446756644454, -122.43618978925) 2 7 5 63 22
60583 203310 1 180 711 Joost Ave 1 Sidewalk: Property side : Yard Tree 2     16     5997341.17783 2094972.11297 37.7322419310188 -122.45155682788 (37.7322419310188, -122.45155682788) 9 7 4 59 40
64555 221657 1 180 119 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6006195.39377 2102302.17548 37.7528717042805 -122.421466132763 (37.7528717042805, -122.421466132763) 2 4 5 28859 19
72319 40311 7 180 121 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/28/2004 12:00:00 AM     Permit Number 41453 6006197.56884078 2102286.11075476 37.7528277168801 -122.421457470156 (37.7528277168801, -122.421457470156) 2 4 5 28859 19
75788 203309 1 180 300x Marietta Dr 44 Median : Cutout Tree 1     12 Width 5ft   5999493.35383 2097506.12856 37.7393227521334 -122.444298328617 (37.7393227521334, -122.444298328617) 9 7 4 59 40
78163 199803 1 180 1330 Donner Ave 1 Sidewalk: Curb side : Pot Tree 2     3 Width 0ft   6015357.8938 2090741.5774 37.72164101353 -122.388973157072 (37.72164101353, -122.388973157072) 10 3 8 58 1
80276 221660 1 180 1106 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6008028.11056 2101448.31178 37.7506303518144 -122.415067804458 (37.7506303518144, -122.415067804458) 2 4 7 28859 19
81497 221655 1 180 1801 Alabama St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   6009351.71824 2099059.68883 37.7441460132414 -122.410322008262 (37.7441460132414, -122.410322008262) 2 7 7 28859 2
85937 125346 1 180 37 MacOndray Ln 2 Sidewalk: Property side : Yard Tree 2     32     6008495.12972 2119144.49563 37.799246123364 -122.414705004452 (37.799246123364, -122.414705004452) 5 1 10 308 32
86745 40312 7 180 123 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/13/1999 12:00:00 AM 6 3x3 Permit Number 41454 6006197.01673983 2102279.01915111 37.7528082138393 -122.421458875834 (37.7528082138393, -122.421458875834) 2 4 5 28859 19
94026 203311 1 180 197 Vernon St 1 Sidewalk: Property side : Yard Tree 2     8 Width 8ft   5992432.99188 2089152.6134 37.7159807180098 -122.46810221944 (37.7159807180098, -122.46810221944) 9 8 6 64 24
108501 125340 1 180 943 Green St 15 Side Yard : Yard Tree 2     20     6008683.32426 2118993.96894 37.7988433862724 -122.414043129483 (37.7988433862724, -122.414043129483) 5 1 10 308 21
110595 125344 1 180 900 Green St 36 Front Yard : Yard Tree 2     10     6008567.57414 2119009.84956 37.7988804887064 -122.414444788317 (37.7988804887064, -122.414444788317) 5 1 10 308 32
113478 120550 1 180 298x Corbett Ave 1 Side Yard : Yard Tree 1     10   Permit Number 778898 5999572 2105342 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505) 15 5 5 28862 3
117525 125342 1 180 900 Green St 34 Front Yard : Yard Tree 2     44     6008569.92711 2119005.57592 37.7988688865349 -122.414436343681 (37.7988688865349, -122.414436343681) 5 1 10 308 32
123492 181835 1 180 1201 Santiago St 4 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   5989284.9043 2099668.4623 37.7446722442303 -122.479752392917 (37.7446722442303, -122.479752392917) 1 8 3 29491 35
138972 125343 1 180 900 Green St 35 Front Yard : Yard Tree 2     49     6008565.48376 2119003.63515 37.7988633080488 -122.414451581778 (37.7988633080488, -122.414451581778) 5 1 10 308 32
145854 125339 1 180 943 Green St 14 Side Yard : Yard Tree 2     10     6008681.4461 2118995.91753 37.7988486311296 -122.414049766478 (37.7988486311296, -122.414049766478) 5 1 10 308 21
153252 251819 1 180 298X Corbett Ave 1 Side Yard : Yard Tree 1       3x3 Permit Number 778898 5999572 2105342 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505) 15 5 5 28862 3
156604 139572 1 180 2101 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   6000749.1121 2112733.0668 37.7812037552799 -122.441048612085 (37.7812037552799, -122.441048612085) 15 5 1 29490 41
158875 221662 1 180 332 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 5ft   6006179.18858 2101087.67748 37.7495360576606 -122.421435929945 (37.7495360576606, -122.421435929945) 2 4 5 28859 19
165651 125345 1 180 37 MacOndray Ln 1 Sidewalk: Property side : Yard Tree 2     14     6008486.65637 2119146.05481 37.7992499284092 -122.414734435667 (37.7992499284092, -122.414734435667) 5 1 10 308 32
172215 125341 1 180 900 Green St 18 Front Yard : Yard Tree 2     18     6008614.63085 2119005.8231 37.7988720764367 -122.414281671073 (37.7988720764367, -122.414281671073) 5 1 10 308 32
184290 192452 1 180 2009 17th St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   1 Width 3ft   6011358.82025 2106481.94376 37.7646381974302 -122.403904049543 (37.7646381974302, -122.403904049543) 8 3 8 28856 29
190070 125337 1 180 943 Green St 10 Side Yard : Yard Tree 2     35     6008660.27555 2118990.50152 37.7988325710362 -122.414122640373 (37.7988325710362, -122.414122640373) 5 1 10 308 21
192774 221656 1 180 123 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6006192.45721 2102280.00009 37.7528106501898 -122.421474713209 (37.7528106501898, -122.421474713209) 2 4 5 28859 19
194202 125335 1 180 945 Green St 2 Front Yard : Yard Tree 2     19     6008588.90325 2118969.76345 37.7987716203837 -122.414368144483 (37.7987716203837, -122.414368144483) 5 1 10 308 21