Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19901 | 19901 | 21524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.5628900002 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) | |||
| 179388 | 179388 | 54050 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2234 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 7 | Permit Number 9772 | 6000883.53161 | 2116117.87685 | 37.7905052265944 | -122.44082646707899 | (37.7905052265944, -122.440826467079) | ||
| 147045 | 147045 | 54023 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 894 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 8 | Permit Number 9742 | 5985137.880030001 | 2109802.85979 | 37.7722566986547 | -122.494838846537 | (37.7722566986547, -122.494838846537) | ||
| 3298 | 3298 | 28315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.9906200003 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | |
| 2953 | 2953 | 192045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.39786558493401 | (37.7746734191738, -122.397865584934) | |
| 2963 | 2963 | 192048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.5616599997 | 37.7748746334969 | -122.39761573260401 | (37.7748746334969, -122.397615732604) | |
| 2964 | 2964 | 192047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.399669999 | 2110155.0455099996 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | |
| 2979 | 2979 | 192049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.505969999 | 2110186.9808900002 | 37.77491796101779 | -122.397555323332 | (37.7749179610178, -122.397555323332) | |
| 2980 | 2980 | 192046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.774723291973096 | -122.39779074965 | (37.7747232919731, -122.39779074965) | |
| 3009 | 3009 | 192050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.39749938908501 | (37.774962173497, -122.397499389085) | |
| 13259 | 13259 | 28538 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4742 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3x3 | Permit Number 779458 | 6001538.107000001 | 2091234.9493 | 37.7222199809558 | -122.436779692563 | (37.7222199809558, -122.436779692563) | |
| 9905 | 9905 | 136907 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779330 | 6011790.69425 | 2119110.61996 | 37.7993377175325 | -122.40329876353901 | (37.7993377175325, -122.403298763539) | |
| 1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
| 9770 | 9770 | 151746 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.962040001 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | |
| 9781 | 9781 | 36044 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 9795 | 9795 | 108228 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492.0 | 2106262.0 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | |
| 9807 | 9807 | 36045 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 113294 | 113294 | 117601 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3150 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778709 | 5995893.0 | 2111461.0 | 37.7774332071911 | -122.457756175704 | (37.7774332071911, -122.457756175704) | |
| 139601 | 139601 | 117381 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1418 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778552 | 5990573.0 | 2105710.8 | 37.7613376586311 | -122.475739608568 | (37.7613376586311, -122.475739608568) | ||
| 101346 | 101346 | 117308 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2282 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778521 | 5990773.7 | 2099873.0 | 37.7453202288292 | -122.47461940570601 | (37.7453202288292, -122.474619405706) | ||
| 92968 | 92968 | 97291 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778496 | 6005288.0 | 2108881.0 | 37.7708843970709 | -122.425072128908 | (37.7708843970709, -122.425072128908) | ||
| 110925 | 110925 | 63591 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778496 | 6005273.78540872 | 2109033.97398783 | 37.7713036237874 | -122.425132184034 | (37.7713036237874, -122.425132184034) | |
| 121539 | 121539 | 117325 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778496 | 6005278.5 | 2109145.6 | 37.7716103882192 | -122.425123819967 | (37.7716103882192, -122.425123819967) | |||
| 99741 | 99741 | 117328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778493 | 5996452.7 | 2091787.1 | 37.7234457259053 | -122.454398490844 | (37.7234457259053, -122.454398490844) | ||
| 99740 | 99740 | 99952 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778491 | 5993609.0 | 2105311.0 | 37.760415458577 | -122.46521040350099 | (37.760415458577, -122.465210403501) | |
| 106778 | 106778 | 117329 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778491 | 5993547.2 | 2105329.5 | 37.760462690756704 | -122.465425483289 | (37.7604626907567, -122.465425483289) | |||
| 78816 | 78816 | 117348 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778484 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||
| 108083 | 108083 | 117346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778484 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||
| 15275 | 15275 | 44767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 36 Waterville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778447 | 6011447.04848 | 2095908.42405 | 37.735610545881 | -122.40285518911301 | (37.735610545881, -122.402855189113) | |
| 11958 | 11958 | 47795 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2534 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778248 | 5985848.7969 | 2097974.9667 | 37.739822144816706 | -122.49150898506001 | (37.7398221448167, -122.49150898506) | |
| 63416 | 63416 | 116997 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 21 ROSEMONT PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778206 | 6005158.0 | 2108058.0 | 37.7686172926755 | -122.42546322320601 | (37.7686172926755, -122.425463223206) | |
| 78883 | 78883 | 98406 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778181 | 5994692.2 | 2088928.8 | 37.7154963945459 | -122.46027718208401 | (37.7154963945459, -122.460277182084) | |
| 81046 | 81046 | 113699 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Minerva St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778180 | 5994635.15348587 | 2088996.04011087 | 37.715677738331706 | -122.460479228374 | (37.7156777383317, -122.460479228374) | |
| 144191 | 144191 | 62654 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 60 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | Permit Number 777885 | 6002631.99691219 | 2108731.43318147 | 37.7703233304254 | -122.434248603775 | (37.7703233304254, -122.434248603775) | |
| 94812 | 94812 | 115422 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 594 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.46814378296101 | (37.7772088768112, -122.468143782961) | ||
| 103483 | 103483 | 115423 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 594 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.46814378296101 | (37.7772088768112, -122.468143782961) | ||
| 106482 | 106482 | 115421 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 594 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.46814378296101 | (37.7772088768112, -122.468143782961) | ||
| 110066 | 110066 | 115425 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 594 10th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.46814378296101 | (37.7772088768112, -122.468143782961) | ||
| 121563 | 121563 | 115424 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 594 10th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777488 | 5992889.8 | 2111442.3 | 37.7772088768112 | -122.46814378296101 | (37.7772088768112, -122.468143782961) | ||
| 1180 | 1180 | 251470 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.0846799999 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | |
| 117601 | 117601 | 115337 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 316 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777442 | 5994682.1 | 2113308.3 | 37.7824357601584 | -122.462079045453 | (37.7824357601584, -122.462079045453) | ||
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 58072 | 58072 | 78399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 735 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777389 | 5986605.59767 | 2110891.31043 | 37.775331081992896 | -122.48984201538299 | (37.7753310819929, -122.489842015383) | |
| 92479 | 92479 | 110604 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1193 GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 4x4 | Permit Number 777025 | 6007369.0 | 2118756.0 | 37.798116076291706 | -122.41857424763599 | (37.7981160762917, -122.418574247636) | ||
| 10943 | 10943 | 117432 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776914 | 6001483.3943300005 | 2089635.3140599998 | 37.717824632186705 | -122.436854363943 | (37.7178246321867, -122.436854363943) | ||
| 91231 | 91231 | 40719 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 31 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/2015 12:00:00 AM | Permit Number 776611 | 6009388.12133896 | 2097277.80711732 | 37.7392553953988 | -122.410070362656 | (37.7392553953988, -122.410070362656) | ||
| 91141 | 91141 | 67994 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 241 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776577 | 5994615.10957021 | 2088996.30431809 | 37.7156773106674 | -122.460548527933 | (37.7156773106674, -122.460548527933) | |
| 106893 | 106893 | 115338 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 723 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776569 | 5994694.4 | 2110613.5 | 37.7750372676085 | -122.461841029764 | (37.7750372676085, -122.461841029764) | ||
| 14706 | 14706 | 117455 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011503.45491 | 2111758.7875900003 | 37.7791352841027 | -122.403775126323 | (37.7791352841027, -122.403775126323) | ||
| 16171 | 16171 | 117453 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011539.59396 | 2111788.0027 | 37.779217520823 | -122.403652162024 | (37.779217520823, -122.403652162024) | ||
| 103900 | 103900 | 117456 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 SHIPLEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011519.0 | 2111785.0 | 37.779208125695604 | -122.403723194086 | (37.7792081256956, -122.403723194086) | ||
| 80228 | 80228 | 115783 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 112X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776402 | 6006834.59164 | 2098690.08898 | 37.74298975220871 | -122.418999487845 | (37.7429897522087, -122.418999487845) | ||
| 143012 | 143012 | 115785 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 112X Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776402 | 6006834.59164 | 2098690.08898 | 37.74298975220871 | -122.418999487845 | (37.7429897522087, -122.418999487845) | ||
| 9771 | 9771 | 159357 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 49 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998577.1355099995 | 2087591.01668 | 37.7120458522191 | -122.446752958004 | (37.7120458522191, -122.446752958004) | |
| 109341 | 109341 | 115403 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 247 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776194 | 6005961.0 | 2096147.1 | 37.7359580430627 | -122.421839537609 | (37.7359580430627, -122.421839537609) | ||
| 44819 | 44819 | 31282 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2566 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2015 12:00:00 AM | 2 | Permit Number 776171 | 5991125.05468 | 2097948.10611 | 37.7400553174119 | -122.47326412925 | (37.7400553174119, -122.47326412925) | |
| 107164 | 107164 | 33465 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 56 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2015 12:00:00 AM | 4x4 | Permit Number 776101 | 6006840.69799791 | 2099396.99355199 | 37.7449310972842 | -122.419028502572 | (37.7449310972842, -122.419028502572) | ||
| 106399 | 106399 | 114794 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2606 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 775835 | 5991470.8 | 2097652.1 | 37.7392625738182 | -122.472047125527 | (37.7392625738182, -122.472047125527) | |||
| 18148 | 18148 | 87029 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775743 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | |
| 14086 | 14086 | 110437 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 224 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007787.18057 | 2109026.8304 | 37.771425672294995 | -122.416437709336 | (37.771425672295, -122.416437709336) | |
| 57211 | 57211 | 112819 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650-680 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | 3x3 | Permit Number 775337 | 6004062.27660598 | 2111036.71049328 | 37.7767341339168 | -122.429465693193 | (37.7767341339168, -122.429465693193) | |
| 175170 | 175170 | 103690 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434004 | -122.440180480455 | (37.804514981434, -122.440180480455) | ||
| 119527 | 119527 | 105833 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 385 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775232 | 5989019.18729 | 2112712.58155 | 37.780472416605704 | -122.481626370529 | (37.7804724166057, -122.481626370529) | |
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 12441 | 12441 | 109572 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003097.99881 | 2091486.06514 | 37.72299801913329 | -122.431405440927 | (37.7229980191333, -122.431405440927) |
| 12665 | 12665 | 109570 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003082.6952599995 | 2091494.46608 | 37.7230202188994 | -122.431458941588 | (37.7230202188994, -122.431458941588) |
| 12843 | 12843 | 109569 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003067.9512 | 2091505.3817099999 | 37.7230493551309 | -122.431510687674 | (37.7230493551309, -122.431510687674) |
| 133374 | 133374 | 65427 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 738 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1989 12:00:00 AM | 1 | Permit Number 774746 | 6010331.84975 | 2116201.1382400002 | 37.7912674029188 | -122.408141592969 | (37.7912674029188, -122.408141592969) | |
| 100237 | 100237 | 34549 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3657 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3 | 2x3 | Permit Number 774523 | 6008501.64960417 | 2097857.05143202 | 37.740796147430295 | -122.413176344592 | (37.7407961474303, -122.413176344592) | |
| 11727 | 11727 | 105903 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 22 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011210.988390001 | 2087529.97721 | 37.71259187470061 | -122.40308219600901 | (37.7125918747006, -122.403082196009) | |
| 118502 | 118502 | 108322 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 22 ARLETA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011232.7 | 2087548.1 | 37.7126428486885 | -122.403008427372 | (37.7126428486885, -122.403008427372) | |
| 3868 | 3868 | 253576 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
| 80444 | 80444 | 112854 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 JUDAH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
| 139016 | 139016 | 115674 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1433 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | ||
| 117451 | 117451 | 41978 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 895 DARIEN WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774097 | 5994361.7 | 2093982.2 | 37.72935279772889 | -122.461785730278 | (37.7293527977289, -122.461785730278) |
| 84729 | 84729 | 88709 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2020 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774056 | 6004475.4 | 2108255.2 | 37.769120165328005 | -122.427838335035 | (37.769120165328, -122.427838335035) | |
| 80649 | 80649 | 107923 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |
| 91281 | 91281 | 107927 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |
| 110152 | 110152 | 107925 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |
| 121537 | 121537 | 107922 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |
| 126576 | 126576 | 107929 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | ||
| 138912 | 138912 | 107926 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |
| 5549 | 5549 | 117113 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | |
| 5738 | 5738 | 117115 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005638.31982 | 2117909.64088 | 37.7956946025865 | -122.42450268015 | (37.7956946025865, -122.42450268015) | |
| 5891 | 5891 | 117112 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005683.22125 | 2117915.42136 | 37.7957130098979 | -122.424347724294 | (37.7957130098979, -122.424347724294) | |
| 7304 | 7304 | 117114 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005648.88243 | 2117910.88116 | 37.7956986045686 | -122.42446621984399 | (37.7956986045686, -122.424466219844) | |
| 7190 | 7190 | 59699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3188 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773904 | 5999466.917230001 | 2116043.86882 | 37.7902212404654 | -122.44572252287901 | (37.7902212404654, -122.445722522879) | |
| 123031 | 123031 | 107610 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 130 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773863 | 5993062.861740001 | 2099209.06962 | 37.7436296195879 | -122.466655678001 | (37.7436296195879, -122.466655678001) | ||
| 79012 | 79012 | 108796 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501-599 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |
| 85560 | 85560 | 108794 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501-599 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |
| 103962 | 103962 | 108809 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301-399 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |
| 12346 | 12346 | 46852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 773811 | 6003293.98042 | 2090989.1519900002 | 37.7216447112248 | -122.43069253035101 | (37.7216447112248, -122.430692530351) | |
| 91856 | 91856 | 108500 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 133 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773778 | 5993020.3424 | 2114605.60013 | 37.7859019761698 | -122.467922339348 | (37.7859019761698, -122.467922339348) | |
| 127560 | 127560 | 108446 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 672 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.5397799998 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | |||
| 13235 | 13235 | 57548 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 150-152 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773714 | 6000424.90401 | 2091350.8079400002 | 37.722474772884 | -122.440636064423 | (37.722474772884, -122.440636064423) | ||
| 78033 | 78033 | 108551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61-79X Santa Ysabel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.727450422234796 | -122.439236196788 | (37.7274504222348, -122.439236196788) |
| 83970 | 83970 | 108550 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61-79X Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.727450422234796 | -122.439236196788 | (37.7274504222348, -122.439236196788) |
| 95093 | 95093 | 108552 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61-79X Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.727450422234796 | -122.439236196788 | (37.7274504222348, -122.439236196788) |
| 121847 | 121847 | 108549 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61-79X Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.727450422234796 | -122.439236196788 | (37.7274504222348, -122.439236196788) |
| 11913 | 11913 | 108546 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.8770599999 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) |
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");