trees
39,840 rows where qLegalStatus_id = 7 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194481 | 256359 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2655 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 48401 | 6005661 | 2119519 | 37.8001147748179 | -122.424538736295 | (37.8001147748179, -122.424538736295) | 13 | 9 | 1 | 57 | 17 | ||
194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
194447 | 265091 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006085.39303 | 2100598.74488 | 37.7481882715663 | -122.421725554794 | (37.7481882715663, -122.421725554794) | 2 | 4 | 5 | 28859 | 19 | |
194446 | 4132 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | 2 | 4 | 5 | 28859 | 19 | |
194443 | 231199 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3636 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6005923.7545 | 2100590.88969 | 37.7481575867153 | -122.422283938475 | (37.7481575867153, -122.422283938475) | 2 | 4 | 5 | 28859 | 19 | |
194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
194360 | 265028 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||||
194332 | 237618 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787900 | 6001516.02196 | 2103550.89224 | 37.756035430207 | -122.437737665468 | (37.756035430207, -122.437737665468) | 2 | 4 | 5 | 28862 | 3 | |
194304 | 264984 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
194299 | 264985 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 94X Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780527 | 5998136 | 2107256 | 37.7660159557417 | -122.449693840282 | (37.7660159557417, -122.449693840282) | 15 | 5 | 11 | 29492 | 9 | |
194296 | 187453 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 4621 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002078.4831 | 2091980.9842 | 37.724299121454 | -122.434965072602 | (37.724299121454, -122.434965072602) | 9 | 7 | 6 | 28861 | 5 | |||
194267 | 264981 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 106X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 4.5x5 | Permit Number 787721 | 6000803 | 2103641 | 37.7562422754387 | -122.440209988419 | (37.7562422754387, -122.440209988419) | 2 | 4 | 5 | 28862 | 38 | |
194265 | 264982 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 106X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 4.5x5 | Permit Number 787721 | 6000803 | 2103641 | 37.7562422754387 | -122.440209988419 | (37.7562422754387, -122.440209988419) | 2 | 4 | 5 | 28862 | 38 | |
194255 | 47737 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 765ST Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2002 12:00:00 AM | Permit Number 45522 | 6001007.50472324 | 2111284.16772448 | 37.7772401606319 | -122.440050778725 | (37.7772401606319, -122.440050778725) | 15 | 5 | 11 | 29492 | 41 | |||
194254 | 84377 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2067 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51008 | 5999701.79957406 | 2111545.8416405 | 37.7778842319528 | -122.444586427675 | (37.7778842319528, -122.444586427675) | 15 | 5 | 11 | 29490 | 16 | ||
194252 | 84854 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1350 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49305 | 6007150 | 2107624 | 37.7675379786574 | -122.418542261588 | (37.7675379786574, -122.418542261588) | 8 | 4 | 7 | 28853 | 19 | |||
194249 | 38153 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | Permit Number 40301 | 6010792.35576836 | 2093128.34869329 | 37.7279404662771 | -122.404923048592 | (37.7279404662771, -122.404923048592) | 10 | 3 | 7 | 309 | 28 | ||
194245 | 106032 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
194241 | 87028 | Permitted Site 7 | Tree(s) :: 17 | 460 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 775764 | 5993816 | 2101815 | 37.7508282780146 | -122.464240679792 | (37.7508282780146, -122.464240679792) | 1 | 8 | 4 | 29491 | 12 | ||
194239 | 33509 | Permitted Site 7 | :: 45 | 24 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | 2 | 7 | 7 | 28859 | 2 | |||
194237 | 31775 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
194236 | 108084 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
194224 | 94020 | Permitted Site 7 | Pittosporum spp :: Pittosporum spp 170 | 455 Buena Vista East Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53438 | 6000469 | 2107132 | 37.765808680756 | -122.44161558785 | (37.765808680756, -122.44161558785) | 15 | 5 | 5 | 29492 | 3 | |||
194220 | 48629 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1417 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45926 | 5991770.27405058 | 2105778.87333807 | 37.761593910046 | -122.471603740431 | (37.761593910046, -122.471603740431) | 1 | 8 | 4 | 56 | 12 | ||
194219 | 56516 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992016.71366179 | 2099080.57669874 | 37.7432163828282 | -122.470263614355 | (37.7432163828282, -122.470263614355) | 1 | 8 | 4 | 29491 | 40 | ||||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
194212 | 102173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
194210 | 67740 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1412 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31359 | 5993990.22084457 | 2105880.95703345 | 37.7620023888233 | -122.463933320103 | (37.7620023888233, -122.463933320103) | 1 | 5 | 11 | 56 | 12 | ||
194208 | 64728 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1007 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25684 | 6001310.25667313 | 2108993.45457351 | 37.7709676675547 | -122.438839270723 | (37.7709676675547, -122.438839270723) | 15 | 5 | 11 | 29492 | 9 | ||
194203 | 59390 | Permitted Site 7 | Tree(s) :: 17 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1980 12:00:00 AM | Permit Number 18744 | 6003369.07429125 | 2095960.92272246 | 37.7353003315172 | -122.430787573509 | (37.7353003315172, -122.430787573509) | 2 | 7 | 5 | 63 | 7 | |||
194197 | 32843 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 838 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37197 | 6001875.52927375 | 2101649.48990957 | 37.7508350700837 | -122.43635829546 | (37.7508350700837, -122.43635829546) | 2 | 4 | 5 | 28862 | 22 | ||
194189 | 36058 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
194173 | 48961 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 28 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46147 | 6013070.77651727 | 2090978.31795111 | 37.72216401444 | -122.396895756374 | (37.72216401444, -122.396895756374) | 10 | 3 | 8 | 58 | 1 | |||
194170 | 99057 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006091.16213 | 2106453.22967 | 37.7642636537255 | -122.422121463956 | (37.7642636537255, -122.422121463956) | 8 | 4 | 5 | 28859 | 19 | |||
194146 | 34249 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 174 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46663 | 5996827.5342502 | 2089032.06513255 | 37.7159025350879 | -122.452903999886 | (37.7159025350879, -122.452903999886) | 9 | 8 | 6 | 28861 | 24 | ||
194137 | 27344 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 664 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
194128 | 21848 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 224 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/1993 12:00:00 AM | 5 | 3X3 | 5994910.90461 | 2110804.06513 | 37.775572970261 | -122.461105914285 | (37.775572970261, -122.461105914285) | 11 | 6 | 2 | 54 | 11 | ||
194126 | 31573 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1823 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35112 | 5989355.93017954 | 2102934.99499768 | 37.7536454065053 | -122.479745775823 | (37.7536454065053, -122.479745775823) | 1 | 8 | 3 | 56 | 35 | ||
194122 | 45253 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 574 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44100 | 6009814.86507162 | 2098861.28779426 | 37.7436271988368 | -122.408706547484 | (37.7436271988368, -122.408706547484) | 2 | 7 | 7 | 28859 | 2 | ||
194121 | 52944 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.441525334084 | (37.727706542786, -122.441525334084) | 9 | 7 | 6 | 28861 | 25 | |||
194120 | 109393 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1619X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.406670373739 | (37.7474841871266, -122.406670373739) | 2 | 7 | 7 | 28859 | 2 |
194118 | 47285 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2850 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45229 | 6010236.13037587 | 2101085.34021251 | 37.7497575458278 | -122.40740666911 | (37.7497575458278, -122.40740666911) | 2 | 4 | 7 | 28859 | 19 | ||
194114 | 107973 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2750 JACKSON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096.4 | 2116670.4 | 37.7920344322485 | -122.440129594684 | (37.7920344322485, -122.440129594684) | 13 | 6 | 1 | 29490 | 27 | ||||
194111 | 59032 | Permitted Site 7 | Tree(s) :: 17 | 985 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1990 12:00:00 AM | Permit Number 29367 | 6008032.28329812 | 2102204.43473858 | 37.7527067292395 | -122.415106889811 | (37.7527067292395, -122.415106889811) | 2 | 4 | 7 | 28859 | 19 | |||
194100 | 96553 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 6 | 2.5x1.5 | Permit Number 770753 | 6009478 | 2092445 | 37.7259905771817 | -122.409418624248 | (37.7259905771817, -122.409418624248) | 10 | 3 | 7 | 309 | 28 | |
194098 | 17635 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
194096 | 64428 | Permitted Site 7 | Tree(s) :: 17 | 174 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1990 12:00:00 AM | Permit Number 29387 | 6002660.36402635 | 2104886.09913536 | 37.7597665896018 | -122.433875586505 | (37.7597665896018, -122.433875586505) | 2 | 4 | 5 | 28862 | 3 | |||
194093 | 24686 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.7797664796243 | -122.490106359296 | (37.7797664796243, -122.490106359296) | 11 | 6 | 2 | 55 | 26 | ||
194091 | 2632 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1884 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004471.16425 | 2115036.06465 | 37.7877385090069 | -122.428336341174 | (37.7877385090069, -122.428336341174) | 13 | 9 | 11 | 28858 | 27 | |||
194080 | 27554 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
194076 | 96525 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
194075 | 53425 | Permitted Site 7 | Tree(s) :: 17 | 22 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1969 12:00:00 AM | Permit Number 6325 | 5998576.48514196 | 2106929.88862027 | 37.7651457271594 | -122.448146813934 | (37.7651457271594, -122.448146813934) | 15 | 5 | 11 | 29492 | 9 | |||
194066 | 58863 | Permitted Site 7 | Tree(s) :: 17 | 331 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1986 12:00:00 AM | Permit Number 23564 | 6007756.09682215 | 2097566.29894188 | 37.7399559215766 | -122.415733611191 | (37.7399559215766, -122.415733611191) | 2 | 7 | 7 | 28859 | 2 | |||
194065 | 92027 | Permitted Site 7 | Tree(s) :: 17 | 80 Crown Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52172 | 5998680.9 | 2104321.8 | 37.7579905367617 | -122.447597912788 | (37.7579905367617, -122.447597912788) | 15 | 5 | 5 | 28862 | 12 | ||
194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
194058 | 30683 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 425 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Permit Number 782764 | 6004598.67244 | 2110025.49511 | 37.773987938825 | -122.42753808092 | (37.773987938825, -122.42753808092) | 7 | 9 | 11 | 28852 | 10 | |
194026 | 36583 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1378 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39444 | 6009261.20468059 | 2101135.34094494 | 37.7498402210045 | -122.410781546504 | (37.7498402210045, -122.410781546504) | 2 | 4 | 7 | 28859 | 19 | ||
194021 | 28572 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1220X Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.08971 | 37.7238479200224 | -122.459124181231 | (37.7238479200224, -122.459124181231) | 9 | 8 | 4 | 28861 | 24 | ||
194014 | 36433 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
194013 | 53275 | Permitted Site 7 | Tree(s) :: 17 | 70 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1969 12:00:00 AM | Permit Number 6165 | 6004072.62968681 | 2102650.60497511 | 37.7537084925961 | -122.428831883911 | (37.7537084925961, -122.428831883911) | 2 | 4 | 5 | 28862 | 22 | |||
194004 | 85541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 8 | 2 | 9 | 28853 | 19 | |||
194003 | 56702 | Permitted Site 7 | Tree(s) :: 17 | 1654 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5983167.42823227 | 2103871.72196183 | 37.7558559430954 | -122.501215923743 | (37.7558559430954, -122.501215923743) | 1 | 8 | 3 | 56 | 35 | |||||
193991 | 52376 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.419314037874 | (37.7454444472056, -122.419314037874) | 2 | 7 | 7 | 28859 | 2 | ||
193986 | 68368 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | 9 | 7 | 5 | 28861 | 25 | ||
193982 | 51339 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2345 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2004 12:00:00 AM | Permit Number 47687 | 5998288.77869718 | 2111348.12240087 | 37.7772606157071 | -122.449460290108 | (37.7772606157071, -122.449460290108) | 15 | 6 | 2 | 29492 | 16 | |||
193977 | 24413 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
193974 | 49958 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1635 REVISED Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.7885517909036 | -122.425424765275 | (37.7885517909036, -122.425424765275) | 13 | 9 | 11 | 28858 | 27 | ||
193973 | 99291 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
193966 | 57757 | Permitted Site 7 | Tree(s) :: 17 | 6 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | Permit Number 16680 | 5996239.23883493 | 2095895.46247941 | 37.73471405973 | -122.455433167904 | (37.73471405973, -122.455433167904) | 9 | 7 | 4 | 59 | 40 | |||
193963 | 17739 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1339X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1992 12:00:00 AM | 6 | 3X3 | 6002224.0418527 | 2113098.314365 | 37.7822905309042 | -122.435972235897 | (37.7822905309042, -122.435972235897) | 15 | 5 | 11 | 29490 | 41 | ||
193961 | 63264 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 474 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 23819 | 6003326.56560874 | 2102164.81247283 | 37.7523323660448 | -122.431377264225 | (37.7523323660448, -122.431377264225) | 2 | 4 | 5 | 28862 | 22 | ||
193960 | 40624 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 14 | 3x3 | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |
193958 | 33625 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 395 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37727 | 6004659.53448336 | 2109979.61228939 | 37.7738653980353 | -122.427324279619 | (37.7738653980353, -122.427324279619) | 7 | 9 | 11 | 28852 | 10 | |||
193950 | 35318 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 558 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38784 | 6005532.25805435 | 2105709.16639326 | 37.7621890925673 | -122.424001640918 | (37.7621890925673, -122.424001640918) | 8 | 4 | 5 | 28859 | 19 | ||
193949 | 45203 | Permitted Site 7 | Tree(s) :: 17 | 1960 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2001 12:00:00 AM | Permit Number 44047 | 5993860.26347806 | 2102157.70521953 | 37.7517718101952 | -122.464112489667 | (37.7517718101952, -122.464112489667) | 1 | 8 | 4 | 29491 | 12 | |||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
193942 | 36713 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39499 | 6006412.25485032 | 2105738.01834436 | 37.7623179565756 | -122.420960109842 | (37.7623179565756, -122.420960109842) | 8 | 4 | 7 | 28859 | 19 | ||
193940 | 99081 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 511 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2012 12:00:00 AM | 3 | 3x3 | 6006244.53682 | 2106614.02725 | 37.7647138154977 | -122.421602404791 | (37.7647138154977, -122.421602404791) | 8 | 4 | 7 | 28859 | 19 | ||
193939 | 57597 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1007 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1976 12:00:00 AM | Permit Number 16465 | 6001956.93021678 | 2101160.46885236 | 37.7494969594121 | -122.436041814854 | (37.7494969594121, -122.436041814854) | 2 | 4 | 5 | 28862 | 22 | |||
193938 | 56966 | Permitted Site 7 | Tree(s) :: 17 | 425 Dellbrook Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 14218 | 5996998.57044522 | 2102801.79522801 | 37.7537206962491 | -122.45330635517 | (37.7537206962491, -122.45330635517) | 1 | 5 | 4 | 63 | 38 | |||
193933 | 40300 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | |||
193932 | 108082 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
193931 | 60620 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 221 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20245 | 6004788.53237408 | 2097060.23831103 | 37.7383991243874 | -122.425958210014 | (37.7383991243874, -122.425958210014) | 2 | 7 | 5 | 63 | 7 | ||
193929 | 93824 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
193906 | 32231 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1550 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | Permit Number 35548 | 6008714.80445497 | 2099826.35460385 | 37.7462153841003 | -122.412578508818 | (37.7462153841003, -122.412578508818) | 2 | 7 | 7 | 28859 | 2 | ||
193902 | 54773 | Permitted Site 7 | Tree(s) :: 17 | 1447 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1972 12:00:00 AM | Permit Number 10622 | 5994255.46908651 | 2105668.26375413 | 37.7614336708029 | -122.463000504273 | (37.7614336708029, -122.463000504273) | 1 | 5 | 11 | 56 | 12 | |||
193886 | 95914 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1900 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767613 | 5988155 | 2102402 | 37.7521121061163 | -122.483859729435 | (37.7521121061163, -122.483859729435) | 1 | 8 | 3 | 56 | 35 | |
193885 | 59393 | Permitted Site 7 | Tree(s) :: 17 | 562 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1980 12:00:00 AM | Permit Number 18747 | 6003134.98309305 | 2095777.70539718 | 37.7347839928279 | -122.4315838364 | (37.7347839928279, -122.4315838364) | 2 | 7 | 5 | 63 | 7 | |||
193880 | 92560 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
193878 | 34952 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 315 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1997 12:00:00 AM | Permit Number 38549 | 5994259.00226066 | 2099898.8670044 | 37.7455925857292 | -122.462569772731 | (37.7455925857292, -122.462569772731) | 1 | 8 | 4 | 29491 | 40 | |||
193873 | 104514 | Permitted Site 7 | Tree(s) :: 17 | 951X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 769348 | 6003136.88102 | 2102566.33372 | 37.7534240963555 | -122.432061893742 | (37.7534240963555, -122.432061893742) | 2 | 4 | 5 | 28862 | 22 | ||
193865 | 26172 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
193864 | 256057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39638 | 6004331 | 2099600 | 37.7453468607112 | -122.427721041632 | (37.7453468607112, -122.427721041632) | 2 | 7 | 5 | 63 | 22 | ||
193861 | 44757 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | 15 | 4 | 5 | 28862 | 3 | ||||
193856 | 85810 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
193839 | 91054 | Permitted Site 7 | Tree(s) :: 17 | 750 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51965 | 6012124 | 2113544 | 37.7840717096161 | -122.401753911211 | (37.7840717096161, -122.401753911211) | 12 | 2 | 9 | 28853 | 6 | ||
193836 | 12192 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016272.6778818 | 2095480.4561364 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | 10 | 3 | 8 | 58 | 1 | |||
193831 | 92223 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52658 | 6009316 | 2104920 | 37.7602351164227 | -122.410859325784 | (37.7602351164227, -122.410859325784) | 2 | 4 | 7 | 28859 | 19 | ||
193829 | 46439 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 801 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | Permit Number 44657 | 6009047.36226192 | 2120070.50682291 | 37.8018197316674 | -122.41285958718 | (37.8018197316674, -122.41285958718) | 3 | 1 | 10 | 308 | 32 |
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) );