Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 3186 | 3186 | 218743 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.5324099995 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | |
| 20373 | 20373 | 101208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 24059 | 24059 | 180255 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003484.65095 | 2094730.37892 | 37.73192808471529 | -122.4303002173 | (37.7319280847153, -122.4303002173) | |||
| 24516 | 24516 | 180327 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000920.894780001 | 2092230.1433299999 | 37.7249174601452 | -122.43898452870899 | (37.7249174601452, -122.438984528709) | ||||
| 24590 | 24590 | 180142 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6004028.1507 | 2089329.0394599999 | 37.7171279723626 | -122.42803645642599 | (37.7171279723626, -122.428036456426) | |||
| 25789 | 25789 | 180259 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003405.48601 | 2094728.1839700001 | 37.7319175734374 | -122.430573750589 | (37.7319175734374, -122.430573750589) | |||
| 27243 | 27243 | 136775 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999017.84714 | 2119772.0428299997 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | ||||
| 28793 | 28793 | 198050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6015069.990669999 | 2101754.6780000003 | 37.7518647765405 | -122.39073761146001 | (37.7518647765405, -122.39073761146) | |||
| 29085 | 29085 | 136812 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001667.708740001 | 2117080.5129400003 | 37.7931930043084 | -122.438182257008 | (37.7931930043084, -122.438182257008) | |||
| 29558 | 29558 | 242300 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6003110.46195 | 2097242.14325 | 37.738803614002 | -122.431773140441 | (37.738803614002, -122.431773140441) | ||||
| 31416 | 31416 | 198059 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6016002.244 | 2105125.97833 | 37.7611733325983 | -122.387748922377 | (37.7611733325983, -122.387748922377) | |||
| 32316 | 32316 | 180260 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003350.60066 | 2094725.0139900001 | 37.731905759936204 | -122.43076327462299 | (37.7319057599362, -122.430763274623) | |||
| 32718 | 32718 | 218432 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 451 Hearst Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5998417.784630001 | 2094357.34884 | 37.730615528667 | -122.447790528326 | (37.730615528667, -122.447790528326) | |||
| 33100 | 33100 | 198058 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6016003.50284 | 2105138.76714 | 37.7612085176665 | -122.387745460881 | (37.7612085176665, -122.387745460881) | |||
| 35870 | 35870 | 218489 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 471 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5994001.40662 | 2089639.1625299999 | 37.717407120114395 | -122.462716356901 | (37.7174071201144, -122.462716356901) | |||
| 37137 | 37137 | 180253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003528.91801 | 2094729.13365 | 37.7319271727957 | -122.430147087941 | (37.7319271727957, -122.430147087941) | |||
| 40388 | 40388 | 180264 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 Still St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003250.762019999 | 2094715.77972 | 37.731874747719296 | -122.43110777880699 | (37.7318747477193, -122.431107778807) | |||
| 43512 | 43512 | 136809 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001664.412769999 | 2117108.48379 | 37.7932696175395 | -122.438195665917 | (37.7932696175395, -122.438195665917) | |||
| 43636 | 43636 | 198046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015063.38208 | 2101850.3789 | 37.7521271843206 | -122.39076715240299 | (37.7521271843206, -122.390767152403) | |||
| 43778 | 43778 | 124094 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Funston Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5991885.08534 | 2111292.1960400003 | 37.7767386560308 | -122.47160843754999 | (37.7767386560308, -122.47160843755) | ||||
| 46379 | 46379 | 214895 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Lomita Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5991278.31882 | 2104203.15861 | 37.7572389407347 | -122.473190275108 | (37.7572389407347, -122.473190275108) | |||
| 47100 | 47100 | 218749 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 45 Burlwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5996533.168769999 | 2095960.73872 | 37.7349101538644 | -122.454421671348 | (37.7349101538644, -122.454421671348) | |||
| 47302 | 47302 | 185177 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985174.5283 | 2097805.5293 | 37.7393174888485 | -122.49382780495 | (37.7393174888485, -122.49382780495) | |||
| 47666 | 47666 | 136810 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001666.14129 | 2117099.3903799998 | 37.793244747706396 | -122.438189033412 | (37.7932447477064, -122.438189033412) | |||
| 49735 | 49735 | 198045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 6015062.9459 | 2101861.12211 | 37.752156658702795 | -122.39076941150299 | (37.7521566587028, -122.390769411503) | |||
| 52006 | 52006 | 180261 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Rotteck St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003329.74924 | 2094722.2171 | 37.7318968989209 | -122.43083516281601 | (37.7318968989209, -122.430835162816) | |||
| 52806 | 52806 | 180320 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 817 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6001210.40568 | 2092189.73212 | 37.7248229683925 | -122.43798083136801 | (37.7248229683925, -122.437980831368) | |||
| 53371 | 53371 | 241532 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6002143.4753 | 2103472.9567400003 | 37.7558570955525 | -122.435562150599 | (37.7558570955525, -122.435562150599) | |||
| 53510 | 53510 | 136776 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Richardson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999020.04225 | 2119778.41485 | 37.8004497840758 | -122.447537603903 | (37.8004497840758, -122.447537603903) | ||||
| 54624 | 54624 | 101207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 55564 | 55564 | 179993 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1297 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6007905.78975 | 2087167.1090000002 | 37.7114103831536 | -122.414480370891 | (37.7114103831536, -122.414480370891) | |||
| 55861 | 55861 | 198051 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015071.52893 | 2101713.75148 | 37.75175248631 | -122.390729432117 | (37.75175248631, -122.390729432117) | |||
| 56508 | 56508 | 198049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015069.63855 | 2101758.53914 | 37.751875358878706 | -122.39073909895201 | (37.7518753588787, -122.390739098952) | |||
| 57471 | 57471 | 241423 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 630 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001786.541680001 | 2099450.84639 | 37.74479305925821 | -122.436508672655 | (37.7447930592582, -122.436508672655) | |||
| 59741 | 59741 | 180263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 Still St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003281.3255900005 | 2094718.1068900002 | 37.7318828694844 | -122.431002280233 | (37.7318828694844, -122.431002280233) | |||
| 60681 | 60681 | 198052 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015072.05685 | 2101707.95994 | 37.7517366132545 | -122.390727201795 | (37.7517366132545, -122.390727201795) | |||
| 68749 | 68749 | 185181 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985173.8643 | 2097833.419 | 37.739394027632606 | -122.493832155461 | (37.7393940276326, -122.493832155461) | |||
| 70887 | 70887 | 180243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 289 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6002278.84858 | 2094070.1176200002 | 37.73004678393279 | -122.43442173648998 | (37.7300467839328, -122.43442173649) | |||
| 71734 | 71734 | 136813 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001669.86096 | 2117066.81611 | 37.7931555187762 | -122.438173828567 | (37.7931555187762, -122.438173828567) | |||
| 72093 | 72093 | 198060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.761132205694295 | -122.387742798886 | (37.7611322056943, -122.387742798886) | |||
| 73109 | 73109 | 214896 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Lomita Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5991273.67519 | 2104194.37709 | 37.757214560125796 | -122.47320569400298 | (37.7572145601258, -122.473205694003) | |||
| 73356 | 73356 | 136814 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001670.664369999 | 2117042.7739 | 37.793089550806705 | -122.438169325648 | (37.7930895508067, -122.438169325648) | |||
| 74370 | 74370 | 180257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003441.65592 | 2094728.25721 | 37.7319198235266 | -122.430448708839 | (37.7319198235266, -122.430448708839) | |||
| 75492 | 75492 | 136808 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001661.89951 | 2117116.97181 | 37.793292780497204 | -122.43820497028601 | (37.7932927804972, -122.438204970286) | |||
| 76099 | 76099 | 180244 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 289 Cayuga Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6002287.23694 | 2094077.32836 | 37.7300670591354 | -122.434393252264 | (37.7300670591354, -122.434393252264) | |||
| 80050 | 80050 | 214994 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 776 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5993711.57582 | 2098146.88521 | 37.7407505437099 | -122.46433549898701 | (37.7407505437099, -122.464335498987) | |||
| 80374 | 80374 | 101209 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 86945 | 86945 | 101210 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 88599 | 88599 | 101205 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 89039 | 89039 | 91154 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 89847 | 89847 | 101525 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 630 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 15 ft wide public RoW | 6001829.0 | 2099440.0 | 37.744765690220106 | -122.436361083968 | (37.7447656902201, -122.436361083968) | |||
| 90242 | 90242 | 91155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 97616 | 97616 | 91159 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 106739 | 106739 | 91156 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 112080 | 112080 | 91153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 113655 | 113655 | 101212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 114794 | 114794 | 101206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 120716 | 120716 | 106300 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 687 28th St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772857 | 6001494.5 | 2099363.3 | 37.7445360779925 | -122.437512227288 | (37.7445360779925, -122.437512227288) | |||||
| 123859 | 123859 | 101211 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 125555 | 125555 | 198253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6018226.96048 | 2093133.1999700002 | 37.728366565251605 | -122.3792214842 | (37.7283665652516, -122.3792214842) | ||||
| 127660 | 127660 | 91157 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | ||
| 132719 | 132719 | 218449 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 360 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5998375.262619999 | 2094122.2697700001 | 37.7299676265075 | -122.44792061435699 | (37.7299676265075, -122.447920614357) | |||
| 133930 | 133930 | 198057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015999.46733 | 2105182.54146 | 37.7613284890375 | -122.38776247247499 | (37.7613284890375, -122.387762472475) | |||
| 136973 | 136973 | 180258 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003421.15336 | 2094728.39885 | 37.7319190510051 | -122.43051960059799 | (37.7319190510051, -122.430519600598) | |||
| 138240 | 138240 | 198068 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6016017.70443 | 2106165.43113 | 37.7640283032988 | -122.387767979012 | (37.7640283032988, -122.387767979012) | ||||
| 143680 | 143680 | 91158 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 245 Fowler Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | |
| 147056 | 147056 | 136811 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001665.7086 | 2117089.02897 | 37.7932162733587 | -122.43818978794701 | (37.7932162733587, -122.438189787947) | |||
| 147174 | 147174 | 242299 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 158 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6002812.353019999 | 2097377.01993 | 37.739157051169 | -122.432813493262 | (37.739157051169, -122.432813493262) | |||
| 148487 | 148487 | 180262 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 76 Rotteck St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003305.93949 | 2094720.0194 | 37.7318895154806 | -122.43091732130199 | (37.7318895154806, -122.430917321302) | |||
| 148959 | 148959 | 242301 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 21 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6003131.09192 | 2097221.8313700003 | 37.7387490116556 | -122.431700361905 | (37.7387490116556, -122.431700361905) | ||||
| 150104 | 150104 | 180141 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6004021.0387699995 | 2089333.04789 | 37.717138576267 | -122.42806132447201 | (37.717138576267, -122.428061324472) | |||
| 151784 | 151784 | 136774 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999022.27584 | 2119774.26108 | 37.800438506586204 | -122.447529575653 | (37.8004385065862, -122.447529575653) | ||||
| 153619 | 153619 | 218567 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 80 Rossmoor Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990805.65582 | 2094520.08565 | 37.7306243456255 | -122.47411840874202 | (37.7306243456255, -122.474118408742) | |||
| 153804 | 153804 | 180256 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003464.1171 | 2094730.21395 | 37.7319264686289 | -122.430371195377 | (37.7319264686289, -122.430371195377) | |||
| 153806 | 153806 | 198047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6015066.24104 | 2101813.8486200003 | 37.75202703851829 | -122.390754712971 | (37.7520270385183, -122.390754712971) | |||
| 154174 | 154174 | 218744 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995904.89403 | 2096229.21076 | 37.7356112608569 | -122.456613232829 | (37.7356112608569, -122.456613232829) | |||
| 155164 | 155164 | 180194 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 162 Tioga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6010134.95637 | 2089163.33615 | 37.7170165958166 | -122.40691636559299 | (37.7170165958166, -122.406916365593) | ||||
| 156215 | 156215 | 202208 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1978 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6012988.24456 | 2093553.53748 | 37.7292304495144 | -122.397361556292 | (37.7292304495144, -122.397361556292) | |||
| 156731 | 156731 | 198053 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6015994.50717 | 2105252.5943299998 | 37.761520564453896 | -122.387784515751 | (37.7615205644539, -122.387784515751) | |||
| 156937 | 156937 | 218566 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 80 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5990820.1078699995 | 2094527.49185 | 37.7306455183576 | -122.474068986495 | (37.7306455183576, -122.474068986495) | |||
| 157246 | 157246 | 198048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6015066.1545400005 | 2101809.56795 | 37.7520152799043 | -122.390754712983 | (37.7520152799043, -122.390754712983) | |||
| 157950 | 157950 | 218754 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 763 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993749.5488 | 2098107.41468 | 37.7406443562632 | -122.46420133903 | (37.7406443562632, -122.46420133903) | |||
| 159393 | 159393 | 198054 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015996.1825 | 2105236.6253 | 37.7614768097219 | -122.387777607167 | (37.7614768097219, -122.387777607167) | |||
| 160948 | 160948 | 185179 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985165.2317 | 2097818.1461 | 37.7393515872788 | -122.49386087752701 | (37.7393515872788, -122.493860877527) | |||
| 161939 | 161939 | 198055 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.74921 | 2105213.0549 | 37.7614121772375 | -122.387770543876 | (37.7614121772375, -122.387770543876) | |||
| 162222 | 162222 | 218442 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 430 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997478.896380001 | 2094887.7172299998 | 37.7320180861463 | -122.45107462221 | (37.7320180861463, -122.45107462221) | ||||
| 164649 | 164649 | 180326 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 467 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6000881.2183 | 2092142.07592 | 37.7246733895406 | -122.439115376482 | (37.7246733895406, -122.439115376482) | ||||
| 166436 | 166436 | 241422 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 687 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6001495.68949 | 2099380.02037 | 37.7445820558098 | -122.437509311417 | (37.7445820558098, -122.437509311417) | |||
| 166808 | 166808 | 218558 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990953.734180001 | 2094508.65771 | 37.7306015442135 | -122.47360565129 | (37.7306015442135, -122.47360565129) | |||
| 174526 | 174526 | 214897 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Lomita Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5991255.59741 | 2104165.1607 | 37.7571332928818 | -122.47326608258301 | (37.7571332928818, -122.473266082583) | |||
| 175846 | 175846 | 242288 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 521 30th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6003236.82693 | 2098315.43327 | 37.7417577834996 | -122.431412827037 | (37.7417577834996, -122.431412827037) | |||
| 178328 | 178328 | 136886 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2655 Polk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006127.922230001 | 2119929.33879 | 37.801267818202895 | -122.422952183303 | (37.8012678182029, -122.422952183303) | |||
| 179681 | 179681 | 180254 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003505.97344 | 2094729.60695 | 37.7319271728025 | -122.43022644590599 | (37.7319271728025, -122.430226445906) | |||
| 180161 | 180161 | 198056 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.12564 | 2105199.4171 | 37.761374696215704 | -122.38777174897699 | (37.7613746962157, -122.387771748977) |
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");