sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1500 251574 3 5 191 Portola Dr 1 9 1 2       3x3   5999731.0 2100707.0 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
10116 173859 3 5 118 Saint Mary's Ave 5 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
10123 173857 3 5 118 Saint Mary's Ave 3 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
10125 173858 3 5 118 Saint Mary's Ave 4 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
16111 102843 2 5 1101X Portola Dr 10 9 1 2                    
90127 89023 3 5 2x Hollywood Ct 1 12 1 2           6000329.0 2088600.0 37.714916215224 -122.440770357879 (37.714916215224, -122.440770357879)
123948 29904 3 5 580 Fell St   1 1 2           6004657.19551 2110576.88809 37.7755052392808 -122.427374927138 (37.7755052392808, -122.427374927138)
145878 89262 1 5 1 Polk St   1 1 2       3x3 Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
1171 172952 3 5 3000X Van Ness Ave 1 1 1 2 6   0 Width 3ft   6005556.34576 2120733.12845 37.8034425497953 -122.42498731221201 (37.8034425497953, -122.424987312212)
17534 5492 3 5 719 Dolores St 1 1 1 2     1 8   6005040.753830001 2104151.1903 37.7578834965409 -122.425590680889 (37.7578834965409, -122.425590680889)
54812 175058 3 5 1132x Alemany Blvd 2 11 1 2     1 Width 3ft   6003548.97454 2094354.07012 37.7308984688672 -122.430051002559 (37.7308984688672, -122.430051002559)
55316 200609 3 5 1400x La Salle Ave 49 11 1 2     1 Width 0ft   6016412.3996 2095168.4353 37.7338546875634 -122.385636349995 (37.7338546875634, -122.385636349995)
62628 200574 3 5 1400x La Salle Ave 44 11 1 2     1 Width 0ft   6016364.4111 2095326.6015 37.734286324847005 -122.385813282871 (37.734286324847, -122.385813282871)
106349 22188 3 5 3955X 03rd St 10 1 1 2     1 6x4   6015734.92142 2098004.1287700003 37.74160341581771 -122.388176448398 (37.7416034158177, -122.388176448398)
133833 188653 3 5 300x Cargo Way 13 3 1 2     1     6017421.68385 2098629.86939 37.7434148869 -122.382387660761 (37.7434148869, -122.382387660761)
175369 188654 3 5 300x Cargo Way 12 3 1 2     1     6017424.39169 2098619.4012 37.7433862929421 -122.382377569482 (37.7433862929421, -122.382377569482)
2529 141382 3 5 1294X Fell St 1 1 1 2     2 Width 0ft   6001285.0 2110102.0 37.7740100190711 -122.439006092772 (37.7740100190711, -122.439006092772)
119608 188659 3 5 400x Cargo Way 3 3 1 2     2     6017103.6349 2098887.87453 37.744105743386 -122.383505361577 (37.744105743386, -122.383505361577)
1059 186952 3 5 2800 Sunset Blvd 26 3 1 2     3 Width 0ft   5985204.8226 2096075.4539 37.734568936321295 -122.493595616872 (37.7345689363213, -122.493595616872)
3196 9420 3 5 700X Golden Gate Ave 9 1 1 2     3 4X4   6005985.41292 2112474.4888400002 37.780790619431706 -122.422915195091 (37.7807906194317, -122.422915195091)
8111 6041 3 5 1830 Eddy St 1 1 1 2   10/19/1990 12:00:00 AM 3 3X3   6001487.9166 2112537.6047 37.78070911887679 -122.438478710972 (37.7807091188768, -122.438478710972)
13955 97226 3 5 1301X Newcomb Ave 6 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016643.51258 2094941.1276900002 37.7332433315076 -122.38482148523899 (37.7332433315076, -122.384821485239)
14140 6797 3 5 1375 Fairfax Ave 6 1 1 2   06/30/2011 12:00:00 AM 3     6016896.75135 2097199.75019 37.7394590596789 -122.384103192232 (37.7394590596789, -122.384103192232)
14947 24225 3 5 58 Whitney Young Cir 1 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6017167.401959999 2094982.30239 37.7333853506538 -122.38301310328698 (37.7333853506538, -122.383013103287)
15245 11544 3 5 101X Jennings St 34 1 1 2   12/23/1997 12:00:00 AM 3 3X3   6018840.43674 2097157.24182 37.7394496095988 -122.37737975539 (37.7394496095988, -122.37737975539)
16107 97223 3 5 1301X Newcomb Ave 3 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016661.55982 2094959.63165 37.733295137843 -122.384760378985 (37.733295137843, -122.384760378985)
16363 6635 3 5 1499 Evans Ave 3 1 1 2   01/02/2016 08:50:00 AM 3 3X3   6016265.445719999 2098016.2601900003 37.741666106596796 -122.38634290341801 (37.7416661065968, -122.386342903418)
16543 15277 3 5 1563X Mission St 2 11 1 2   10/28/2016 12:00:00 AM 3 4X4 Permit Number 777705 6007250.560819999 2109703.40074 37.7732531819334 -122.418341887077 (37.7732531819334, -122.418341887077)
18211 11709 3 5 700X Junipero Serra Blvd 26 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991284.83406 2092750.4086799999 37.7257930014245 -122.472332875878 (37.7257930014245, -122.472332875878)
19829 10274 3 5 218 Haight St 1 1 1 2   09/29/2016 03:07:00 PM 3 3x3   6004921.53459 2109545.1488200002 37.772687280827604 -122.426387037745 (37.7726872808276, -122.426387037745)
20767 5601 3 5 1120-1122 Dolores St 2 1 1 2   05/17/2016 12:00:00 AM 3 6X6   6005089.20528 2101804.2581 37.7514421059774 -122.425256113291 (37.7514421059774, -122.425256113291)
21068 29972 3 5 500X Junipero Serra Blvd 16 11 1 2   04/01/2007 12:00:00 AM 3 3x3   5991341.172 2093706.68724 37.7284219643784 -122.47220779725299 (37.7284219643784, -122.472207797253)
21269 5395 3 5 347 Dolores St 4 1 1 2   01/08/2014 12:00:00 AM 3 3x3   6004924.31069 2106310.22613 37.763805117627896 -122.426147093211 (37.7638051176279, -122.426147093211)
21937 29584 3 5 500X Junipero Serra Blvd 17 11 1 2   02/12/2016 12:00:00 AM 3 3X3   5991345.88941 2093701.3780900002 37.728407659786 -122.47219110225299 (37.728407659786, -122.472191102253)
42702 200540 3 5 1400x La Salle Ave 16 11 1 2     3 Width 0ft   6016179.8101 2095650.1621 37.7351645401576 -122.38647406665501 (37.7351645401576, -122.386474066655)
69580 188649 3 5 1700x Quesada Ave 50 3 1 2     3 Width 7ft   6014280.17751 2095342.33163 37.734213959905205 -122.393020304839 (37.7342139599052, -122.393020304839)
81565 443 3 5 700x 23rd Ave 3 11 1 2     3     5988815.988030001 2110428.99683 37.774190512498706 -122.482161976658 (37.7741905124987, -122.482161976658)
83214 448 3 5 700x 23rd Ave 8 11 1 2     3     5988818.05287 2110350.21953 37.773974331987795 -122.482149061597 (37.7739743319878, -122.482149061597)
88164 12734 3 5 1600 Lake St 1 1 1 2   09/23/2015 12:00:00 AM 3 3X3   5990479.84568 2114768.877 37.7862032574553 -122.476723596597 (37.7862032574553, -122.476723596597)
93273 21282 3 5 2492X Sunset Blvd 20 1 1 2     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671)
93717 25437 3 5 2555 Bay Shore Blvd 11 1 1 2   03/26/1998 12:00:00 AM 3 3x3   6010830.95304 2086585.06609 37.7099761086624 -122.40432925767401 (37.7099761086624, -122.404329257674)
108793 17197 3 5 1675X Lombard St 1 1 1 2     3 3x3   6004367.95797 2119722.65234 37.8006008446769 -122.42902768903099 (37.8006008446769, -122.429027689031)
123767 22132 3 5 3795X 03rd St 17 1 1 2     3 3x3   6015998.68116 2098857.5612 37.743961376796996 -122.387323966992 (37.743961376797, -122.387323966992)
141992 89458 3 5 3500X Anza St 1 1 1 2   03/21/2008 12:00:00 AM 3 3x3   5987773.9063 2111900.8711599996 37.7781711994801 -122.48587473348199 (37.7781711994801, -122.485874733482)
51216 200556 3 5 1400x La Salle Ave 32 11 1 2     4 Width 0ft   6016262.7203 2095558.3918 37.734917146653 -122.38618101771601 (37.734917146653, -122.386181017716)
59915 200610 3 5 1400x La Salle Ave 50 11 1 2     4 Width 0ft   6016417.2964 2095161.5798 37.733836134681795 -122.385618942498 (37.7338361346818, -122.385618942498)
23087 6567 3 5 1301 Evans Ave 2 1 1 2   01/09/2004 12:00:00 AM 5 3X3   6017004.85053 2097463.70294 37.7401897966309 -122.383747801739 (37.7401897966309, -122.383747801739)
55759 188646 3 5 150x Cargo Way 9 3 1 2     5     6018092.675340001 2098102.14022 37.74200288923021 -122.380030855133 (37.7420028892302, -122.380030855133)
130923 188582 3 5 900x Carolina St 19 3 1 2     5     6012479.86277 2103522.41115 37.7565745414011 -122.39981880719999 (37.7565745414011, -122.3998188072)
131211 200607 3 5 1400x La Salle Ave 48 11 1 2     5 Width 0ft   6016406.5235 2095183.1256 37.73389469904829 -122.385657689133 (37.7338946990483, -122.385657689133)
133052 203807 3 5 335x Pacheco St 20 3 1 2     5 Width 8ft   5994179.6676199995 2101287.15386 37.7493999011887 -122.46294480178699 (37.7493999011887, -122.462944801787)
133432 203808 3 5 335x Pacheco St 30 3 1 2     5 Width 8ft   5994148.64523 2101441.5060099997 37.7498219260394 -122.46306327486 (37.7498219260394, -122.46306327486)
137116 188583 3 5 900x Carolina St 20 3 1 2     5     6012480.57258 2103516.6299400004 37.7565587070348 -122.399815946472 (37.7565587070348, -122.399815946472)
137306 125295 3 5 1306x Montgomery St 24 3 1 2     5 Width 8ft   6011445.958380001 2119999.7387 37.801759761770604 -122.40455429893998 (37.8017597617706, -122.40455429894)
137749 200543 3 5 1400x La Salle Ave 19 11 1 2     5 Width 0ft   6016187.8616 2095644.6304 37.7351497969246 -122.38644584387501 (37.7351497969246, -122.386445843875)
166461 188581 3 5 900x Carolina St 18 3 1 2     5     6012475.30485 2103528.81943 37.75659188303771 -122.39983502019 (37.7565918830377, -122.39983502019)
188905 200550 3 5 1400x La Salle Ave 26 11 1 2     5 Width 0ft   6016212.9331 2095623.1152 37.7350921083386 -122.386357662249 (37.7350921083386, -122.386357662249)
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
1084 8287 3 5 1601 Galvez Ave 3 1 1 2   05/01/2017 12:00:00 AM 6 3x3   6015799.31492 2097666.33838 37.7406794801837 -122.387930230222 (37.7406794801837, -122.387930230222)
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
5371 18271 3 5 1949 Post St 2 1 1 2     6 3X3   6002897.9436 2114073.452 37.785006273193495 -122.43371055367399 (37.7850062731935, -122.433710553674)
6495 26421 3 5 2235X Octavia St 6 11 1 2     6 20   6004624.1328 2116974.76242 37.793070338586205 -122.427945300259 (37.7930703385862, -122.427945300259)
6982 17878 3 5 2189 Pine St 2 1 1 2     6 3X3   6003500.3079 2115200.4578 37.78813490757079 -122.431707058922 (37.7881349075708, -122.431707058922)
8001 20026 3 5 100 STAIRWAY48 10 1 1 2     6 10ST            
8245 20020 3 5 100 STAIRWAY48 4 1 1 2     6 10ST            
9882 173729 3 5 994 Carolina St 2 11 1 2     6 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
11240 19966 3 5 100 STAIRWAY41 4 1 1 2     6 25ST            
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
15525 3745 3 5 900 Carolina St 4 11 1 2     6 18   6012461.71984 2103674.63492 37.7569915030708 -122.39989224135799 (37.7569915030708, -122.399892241358)
16079 19828 3 5 100 STAIRWAY25 12 1 1 2     6 60X            
16094 20027 3 5 100 STAIRWAY48 11 1 1 2     6 10ST            
16182 6428 3 5 1100X Evans Ave 10 1 1 2   11/29/1990 12:00:00 AM 6 3x3   6018145.74781 2096700.42192 37.7381569780515 -122.379749980697 (37.7381569780515, -122.379749980697)
16240 97228 3 5 1301X Newcomb Ave 8 11 1 2     6 15x200   6016642.6726 2094934.5266099998 37.733225159799204 -122.384823929606 (37.7332251597992, -122.384823929606)
16309 6731 3 5 1300X Fairfax Ave 1 1 1 2   12/29/1992 12:00:00 AM 6 3x3   6017098.09908 2097131.4743700002 37.7392827179327 -122.38340226151699 (37.7392827179327, -122.383402261517)
23028 97224 3 5 1301X Newcomb Ave 4 11 1 2   09/30/2011 12:00:00 AM 6 15x200   6016653.042219999 2094950.9325 37.733270780626995 -122.38478922115499 (37.733270780627, -122.384789221155)
38644 200553 3 5 1400x La Salle Ave 29 11 1 2     6 Width 0ft   6016224.312999999 2095613.1578 37.7350653972301 -122.38631762348301 (37.7350653972301, -122.386317623483)
72358 124133 3 5 3500x Geary Blvd 6 3 1 2     6     5996054.79965 2112880.00292 37.781338707390105 -122.45729914105499 (37.7813387073901, -122.457299141055)
77165 24211 3 5 80X Whitney Young Cir 11 1 1 2     6 3x3   6016364.4746918 2096121.5533417999 37.736469106467 -122.38586845516501 (37.736469106467, -122.385868455165)
83174 111552 3 5 900x BOSWORTH ST 30 7 1 2     6     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
101329 18212 3 5 1575 Post St 7 1 1 2   06/22/1998 12:00:00 AM 6 3X3   6004651.317293701 2114317.5621297 37.7857758731644 -122.427661834419 (37.7857758731644, -122.427661834419)
107225 41576 1 5 200 Dolores St 4 1 1 2   07/22/2010 12:00:00 AM 6 3x3 Permit Number 53640 6004804.85382115 2107218.95663379 37.7662935218736 -122.426624972491 (37.7662935218736, -122.426624972491)
136589 188651 3 5 300x Cargo Way 15 3 1 2     6     6017373.9642900005 2098663.52344 37.7435046581055 -122.38255500572399 (37.7435046581055, -122.382555005724)
138777 22638 3 5 1200X Turk St 1 1 1 2   05/01/1990 12:00:00 AM 6 3X3   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
143355 111556 3 5 900x BOSWORTH ST 34 7 1 2     6     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
172385 200555 3 5 1400x La Salle Ave 31 11 1 2     6 Width 0ft   6016252.4072 2095574.3949 37.7349605171331 -122.386217789361 (37.7349605171331, -122.386217789361)
49943 200538 3 5 1400x La Salle Ave 14 11 1 2     7 Width 0ft   6016175.1953 2095654.7768 37.7351769557335 -122.38649034349899 (37.7351769557335, -122.386490343499)
121090 200539 3 5 1400x La Salle Ave 15 11 1 2     7 Width 0ft   6016182.3272 2095656.8744 37.735183110122 -122.38646583191401 (37.735183110122, -122.386465831914)
169431 200546 3 5 1400x La Salle Ave 22 11 1 2     7 Width 0ft   6016197.8191 2095632.8949 37.735118124804394 -122.386410598906 (37.7351181248044, -122.386410598906)
9906 173728 3 5 994 Carolina St 1 11 1 2     8 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
15842 97227 3 5 1301X Newcomb Ave 7 11 1 2     8 15x200   6016638.64484 2094938.128 37.733234825728296 -122.384838105605 (37.7332348257283, -122.384838105605)
72616 188650 3 5 1700x Quesada Ave 51 3 1 2     8     6014234.97615 2095377.1002900002 37.734306916536 -122.39317901359699 (37.734306916536, -122.393179013597)
93197 6832 3 5 1485 FAIRFAX AVE 1 1 1 2     8 3X3   6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
180983 200531 3 5 1400x La Salle Ave 7 11 1 2     8 Width 0ft   6016156.3167 2095682.0459 37.7352507861079 -122.386557515095 (37.7352507861079, -122.386557515095)
125197 110465 3 5 1485 FAIRFAX AVE 2 2 1 2     9 3x3   6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
137314 200611 3 5 1400x La Salle Ave 51 11 1 2     9 Width 0ft   6016421.2138 2095153.2552 37.7338134937512 -122.385604818769 (37.7338134937512, -122.385604818769)
143150 24212 3 5 80X Whitney Young Cir 12 1 1 2   01/08/2002 12:00:00 AM 9 3x3   6016364.4746918 2096121.5533417999 37.736469106467 -122.38586845516501 (37.736469106467, -122.385868455165)
159406 200605 3 5 1400x La Salle Ave 46 11 1 2     9 Width 0ft   6016398.6886 2095199.7747 37.7339399806144 -122.385685937001 (37.7339399806144, -122.385685937001)
168459 188642 3 5 2x Cargo Way 3 3 1 2     9     6018846.51114 2097536.89048 37.7404923843103 -122.377385089264 (37.7404923843103, -122.377385089264)
187646 200535 3 5 1400x La Salle Ave 11 11 1 2     9 Width 0ft   6016168.4829 2095664.0064 37.735201926775396 -122.386514194261 (37.7352019267754, -122.386514194261)
Powered by Datasette · Query took 34.724ms · Data source: data.sfgov.org