trees
3,965 rows where qSpecies_id = 70 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63360 | 203898 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5990605.80648 | 2090479.00693 | 37.7195169745995 | -122.474514509734 | (37.7195169745995, -122.474514509734) | 9 | 8 | 4 | 64 | 40 | |||
| 63689 | 27070 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 801 Silver Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2000 12:00:00 AM | 6 | 4x15 | 6006926.95376 | 2093626.25966 | 37.7290907946921 | -122.418321164017 | (37.7290907946921, -122.418321164017) | 9 | 3 | 7 | 309 | 28 | ||
| 64843 | 203262 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 512 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5997988.38195 | 2097644.1119 | 37.7396156424485 | -122.449511768663 | (37.7396156424485, -122.449511768663) | 9 | 7 | 4 | 59 | 40 | |||
| 66047 | 203851 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5998148.5387 | 2094357.88923 | 37.7306016197611 | -122.448721386881 | (37.7306016197611, -122.448721386881) | 9 | 7 | 4 | 28861 | 40 | |||
| 66284 | 203884 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 181 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5990872.1544 | 2094661.20304 | 37.7310156703418 | -122.473898806879 | (37.7310156703418, -122.473898806879) | 9 | 8 | 4 | 64 | 40 | |||
| 66720 | 203849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 615 Hearst Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5997371.26354 | 2094385.62259 | 37.7306332911786 | -122.451410529785 | (37.7306332911786, -122.451410529785) | 9 | 7 | 4 | 28861 | 40 | |||
| 66743 | 175008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 162 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999477.70218 | 2087171.23206 | 37.7109446224578 | -122.443610214149 | (37.7109446224578, -122.443610214149) | 9 | 7 | 6 | 28861 | 5 | |||
| 67925 | 175029 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010591.02139 | 2086933.10615 | 37.7109183460773 | -122.405183003288 | (37.7109183460773, -122.405183003288) | 9 | 7 | 8 | 309 | 39 | |||
| 68079 | 203280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 59 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | Permit Number 781025 | 5999721.17343 | 2095479.15955 | 37.7337701687542 | -122.443365077855 | (37.7337701687542, -122.443365077855) | 9 | 7 | 4 | 63 | 40 | ||
| 69668 | 203260 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 31 Sequoia Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5998240.18934 | 2097553.89046 | 37.7393823178446 | -122.448634634681 | (37.7393823178446, -122.448634634681) | 9 | 7 | 4 | 59 | 40 | |||
| 69908 | 51791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | 9 | 7 | 4 | 59 | 40 | |||
| 70395 | 174981 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002909.51396 | 2089790.51984 | 37.7183317437001 | -122.431935981587 | (37.7183317437001, -122.431935981587) | 9 | 7 | 6 | 28861 | 5 | |||
| 70659 | 4806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 71908 | 87252 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.7098574142528 | -122.414638464087 | (37.7098574142528, -122.414638464087) | 9 | 7 | 8 | 309 | 39 | |||
| 72460 | 203989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 665 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 3ft | 5994872.64121 | 2092622.44176 | 37.725648630558 | -122.45992091054 | (37.725648630558, -122.45992091054) | 9 | 7 | 4 | 28861 | 40 | |||
| 74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
| 74761 | 174977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001002.85904 | 2088768.34496 | 37.7154168062239 | -122.4384532767 | (37.7154168062239, -122.4384532767) | 9 | 7 | 6 | 28861 | 5 | |||
| 74908 | 203780 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5995711.83898 | 2094094.29693 | 37.7297382193253 | -122.457126310455 | (37.7297382193253, -122.457126310455) | 9 | 7 | 4 | 28861 | 40 | |||
| 75951 | 203899 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990601.43491 | 2090484.56274 | 37.7195319761887 | -122.474530025745 | (37.7195319761887, -122.474530025745) | 9 | 8 | 4 | 64 | 40 | |||
| 76918 | 11791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 77628 | 203243 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1648 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5995591.85858 | 2094957.07718 | 37.7321003138704 | -122.45760349431 | (37.7321003138704, -122.45760349431) | 9 | 7 | 4 | 59 | 40 | |||
| 77667 | 203246 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 401 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995758.26971 | 2095116.97612 | 37.7325489155023 | -122.45703973989 | (37.7325489155023, -122.45703973989) | 9 | 7 | 4 | 59 | 40 | |||
| 78574 | 175032 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010498.816 | 2086727.27775 | 37.7103480275041 | -122.405487201665 | (37.7103480275041, -122.405487201665) | 9 | 7 | 8 | 309 | 39 | |||
| 78865 | 203995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 5995937.30914 | 2093745.22314 | 37.7287926928137 | -122.45632160966 | (37.7287926928137, -122.45632160966) | 9 | 7 | 4 | 28861 | 40 | |||
| 79364 | 4807 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
| 79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 79806 | 203265 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998990.96313 | 2097286.06804 | 37.7386898425472 | -122.446019541966 | (37.7386898425472, -122.446019541966) | 9 | 7 | 4 | 59 | 40 | |||
| 79875 | 174991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 42 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000531.41546 | 2088375.4753 | 37.7143112462302 | -122.440054636526 | (37.7143112462302, -122.440054636526) | 9 | 7 | 6 | 28861 | 5 | |||
| 80008 | 203819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 224 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5996114.34243 | 2094848.95185 | 37.7318334274665 | -122.455789350407 | (37.7318334274665, -122.455789350407) | 9 | 7 | 4 | 59 | 40 | ||||
| 80056 | 98544 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 80608 | 203242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1660 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995530.96911 | 2095074.55373 | 37.7324193780388 | -122.457822499013 | (37.7324193780388, -122.457822499013) | 9 | 7 | 4 | 59 | 40 | |||
| 81179 | 175042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 San Diego Ave | 1 | Front Yard : Yard | Tree | Private 2 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | 9 | 8 | 6 | 28588 | 25 | ||||
| 82006 | 203832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1625 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 5995572.09683 | 2094748.54485 | 37.731526599451 | -122.457656731475 | (37.731526599451, -122.457656731475) | 9 | 7 | 4 | 59 | 40 | |||
| 82296 | 175002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000849.25835 | 2088363.04115 | 37.7142951942344 | -122.438955158647 | (37.7142951942344, -122.438955158647) | 9 | 7 | 6 | 28861 | 5 | |||
| 82457 | 255992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6000562.83378 | 2088278.17036 | 37.7140458572152 | -122.439939070053 | (37.7140458572152, -122.439939070053) | 9 | 7 | 6 | 28861 | 5 | ||||
| 82829 | 203988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 665 Faxon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 5994873.24978 | 2092595.62975 | 37.7255750462432 | -122.459916865398 | (37.7255750462432, -122.459916865398) | 9 | 7 | 4 | 28861 | 40 | |||
| 82863 | 203820 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 270 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5996086.90151 | 2095051.70628 | 37.7323885672656 | -122.455898870764 | (37.7323885672656, -122.455898870764) | 9 | 7 | 4 | 59 | 40 | ||||
| 83209 | 174990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 123 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000722.13053 | 2088562.69277 | 37.7148361589252 | -122.439408863925 | (37.7148361589252, -122.439408863925) | 9 | 7 | 6 | 28861 | 5 | |||
| 83311 | 174980 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002900.06306 | 2089775.87856 | 37.7182910061937 | -122.431967604438 | (37.7182910061937, -122.431967604438) | 9 | 7 | 6 | 28861 | 5 | |||
| 83487 | 11823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
| 83674 | 187567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 136 Alpha St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6010892.9605 | 2088110.22572 | 37.7141673547183 | -122.404222218893 | (37.7141673547183, -122.404222218893) | 9 | 7 | 8 | 309 | 39 | |||
| 83959 | 255873 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990871 | 2092383 | 37.7247602290732 | -122.473736664855 | (37.7247602290732, -122.473736664855) | 9 | 8 | 4 | 64 | 40 | ||||
| 84645 | 203261 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 506 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5997991.23111 | 2097614.06115 | 37.7395332933219 | -122.44949975281 | (37.7395332933219, -122.44949975281) | 9 | 7 | 4 | 59 | 40 | |||
| 84675 | 42562 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | 9 | 8 | 4 | 59 | 40 | ||
| 85312 | 175074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 6001979.9665 | 2087165.3446 | 37.7110708522134 | -122.434961389078 | (37.7110708522134, -122.434961389078) | 9 | 7 | 6 | 28861 | 5 | |||
| 87537 | 203281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000198.21864 | 2096046.74444 | 37.7353558165236 | -122.441756516251 | (37.7353558165236, -122.441756516251) | 9 | 7 | 5 | 63 | 40 | |||
| 88347 | 175022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010987.76373 | 2087310.02713 | 37.7119754676783 | -122.403838266825 | (37.7119754676783, -122.403838266825) | 9 | 7 | 8 | 309 | 39 | |||
| 89490 | 85305 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545 | 37.7337362418337 | -122.456343520233 | (37.7337362418337, -122.456343520233) | 9 | 7 | 4 | 59 | 40 | |||
| 91558 | 203887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 179 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5990924.31615 | 2094659.11816 | 37.7310129669604 | -122.47371832465 | (37.7310129669604, -122.47371832465) | 9 | 8 | 4 | 64 | 40 | |||
| 91816 | 175060 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.7292089332358 | -122.422256493849 | (37.7292089332358, -122.422256493849) | 9 | 7 | 6 | 28861 | 5 | |||
| 94772 | 114816 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x10 | 5995779 | 2095603 | 37.7338846095715 | -122.457003213247 | (37.7338846095715, -122.457003213247) | 9 | 7 | 4 | 59 | 40 | ||||
| 95095 | 175025 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011065.88407 | 2087267.99252 | 37.7118644130932 | -122.403565303698 | (37.7118644130932, -122.403565303698) | 9 | 7 | 8 | 309 | 39 | |||
| 95228 | 203833 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 470 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 5995548.29749 | 2095369.378 | 37.7332298893389 | -122.457783917193 | (37.7332298893389, -122.457783917193) | 9 | 7 | 4 | 59 | 40 | |||
| 95711 | 174987 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6001163.67681 | 2088517.01471 | 37.7147358557539 | -122.437879429197 | (37.7147358557539, -122.437879429197) | 9 | 7 | 6 | 28861 | 5 | |||
| 96067 | 203866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996236.4849 | 2090473.91249 | 37.7198276211289 | -122.455051057381 | (37.7198276211289, -122.455051057381) | 9 | 8 | 6 | 28861 | 24 | |||
| 96578 | 358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | |||
| 97294 | 203247 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 435 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5995610.12397 | 2095259.68006 | 37.732932237139 | -122.457562233408 | (37.732932237139, -122.457562233408) | 9 | 7 | 4 | 59 | 40 | |||
| 97637 | 203891 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 173 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 5991044.7899 | 2094655.13381 | 37.7310090036421 | -122.473301540158 | (37.7310090036421, -122.473301540158) | 9 | 8 | 4 | 64 | 40 | |||
| 97954 | 203853 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 366 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5997667.53367 | 2093836.2933 | 37.7291419238547 | -122.450346700167 | (37.7291419238547, -122.450346700167) | 9 | 7 | 4 | 28861 | 40 | ||||
| 98363 | 174988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6001118.27335 | 2088513.95986 | 37.7147248858297 | -122.438036143261 | (37.7147248858297, -122.438036143261) | 9 | 7 | 6 | 28861 | 5 | |||
| 100203 | 174978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001016.58593 | 2088794.32712 | 37.7154889282344 | -122.438407690968 | (37.7154889282344, -122.438407690968) | 9 | 7 | 6 | 28861 | 5 | |||
| 100294 | 11789 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 101095 | 203252 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5996075.27063 | 2095441.53755 | 37.7334582820635 | -122.455967253399 | (37.7334582820635, -122.455967253399) | 9 | 7 | 4 | 59 | 40 | |||
| 101389 | 174994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 86 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000642.03466 | 2088027.29642 | 37.7133615216919 | -122.439647347957 | (37.7133615216919, -122.439647347957) | 9 | 7 | 6 | 28861 | 5 | |||
| 101464 | 175043 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 199 Shakespeare St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.7092485595475 | -122.464240538697 | (37.7092485595475, -122.464240538697) | 9 | 8 | 6 | 28861 | 25 | |||
| 102740 | 203893 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 Eucalyptus Dr | 2 | : | Tree | Private 2 | 5 | Width 2ft | 5991106.51635 | 2094658.68815 | 37.7310223370083 | -122.473088402602 | (37.7310223370083, -122.473088402602) | 9 | 8 | 4 | 64 | 40 | |||
| 102741 | 98542 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 103927 | 97976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.50101 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | 9 | 3 | 7 | 309 | 28 | |
| 104694 | 203830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 990 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5995335.27016 | 2094553.61244 | 37.730977754916 | -122.45846137649 | (37.730977754916, -122.45846137649) | 9 | 7 | 4 | 59 | 40 | ||||
| 104813 | 203831 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1635 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 5995566.12601 | 2094800.15674 | 37.7316679701912 | -122.457681106717 | (37.7316679701912, -122.457681106717) | 9 | 7 | 4 | 59 | 40 | |||
| 104965 | 258052 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 856 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x6 | 5991236 | 2091663 | 37.7228044207006 | -122.472422451465 | (37.7228044207006, -122.472422451465) | 9 | 8 | 4 | 64 | 40 | ||||
| 105200 | 113348 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | 9 | 7 | 6 | 28861 | 5 | |||
| 105543 | 203821 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 280 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5996076.68769 | 2095086.62042 | 37.7324838468387 | -122.455936705234 | (37.7324838468387, -122.455936705234) | 9 | 7 | 4 | 59 | 40 | ||||
| 105857 | 175004 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000799.83685 | 2087474.06608 | 37.7118514547512 | -122.4390623048 | (37.7118514547512, -122.4390623048) | 9 | 7 | 6 | 28861 | 5 | |||
| 106195 | 174983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1005 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001103.82585 | 2088413.52914 | 37.7144483038197 | -122.438078889846 | (37.7144483038197, -122.438078889846) | 9 | 7 | 6 | 28861 | 5 | |||
| 106748 | 114218 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 119 TALBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010311 | 2086793 | 37.7105179840213 | -122.406140963349 | (37.7105179840213, -122.406140963349) | 9 | 7 | 8 | 309 | 39 | ||||
| 106917 | 203975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Santa Clara Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5993162.43396 | 2095420.11444 | 37.7332318444753 | -122.466036114303 | (37.7332318444753, -122.466036114303) | 9 | 8 | 4 | 59 | 40 | |||
| 108347 | 203877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 6 | Back Yard : Yard | Tree | Private 2 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | 9 | 8 | 6 | 64 | 24 | ||||
| 108549 | 203852 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 366 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5997653.19535 | 2093836.43462 | 37.7291414912794 | -122.450396278864 | (37.7291414912794, -122.450396278864) | 9 | 7 | 4 | 28861 | 40 | ||||
| 109757 | 175061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007438.23768 | 2093801.40772 | 37.7296004809653 | -122.416566012029 | (37.7296004809653, -122.416566012029) | 9 | 3 | 7 | 309 | 28 | |||
| 110893 | 97972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.26524 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | 9 | 3 | 7 | 309 | 28 | |
| 111250 | 174972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002023.67142 | 2088654.27361 | 37.7151616047126 | -122.434916747615 | (37.7151616047126, -122.434916747615) | 9 | 7 | 6 | 28861 | 5 | |||
| 111808 | 203861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991252.63127 | 2090414.41238 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | 9 | 8 | 6 | 64 | 24 | |||
| 112205 | 74759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 112372 | 175000 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000913.68292 | 2088416.04072 | 37.7144443845714 | -122.438736278079 | (37.7144443845714, -122.438736278079) | 9 | 7 | 6 | 28861 | 5 | |||
| 113579 | 203904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357 | (37.7272777533559, -122.47464379357) | 9 | 8 | 4 | 64 | 40 | |||
| 113685 | 203976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993355.56121 | 2095278.1224 | 37.7328531093825 | -122.465358115406 | (37.7328531093825, -122.465358115406) | 9 | 8 | 4 | 59 | 40 | |||
| 113841 | 174982 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 323 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002277.67573 | 2091830.36717 | 37.7238968690373 | -122.434265730182 | (37.7238968690373, -122.434265730182) | 9 | 7 | 6 | 28861 | 5 | |||
| 113918 | 203264 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998985.5282 | 2097263.71867 | 37.73862816615 | -122.446036726233 | (37.73862816615, -122.446036726233) | 9 | 7 | 4 | 59 | 40 | |||
| 114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
| 115600 | 24277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 15 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000814.16949 | 2086790.45771 | 37.7099752333455 | -122.43896380744 | (37.7099752333455, -122.43896380744) | 9 | 7 | 6 | 28861 | 5 | |||
| 116275 | 175028 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 50 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010596.82334 | 2086951.59743 | 37.7109694437689 | -122.405164251526 | (37.7109694437689, -122.405164251526) | 9 | 7 | 8 | 309 | 39 | |||
| 116509 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 117611 | 104976 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | 9 | 8 | 4 | 64 | 40 | |||
| 118067 | 102444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.7157989956067 | -122.436645469419 | (37.7157989956067, -122.436645469419) | 9 | 7 | 6 | 28861 | 5 | |||
| 118802 | 175077 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 19 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6002777.56398 | 2087080.30562 | 37.7108826088193 | -122.432198632175 | (37.7108826088193, -122.432198632175) | 9 | 7 | 6 | 28861 | 5 | |||
| 118961 | 203872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995594.11167 | 2089942.67302 | 37.7183320899249 | -122.457233092344 | (37.7183320899249, -122.457233092344) | 9 | 8 | 6 | 28861 | 24 | |||
| 119214 | 96535 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
| 119233 | 203244 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1648 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995594.77464 | 2094937.09571 | 37.7320456171101 | -122.457591967706 | (37.7320456171101, -122.457591967706) | 9 | 7 | 4 | 59 | 40 | |||
| 120304 | 174992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000562.83378 | 2088278.17036 | 37.7140458572152 | -122.439939070053 | (37.7140458572152, -122.439939070053) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );