trees
11,761 rows where qSpecies_id = 17 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
171 | 50655 | Permitted Site 7 | Tree(s) :: 17 | 430 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47238 | 6008643.36799877 | 2088325.11427356 | 37.7146314352433 | -122.412012884014 | (37.7146314352433, -122.412012884014) | 9 | 7 | 8 | 309 | 18 | ||||
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
323 | 106136 | Undocumented 4 | Tree(s) :: 17 | 200X RIDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996801 | 2094865 | 37.7319168756422 | -122.453416604011 | (37.7319168756422, -122.453416604011) | 9 | 7 | 4 | 59 | 40 | ||||
383 | 94356 | DPW Maintained 1 | Tree(s) :: 17 | 455 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999581.42646 | 2091332.3229 | 37.7223759483442 | -122.443550437353 | (37.7223759483442, -122.443550437353) | 9 | 7 | 6 | 28861 | 25 | ||||
434 | 102445 | Undocumented 4 | Tree(s) :: 17 | 900 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001563.3 | 2088855.6 | 37.7156882523244 | -122.436522388875 | (37.7156882523244, -122.436522388875) | 9 | 7 | 6 | 28861 | 5 | |||
528 | 57932 | Permitted Site 7 | Tree(s) :: 17 | 583 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16891 | 5999047.47505332 | 2086793.7936429 | 37.7098837148731 | -122.445070058439 | (37.7098837148731, -122.445070058439) | 9 | 7 | 6 | 28861 | 5 | |||
660 | 261647 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||
727 | 208976 | DPW Maintained 1 | Tree(s) :: 17 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 6ft | Permit Number 784904 | 5994151.01662 | 2096664.66272 | 37.7367060496466 | -122.462708592139 | (37.7367060496466, -122.462708592139) | 9 | 8 | 4 | 59 | 40 | |
797 | 260459 | Significant Tree 6 | Tree(s) :: 17 | 1798X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 5x10 | Permit Number 784470 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | |
1052 | 65988 | Permitted Site 7 | Tree(s) :: 17 | 121 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1990 12:00:00 AM | Permit Number 29018 | 5995709.58889373 | 2096251.06183698 | 37.7356600432467 | -122.457290053496 | (37.7356600432467, -122.457290053496) | 9 | 7 | 4 | 59 | 40 | |||
1314 | 67685 | Permitted Site 7 | Tree(s) :: 17 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31289 | 5997024.37469935 | 2095029.17182905 | 37.7323804536882 | -122.452656198743 | (37.7323804536882, -122.452656198743) | 9 | 7 | 4 | 59 | 40 | |||
1324 | 109608 | DPW Maintained 1 | Tree(s) :: 17 | 30 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781648 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | 9 | 7 | 6 | 28861 | 5 | |
1347 | 109892 | Permitted Site 7 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.7220304751495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | 9 | 8 | 4 | 28861 | 24 | ||
1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9817 | 5991911.06498332 | 2095358.19732765 | 37.7329895631391 | -122.47035789011 | (37.7329895631391, -122.47035789011) | 9 | 8 | 4 | 59 | 40 | |||
1430 | 67640 | Permitted Site 7 | Tree(s) :: 17 | 66 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | Permit Number 31239 | 5999465.40351772 | 2088851.00886819 | 37.7155562089288 | -122.443773323232 | (37.7155562089288, -122.443773323232) | 9 | 7 | 6 | 28861 | 25 | |||
1527 | 155727 | DPW Maintained 1 | Tree(s) :: 17 | 251 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787672 | 5993647.1889 | 2094105.14579 | 37.7296492188193 | -122.464264763718 | (37.7296492188193, -122.464264763718) | 9 | 8 | 4 | 59 | 40 | |
1559 | 68149 | Permitted Site 7 | Tree(s) :: 17 | 306 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | Permit Number 31907 | 5992597.64738181 | 2094843.40601485 | 37.731615747375 | -122.467946785243 | (37.731615747375, -122.467946785243) | 9 | 8 | 4 | 59 | 40 | |||
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
1988 | 53775 | Permitted Site 7 | Tree(s) :: 17 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1972 12:00:00 AM | Permit Number 9461 | 5992772.54452217 | 2094326.15826887 | 37.7302056116577 | -122.467304539962 | (37.7302056116577, -122.467304539962) | 9 | 8 | 4 | 59 | 40 | |||
2210 | 53264 | Permitted Site 7 | Tree(s) :: 17 | 523 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6154 | 5993474.77624345 | 2089341.33970508 | 37.7165590253308 | -122.464515046881 | (37.7165590253308, -122.464515046881) | 9 | 8 | 6 | 64 | 24 | |||
2328 | 57118 | Permitted Site 7 | Tree(s) :: 17 | 567 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 14388 | 6001433.85993869 | 2090479.06392424 | 37.7201385647203 | -122.437085957535 | (37.7201385647203, -122.437085957535) | 9 | 7 | 6 | 28861 | 5 | |||
2478 | 110785 | Permitted Site 7 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | 9 | 7 | 4 | 28861 | 40 | |||
2586 | 66958 | Permitted Site 7 | Tree(s) :: 17 | 283 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1992 12:00:00 AM | Permit Number 30294 | 5994190.17633556 | 2087741.03649596 | 37.7122061872577 | -122.461926308953 | (37.7122061872577, -122.461926308953) | 9 | 8 | 6 | 28861 | 24 | |||
2598 | 95032 | - 12 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout | Landscaping | Private 2 | 6004772 | 2093802 | 37.7294517978782 | -122.425783519869 | (37.7294517978782, -122.425783519869) | 9 | 7 | 6 | 28861 | 5 | ||||||
2764 | 262058 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 9 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
2838 | 65166 | Permitted Site 7 | Tree(s) :: 17 | 439 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2006 12:00:00 AM | Permit Number 48848 | 5999406.26967916 | 2094532.50818101 | 37.7311529235029 | -122.444385781456 | (37.7311529235029, -122.444385781456) | 9 | 7 | 4 | 59 | 40 | |||
2991 | 99574 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
3133 | 53387 | Permitted Site 7 | Tree(s) :: 17 | 272 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994766.71798377 | 2090393.02640531 | 37.7195210985022 | -122.460125633496 | (37.7195210985022, -122.460125633496) | 9 | 8 | 6 | 28861 | 24 | |||||
3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
3535 | 57947 | Permitted Site 7 | Tree(s) :: 17 | 12 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16906 | 5999407.80723315 | 2086738.68680627 | 37.7097529637216 | -122.443820730773 | (37.7097529637216, -122.443820730773) | 9 | 7 | 6 | 28861 | 5 | |||
3975 | 56564 | Permitted Site 7 | Tree(s) :: 17 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992102.77849477 | 2095182.39763056 | 37.7325179438205 | -122.469682298657 | (37.7325179438205, -122.469682298657) | 9 | 8 | 4 | 59 | 40 | |||||
4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
4958 | 106604 | Permitted Site 7 | Tree(s) :: 17 | 499X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772978 | 6002049.33574 | 2091000.17806 | 37.7216043931857 | -122.434995717595 | (37.7216043931857, -122.434995717595) | 9 | 7 | 6 | 28861 | 5 | |||
5027 | 261648 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||||
5267 | 121644 | Undocumented 4 | Tree(s) :: 17 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 2x4 | Permit Number 779268 | 5997955 | 2098188 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | 9 | 7 | 4 | 59 | 40 | |
5837 | 87442 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | |||
6001 | 262052 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
6241 | 261939 | DPW Maintained 1 | Tree(s) :: 17 | 1 Verna St | 4 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
6332 | 62387 | Permitted Site 7 | Tree(s) :: 17 | 48 Liebig St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1985 12:00:00 AM | Permit Number 22537 | 5995755.88056567 | 2086462.13640381 | 37.7087846394558 | -122.456422387366 | (37.7087846394558, -122.456422387366) | 9 | 7 | 6 | 28861 | 25 | |||
6933 | 208904 | Permitted Site 7 | Tree(s) :: 17 | 169 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784313 | 6002070.01815 | 2095092.81626 | 37.7328430243879 | -122.435216810032 | (37.7328430243879, -122.435216810032) | 9 | 7 | 5 | 63 | 40 | |
6942 | 59804 | Permitted Site 7 | Tree(s) :: 17 | 1015 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1981 12:00:00 AM | Permit Number 19255 | 5996769.15845225 | 2091684.38199603 | 37.7231818302973 | -122.453297145578 | (37.7231818302973, -122.453297145578) | 9 | 8 | 4 | 28861 | 24 | |||
7284 | 60066 | Permitted Site 7 | Tree(s) :: 17 | 340 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1982 12:00:00 AM | Permit Number 19566 | 6001320.14749485 | 2086564.43868113 | 37.709383410615 | -122.437198881793 | (37.709383410615, -122.437198881793) | 9 | 7 | 6 | 28861 | 5 | |||
7347 | 262056 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 7 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
7545 | 60963 | Permitted Site 7 | Tree(s) :: 17 | 724 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1983 12:00:00 AM | Permit Number 20768 | 5994679.63854642 | 2091263.13011286 | 37.7219051860793 | -122.460489648045 | (37.7219051860793, -122.460489648045) | 9 | 8 | 4 | 28861 | 24 | |||
8002 | 212121 | DPW Maintained 1 | Tree(s) :: 17 | 2101x Monterey Blvd | 3 | Median : Yard | Tree | DPW 1 | 11/27/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784468 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | |
8161 | 262050 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
9265 | 261652 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||||
9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
9529 | 53324 | Permitted Site 7 | Tree(s) :: 17 | 2604 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/1969 12:00:00 AM | Permit Number 6216 | 5997513.34274757 | 2089093.12192782 | 37.7161094601217 | -122.450537936417 | (37.7161094601217, -122.450537936417) | 9 | 8 | 6 | 28861 | 24 | |||
10059 | 261650 | DPW Maintained 1 | Tree(s) :: 17 | 545 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5993997 | 2090147 | 37.7188012663705 | -122.462768408851 | (37.7188012663705, -122.462768408851) | 9 | 8 | 6 | 64 | 24 | ||
10146 | 78362 | DPW Maintained 1 | Tree(s) :: 17 | 207 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | Permit Number 781699 | 6000993.78153 | 2089200.02562 | 37.7166015883641 | -122.438515563747 | (37.7166015883641, -122.438515563747) | 9 | 7 | 6 | 28861 | 5 | |
10421 | 258022 | DPW Maintained 1 | Tree(s) :: 17 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 2x3 | Permit Number 782791 | 5991571 | 2092608 | 37.7254185405379 | -122.471333259188 | (37.7254185405379, -122.471333259188) | 9 | 8 | 4 | 59 | 40 | |
10439 | 56506 | Permitted Site 7 | Tree(s) :: 17 | 556 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000140.95591591 | 2095509.77922044 | 37.733878172831 | -122.441915966113 | (37.733878172831, -122.441915966113) | 9 | 7 | 5 | 63 | 40 | |||||
10611 | 49383 | Permitted Site 7 | Tree(s) :: 17 | 522Walbridge Carter St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46344 | 6005268.88409545 | 2086363.71271864 | 37.7090559366076 | -122.423537125807 | (37.7090559366076, -122.423537125807) | 9 | 7 | 8 | 309 | 5 | ||||
10729 | 262053 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 4 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
10796 | 56567 | Permitted Site 7 | Tree(s) :: 17 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992136.3013072 | 2094883.62123857 | 37.7316995160329 | -122.469544661545 | (37.7316995160329, -122.469544661545) | 9 | 8 | 4 | 59 | 40 | |||||
11038 | 262060 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 11 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
11067 | 50712 | Permitted Site 7 | Tree(s) :: 17 | 5199 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2004 12:00:00 AM | Permit Number 47269 | 6000058.23697259 | 2088780.77104281 | 37.7153971480591 | -122.441719191836 | (37.7153971480591, -122.441719191836) | 9 | 7 | 6 | 28861 | 5 | |||
11857 | 58166 | Permitted Site 7 | Tree(s) :: 17 | 82 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/1978 12:00:00 AM | Permit Number 17151 | 6004845.68469619 | 2091453.66112065 | 37.7230079405286 | -122.425361737195 | (37.7230079405286, -122.425361737195) | 9 | 7 | 6 | 28861 | 5 | |||
11990 | 53265 | Permitted Site 7 | Tree(s) :: 17 | 518 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6155 | 5993526.45994687 | 2089315.57926722 | 37.7164912726104 | -122.464334534512 | (37.7164912726104, -122.464334534512) | 9 | 8 | 6 | 64 | 24 | |||
12539 | 208984 | DPW Maintained 1 | Tree(s) :: 17 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782906 | 5993085 | 2095640 | 37.7338311279924 | -122.466319797261 | (37.7338311279924, -122.466319797261) | 9 | 8 | 4 | 59 | 40 | |
12596 | 208983 | DPW Maintained 1 | Tree(s) :: 17 | 330 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/08/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783251 | 5993097.51511 | 2095800.07009 | 37.73427136274 | -122.466288158284 | (37.73427136274, -122.466288158284) | 9 | 8 | 4 | 59 | 40 | |
12610 | 262055 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 6 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
12879 | 261642 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||||
13049 | 52672 | Permitted Site 7 | Tree(s) :: 17 | 160@ WINSTON Broadmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48753 | 5990984.89473485 | 2092824.05440555 | 37.7259778503357 | -122.473375102844 | (37.7259778503357, -122.473375102844) | 9 | 8 | 4 | 64 | 40 | |||
13197 | 40567 | Permitted Site 7 | Tree(s) :: 17 | 31 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2010 12:00:00 AM | Permit Number 53706 | 6000803.08973979 | 2089865.40305988 | 37.7184177160492 | -122.439222351797 | (37.7184177160492, -122.439222351797) | 9 | 7 | 6 | 28861 | 5 | |||
13533 | 68369 | Permitted Site 7 | Tree(s) :: 17 | 1219 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | Permit Number 32190 | 5999787.45489561 | 2090260.77177141 | 37.7194454618366 | -122.442761341724 | (37.7194454618366, -122.442761341724) | 9 | 7 | 6 | 28861 | 25 | |||
13769 | 69131 | Permitted Site 7 | Tree(s) :: 17 | 170 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | Permit Number 33157 | 5994423.99430324 | 2094372.47335057 | 37.7304279789784 | -122.461598658909 | (37.7304279789784, -122.461598658909) | 9 | 8 | 4 | 59 | 40 | |||
13877 | 262059 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 10 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
14142 | 57748 | Permitted Site 7 | Tree(s) :: 17 | 543 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | Permit Number 16668 | 5996663.15247063 | 2095607.64429531 | 37.7339480955885 | -122.453946782812 | (37.7339480955885, -122.453946782812) | 9 | 7 | 4 | 59 | 40 | |||
14240 | 174970 | DPW Maintained 1 | Tree(s) :: 17 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5999272.73496 | 2090903.68447 | 37.7211813957975 | -122.444586716009 | (37.7211813957975, -122.444586716009) | 9 | 7 | 6 | 28861 | 25 | |||
14550 | 261641 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||
14604 | 108382 | Undocumented 4 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | 9 | 7 | 8 | 309 | 39 | ||||
14657 | 208982 | DPW Maintained 1 | Tree(s) :: 17 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782907 | 5993096.56578 | 2095876.31596 | 37.7344806601409 | -122.466296979745 | (37.7344806601409, -122.466296979745) | 9 | 8 | 4 | 59 | 40 | |
14776 | 209001 | DPW Maintained 1 | Tree(s) :: 17 | 125 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5994148.93284 | 2096709.76404 | 37.7368297666801 | -122.462719067425 | (37.7368297666801, -122.462719067425) | 9 | 8 | 4 | 59 | 40 | |
14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
15525 | 261460 | Undocumented 4 | Tree(s) :: 17 | 701X Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
15589 | 67571 | Permitted Site 7 | Tree(s) :: 17 | 1042 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1992 12:00:00 AM | Permit Number 31126 | 6004491.22819512 | 2090600.12936248 | 37.7206442968761 | -122.426526275127 | (37.7206442968761, -122.426526275127) | 9 | 7 | 6 | 28861 | 5 | |||
15590 | 260947 | Private 9 | Tree(s) :: 17 | 143 Gambier St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005856 | 2093079 | 37.72752779603 | -122.421984681693 | (37.72752779603, -122.421984681693) | 9 | 7 | 7 | 309 | 5 | ||||
15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
15805 | 57484 | Permitted Site 7 | Tree(s) :: 17 | 508 Carter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1976 12:00:00 AM | Permit Number 16335 | 6005285.76738165 | 2086407.83272449 | 37.7091780337596 | -122.42348190912 | (37.7091780337596, -122.42348190912) | 9 | 7 | 8 | 309 | 5 | |||
16232 | 262057 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 8 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
16294 | 48467 | Permitted Site 7 | Tree(s) :: 17 | 337 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | Permit Number 45829 | 5995825.19093791 | 2091191.15517782 | 37.7217733955179 | -122.456524586993 | (37.7217733955179, -122.456524586993) | 9 | 8 | 6 | 28861 | 24 | |||
16343 | 62757 | Permitted Site 7 | Tree(s) :: 17 | 801 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1986 12:00:00 AM | Permit Number 23108 | 6001185.33927119 | 2089069.45296816 | 37.7162539597586 | -122.437844099146 | (37.7162539597586, -122.437844099146) | 9 | 7 | 6 | 28861 | 5 | |||
16744 | 261651 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||
16784 | 38430 | Permitted Site 7 | Tree(s) :: 17 | 200 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40458 | 5994627.21829039 | 2092807.09536405 | 37.7261415269154 | -122.460782687965 | (37.7261415269154, -122.460782687965) | 9 | 8 | 4 | 28861 | 40 | ||||
16788 | 106928 | Undocumented 4 | Tree(s) :: 17 | 132 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 772627 | 5999153.18191 | 2093532.26995 | 37.7283920599051 | -122.445188861704 | (37.7283920599051, -122.445188861704) | 9 | 7 | 4 | 28861 | 40 | |||
16789 | 58183 | Permitted Site 7 | Tree(s) :: 17 | 439 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1978 12:00:00 AM | Permit Number 17170 | 5998520.73657118 | 2095224.46566135 | 37.7330023103741 | -122.447497001156 | (37.7330023103741, -122.447497001156) | 9 | 7 | 4 | 59 | 40 | |||
16812 | 55302 | Permitted Site 7 | Tree(s) :: 17 | 286 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1972 12:00:00 AM | Permit Number 11231 | 5994157.85474702 | 2089358.87482809 | 37.7166465262229 | -122.462155276525 | (37.7166465262229, -122.462155276525) | 9 | 8 | 6 | 28861 | 24 | |||
16892 | 59824 | Permitted Site 7 | Tree(s) :: 17 | 1926 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1981 12:00:00 AM | Permit Number 19276 | 5993986.26226436 | 2092648.68281763 | 37.725669664928 | -122.462986931104 | (37.725669664928, -122.462986931104) | 9 | 8 | 4 | 59 | 40 | |||
17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
17070 | 59819 | Permitted Site 7 | Tree(s) :: 17 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1981 12:00:00 AM | Permit Number 19271 | 5995083.88274791 | 2092234.3931213 | 37.7245952889407 | -122.459162583785 | (37.7245952889407, -122.459162583785) | 9 | 8 | 4 | 28861 | 40 | |||
17296 | 262054 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 5 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
17395 | 208939 | DPW Maintained 1 | Tree(s) :: 17 | 100 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784719 | 5992155.70572 | 2095974.23732 | 37.7346951961161 | -122.469556940308 | (37.7346951961161, -122.469556940308) | 9 | 8 | 4 | 59 | 40 | |
17730 | 25297 | DPW Maintained 1 | Tree(s) :: 17 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:24:00 PM | 3 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510353 | -122.440332418218 | (37.723490510353, -122.440332418218) | 9 | 7 | 6 | 28861 | 25 |
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) );