Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23155 | 23155 | 543 | DPW Maintained 3 | Tree(s) :: 17 | 2871 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6009625.4825 | 2102172.3236 | 37.7527079631855 | -122.409595033175 | (37.7527079631855, -122.409595033175) | |||
| 118050 | 118050 | 863 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 129034 | 129034 | 864 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 123878 | 123878 | 865 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 114508 | 114508 | 867 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 104703 | 104703 | 868 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 141120 | 141120 | 869 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 103703 | 103703 | 870 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 144585 | 144585 | 871 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 110027 | 110027 | 872 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 116286 | 116286 | 873 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 115507 | 115507 | 874 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 104999 | 104999 | 875 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 83951 | 83951 | 876 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 96466 | 96466 | 877 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 95804 | 95804 | 879 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 105874 | 105874 | 880 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 79374 | 79374 | 881 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 85406 | 85406 | 984 | DPW Maintained 3 | Tree(s) :: 17 | 1617 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1997 12:00:00 AM | 3 | 2X2 | 6001782.703797701 | 2092720.8776329 | 37.726313902626295 | -122.436040457682 | (37.7263139026263, -122.436040457682) | ||
| 84279 | 84279 | 1036 | DPW Maintained 3 | Tree(s) :: 17 | 1992 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6000710.3605652 | 2090584.316502 | 37.720386412787 | -122.439594386876 | (37.720386412787, -122.439594386876) | ||
| 85551 | 85551 | 1317 | DPW Maintained 3 | Tree(s) :: 17 | 4050X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 111178 | 111178 | 1318 | DPW Maintained 3 | Tree(s) :: 17 | 4050X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 100742 | 100742 | 3886 | DPW Maintained 3 | Tree(s) :: 17 | 18 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002041.7840637 | 2108518.2345868 | 37.769704422667395 | -122.436274885743 | (37.7697044226674, -122.436274885743) | |||
| 110278 | 110278 | 4150 | DPW Maintained 3 | Tree(s) :: 17 | 3709X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005798.7041306 | 2100501.8256948995 | 37.7479059827851 | -122.42271003071001 | (37.7479059827851, -122.42271003071) | |||
| 82741 | 82741 | 4671 | Permitted Site 1 | Tree(s) :: 17 | 601 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 60 | 3X3 | Permit Number 770809 | 6009494.72619 | 2119646.85945 | 37.8006816014836 | -122.41128154904 | (37.8006816014836, -122.41128154904) | |
| 96456 | 96456 | 5412 | Permitted Site 1 | Tree(s) :: 17 | 414 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | 6004849.3785887 | 2105949.0211321 | 37.7628090992038 | -122.426380541105 | (37.7628090992038, -122.426380541105) | |||
| 93614 | 93614 | 8324 | DPW Maintained 3 | Tree(s) :: 17 | 1101 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2013 12:00:00 AM | 6 | 3x5 | 6006325.83915 | 2114183.13875 | 37.7855013564448 | -122.421858899832 | (37.7855013564448, -122.421858899832) | ||
| 7667 | 7667 | 8705 | Permitted Site 1 | Tree(s) :: 17 | 3040 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770786 | 5997594.5132 | 2113094.3321 | 37.7820155113305 | -122.45198797937 | (37.7820155113305, -122.45198797937) | |
| 100402 | 100402 | 8792 | Permitted Site 1 | Tree(s) :: 17 | 3575 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51928 | 5996034.3112873 | 2112825.1588314 | 37.7811869433326 | -122.457366051428 | (37.7811869433326, -122.457366051428) | |
| 22766 | 22766 | 9009 | DPW Maintained 3 | Tree(s) :: 17 | 5255 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777115 | 5990680.0267 | 2112634.9623 | 37.7803557304658 | -122.47587513459999 | (37.7803557304658, -122.4758751346) | |
| 22420 | 22420 | 9117 | Permitted Site 1 | Tree(s) :: 17 | 5800 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2015 12:00:00 AM | 3 | 3X3 | Permit Number 775232 | 5989008.1298 | 2112676.6315 | 37.780373064863504 | -122.48166198928999 | (37.7803730648635, -122.48166198929) | |
| 2525 | 2525 | 9534 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.42922989330201 | (37.779990692526, -122.429229893302) | |
| 99504 | 99504 | 9535 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 12 | 3X3 | Permit Number 771276 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | |
| 5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
| 9632 | 9632 | 9905 | Permitted Site 1 | Tree(s) :: 17 | 1801 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779094 | 6005234.1394 | 2115947.34634 | 37.790283803614 | -122.425761478317 | (37.790283803614, -122.425761478317) | |
| 2977 | 2977 | 10292 | DPW Maintained 3 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.43016441338301 | (37.7722102257422, -122.430164413383) | |||
| 138762 | 138762 | 10547 | DPW Maintained 3 | Tree(s) :: 17 | 187 Harbor Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/1995 12:00:00 AM | 6 | 3X4 | 6018418.3027239 | 2094690.3062518998 | 37.7326526259914 | -122.37866807421301 | (37.7326526259914, -122.378668074213) | ||
| 119427 | 119427 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | |||
| 103506 | 103506 | 12958 | DPW Maintained 3 | Tree(s) :: 17 | 829X Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001844.208871599 | 2095812.5283612 | 37.7348063625139 | -122.436048971563 | (37.7348063625139, -122.436048971563) | |||
| 5614 | 5614 | 13240 | Permitted Site 1 | Tree(s) :: 17 | 2346 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774035 | 6001131.9237 | 2119364.2962 | 37.7994331868979 | -122.440199950322 | (37.7994331868979, -122.440199950322) | |
| 106236 | 106236 | 16460 | DPW Maintained 3 | Tree(s) :: 17 | 2X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774049 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |
| 2769 | 2769 | 17844 | DPW Maintained 3 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | |
| 2658 | 2658 | 18040 | Permitted Site 1 | Tree(s) :: 17 | 2814 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 12 | 3X3 | Permit Number 768742 | 6000432.8759 | 2114826.5316 | 37.7869338528481 | -122.442292960737 | (37.7869338528481, -122.442292960737) | |
| 7353 | 7353 | 18041 | Permitted Site 1 | Tree(s) :: 17 | 2814 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 12 | 3X3 | Permit Number 768742 | 6000421.7394 | 2114827.2741 | 37.7869352568394 | -122.442331543699 | (37.7869352568394, -122.442331543699) | |
| 145503 | 145503 | 18520 | Permitted Site 1 | Tree(s) :: 17 | 1711 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773876 | 6009572.06002 | 2119547.78845 | 37.800413913902 | -122.411006939511 | (37.800413913902, -122.411006939511) | |
| 114434 | 114434 | 18521 | Permitted Site 1 | Tree(s) :: 17 | 1711 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773876 | 6009589.232647 | 2119528.59828 | 37.800362185394704 | -122.410946158962 | (37.8003621853947, -122.410946158962) | |
| 8470 | 8470 | 19243 | Permitted Site 1 | Tree(s) :: 17 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2007 12:00:00 AM | 3 | 3x3 | 6002038.0023 | 2110993.4691 | 37.776500585825204 | -122.436465151941 | (37.7765005858252, -122.436465151941) | ||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) | |||
| 125471 | 125471 | 21896 | Permitted Site 1 | Tree(s) :: 17 | 2051 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1995 12:00:00 AM | 3 | 3X3 | Permit Number 771015 | 6015779.94885 | 2106081.4745099996 | 37.763784603290794 | -122.38858445189301 | (37.7637846032908, -122.388584451893) | |
| 105531 | 105531 | 22604 | Permitted Site 1 | Tree(s) :: 17 | 888 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773338 | 6005785.14207 | 2112871.0019400003 | 37.7818680447544 | -122.42363622995701 | (37.7818680447544, -122.423636229957) | |
| 83347 | 83347 | 22801 | DPW Maintained 3 | Tree(s) :: 17 | 1 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 2x2 | 5998832.3639752995 | 2099992.0164602003 | 37.746110667966704 | -122.446762549602 | (37.7461106679667, -122.446762549602) | ||
| 92298 | 92298 | 22858 | DPW Maintained 3 | Tree(s) :: 17 | 144 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5999468.3728742 | 2098975.529944 | 37.7433559522386 | -122.444490278488 | (37.7433559522386, -122.444490278488) | |||
| 124966 | 124966 | 23133 | Permitted Site 1 | Tree(s) :: 17 | 610X Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774306 | 6010568.02128 | 2118944.52552 | 37.7988133007101 | -122.407517943228 | (37.7988133007101, -122.407517943228) | |
| 100391 | 100391 | 23134 | Permitted Site 1 | Tree(s) :: 17 | 610X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774306 | 6010538.21555 | 2118937.62063 | 37.7987926731864 | -122.407620594135 | (37.7987926731864, -122.407620594135) | |
| 124302 | 124302 | 23135 | Permitted Site 1 | Tree(s) :: 17 | 610X Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774306 | 6010505.00022 | 2118936.13868 | 37.79878674477239 | -122.40773542594101 | (37.7987867447724, -122.407735425941) | |
| 19780 | 19780 | 23783 | Permitted Site 1 | Tree(s) :: 17 | 1010 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | 30 | 3X3 | Permit Number 771274 | 6003903.8361546 | 2112182.8886988997 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | |
| 106173 | 106173 | 24034 | Permitted Site 1 | Tree(s) :: 17 | 57 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6017316.3969308 | 2095539.3705438 | 37.7349231809729 | -122.382536728248 | (37.7349231809729, -122.382536728248) | ||
| 84529 | 84529 | 25575 | DPW Maintained 3 | Tree(s) :: 17 | 250 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788003 | 37.738393566923705 | -122.40567687514499 | (37.7383935669237, -122.405676875145) | |||
| 112230 | 112230 | 25576 | DPW Maintained 3 | Tree(s) :: 17 | 250 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788003 | 37.738393566923705 | -122.40567687514499 | (37.7383935669237, -122.405676875145) | |||
| 80854 | 80854 | 25577 | DPW Maintained 3 | Tree(s) :: 17 | 250 Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788003 | 37.738393566923705 | -122.40567687514499 | (37.7383935669237, -122.405676875145) | |||
| 99588 | 99588 | 26070 | DPW Maintained 3 | Tree(s) :: 17 | 251 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2002 12:00:00 AM | 3 | 3X3 | 5993991.0956793 | 2088217.0958163997 | 37.7135018699932 | -122.46264889703801 | (37.7135018699932, -122.462648897038) | ||
| 14681 | 14681 | 26104 | Permitted Site 1 | Tree(s) :: 17 | 1551 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773944 | 6015292.9933 | 2095253.9285 | 37.734027431666604 | -122.389512476698 | (37.7340274316666, -122.389512476698) | |
| 120028 | 120028 | 26846 | Permitted Site 1 | Tree(s) :: 17 | 130 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | |
| 127373 | 127373 | 26847 | DPW Maintained 3 | Tree(s) :: 17 | 130 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | |
| 82688 | 82688 | 26848 | DPW Maintained 3 | Tree(s) :: 17 | 130 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | |
| 126604 | 126604 | 26849 | DPW Maintained 3 | Tree(s) :: 17 | 130 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006960.268726001 | 2111024.2991522998 | 37.7768637073231 | -122.4194397761 | (37.7768637073231, -122.4194397761) | |
| 9042 | 9042 | 27384 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | Permit Number 779236 | 6007162.48532 | 2119880.42159 | 37.801191826388504 | -122.41936866015101 | (37.8011918263885, -122.419368660151) | ||
| 9039 | 9039 | 27385 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779236 | 6007159.916809999 | 2119895.6354400003 | 37.8012334551161 | -122.419378628241 | (37.8012334551161, -122.419378628241) | |
| 128073 | 128073 | 27426 | DPW Maintained 3 | Tree(s) :: 17 | 98X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/14/2012 12:00:00 AM | 1 | 3x3 | 6006094.6477071 | 2108521.7458746 | 37.769943504838295 | -122.422256382252 | (37.7699435048383, -122.422256382252) | ||
| 78307 | 78307 | 27438 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | |||
| 97347 | 97347 | 27440 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | |||
| 125942 | 125942 | 27441 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | |||
| 85441 | 85441 | 27443 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2000 12:00:00 AM | 3 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | ||
| 98648 | 98648 | 27545 | DPW Maintained 3 | Tree(s) :: 17 | 1301X Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/24/2004 12:00:00 AM | 3 | 3X3 | 6016183.3939042995 | 2103024.5390709997 | 37.7554132592376 | -122.386975829537 | (37.7554132592376, -122.386975829537) | ||
| 144586 | 144586 | 27546 | DPW Maintained 3 | Tree(s) :: 17 | 1301X Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016183.3939042995 | 2103024.5390709997 | 37.7554132592376 | -122.386975829537 | (37.7554132592376, -122.386975829537) | ||
| 125531 | 125531 | 27581 | DPW Maintained 3 | Tree(s) :: 17 | 1299X Illinois St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2001 12:00:00 AM | 3 | 3X3 | 6016181.753397901 | 2103053.0321119 | 37.7554914042844 | -122.38698349008999 | (37.7554914042844, -122.38698349009) | ||
| 78475 | 78475 | 28079 | Permitted Site 1 | Tree(s) :: 17 | 601 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 70 | 3X3 | Permit Number 770809 | 6009494.72619 | 2119646.85945 | 37.8006816014836 | -122.41128154904 | (37.8006816014836, -122.41128154904) | |
| 93537 | 93537 | 28936 | DPW Maintained 3 | Tree(s) :: 17 | 350 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.40910727123199 | (37.7741332326441, -122.409107271232) | |
| 95809 | 95809 | 28937 | DPW Maintained 3 | Tree(s) :: 17 | 350 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.40910727123199 | (37.7741332326441, -122.409107271232) | |
| 92240 | 92240 | 28968 | DPW Maintained 3 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | ||||||
| 102705 | 102705 | 29461 | DPW Maintained 3 | Tree(s) :: 17 | 1735X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6016645.7817587005 | 2093112.7248692 | 37.7282230250629 | -122.384686318732 | (37.7282230250629, -122.384686318732) | |||
| 123845 | 123845 | 29902 | DPW Maintained 3 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6001149.68281092 | 2114264.52722613 | 37.785431561169794 | -122.439772670022 | (37.7854315611698, -122.439772670022) | ||||||
| 112236 | 112236 | 29903 | DPW Maintained 3 | Tree(s) :: 17 | 750 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6005639.13550214 | 2098758.44315121 | 37.7431100472957 | -122.423137910761 | (37.7431100472957, -122.423137910761) | ||||||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 89815 | 89815 | 30279 | Permitted Site 1 | Tree(s) :: 17 | 1298 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 129 | 6005782.31041484 | 2101407.93527218 | 37.7503930270245 | -122.42283110623998 | (37.7503930270245, -122.42283110624) | ||||
| 86078 | 86078 | 30280 | Permitted Site 1 | Tree(s) :: 17 | 1222 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1956 12:00:00 AM | Permit Number 130 | 5992707.42802641 | 2107137.73306509 | 37.7653791542065 | -122.46846140336201 | (37.7653791542065, -122.468461403362) | |||
| 110156 | 110156 | 30281 | Permitted Site 1 | Tree(s) :: 17 | 3201 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | Permit Number 131 | 5998946.4353037 | 2116245.8365118 | 37.790746059876 | -122.44753788816999 | (37.790746059876, -122.44753788817) | |||
| 116077 | 116077 | 30282 | Permitted Site 1 | Tree(s) :: 17 | 3201 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1978 12:00:00 AM | Permit Number 17098 | 5998946.4353037 | 2116245.8365118 | 37.790746059876 | -122.44753788816999 | (37.790746059876, -122.44753788817) | |||
| 106962 | 106962 | 30283 | Permitted Site 1 | Tree(s) :: 17 | 3201 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | Permit Number 131 | 5998946.4353037 | 2116245.8365118 | 37.790746059876 | -122.44753788816999 | (37.790746059876, -122.44753788817) | |||
| 77446 | 77446 | 30287 | Permitted Site 1 | Tree(s) :: 17 | 1355 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | Permit Number 132 | 6008897.64441168 | 2117513.34582038 | 37.7947899953537 | -122.41319675365601 | (37.7947899953537, -122.413196753656) | |||
| 77929 | 77929 | 30300 | Permitted Site 1 | Tree(s) :: 17 | 107 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 143 | 5990498.42551573 | 2114680.4203788997 | 37.7859614580277 | -122.47665285108299 | (37.7859614580277, -122.476652851083) | ||||
| 101023 | 101023 | 30303 | Permitted Site 1 | Tree(s) :: 17 | 835 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 146 | 6010722.8155018 | 2117232.25883609 | 37.7941204951005 | -122.406861558909 | (37.7941204951005, -122.406861558909) | |||
| 117873 | 117873 | 30306 | Permitted Site 1 | Tree(s) :: 17 | 123 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | Permit Number 7 | 5996197.18190059 | 2113600.30117228 | 37.7833246315205 | -122.45685868342699 | (37.7833246315205, -122.456858683427) | |||
| 123560 | 123560 | 30307 | Permitted Site 1 | Tree(s) :: 17 | 123 Jordan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | Permit Number 7 | 5996197.18190059 | 2113600.30117228 | 37.7833246315205 | -122.45685868342699 | (37.7833246315205, -122.456858683427) | |||
| 99408 | 99408 | 30312 | Permitted Site 1 | Tree(s) :: 17 | 501 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1955 12:00:00 AM | Permit Number 11 | 6012995.39940589 | 2104700.44134933 | 37.759837881487705 | -122.398118527649 | (37.7598378814877, -122.398118527649) | |||
| 95244 | 95244 | 30313 | Permitted Site 1 | Tree(s) :: 17 | 501 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1955 12:00:00 AM | Permit Number 11 | 6012995.39940589 | 2104700.44134933 | 37.759837881487705 | -122.398118527649 | (37.7598378814877, -122.398118527649) | |||
| 78506 | 78506 | 30317 | Permitted Site 1 | Tree(s) :: 17 | 1706 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 13 | 5984110.55692698 | 2103537.5085246996 | 37.7549936244447 | -122.497929649963 | (37.7549936244447, -122.497929649963) | ||||
| 99923 | 99923 | 30328 | Permitted Site 1 | Tree(s) :: 17 | 425 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1956 12:00:00 AM | Permit Number 19 | 6013814.09388728 | 2105118.88891553 | 37.76103241314689 | -122.395316357062 | (37.7610324131469, -122.395316357062) | |||
| 126586 | 126586 | 30336 | Permitted Site 1 | Tree(s) :: 17 | 607 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1956 12:00:00 AM | Permit Number 24 | 6002650.64744671 | 2098858.1822129 | 37.743214806503296 | -122.43347841679 | (37.7432148065033, -122.43347841679) | |||
| 138554 | 138554 | 30345 | Permitted Site 1 | Tree(s) :: 17 | 409 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1956 12:00:00 AM | Permit Number 28 | 6012970.58819224 | 2105143.62107923 | 37.7610533736303 | -122.398235431944 | (37.7610533736303, -122.398235431944) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");