Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92960 | 92960 | 105730 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1245 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 771762 | 5992955.9 | 2106987.0 | 37.7649796301557 | -122.467591041048 | (37.7649796301557, -122.467591041048) | ||
| 93052 | 93052 | 107928 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 93616 | 93616 | 25960 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6011400.367219999 | 2098224.16578 | 37.741966473568795 | -122.40317942951 | (37.7419664735688, -122.40317942951) | ||
| 94657 | 94657 | 25957 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.7686799997 | 37.741952058974796 | -122.40315399409201 | (37.7419520589748, -122.403153994092) | ||
| 95036 | 95036 | 102808 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 33567 | 5985657.5923 | 2112619.63972 | 37.7800211808507 | -122.49324869465 | (37.7800211808507, -122.49324869465) | ||
| 95894 | 95894 | 107924 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) | |||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 97056 | 97056 | 89006 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2200 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51758 | 6003287.9 | 2116231.2 | 37.7909530209385 | -122.432515604779 | (37.7909530209385, -122.432515604779) | |||
| 98265 | 98265 | 95649 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 99570 | 99570 | 56660 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x5 | 6001647.0 | 2102006.0 | 37.7518009738438 | -122.437174092108 | (37.7518009738438, -122.437174092108) | |||
| 100025 | 100025 | 121675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||||
| 100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 101700 | 101700 | 86749 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 102210 | 102210 | 100310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3899 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996194.7 | 2115482.8 | 37.7884933268854 | -122.457003479054 | (37.7884933268854, -122.457003479054) | |||||
| 102722 | 102722 | 95195 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | Permit Number 767109 | 5986864.6 | 2114238.7 | 37.7845371806063 | -122.489192237355 | (37.7845371806063, -122.489192237355) | |||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 103706 | 103706 | 34223 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4353 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | Permit Number 38036 | 6001597.05586573 | 2101140.27274833 | 37.7494210542971 | -122.43728482259199 | (37.7494210542971, -122.437284822592) | |||
| 104139 | 104139 | 87677 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 Upland Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992947.0 | 2094378.0 | 37.7303580257382 | -122.46670519643499 | (37.7303580257382, -122.466705196435) | ||
| 104451 | 104451 | 44044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2000 12:00:00 AM | 3x3 | Permit Number 52166 | 6007300.39530105 | 2099500.4637239 | 37.7452410789231 | -122.417446281159 | (37.7452410789231, -122.417446281159) | ||
| 104528 | 104528 | 39968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41229 | 5994642.74946915 | 2095844.31987513 | 37.7344818986137 | -122.460949031683 | (37.7344818986137, -122.460949031683) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 106817 | 106817 | 55765 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1932 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | Permit Number 11801 | 5989775.56943078 | 2106540.70455177 | 37.7635700889575 | -122.478558247096 | (37.7635700889575, -122.478558247096) | |||
| 107126 | 107126 | 85498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 108027 | 108027 | 54458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | Permit Number 10249 | 6001672.30868862 | 2101726.83398167 | 37.751035889282 | -122.437066586385 | (37.751035889282, -122.437066586385) | |||
| 108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 108792 | 108792 | 52088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 533 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48285 | 6003018.90245389 | 2105154.15611633 | 37.7605229492534 | -122.432654727925 | (37.7605229492534, -122.432654727925) | ||||
| 109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
| 109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 109592 | 109592 | 2713 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2168 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 769716 | 6003121.54577 | 2114856.3596900003 | 37.7871686246892 | -122.43299291599199 | (37.7871686246892, -122.432992915992) | ||
| 110440 | 110440 | 111631 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 200 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | |||
| 110464 | 110464 | 51814 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 266 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48060 | 5994901.32061156 | 2096492.00794019 | 37.736275166275796 | -122.460101979176 | (37.7362751662758, -122.460101979176) | |||
| 110601 | 110601 | 61062 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1983 12:00:00 AM | 15 | 3x3 | Permit Number 20894 | 6003791.73087977 | 2114891.68292751 | 37.7873036043324 | -122.430676743416 | (37.7873036043324, -122.430676743416) | |
| 110927 | 110927 | 52190 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 71 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48381 | 5999969.39262726 | 2104422.33072392 | 37.758340122613795 | -122.44314899255 | (37.7583401226138, -122.44314899255) | ||||
| 113010 | 113010 | 102041 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1839 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 769553 | 5993714.1 | 2102972.1 | 37.753999504217894 | -122.464677070579 | (37.7539995042179, -122.464677070579) | |||
| 113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 113184 | 113184 | 40561 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 25 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1999 12:00:00 AM | Permit Number 41605 | 6002662.09875993 | 2105750.86481793 | 37.7621411257649 | -122.43393140036699 | (37.7621411257649, -122.433931400367) | |||
| 113608 | 113608 | 51648 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47932 | 5999618.72813404 | 2107626.34389142 | 37.7671175447299 | -122.444592021369 | (37.7671175447299, -122.444592021369) | |||
| 113873 | 113873 | 61358 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1029 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1984 12:00:00 AM | Permit Number 21266 | 6001344.49519126 | 2100781.43952904 | 37.7484214231354 | -122.438132480542 | (37.7484214231354, -122.438132480542) | |||
| 114027 | 114027 | 52737 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 114587 | 114587 | 100397 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 204 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2014 12:00:00 AM | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.46527922129101 | (37.7585961040831, -122.465279221291) | |
| 115297 | 115297 | 86750 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 115892 | 115892 | 95277 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 554 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 12:00:00 AM | 3 | 5x7 | Permit Number 777230 | 5994096.260869999 | 2111723.67308 | 37.778051054367204 | -122.463990712248 | (37.7780510543672, -122.463990712248) | |
| 116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
| 116320 | 116320 | 49878 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 511@ PAGE Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46644 | 5998896.54514998 | 2108984.87658964 | 37.77080649578671 | -122.44718771644301 | (37.7708064957867, -122.447187716443) | |||
| 118632 | 118632 | 101969 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3933 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769449 | 5995942.1 | 2115156.1 | 37.7875817876952 | -122.457853779738 | (37.7875817876952, -122.457853779738) | |||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 119890 | 119890 | 43991 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | |||
| 120345 | 120345 | 95655 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 120647 | 120647 | 87298 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 32 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50311 | 5999892.3 | 2095538.5 | 37.7339428609205 | -122.44277770379699 | (37.7339428609205, -122.442777703797) | |||
| 120984 | 120984 | 108301 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2898 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773671 | 6000896.59861 | 2115909.1323 | 37.7899328124933 | -122.440766276199 | (37.7899328124933, -122.440766276199) | ||||
| 121978 | 121978 | 55766 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 294 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2003 12:00:00 AM | Permit Number 46713 | 6002057.64133429 | 2104155.81527833 | 37.757727185230706 | -122.435907849922 | (37.7577271852307, -122.435907849922) | |||
| 122045 | 122045 | 94044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1354 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53453 | 6012181.6 | 2102103.5 | 37.752661889425 | -122.40075063354601 | (37.752661889425, -122.400750633546) | |||
| 122135 | 122135 | 91117 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 496 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2009 12:00:00 AM | Permit Number 52007 | 6003146.0 | 2102729.0 | 37.753871256411 | -122.432041973434 | (37.753871256411, -122.432041973434) | |||
| 123095 | 123095 | 63455 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 746 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28489 | 6007346.89818679 | 2095405.54054849 | 37.7339999430548 | -122.41699539620001 | (37.7339999430548, -122.4169953962) | ||
| 124154 | 124154 | 94043 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1354 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2010 12:00:00 AM | 3x3 | Permit Number 53453 | 6012181.6 | 2102103.5 | 37.752661889425 | -122.40075063354601 | (37.752661889425, -122.400750633546) | ||
| 124556 | 124556 | 53759 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 492x Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | Permit Number 9439 845-849 Diamond St | 6001965.94583867 | 2101505.01209507 | 37.750443505469605 | -122.43603528995001 | (37.7504435054696, -122.43603528995) | |||
| 125247 | 125247 | 41048 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 41828 | 5993076.0 | 2107259.0 | 37.7657334037891 | -122.46719542706002 | (37.7657334037891, -122.46719542706) | |
| 126881 | 126881 | 40087 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 708 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41310 | 6002385.65008555 | 2104050.52983918 | 37.7574567244894 | -122.434765933114 | (37.7574567244894, -122.434765933114) | |||
| 126932 | 126932 | 102807 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 770137 | 5985657.75406 | 2112608.5336700003 | 37.7799906962888 | -122.49324731662901 | (37.7799906962888, -122.493247316629) | ||
| 127271 | 127271 | 56508 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 583 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000090.55107769 | 2095627.82411946 | 37.73419942412529 | -122.442098700898 | (37.7341994241253, -122.442098700898) | ||||
| 127812 | 127812 | 40861 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41784 | 5994083.13181366 | 2093531.57356405 | 37.728099447432896 | -122.462716082104 | (37.7280994474329, -122.462716082104) | |||
| 127843 | 127843 | 97325 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1123 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 15 | 3x3 | 5989733.4 | 2098972.0 | 37.7427859847726 | -122.478150688587 | (37.7427859847726, -122.478150688587) | ||
| 128209 | 128209 | 79368 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 54 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51121 | 6000325.93637272 | 2101364.83619438 | 37.7499653094156 | -122.441696487801 | (37.7499653094156, -122.441696487801) | ||
| 128916 | 128916 | 33827 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 405 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37843 | 5999402.87583246 | 2094395.39820181 | 37.730776257944 | -122.44438766473101 | (37.730776257944, -122.444387664731) | |||
| 129072 | 129072 | 34519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 129286 | 129286 | 53959 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9674 | 6004995.7689664 | 2119500.86037361 | 37.800027377944495 | -122.42683940106701 | (37.8000273779445, -122.426839401067) | |||
| 129331 | 129331 | 52144 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48326 | 5983357.46927228 | 2096816.23912163 | 37.7364946892524 | -122.500037175829 | (37.7364946892524, -122.500037175829) | ||||
| 129899 | 129899 | 97406 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1642 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2011 12:00:00 AM | 0 | 3x3 | Permit Number 768387 | 5981634.3 | 2103894.4 | 37.755828061107394 | -122.506519568736 | (37.7558280611074, -122.506519568736) | |
| 133273 | 133273 | 53674 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1970 12:00:00 AM | 27 | 3x3 | Permit Number 6615 | 6000847.30796 | 2116375.23213 | 37.7912097941415 | -122.44097026868401 | (37.7912097941415, -122.440970268684) | |
| 136240 | 136240 | 53866 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1746 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 13 | Permit Number 9576 | 5983496.0301 | 2103256.2411 | 37.754185295753295 | -122.50003403412201 | (37.7541852957533, -122.500034034122) | ||
| 139715 | 139715 | 32413 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | ||
| 139768 | 139768 | 111630 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 200 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | |||
| 140078 | 140078 | 56595 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 535 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 6003215.47967599 | 2096091.02007461 | 37.735648845754795 | -122.431327890197 | (37.7356488457548, -122.431327890197) | ||||
| 140399 | 140399 | 44756 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | ||
| 141356 | 141356 | 86901 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 370 Santa Ana Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49847 | 5992482.1 | 2094336.7 | 37.73021778542579 | -122.468309402689 | (37.7302177854258, -122.468309402689) | |||
| 142181 | 142181 | 52735 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 142341 | 142341 | 32011 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
| 142677 | 142677 | 95654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 143052 | 143052 | 101841 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 660 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769516 | 6011209.4 | 2105267.4 | 37.7612949842186 | -122.404335364411 | (37.7612949842186, -122.404335364411) | |||
| 143090 | 143090 | 32410 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
| 143696 | 143696 | 57758 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/1977 12:00:00 AM | Permit Number 778232 | 5996349.7575948 | 2095933.20555752 | 37.73482403404479 | -122.45505379547 | (37.7348240340448, -122.45505379547) | |||
| 143850 | 143850 | 50968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 3x3 | Permit Number 778895 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | ||
| 144569 | 144569 | 95652 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 144574 | 144574 | 33894 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4152 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37868 | 6002903.75621342 | 2100679.60251963 | 37.74823035826571 | -122.43273331953199 | (37.7482303582657, -122.432733319532) | |||
| 147512 | 147512 | 55950 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3119 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1973 12:00:00 AM | 13 | Permit Number 12017 | 5983275.8316 | 2096739.2371 | 37.73627847101589 | -122.50031373613999 | (37.7362784710159, -122.50031373614) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 148976 | 148976 | 47819 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2 Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | 11 | Permit Number 45583 | 6001696.6687 | 2111985.4923 | 37.7792050300035 | -122.43771698483499 | (37.7792050300035, -122.437716984835) | ||
| 151152 | 151152 | 102632 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 611 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Permit Number 770009 | 6011832.65646 | 2105500.64155 | 37.7619702218631 | -122.402196169527 | (37.7619702218631, -122.402196169527) | |||
| 151251 | 151251 | 58055 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1951 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 6 | Permit Number 17024 | 6002508.23206 | 2119853.3281 | 37.8008542011299 | -122.435472445005 | (37.8008542011299, -122.435472445005) | ||
| 153246 | 153246 | 69457 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 19 | 3x3 | Permit Number 33567 | 5985660.203509999 | 2112573.9841400003 | 37.7798959764685 | -122.493236296991 | (37.7798959764685, -122.493236296991) |
| 153440 | 153440 | 83675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4229 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50208 | 5981109.0607 | 2103468.6155 | 37.7546280386671 | -122.508304380172 | (37.7546280386671, -122.508304380172) | |
| 157049 | 157049 | 65781 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3540 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 19 | Permit Number 28747 | 5997819.18709 | 2115811.30002 | 37.7894884539845 | -122.451406736458 | (37.7894884539845, -122.451406736458) | ||
| 157863 | 157863 | 50783 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.51000993912201 | (37.7738083996933, -122.510009939122) | ||
| 158794 | 158794 | 97321 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 9 | 3x3 | 5989897.1093 | 2098999.7408 | 37.7428716552125 | -122.477586661544 | (37.7428716552125, -122.477586661544) | ||
| 158901 | 158901 | 51084 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1358 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 5 | Permit Number 47542 | 5981543.7588 | 2105841.1993 | 37.7611680849155 | -122.50697708881701 | (37.7611680849155, -122.506977088817) | ||
| 159091 | 159091 | 52591 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | 24 | Permit Number 48684 | 6005626.503190001 | 2117904.3459900003 | 37.7956793968408 | -122.424543191035 | (37.7956793968408, -122.424543191035) | ||
| 160379 | 160379 | 35170 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 414 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 17 | Permit Number 38703 | 5984711.39216 | 2113056.75346 | 37.7811659806757 | -122.496554242469 | (37.7811659806757, -122.496554242469) |
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");