home / trees

Street_Tree_List

Data source: data.sfgov.org

3,956 rows where qSpecies = 21

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
75 100067 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 93 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x2 On property line with 99 Buena Vista Ter 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
130 100123 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 690 Miramar Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
207 100204 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2237 Sutter St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     26 5x5   6001902.2596 2114280.466 37.7855181330415 -122.437170124873 (37.7855181330415, -122.437170124873) 13 6 11 29490 13
243 100245 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 539 18th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 5x4   5990297.625519999 2111697.27561 37.7777589234968 -122.47712948237101 (37.7777589234968, -122.477129482371) 11 6 2 55 26
244 100246 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 539 18th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 7x4   5990298.61194 2111686.34529 37.77772896908439 -122.477125271101 (37.7777289690844, -122.477125271101) 11 6 2 55 26
353 100371 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 836 Montgomery St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     23   Permit Number 22564 6011703.37581 2118243.8311400004 37.7969528476575 -122.403539900553 (37.7969528476575, -122.403539900553) 3 1 10 308 4
356 100386 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1630 21st Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5989668.805 2104235.219 37.7572336462205 -122.478758883384 (37.7572336462205, -122.478758883384) 1 8 3 56 35
357 100387 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1630 21st Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5989667.3817 2104248.5033 37.75727003871479 -122.47876477719299 (37.7572700387148, -122.478764777193) 1 8 3 56 35
361 100392 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 1800X Lincoln Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 769124 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
362 100393 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 1800X Lincoln Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
363 100394 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 1800X Lincoln Way 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
364 100395 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 1800X Lincoln Way 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
594 100653 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1594 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x4   5992503.0 2104630.0 37.7584817696578 -122.46898595103599 (37.7584817696578, -122.468985951036) 1 8 4 56 12
596 100655 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 590X Lawton St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5992492.1 2104587.3 37.758363896854796 -122.469020540261 (37.7583638968548, -122.469020540261) 1 8 4 56 12
597 100656 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 590X Lawton St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5992503.0 2104630.0 37.7584817696578 -122.46898595103599 (37.7584817696578, -122.468985951036) 1 8 4 56 12
705 100788 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 29 16th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 6x28   5990804.2657699995 2114865.5687599997 37.786487558431 -122.475608262715 (37.786487558431, -122.475608262715) 11 6 1 54 33
706 100789 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 29 16th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     28 6x25 Permit Number 27110 5990805.4528 2114847.4616900003 37.7864379102909 -122.47560283327499 (37.7864379102909, -122.475602833275) 11 6 1 54 33
747 100837 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 10X Tulane St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x9   6007491.7 2093814.7 37.7296399852574 -122.416382127882 (37.7296399852574, -122.416382127882) 9 3 7 309 28
748 100838 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 10X Tulane St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x9   6007491.7 2093814.7 37.7296399852574 -122.416382127882 (37.7296399852574, -122.416382127882) 9 3 7 309 28
862 101002 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
865 101005 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
866 101006 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
867 101007 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
868 101008 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
869 101009 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
870 101010 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2801X Buchanan St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003500.6 2117942.3 37.795663322696704 -122.43190190430201 (37.7956633226967, -122.431901904302) 13 9 1 57 17
883 101023 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3024 Baker St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5999465.0 2119192.0 37.7988650643156 -122.445955676486 (37.7988650643156, -122.445955676486) 13 9 1 57 17
981 101136 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1477 Grove St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000824.6116 2110666.7087 37.7755343608772 -122.44063916358499 (37.7755343608772, -122.440639163585) 15 5 11 29492 10
982 101137 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1477 Grove St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000842.8876 2110669.9339 37.7755442571847 -122.440576174035 (37.7755442571847, -122.440576174035) 15 5 11 29492 10
1130 101287 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3355X Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001810.5 2119614.7 37.8001593395999 -122.437869785341 (37.8001593395999, -122.437869785341) 13 9 1 57 17
1251 101420 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2200 Broderick St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10     6000374.3516 2116185.0207 37.7906605745677 -122.442593016179 (37.7906605745677, -122.442593016179) 13 6 1 29490 27
1252 101421 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2200 Broderick St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11     6000370.97152 2116196.31251 37.790691386252604 -122.442605522132 (37.7906913862526, -122.442605522132) 13 6 1 29490 27
1253 101422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2200 Broderick St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16     6000369.95559 2116208.8257400002 37.790725686401 -122.44260993601802 (37.790725686401, -122.442609936018) 13 6 1 29490 27
1254 101423 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2200 Broderick St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13     6000367.44733 2116221.15803 37.7907594046669 -122.44261950028401 (37.7907594046669, -122.442619500284) 13 6 1 29490 27
1255 101424 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2200 Broderick St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6000365.03159 2116237.93468 37.79080533125679 -122.442629063689 (37.7908053312568, -122.442629063689) 13 6 1 29490 27
1463 101654 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 465 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12     5991223.427730001 2112267.5766 37.779378481558396 -122.473968464522 (37.7793784815584, -122.473968464522) 11 6 2 54 26
1733 102012 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1630 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992512.8 2104342.0 37.7576915632091 -122.46893110017099 (37.7576915632091, -122.468931100171) 1 8 4 56 12
1734 102013 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1630 12th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992512.8 2104342.0 37.7576915632091 -122.46893110017099 (37.7576915632091, -122.468931100171) 1 8 4 56 12
1735 102014 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1630 12th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992512.8 2104342.0 37.7576915632091 -122.46893110017099 (37.7576915632091, -122.468931100171) 1 8 4 56 12
1897 102186 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3999X Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1898 102187 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3999X Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
2152 102444 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 430X Amazon Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6001528.5407 2088896.6516 37.715798995606704 -122.436645469419 (37.7157989956067, -122.436645469419) 9 7 6 28861 5
2181 102472 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 66 Sotelo Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x15   5993897.9 2101386.8 37.7496572701738 -122.46392638569701 (37.7496572701738, -122.463926385697) 1 8 4 29491 40
2252 10255 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 140 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     80 3X3   6005448.277840001 2109623.5866799997 37.7729324136912 -122.424570554491 (37.7729324136912, -122.424570554491) 7 9 11 28852 10
2259 10256 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 150 Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/18/1998 12:00:00 AM 30 3X3   6005382.9385 2109612.15 37.7728973211229 -122.424795757535 (37.7728973211229, -122.424795757535) 7 9 11 28852 10
2309 10261 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 198 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     80 3X4   6005221.62679 2109603.34443 37.772864030808 -122.425353127526 (37.772864030808, -122.425353127526) 7 9 11 28852 10
2324 102623 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 351 Chestnut St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6010148.1574 2120916.7901 37.80420514282329 -122.40911005673401 (37.8042051428233, -122.409110056734) 3 1 10 308 23
2330 102629 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 168 25th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15   Permit Number 769953 5988063.8153 2114882.99878 37.7863761669029 -122.485090700066 (37.7863761669029, -122.485090700066) 11 6 1 55 33
2331 10263 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 212 Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     70 3X3   6005030.70582 2109564.31462 37.77274607605089 -122.426010766966 (37.7727460760509, -122.426010766966) 7 9 11 28852 10
2332 102630 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 168 25th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5988081.5 2114873.1 37.7863500177909 -122.48502878974399 (37.7863500177909, -122.485028789744) 11 6 1 55 33
2333 102631 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 175 25th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769999 5987997.5 2114816.6 37.7861899917282 -122.485315257259 (37.7861899917282, -122.485315257259) 11 6 1 55 33
2398 102707 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 369 14th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5991523.740540001 2112932.53548 37.7812216665299 -122.472978070118 (37.7812216665299, -122.472978070118) 11 6 2 54 26
2424 10274 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 218 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/29/2016 03:07:00 PM 3 3x3   6004921.53459 2109545.1488200002 37.772687280827604 -122.426387037745 (37.7726872808276, -122.426387037745) 7 9 11 28852 10
2432 102747 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2900 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 4x5 Permit Number 20974 6001053.30266 2118369.0806400003 37.796696110983795 -122.44040059224 (37.7966961109838, -122.44040059224) 13 9 1 57 17
2433 102748 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2900 Scott St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 4x5 Permit Number 20974 6001048.4849 2118395.3154599997 37.7967678705825 -122.440419145231 (37.7967678705825, -122.440419145231) 13 9 1 57 17
2435 10275 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 222 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 3x3   6004852.2764800005 2109616.19972 37.772878454111705 -122.42663166961701 (37.7728784541117, -122.426631669617) 7 9 11 28852 10
2439 102753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 542 11th Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 3x9   5992553.895830001 2111741.50306 37.778011002181 -122.469327555756 (37.778011002181, -122.469327555756) 11 6 2 54 11
2488 102800 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 708 03rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11     5995062.7103 2110691.85511 37.7752736059254 -122.460572652238 (37.7752736059254, -122.460572652238) 11 6 2 54 11
2489 102801 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 708 03rd Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     5995061.23686 2110707.0518099996 37.775315247273205 -122.460578850624 (37.7753152472732, -122.460578850624) 11 6 2 54 11
2490 102802 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1245 27th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5987672.179 2106793.3292 37.764141382947706 -122.485851660773 (37.7641413829477, -122.485851660773) 1 8 3 56 35
2506 10282 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 359 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     80 3X3   6004422.78828 2109427.83457 37.772336958917606 -122.428103893873 (37.7723369589176, -122.428103893873) 7 9 11 28852 10
2530 102843 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1101X Portola Dr 10 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
2583 10290 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 457 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3x3   6003955.27989 2109364.91773 37.772137742885604 -122.429716559981 (37.7721377428856, -122.429716559981) 7 9 11 29492 10
2627 10296 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 533 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X3   6003575.42628 2109315.1173099997 37.7719794864975 -122.431026949543 (37.7719794864975, -122.431026949543) 15 9 11 29492 10
2646 10298 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 545 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X3   6003525.02911 2109303.7259299997 37.771945352740005 -122.43120046383699 (37.77194535274, -122.431200463837) 15 9 11 29492 10
2720 10306 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 618- 620 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     33 7x5   6003056.4779 2109285.6248 37.771869088105795 -122.432819922419 (37.7718690881058, -122.432819922419) 15 5 11 29492 9
2842 10319 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 739 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     50 3X3   6002579.70252 2109173.84871 37.7715351260824 -122.434461126791 (37.7715351260824, -122.434461126791) 15 5 11 29492 9
2903 10325 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 807 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 3X3   6002259.2753800005 2109123.5178 37.7713787357685 -122.435565898974 (37.7713787357685, -122.435565898974) 15 5 11 29492 9
2931 103283 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 3195X Jackson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998987.7 2116257.6 37.790780717413 -122.44739596204201 (37.790780717413, -122.447395962042) 13 6 1 29490 31
2938 10329 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 826 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 4X4   6002169.5428 2109164.5209999997 37.7714862234563 -122.435879222083 (37.7714862234563, -122.435879222083) 15 5 11 29492 9
2977 10334 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 850 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 4X4   6002067.0 2109164.0 37.7714789673294 -122.436233885162 (37.7714789673294, -122.436233885162) 15 5 11 29492 9
2987 10335 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 860 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     26 4x4   6002028.0975 2109143.8299 37.7714213748567 -122.436367006921 (37.7714213748567, -122.436367006921) 15 5 11 29492 9
3017 103382 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3199X JACKSON ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5999158.0 2116301.0 37.7909096124749 -122.446809858862 (37.7909096124749, -122.446809858862) 13 6 1 29490 31
3018 103383 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3199X JACKSON ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5999158.0 2116301.0 37.7909096124749 -122.446809858862 (37.7909096124749, -122.446809858862) 13 6 1 29490 31
3019 103385 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 104 PRESIDIO AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5999013.0 2116197.0 37.79061577152721 -122.447304062173 (37.7906157715272, -122.447304062173) 13 6 1 29490 31
3043 103408 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 201 Executive Park Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929) 10 3 8 58 1
3044 103409 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 201 Executive Park Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929) 10 3 8 58 1
3046 103410 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 201 Executive Park Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929) 10 3 8 58 1
3112 103476 Permitted Site 2 Acacia melanoxylon :: Blackwood Acacia 21 147 Cervantes Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/11/2013 12:00:00 AM     Permit Number 775299 6001179.7 2121217.2 37.8045234887457 -122.440167571349 (37.8045234887457, -122.440167571349) 13 9 1 57 17
3121 103488 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2601 Vallejo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6001028.36335 2117564.6672900002 37.7944859830059 -122.44042916637899 (37.7944859830059, -122.440429166379) 13 9 1 57 27
3122 103489 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2601 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   6001042.45399 2117566.1251 37.7944907880724 -122.440380515743 (37.7944907880724, -122.440380515743) 13 9 1 57 27
3124 103490 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2601 Vallejo St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6001053.62878 2117568.22705 37.7944971957398 -122.440342000495 (37.7944971957398, -122.440342000495) 13 9 1 57 27
3215 10359 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1060 HAIGHT ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     28 3X4   6001056.0 2109004.0 37.770982153968 -122.439719505856 (37.770982153968, -122.439719505856) 15 5 11 29492 9
3227 10360 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1080 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     21 3x3   6000968.2773 2109001.3276 37.770969822766396 -122.440022748836 (37.7709698227664, -122.440022748836) 15 5 11 29492 9
3249 10362 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1126 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 3X4   6000713.44362 2108968.6618 37.7708656202791 -122.440901879767 (37.7708656202791, -122.440901879767) 15 5 11 29492 9
3259 10363 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1136 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     25 3X4   6000656.6881 2108954.0474 37.7708222602121 -122.441097149265 (37.7708222602121, -122.441097149265) 15 5 11 29492 9
3297 10367 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1190 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X4   6000483.5353 2108928.9047 37.77074336050121 -122.441694282188 (37.7707433605012, -122.441694282188) 15 5 11 29492 9
3307 10368 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1190 Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     24 3X3   6000449.8535 2108924.1608 37.770728415806495 -122.441810447284 (37.7707284158065, -122.441810447284) 15 5 11 29492 9
3315 10369 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1190 Haight St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     22 3X4   6000434.46289 2108927.9712900002 37.770738001484496 -122.44186395705 (37.7707380014845, -122.44186395705) 15 5 11 29492 9
3328 10371 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1202 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X3   6000331.2557 2108908.0315 37.7706773703693 -122.442219519892 (37.7706773703693, -122.442219519892) 15 5 11 29492 9
3335 10372 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1216 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 3X3   6000283.8166 2108900.9156 37.7706551281266 -122.442383101019 (37.7706551281266, -122.442383101019) 15 5 11 29492 9
3346 10373 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1234 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 9x5   6000208.6256 2108891.1906 37.770624139779 -122.44264248857 (37.770624139779, -122.44264248857) 15 5 11 29492 9
3374 10376 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1255X Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 21x6   6000170.7774495995 2108835.6049214 37.7704693578958 -122.44276941339199 (37.7704693578958, -122.442769413392) 15 5 5 29492 9
3552 103929 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 191 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x10   5994248.3 2114379.9 37.7853530981444 -122.46365759100401 (37.7853530981444, -122.463657591004) 11 6 1 54 11
3561 103938 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2300 Mason St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6008916.3437 2121176.0576 37.80484794271371 -122.413391203795 (37.8048479427137, -122.413391203795) 3 1 10 308 23
3562 103939 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 2300 Mason St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9     6008915.3132 2121187.3941 37.8048790120409 -122.413395572179 (37.8048790120409, -122.413395572179) 3 1 10 308 23
3564 103940 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 2300 Mason St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
3743 10422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1407 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3x3   5999387.74957 2108726.3420700002 37.7701246795762 -122.44547004321699 (37.7701246795762, -122.445470043217) 15 5 11 29492 9
3785 10426 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 21 1418 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     70 3x4   5999318.4357900005 2108766.88191 37.7702320345214 -122.44571271379 (37.7702320345214, -122.44571271379) 15 5 11 29492 9
3794 104272 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3675 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997210.1 2115656.5 37.7890285184352 -122.453502918425 (37.7890285184352, -122.453502918425) 11 6 1 54 31

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 114.608ms · Data source: data.sfgov.org