trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
17239 32497 6 40 665 Andover St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.30694 2095863.10154 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676) 2 7 7 28859 2
17429 103965 6 17 141 Marview Way 1 Front Yard : Yard Tree 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
17557 261982 6 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
17656 261984 6 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
17902 113640 6 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
17949 100194 6 163 361 Dellbrook Ave 2 Front Yard : Yard Tree 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18324 109414 6 34 4 GUY PL 1 Front Yard : Yard Tree 2     14     6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
18482 260468 6 185 1 Masonic Ave 3 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
18988 103657 6 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
19052 260948 6 15 370 Drumm St 1 Side Yard : Yard Tree 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
19112 261751 6 51 127 Edgehill Way 1 Back Yard : Cutout Tree 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
19367 254458 6 17 1055X Duncan St 3 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
19388 114226 6 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
19573 254456 6 113 1055X Duncan St 1 Side Yard : Yard Tree 2                              
19958 104685 6 36 33 08th St 7 Front Yard : Yard Tree 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
20037 100423 6 47 155 Winston Dr 1 Front Yard : Yard Tree 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
20207 105239 6 17 20X Cleary Ct 6 Front Yard : Yard Tree 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
20228 251632 6 41 14R Amethyst Way 1 Back Yard : Yard Tree 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
20298 113730 6 36 1580 Valencia St 7 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
20385 251602 6 95 44R Amber Dr 1 Back Yard : Yard Tree 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
20461 104283 6 17 150X Middle Point Rd 5 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
21577 114229 6 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21762 100124 6 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
22018 106361 6 155 1645 WEBSTER ST 2 Front Yard : Yard Tree 2     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
22273 106336 6 15 112 EUGENIA AVE 1 Front Yard : Yard Tree 2     18     6006345.6 2098165.7 37.7415223501304 -122.420653072553 (37.7415223501304, -122.420653072553) 2 7 7 28859 2
22296 113639 6 175 1X Russ St 3 Sidewalk: Property side : Cutout Tree 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
22312 116999 6 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
22628 101981 6 93 25X Tiffany Ave 4 Front Yard : Yard Tree 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
22679 108026 6 155 862 Kansas St   Front Yard : Yard Tree 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
22846 105861 6 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
22915 92852 6 250 3794 16th St 1 Front Yard : Yard Tree 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
22976 103600 6 41 50X Hermann St 1 Front Yard : Yard Tree 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
23065 98547 6 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
23199 112923 6 155 2X Noe St   Sidewalk: Property side : Yard Tree 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
23401 114142 6 15 99 Divisadero St   Front Yard : Yard Tree 2           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265) 15 5 5 29492 3
23427 107541 6 15 2 GARFIELD ST 4 Back Yard : Yard Tree 2     36     5993976.6 2090624.3 37.7201106425596 -122.462873531809 (37.7201106425596, -122.462873531809) 9 8 6 64 24
23771 105863 6 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23877 105554 6 58 410 Elizabeth St 1 Front Yard : Yard Tree 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 2 4 5 28862 22
23924 92900 6 56 208 States St 4 Back Yard : Yard Tree 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
23985 114387 6 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
24444 173927 6 15 240 States St 1 Back Yard : Yard Tree 2           6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
24668 97534 6 63 203 Surrey St 1 Front Yard : Yard Tree 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
24833 104679 6 36 33 08th St 1 Front Yard : Yard Tree 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
24927 107413 6 285 276 Yerba Buena Ave 1 Front Yard : Yard Tree 2     28     5995080.66446 2095640.15746 37.7339465073544 -122.459420244296 (37.7339465073544, -122.459420244296) 9 8 4 59 40
25337 106567 6 17 50 Mendell St 1 Front Yard : Yard Tree 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
25451 105226 6 17 1150X Golden Gate Ave 1 Front Yard : Yard Tree 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
26236 99105 6 11 1400@ Mendell Evans Ave 1 Front Yard : Yard Tree 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
26401 114389 6 27 345x ARBALLO DR 1 Front Yard : Yard Tree 2     8     5988176 2090635 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788) 1 8 4 64 14
27121 114234 6 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
27545 115090 6 17 121 Topaz Way 1 Front Yard : Yard Tree 2   01/11/2016 12:00:00 AM     Permit Number 776934 6001846.4 2098050 37.7409500647868 -122.436201464472 (37.7409500647868, -122.436201464472) 2 7 5 63 7
27763 105240 6 17 20X Cleary Ct 10 Front Yard : Yard Tree 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
27831 98834 6 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
27944 252826 6 72 3852 17th St 5 Front Yard : Yard Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
28176 114157 6 15 1200x JUNIPERO SERRA BLVD 18 Front Yard : Yard Tree 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
28198 106364 6 127 155 BORICA ST 1 Front Yard : Yard Tree 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
28871 100193 6 163 361 Dellbrook Ave 1 Front Yard : Yard Tree 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
29114 103653 6 17 307X Octavia St 2 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
29607 101467 6 185 301 Hazelwood Ave 2 Front Yard : Yard Tree 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
30455 114232 6 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30460 104285 6 17 71X Middle Point Rd 1 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
30556 104909 6 15 533 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
30591 105422 6 15 5827 DIAMOND HEIGHTS BLVD 1 Front Yard : Yard Tree 2     36     6000844.1 2096795.2 37.7374476811542 -122.439577108095 (37.7374476811542, -122.439577108095) 2 7 5 63 7
30713 99829 6 109 2398 Broadway 3 Front Yard : Yard Tree 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
31451 114152 6 15 1200X JUNIPERO SERRA BLVD 11 Front Yard : Yard Tree 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
31523 98952 6 52 302 Ivy St 18 Front Yard : Yard Tree 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
31713 107635 6 7 1150 Lombard St 10 Front Yard : Yard Tree 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.420576003873 (37.8027004912885, -122.420576003873) 5 1 1 28858 32
32630 85060 6 41 7070 California St 1 Front Yard : Cutout Tree 2   07/03/2007 12:00:00 AM     Permit Number 49405 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
32725 106972 6 17 464 46TH AVE 3 Front Yard : Yard Tree 2   08/07/2014 12:00:00 AM     Permit Number 773827 5981646.2 2112608 37.7797537818913 -122.507124798545 (37.7797537818913, -122.507124798545) 11 6 2 55 26
32951 112484 6 52 1275 Columbus Ave 4 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
33433 104433 6 28 1601X PORTOLA DR 2 Front Yard : Yard Tree 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
34055 105417 6 70 1450X McAllister St 3 Front Yard : Yard Tree 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
34175 87149 6 155 4 Bellair Pl 2 Back Yard : Yard Tree 2           6010093 2120950 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994) 3 1 10 308 23
34428 251636 6 15 22R Amethyst Way 1 Back Yard : Yard Tree 2           5999148 2100052 37.7462933941297 -122.445675437709 (37.7462933941297, -122.445675437709) 2 7 5 63 22
34585 104280 6 17 150X Middle Point Rd 2 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
34658 104715 6 113 3618 22nd St 1 Sidewalk: Property side : Yard Tree 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
34754 101438 6 16 600X Grant Ave 3 Front Yard : Yard Tree 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
34770 251426 6 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
34790 105768 6 15 98X GOLD MINE DR 3 Front Yard : Yard Tree 2     16     6001350 2099153 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375) 2 7 5 63 22
35139 104434 6 28 1601X PORTOLA DR 3 Front Yard : Yard Tree 2     13     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
35186 100579 6 17 35 Lloyd St 2 Front Yard : Yard Tree 2           6002279.7 2108550 37.7698051576272 -122.435454215606 (37.7698051576272, -122.435454215606) 15 5 5 29492 9
35440 97955 6 438 2 Mendosa Ave 1 Front Yard : Yard Tree 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
35675 105864 6 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35918 109061 6 15 36 ARBOR ST   Front Yard : Yard Tree 2         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151) 2 7 5 63 7
36007 107047 6 17 1933 15TH ST   Front Yard : Yard Tree 2           6004592.7 2107127.1 37.7660293092823 -122.427352228532 (37.7660293092823, -122.427352228532) 8 4 5 28862 3
36574 107552 6 17 1 Newhall St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
36670 87156 6 57 237 Rivoli St 1 Front Yard : Yard Tree 2         Permit Number 50138 5997662 2105892 37.7622436280127 -122.451234923187 (37.7622436280127, -122.451234923187) 15 5 11 29492 9
36736 101527 6 333 151-153 Lower Ter 1 Front Yard : Yard Tree 2     18   Permit Number 769490 6000139.7 2106146.6 37.7630842500585 -122.4426838025 (37.7630842500585, -122.4426838025) 15 5 5 28862 3
37022 95985 6 113 577 Sanchez St 1 Front Yard : Tree 2           6003673 2104901 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
37050 252828 6 273 3852 17th St 7 Front Yard : Yard Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
37139 98289 6 9 300 Mangels Ave 5 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
37158 254238 6 41 47 Cole St 3 Front Yard : Yard Tree 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
37483 85089 6 83 1600 Chestnut St 2 Sidewalk: Property side : Cutout Tree 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
37603 93205 6 41 400 Masonic Ave 3 Front Yard : Yard Tree 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
37736 101041 6 17 3750 18th St 1 Front Yard : Yard Tree 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
38032 110839 6 17 2037 TURK BLVD 1 Front Yard : Yard Tree 2     13     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
38051 108038 6 15 1 Twin Peaks Blvd   Front Yard : Yard Tree 2           5998985.48572 2105240.3128 37.7605299471227 -122.446610614338 (37.7605299471227, -122.446610614338) 15 5 5 28862 12
38129 114239 6 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
38717 98546 6 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
38818 105964 6 17 360 MISSOURI ST 1 Front Yard : Yard Tree 2           6013401.8 2105413.2 37.7618175880082 -122.396762946114 (37.7618175880082, -122.396762946114) 10 3 8 28856 29
38864 114149 6 15 1200X JUNIPERO SERRA BLVD 8 Front Yard : Yard Tree 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
38960 103564 6 113 878 14th St 2 Front Yard : Yard Tree 2     13   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3