sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10201 173901 2 34 4201x Lincoln Blvd 1 5 1 1       5x5            
14347 87020 1 2 10 Osceola Dr 2 5 1 1   12/05/2007 12:00:00 AM     Permit Number 49949          
99448 116072 6 19 388 POLARIS WAY 1 5 1 1       3x3   6000586.0 2086414.0 37.70892857908329 -122.439725431133 (37.7089285790833, -122.439725431133)
101229 85273 1 17 36 Santa Cruz Ave   5 2 1           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218)
77951 99580 2 141 650X Brunswick St 20 5 1 1     10 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
101382 108685 3 40 301X CHESTER AVE 1 5 1 2     18     5991720.0 2087146.0 37.7104298409998 -122.47042057923099 (37.7104298409998, -122.470420579231)
10627 1283 6 44 3995X Alemany Blvd 1 5 1 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
79808 37377 1 98 755 Morse St 11 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84241 37371 1 98 755 Morse St 5 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84675 37375 1 264 755 Morse St 9 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
101108 37381 1 264 755 Morse St 15 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
102673 37386 1 264 755 Morse St 20 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
107719 37383 1 264 755 Morse St 17 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
111807 37385 1 264 755 Morse St 19 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
125659 37373 1 264 755 Morse St 7 5 1 1 1 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
139023 37379 1 98 755 Morse St 13 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 6 3 3995X Alemany Blvd 6 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 6 3 3995X Alemany Blvd 14 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 6 3 3995X Alemany Blvd 5 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10006 120927 6 3 3995X Alemany Blvd 10 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 6 3 3995X Alemany Blvd 11 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10021 120935 6 3 3995X Alemany Blvd 18 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
74397 120924 6 143 3995X Alemany Blvd 7 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
79421 120930 6 3 3995X Alemany Blvd 13 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
84748 120926 6 143 3995X Alemany Blvd 9 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
100341 120932 6 143 3995X Alemany Blvd 15 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
115407 120934 6 143 3995X Alemany Blvd 17 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
116287 120933 6 143 3995X Alemany Blvd 16 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
118149 120936 6 143 3995X Alemany Blvd 19 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
119867 120929 6 143 3995X Alemany Blvd 12 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
120789 120921 6 143 3995X Alemany Blvd 4 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
22894 206842 6 17 218 Sadowa St 3 5 1 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288001 (37.712360795684, -122.45981072288)
22897 215094 6 17 218 Sadowa St 1 5 1 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.2030900002 37.7123610457095 -122.45974695827199 (37.7123610457095, -122.459746958272)
110973 106962 6 47 218 SADOWA ST 3 5 1 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
10019 173629 6 260 10X Junipero Serra Blvd Off Ramp 1 5 1 1   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
140493 115828 2 1 65 CHUMASERO DR 1 5 1 1   08/30/2016 12:00:00 AM 3 3x3   5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
93028 115827 6 1 60X CHUMASERO DR 1 5 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
4673 253651 6 60 131 Font Blvd 1 5 1 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
10089 173834 2 262 37 Tucker Ave 1 5 1 1           6010894.0 2088503.0 37.7152458914151 -122.404246253618 (37.7152458914151, -122.404246253618)
62736 92146 1 191 728 Jamestown Ave 3 5 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52458 6015302.1 2088427.9 37.715285014192204 -122.389004565667 (37.7152850141922, -122.389004565667)
11285 83683 1 12 215 Dublin St 1 5 1 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52308 6004110.69577 2089162.29942 37.716674810270206 -122.42773926378 (37.7166748102702, -122.42773926378)
10590 82568 1 12 215 Dublin St 2 5 1 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52308 6004119.416680001 2089176.12127 37.7167132553824 -122.427710104164 (37.7167132553824, -122.427710104164)
10128 173868 1 54 808 Capitol Ave 2 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
10139 173867 1 54 808 Capitol Ave 1 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
90554 114400 2 103 1X HIGUERA AVE 3 5 1 1     22 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
36317 108395 1 41 311 Ordway St 1 5 1 1 1   2 3x3   6011028.372719999 2090050.89786 37.7195036115824 -122.403890660433 (37.7195036115824, -122.403890660433)
78524 47338 1 16 399X Vernon St 3 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
80317 47339 1 16 399 Vernon St 1 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
92211 47340 1 16 399X Vernon St 2 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
50102 94943 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
88058 94937 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
96189 94940 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111560 94941 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111884 94939 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
112975 94938 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
139320 94936 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144144 94944 6 540 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144883 94942 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
141804 96996 6 235 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
12769 17578 3 46 801X Persia Ave 2 5 1 2     18 3x3   6003799.63122 2090323.6743700001 37.7198460905006 -122.428897210135 (37.7198460905006, -122.428897210135)
10957 17580 3 46 801X Persia Ave 4 5 1 2     18 3x3   6003780.63082 2090335.5596900003 37.719877649504205 -122.428963734788 (37.7198776495042, -122.428963734788)
2661 37833 3 42 450X Moscow St 20 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.4611400003 37.719899544415604 -122.428784371324 (37.7198995444156, -122.428784371324)
11152 17582 3 46 801X Persia Ave 6 5 1 2     18 3x3   6003762.13068 2090345.22062 37.7199031291015 -122.42902837176202 (37.7199031291015, -122.429028371762)
83253 98082 6 105 525 Grafton Ave 1 5 1 1           5995193.7 2090526.9 37.7199132334677 -122.45865940878001 (37.7199132334677, -122.45865940878)
12305 17584 3 46 801X Persia Ave 8 5 1 2     18 3x3   6003740.32149 2090358.06458 37.7199371612464 -122.42910467385201 (37.7199371612464, -122.429104673852)
12852 17587 3 46 801X Persia Ave 11 5 1 2     35 3X3   6003703.481380001 2090378.19842 37.7199903588363 -122.42923345225901 (37.7199903588363, -122.429233452259)
2638 37832 3 42 450X Moscow St 19 5 1 4 2 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048)
11319 17589 3 46 801X Persia Ave 13 5 1 2     18 3x3   6003683.23846 2090394.91559 37.720035114503006 -122.42930461652 (37.720035114503, -122.42930461652)
11996 17591 3 46 801X Persia Ave 15 5 1 2     30 3x3   6003659.63671 2090407.2266799998 37.7200675818369 -122.42938707716299 (37.7200675818369, -122.429387077163)
2660 37827 3 9 450X Moscow St 15 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003888.33038 2090432.03853 37.7201486548235 -122.428598328547 (37.7201486548235, -122.428598328547)
4355 37822 3 48 450X Moscow St 10 5 1 4 2 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301)
2652 37819 3 9 450X Moscow St 7 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003953.55423 2090513.34715 37.7203756014419 -122.428378663762 (37.7203756014419, -122.428378663762)
2643 37817 3 48 450X Moscow St 5 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.1025099999 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393)
4367 253150 3 48 450X Moscow St 3 5 1 4 2 10/11/2017 09:41:00 AM 3 3x3   6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
12958 37815 3 42 450X Moscow St 2 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
102637 107643 3 17 455 ATHENS ST   5 1 4 1     4x4   6003769.0 2090659.8 37.720767283734105 -122.429027043999 (37.7207672837341, -122.429027043999)
93136 37837 3 42 450X Moscow St 23 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
96417 37825 3 42 450X Moscow St 12 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
139322 37829 3 42 450X Moscow St 16 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
142748 37835 3 42 450X Moscow St 21 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
111731 122636 6 19 3698X 19th Ave 1 5 1 1       3x3   5990586.0 2091171.0 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984)
88445 122634 6 17 3680X 19th Ave 1 5 1 1   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592.0 2091224.0 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991)
125075 53133 1 90 925 Holloway Ave 1 5 1 1 1 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.46282963525199 (37.7216197566197, -122.462829635252)
80965 96878 1 17 2200X San Jose Ave 3 5 1 1   06/30/2014 12:00:00 AM     Permit Number 773235 5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
82276 96882 1 55 2200X San Jose Ave 7 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
84624 96883 1 55 2200X San Jose Ave 8 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
86463 96884 1 55 2200X San Jose Ave 9 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
92219 96879 1 17 2200X San Jose Ave 2 5 1 1   06/30/2014 12:00:00 AM     Permit Number 773235 5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
96525 96881 1 15 2200X San Jose Ave 6 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
102293 96885 1 55 2200X San Jose Ave 10 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
116057 96347 1 17 2200X San Jose Ave 1 5 1 1   06/30/2014 12:00:00 AM     Permit Number 773235 5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
84318 114974 1 134 23 Holloway Ave 1 5 1 1   12/28/2015 12:00:00 AM     Permit Number 775981 5996745.4 2091181.1 37.7217985747524 -122.45334295571999 (37.7217985747524, -122.45334295572)
43480 111380 2 3 301x OCEAN AVE 2 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
107894 111381 2 3 301x OCEAN AVE 3 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
Powered by Datasette · Query took 7.356ms · Data source: data.sfgov.org