trees

Custom SQL query returning 55 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1694 100166 8 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree 2         Permit Number 769026                    
5758 262529 8 63 555 Portola Dr 8 Front Yard : Yard Tree 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
10450 114373 8 37 805 GONZALEZ DR 1 Front Yard : Yard Tree 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
12060 101900 8 15 1100 Ocean Ave 1 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
13614 258670 8 15 152 Kensington Way   Front Yard : Yard Tree 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
20402 257888 8 28 155X Magellan Ave 1 Front Yard : Yard Tree 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
20715 99276 8 17 85X 10th St 2 Front Yard : Yard Tree 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
22075 187658 8 42 600X Clarendon Ave 1 Front Yard : Yard Tree 2       3x3   5995637 2102382 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932) 1 5 4 63 12
23775 108576 8 45 2479 Diamond St 1 Front Yard : Yard Landscaping 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
27030 106971 8 15 3479X San Bruno Ave 1 Front Yard : Yard Tree 2     30     6011510.60551 2091910.03431 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294) 10 3 7 309 28
30075 100070 8 17 331 Serrano Dr 1 Front Yard : Yard Tree 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
30542 98548 8 155 132 Hamerton Ave 1 Front Yard : Yard Tree 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
31670 104539 8 113 1101 Van Ness Ave 2 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
33684 97290 8 15 55 Hiliritas Ave   Front Yard : Yard Tree 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
42557 101977 8 109 601 Grand View Ave   Front Yard : Yard Tree 2           6000076.2 2101609.9 37.7506239629918 -122.442577679409 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
44661 102745 8 41 222 Moncada Way 1 Front Yard : Yard Tree 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
49750 104540 8 113 1101 Van Ness Ave 4 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
52825 104544 8 113 1101 Van Ness Ave 8 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
53202 102251 8 317 125X Powhattan Ave 4 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
53937 94690 8 348 749 Congo St   Front Yard : Yard Tree 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
54121 101901 8 16 1100 Ocean Ave 2 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
56024 105231 8 100 460X ROOSEVELT WAY 1 Front Yard : Yard Tree 2     9     6000051 2106345 37.7636239504047 -122.443004833609 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
57437 108624 8 113 101 GENEBERN WAY 1 Front Yard : Yard Tree 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
58309 100046 8 17 562 28th St   Front Yard : Yard Tree 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
68497 99961 8 67 537 Valley St 1 Front Yard : Yard Tree 2   07/25/2012 12:00:00 AM     Permit Number 768880 6002459 2099152 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356) 2 7 5 63 22
75016 98140 8 41 315 San Marcos Ave   Front Yard : Yard Tree 2           5992920.8 2100212.1 37.7463754865467 -122.467219803339 (37.7463754865467, -122.467219803339) 1 8 4 29491 40
86207 104538 8 113 1101 Van Ness Ave 1 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
89589 99277 8 17 85X 10th St 3 Front Yard : Yard Tree 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
95526 100139 8 17 155 05th St 2 Front Yard : Yard Tree 2         Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
96626 91109 8 17 2650 Turk Blvd 2 Front Yard : Yard Tree 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
99497 104543 8 113 1101 Van Ness Ave 7 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101616 102250 8 9 125X Powhattan Ave 3 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
101786 104542 8 113 1101 Van Ness Ave 6 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101831 120995 8 284 231 Delano Ave 1 Front Yard : Yard Landscaping 2       3x3   6000066 2092260 37.7249507611268 -122.44194193564 (37.7249507611268, -122.44194193564) 9 7 6 28861 25
103261 99275 8 17 85X 10th St 1 Front Yard : Yard Tree 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
103546 113379 8 272 140 CASTENADA AVE 1 Front Yard : Yard Tree 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
105239 110843 8 285 2037 TURK BLVD   Front Yard : Yard Tree 2     15     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
108303 102249 8 9 125X Powhattan Ave 2 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
109556 91108 8 17 2650 Turk Blvd 1 Front Yard : Yard Tree 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
117229 102248 8 9 125X Powhattan Ave 1 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
117341 104397 8 285 350 Collingwood St 1 Front Yard : Yard Tree 2           6002086 2103822 37.7568122198273 -122.435785890783 (37.7568122198273, -122.435785890783) 2 4 5 28862 3
120627 100045 8 111 556 28th St   Front Yard : Yard Tree 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
121285 104318 8 19 22 Beaver St 1 Front Yard : Yard Tree 2       3x3   6002763 2106816 37.765071454108 -122.433658549479 (37.765071454108, -122.433658549479) 15 5 5 28862 3
124153 118318 8 58 20 Norton St 1 Front Yard : Yard Tree 3           6002015.68632 2092167.12899 37.7248066672809 -122.435195459751 (37.7248066672809, -122.435195459751) 9 7 6 28861 25
128219 101903 8 72 1100 Ocean Ave 4 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
129765 105353 8 17 1979 SAN JOSE AVE 2 Front Yard : Yard Tree 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
144842 101905 8 72 1100 Ocean Ave 6 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
146144 105171 8 19 4755X 03RD ST 5 Front Yard : Yard Tree 19     14 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
149052 105232 8 15 460X ROOSEVELT WAY 2 Front Yard : Yard Tree 2     17     5999944 2106286 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769) 15 5 5 29492 3
162706 94228 8 216 1097 Church St   Front Yard : Yard Tree 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
169065 108625 8 34 100 GENEBERN WAY 1 Front Yard : Yard Tree 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
181064 104568 8 113 1101 Van Ness Ave 9 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 8 113 1101 Van Ness Ave 5 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
191552 101904 8 72 1100 Ocean Ave 5 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
192549 98880 8 41 101 Lansdale Ave 1 Front Yard : Yard Tree 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40