Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96847 | 96847 | 376 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 125133 | 125133 | 377 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 124243 | 124243 | 378 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 129416 | 129416 | 379 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 105060 | 105060 | 380 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 101507 | 101507 | 381 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 89509 | 89509 | 399 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3790X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990543.5477982005 | 2090571.3277717 | 37.719766857298396 | -122.474736447703 | (37.7197668572984, -122.474736447703) | ||
| 16908 | 16908 | 406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3822 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 2x5 | 5990686.0398699995 | 2090357.61675 | 37.7191883155766 | -122.47422832208599 | (37.7191883155766, -122.474228322086) | ||
| 21232 | 21232 | 409 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3838 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2X3 | 5990744.200019999 | 2090277.4187900003 | 37.7189714809286 | -122.474021438444 | (37.7189714809286, -122.474021438444) | ||
| 21161 | 21161 | 419 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3874 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2X3 | 5990927.36264 | 2090022.7346400002 | 37.718282789105295 | -122.47336975731501 | (37.7182827891053, -122.473369757315) | ||
| 18730 | 18730 | 420 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3878 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2008 12:00:00 AM | 3 | 2X3 | 5990951.59904 | 2089989.44281 | 37.7181927813499 | -122.47328355639799 | (37.7181927813499, -122.473283556398) | ||
| 114406 | 114406 | 423 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989520.14191 | 2114679.4353400003 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | |||
| 89647 | 89647 | 424 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989549.9462 | 2114680.6916799997 | 37.7859071433722 | -122.479934312872 | (37.7859071433722, -122.479934312872) | |||
| 92749 | 92749 | 425 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5800X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5989566.99548 | 2114057.22504 | 37.7841962699423 | -122.479829688766 | (37.7841962699423, -122.479829688766) | |||
| 98075 | 98075 | 426 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5750X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5989712.1969 | 2114062.83414 | 37.784220105429 | -122.47932775959801 | (37.784220105429, -122.479327759598) | |||
| 83054 | 83054 | 427 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5750X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5989666.908430001 | 2114060.8985200003 | 37.7842121602686 | -122.479484298226 | (37.7842121602686, -122.479484298226) | |||
| 118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
| 79980 | 79980 | 433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5900X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5989228.21331 | 2114045.1734599997 | 37.7841434921695 | -122.481000858329 | (37.7841434921695, -122.481000858329) | |||
| 143470 | 143470 | 435 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2304X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1990 12:00:00 AM | 18 | 3X3 | 6009640.4705467 | 2103910.2968541 | 37.7574808881207 | -122.409665861744 | (37.7574808881207, -122.409665861744) | ||
| 122084 | 122084 | 439 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2606X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008239.9535300005 | 2103244.59604 | 37.7555744447599 | -122.41446232215701 | (37.7555744447599, -122.414462322157) | |||
| 103089 | 103089 | 467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2490 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 12 | 4X4 | 6009704.8170941 | 2102845.1135009998 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | ||
| 9131 | 9131 | 468 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2490 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009704.8170941 | 2102845.1135009998 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | |||
| 116736 | 116736 | 469 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2490 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009704.8170941 | 2102845.1135009998 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | |||
| 9082 | 9082 | 470 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2490 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009704.8170941 | 2102845.1135009998 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | |||
| 17948 | 17948 | 472 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2790 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2005 12:00:00 AM | 6 | 3x3 | 6008923.39958 | 2102238.9424099997 | 37.7528515171836 | -122.412027677747 | (37.7528515171836, -122.412027677747) | ||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 113086 | 113086 | 486 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.40652353202299 | (37.7529942564805, -122.406523532023) | |||
| 87388 | 87388 | 488 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 22172 | 22172 | 489 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.40706114707301 | (37.7529750670361, -122.407061147073) | |||
| 17941 | 17941 | 495 | Permitted Site 1 | Tristania conferta :: 79 | 2749X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2010 12:00:00 AM | 3 | 3X3 | 6010480.319 | 2102220.7863 | 37.752888894824295 | -122.406642256485 | (37.7528888948243, -122.406642256485) | ||
| 3273 | 3273 | 499 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | |
| 85222 | 85222 | 504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | |||
| 106609 | 106609 | 506 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 17520 | 17520 | 507 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2755X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008976.16945 | 2102362.07248 | 37.753192565308204 | -122.411853889149 | (37.7531925653082, -122.411853889149) | ||
| 18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
| 120595 | 120595 | 510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 128389 | 128389 | 512 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.40800714042601 | (37.7529955768562, -122.408007140426) | |||
| 20896 | 20896 | 523 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2813 24th St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777511 | 6009929.7366 | 2102188.669 | 37.752769888235704 | -122.408544016423 | (37.7527698882357, -122.408544016423) | |
| 17851 | 17851 | 526 | Permitted Site 1 | Tristania conferta :: 79 | 2830 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009862.6031 | 2102227.8681 | 37.7528737602498 | -122.40877894251899 | (37.7528737602498, -122.408778942519) | |||
| 19393 | 19393 | 527 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | |||
| 21990 | 21990 | 528 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | |||
| 141568 | 141568 | 535 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2578X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009729.93179 | 2102266.32124 | 37.7529719120351 | -122.409240459881 | (37.7529719120351, -122.409240459881) | |||
| 18274 | 18274 | 537 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2855 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 3 | 3X3 | 6009690.2907 | 2102176.9118 | 37.752724192681896 | -122.40937123766199 | (37.7527241926819, -122.409371237662) | ||
| 139756 | 139756 | 539 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2862 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 07:55:00 AM | 3 | 3X3 | 6009630.84107 | 2102242.33848 | 37.752900508699206 | -122.40958144339399 | (37.7529005086992, -122.409581443394) | ||
| 17565 | 17565 | 542 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.40967549279199 | (37.7528202149244, -122.409675492792) | |||
| 17142 | 17142 | 545 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.40983092966101 | (37.7528128183786, -122.409830929661) | |||
| 21996 | 21996 | 553 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2913 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2009 12:00:00 AM | 3 | 3X3 | 6009381.263809999 | 2102159.45756 | 37.7526589480672 | -122.410438680004 | (37.7526589480672, -122.410438680004) | ||
| 20317 | 20317 | 558 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2929 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2010 12:00:00 AM | 3 | 3x3 | 6009323.95705 | 2102154.80384 | 37.7526429572166 | -122.410636529062 | (37.7526429572166, -122.410636529062) | ||
| 21452 | 21452 | 569 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009068.4734 | 2102184.68731 | 37.7527106833549 | -122.411522150837 | (37.7527106833549, -122.411522150837) | |||
| 123037 | 123037 | 570 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2972 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009057.78841 | 2102246.54845 | 37.7528799408325 | -122.411563471864 | (37.7528799408325, -122.411563471864) | |||
| 87023 | 87023 | 572 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2980X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776380 | 6009061.0945003 | 2102187.7119023 | 37.752718574309995 | -122.41154788216299 | (37.75271857431, -122.411547882163) | |
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 85589 | 85589 | 581 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3013 24TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 5 | 3X3 | 6008864.0 | 2102095.0 | 37.7524529507625 | -122.41222292066799 | (37.7524529507625, -122.412222920668) | ||
| 20413 | 20413 | 589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3045 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 6 | 3x3 | 6008694.50284 | 2102123.85883 | 37.7525226783038 | -122.41281111226101 | (37.7525226783038, -122.412811112261) | ||
| 20951 | 20951 | 592 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008558.8392900005 | 2102157.7680200003 | 37.752608169649 | -122.41328265918699 | (37.752608169649, -122.413282659187) | |||
| 93429 | 93429 | 594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008579.288380001 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | |||
| 18661 | 18661 | 598 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6008489.074019999 | 2102147.94889 | 37.75257729142999 | -122.41352322603399 | (37.75257729143, -122.413523226034) | |||
| 91511 | 91511 | 599 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008567.5453 | 2102081.22398 | 37.7523984857225 | -122.413247139853 | (37.7523984857225, -122.413247139853) | |||
| 19961 | 19961 | 600 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.41362163882401 | (37.7525711157729, -122.413621638824) | |||
| 21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
| 20158 | 20158 | 605 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008383.72095 | 2102142.9064 | 37.752557529712895 | -122.41388719964701 | (37.7525575297129, -122.413887199647) | |||
| 21643 | 21643 | 606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008351.06015 | 2102163.79121 | 37.75261304037179 | -122.41400162398399 | (37.7526130403718, -122.414001623984) | |||
| 20891 | 20891 | 607 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008349.31996 | 2102181.9005400003 | 37.7526626667701 | -122.414008922882 | (37.7526626667701, -122.414008922882) | |||
| 17137 | 17137 | 608 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008346.158869999 | 2102213.06871 | 37.7527480699909 | -122.41402205928101 | (37.7527480699909, -122.414022059281) | |||
| 20356 | 20356 | 620 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3145 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008061.58213 | 2102085.15012 | 37.752380847108604 | -122.41499712672 | (37.7523808471086, -122.41499712672) | |||
| 18462 | 18462 | 623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3158 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6007941.8237 | 2102115.0630200002 | 37.7524562507759 | -122.415413389641 | (37.7524562507759, -122.415413389641) | |||
| 17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
| 18232 | 18232 | 630 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.752440194268395 | -122.41577423901501 | (37.7524401942684, -122.415774239015) | |||
| 139691 | 139691 | 634 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3194 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6007781.42285 | 2102140.57786 | 37.7525172919755 | -122.41596989079201 | (37.7525172919755, -122.415969890792) | |||
| 98043 | 98043 | 637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3205 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007653.0 | 2102067.0 | 37.7523080428222 | -122.41640878881701 | (37.7523080428222, -122.416408788817) | ||
| 17622 | 17622 | 638 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007578.42744 | 2102058.8333799997 | 37.752281425265295 | -122.41666609486401 | (37.7522814252653, -122.416666094864) | ||
| 21501 | 21501 | 639 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007596.74853 | 2102059.47083 | 37.7522842059666 | -122.416602782609 | (37.7522842059666, -122.416602782609) | ||
| 17807 | 17807 | 640 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3214 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.41668183031601 | (37.7523944952223, -122.416681830316) | |||
| 20895 | 20895 | 641 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | |||
| 20129 | 20129 | 642 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | |||
| 17817 | 17817 | 643 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3224 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6007548.56119 | 2102101.97423 | 37.752398200442 | -122.41677243341199 | (37.752398200442, -122.416772433412) | |||
| 17517 | 17517 | 653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.752208423697205 | -122.41776437753201 | (37.7522084236972, -122.417764377532) | |||
| 20968 | 20968 | 655 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.41755949396901 | (37.7522209377659, -122.417559493969) | ||
| 19861 | 19861 | 656 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.41750321711099 | (37.7522209377618, -122.417503217111) | |||
| 81377 | 81377 | 683 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | |
| 89350 | 89350 | 684 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2340X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 6 | 4X4 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | ||
| 86609 | 86609 | 685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2340X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3 | 4X4 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | ||
| 91483 | 91483 | 686 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1289X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6010615.826236401 | 2101854.9677848998 | 37.751892018433104 | -122.40614787408998 | (37.7518920184331, -122.40614787409) | ||
| 17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 92348 | 92348 | 690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 83618 | 83618 | 693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 91816 | 91816 | 694 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 84299 | 84299 | 699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2551X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5987474.44326 | 2114604.18984 | 37.785576288970795 | -122.487109266635 | (37.7855762889708, -122.487109266635) | |||
| 126299 | 126299 | 704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 85390 | 85390 | 705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 141614 | 141614 | 710 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5 | 5986716.67704 | 2113957.13547 | 37.783755449840996 | -122.489683280356 | (37.783755449841, -122.489683280356) | |||
| 94870 | 94870 | 711 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 140386 | 140386 | 712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 128019 | 128019 | 714 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x33 | 5986452.35935 | 2113947.57202 | 37.7837137557398 | -122.490597003715 | (37.7837137557398, -122.490597003715) | |||
| 128102 | 128102 | 715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986402.41509 | 2113942.22606 | 37.7836961598318 | -122.490769396103 | (37.7836961598318, -122.490769396103) | |||
| 129062 | 129062 | 718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986263.20776 | 2113937.4435799997 | 37.783674895540706 | -122.491250641927 | (37.7836748955407, -122.491250641927) | |||
| 119423 | 119423 | 721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6859X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986379.68484 | 2113889.27863 | 37.783549453567 | -122.49084413577101 | (37.783549453567, -122.490844135771) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) |
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");