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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164325 | 164325 | 52073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Normandie Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2005 12:00:00 AM | 5 | Permit Number 48268 | 6000955.032430001 | 2117341.04068 | 37.793867787207496 | -122.4406668518 | (37.7938677872075, -122.4406668518) | ||
| 188925 | 188925 | 238649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003254.383880001 | 2096371.53066 | 37.736421268524296 | -122.431213399685 | (37.7364212685243, -122.431213399685) | |||
| 67083 | 67083 | 249597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Starr King Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6005903.20388 | 2113896.36406 | 37.7846901005097 | -122.42330070209199 | (37.7846901005097, -122.423300702092) | |||
| 40372 | 40372 | 195389 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014246.64509 | 2115666.49107 | 37.790017805725796 | -122.39455894686199 | (37.7900178057258, -122.394558946862) | |||
| 54561 | 54561 | 195388 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6014215.1610199995 | 2115700.56054 | 37.7901096022186 | -122.394670266731 | (37.7901096022186, -122.394670266731) | |||
| 132107 | 132107 | 195387 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6014181.23007 | 2115734.6796 | 37.7902013987203 | -122.394790056432 | (37.7902013987203, -122.394790056432) | |||
| 172128 | 172128 | 195386 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014158.70087 | 2115761.95105 | 37.7902750271279 | -122.394869917116 | (37.7902750271279, -122.394869917116) | |||
| 79804 | 79804 | 33888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 90540 | 90540 | 33876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 92338 | 92338 | 33877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 140035 | 140035 | 33879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 142075 | 142075 | 33884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 143203 | 143203 | 33875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 146868 | 146868 | 238684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Clifford Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999616.55259 | 2106525.7445799997 | 37.7640954502549 | -122.44452043687401 | (37.7640954502549, -122.444520436874) | |||
| 147751 | 147751 | 238685 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5999630.02882 | 2106521.8423599997 | 37.7640855046726 | -122.444473546215 | (37.7640855046726, -122.444473546215) | |||
| 47821 | 47821 | 211986 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 De Montfort Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995007.309090001 | 2091908.61395 | 37.7236963750783 | -122.459403705022 | (37.7236963750783, -122.459403705022) | |||
| 154247 | 154247 | 211985 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995023.16483 | 2091909.8583400003 | 37.7237007035157 | -122.45934898488701 | (37.7237007035157, -122.459348984887) | |||
| 96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
| 25897 | 25897 | 134510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6008017.687530001 | 2112101.62184 | 37.7798812789472 | -122.415858138542 | (37.7798812789472, -122.415858138542) | |||
| 26079 | 26079 | 134508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 4ft | 6008055.00417 | 2112104.50717 | 37.7798912991906 | -122.41572924771499 | (37.7798912991906, -122.415729247715) | |||
| 40126 | 40126 | 134511 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 4ft | 6008018.559330001 | 2112114.37672 | 37.7799163498009 | -122.41585602603399 | (37.7799163498009, -122.415856026034) | |||
| 43990 | 43990 | 134521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6007806.05941 | 2112087.1007 | 37.7798295076742 | -122.416589227122 | (37.7798295076742, -122.416589227122) | |||
| 44987 | 44987 | 134512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 4ft | 6007952.73516 | 2112091.3955099997 | 37.7798495481525 | -122.416082113806 | (37.7798495481525, -122.416082113806) | |||
| 57595 | 57595 | 134520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6007809.423690001 | 2112072.4347 | 37.779789427567 | -122.41657654936199 | (37.779789427567, -122.416576549362) | |||
| 60593 | 60593 | 134509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | Width 4ft | 6008051.61488 | 2112117.95752 | 37.7799280400987 | -122.415741925456 | (37.7799280400987, -122.415741925456) | |||
| 66598 | 66598 | 134503 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 4ft | 6008163.02923 | 2112130.27379 | 37.7799681201757 | -122.41535736455799 | (37.7799681201757, -122.415357364558) | |||
| 70214 | 70214 | 134516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6007879.23543 | 2112081.34439 | 37.7798178173801 | -122.416335670458 | (37.7798178173801, -122.416335670458) | |||
| 70475 | 70475 | 134506 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 4ft | 6008094.26451 | 2112112.8267900003 | 37.779916349808396 | -122.41559401757699 | (37.7799163498084, -122.415594017577) | |||
| 73716 | 73716 | 134514 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 6007916.55212 | 2112084.22953 | 37.779827837626705 | -122.41620677962 | (37.7798278376267, -122.41620677962) | |||
| 137288 | 137288 | 134517 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6007880.14491 | 2112095.92317 | 37.7798578983531 | -122.41633355704599 | (37.7798578983531, -122.416333557046) | |||
| 137329 | 137329 | 134502 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | Width 4ft | 6008165.1975300005 | 2112116.84845 | 37.779931379274004 | -122.415348912733 | (37.779931379274, -122.415348912733) | |||
| 138148 | 138148 | 134518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6007848.65925 | 2112079.5377 | 37.7798111372171 | -122.41644131921801 | (37.7798111372171, -122.416441319218) | |||
| 153139 | 153139 | 134513 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 4ft | 6007949.93141 | 2112103.61743 | 37.779882948971206 | -122.416092679044 | (37.7798829489712, -122.416092679044) | |||
| 164267 | 164267 | 134504 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 4ft | 6008127.86822 | 2112113.3553299997 | 37.7799196898886 | -122.41547780446999 | (37.7799196898886, -122.41547780447) | |||
| 172984 | 172984 | 134507 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008088.37088 | 2112123.28694 | 37.779944739586 | -122.415615147138 | (37.779944739586, -122.415615147138) | |||
| 177126 | 177126 | 134515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6007920.47696 | 2112096.9218900003 | 37.7798629084902 | -122.416194101002 | (37.7798629084902, -122.416194101002) | |||
| 177530 | 177530 | 134505 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008123.85605 | 2112126.20986 | 37.7799547598338 | -122.41549259472299 | (37.7799547598338, -122.415492594723) | |||
| 177540 | 177540 | 134519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6007845.81845 | 2112089.93571 | 37.779839527901295 | -122.416451883555 | (37.7798395279013, -122.416451883555) | |||
| 33777 | 33777 | 135219 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012270.743430001 | 2119520.64985 | 37.8004903596904 | -122.401666450845 | (37.8004903596904, -122.401666450845) | |||
| 41988 | 41988 | 135221 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012239.1724 | 2119517.3067400004 | 37.8004794185404 | -122.401775464881 | (37.8004794185404, -122.401775464881) | |||
| 71283 | 71283 | 135223 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012206.95823 | 2119513.44352 | 37.800467013300704 | -122.40188666783999 | (37.8004670133007, -122.40188666784) | |||
| 148861 | 148861 | 135218 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012291.91752 | 2119524.6779 | 37.8005026012769 | -122.40159346277399 | (37.8005026012769, -122.401593462774) | |||
| 154161 | 154161 | 135220 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012254.17639 | 2119520.76645 | 37.8004897553577 | -122.40172378803301 | (37.8004897553577, -122.401723788033) | |||
| 181113 | 181113 | 135222 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Green St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012225.8957 | 2119515.12927 | 37.800472698816 | -122.401821254743 | (37.800472698816, -122.401821254743) | |||
| 57690 | 57690 | 195191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Industrial St | 8 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6011603.00952 | 2097270.79889 | 37.7393600461416 | -122.402411733411 | (37.7393600461416, -122.402411733411) | |||
| 63855 | 63855 | 235399 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006402.46295 | 2107189.13843 | 37.766301838874604 | -122.421097017736 | (37.7663018388746, -122.421097017736) | |||
| 67887 | 67887 | 235398 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006402.76817 | 2107204.00468 | 37.7663426752898 | -122.421097017717 | (37.7663426752898, -122.421097017717) | |||
| 69916 | 69916 | 235400 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006402.485780001 | 2107171.59575 | 37.7662536721077 | -122.42109569303301 | (37.7662536721077, -122.421095693033) | |||
| 146726 | 146726 | 235396 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006401.16796 | 2107237.9775799997 | 37.7664358666353 | -122.421104965047 | (37.7664358666353, -122.421104965047) | |||
| 151198 | 151198 | 235401 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006403.7322 | 2107160.30834 | 37.7662227498105 | -122.421090580359 | (37.7662227498105, -122.421090580359) | |||
| 152033 | 152033 | 235397 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006400.8079699995 | 2107220.44308 | 37.766387700749505 | -122.421104965023 | (37.7663877007495, -122.421104965023) | |||
| 157589 | 157589 | 235403 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006405.10685 | 2107135.85255 | 37.7661556774811 | -122.421084089062 | (37.7661556774811, -122.421084089062) | |||
| 162848 | 162848 | 235395 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6006399.13733 | 2107250.9852400003 | 37.7664714681224 | -122.421112912346 | (37.7664714681224, -122.421112912346) | |||
| 166170 | 166170 | 235404 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006405.80083 | 2107120.89667 | 37.7661146512887 | -122.421080626682 | (37.7661146512887, -122.421080626682) | |||
| 175885 | 175885 | 235402 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Julian Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6006404.93167 | 2107147.95054 | 37.76618888582821 | -122.42108555407101 | (37.7661888858282, -122.421085554071) | |||
| 25686 | 25686 | 134476 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007839.62129 | 2111720.04477 | 37.7788235475933 | -122.416447114449 | (37.7788235475933, -122.416447114449) | |||
| 34610 | 34610 | 134478 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | |||
| 163644 | 163644 | 134475 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6007841.9140099995 | 2111705.3634 | 37.7787833650015 | -122.416438142805 | (37.7787833650015, -122.416438142805) | |||
| 165595 | 165595 | 134477 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6007817.152919999 | 2111847.0495700003 | 37.7791710087729 | -122.416533840565 | (37.7791710087729, -122.416533840565) | |||
| 37762 | 37762 | 133567 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998026.17704 | 2116047.2412900003 | 37.7901481363752 | -122.450707595398 | (37.7901481363752, -122.450707595398) | |||
| 77074 | 77074 | 133569 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Laurel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998021.08065 | 2116073.32395 | 37.790219460698 | -122.45072710977 | (37.790219460698, -122.45072710977) | |||
| 149119 | 149119 | 133566 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998025.38031 | 2116031.57851 | 37.790105084941395 | -122.45070922225901 | (37.7901050849414, -122.450709222259) | |||
| 168140 | 168140 | 133568 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998022.46628 | 2116060.8916700003 | 37.790185404279704 | -122.450721418877 | (37.7901854042797, -122.450721418877) | |||
| 175335 | 175335 | 133570 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Laurel St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998019.709369999 | 2116086.45752 | 37.790255443493 | -122.450732801604 | (37.790255443493, -122.450732801604) | |||
| 42785 | 42785 | 133601 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5996617.65235 | 2115687.31226 | 37.789079141944796 | -122.45555492592301 | (37.7890791419448, -122.455554925923) | |||
| 186264 | 186264 | 133600 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Maple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996624.289609999 | 2115664.5726799998 | 37.789017086025794 | -122.455530317763 | (37.7890170860258, -122.455530317763) | |||
| 34872 | 34872 | 211905 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993202.216519999 | 2096632.8865099999 | 37.7365641096345 | -122.465986670445 | (37.7365641096345, -122.465986670445) | |||
| 177657 | 177657 | 211906 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5993235.809830001 | 2096611.3169099998 | 37.736506822832204 | -122.465868958209 | (37.7365068228322, -122.465868958209) | |||
| 55569 | 55569 | 133486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997077.73236 | 2115875.669 | 37.789622709270894 | -122.45397672545401 | (37.7896227092709, -122.453976725454) | |||
| 63299 | 63299 | 133485 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997070.63549 | 2115917.82612 | 37.7897380545196 | -122.454004325646 | (37.7897380545196, -122.454004325646) | |||
| 72631 | 72631 | 133480 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5997061.96656 | 2115975.36565 | 37.7898955455971 | -122.454038476491 | (37.7898955455971, -122.454038476491) | |||
| 155276 | 155276 | 133482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5997065.74599 | 2115955.6287599998 | 37.78984157009079 | -122.45402397405 | (37.7898415700908, -122.45402397405) | |||
| 161753 | 161753 | 133484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5997068.33447 | 2115930.66537 | 37.789773175726296 | -122.454013214559 | (37.7897731757263, -122.454013214559) | |||
| 168312 | 168312 | 133483 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5997067.112000001 | 2115943.34749 | 37.7898079273373 | -122.45401836046699 | (37.7898079273373, -122.454018360467) | |||
| 170897 | 170897 | 133481 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Spruce St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997065.264140001 | 2115964.92901 | 37.7898670784577 | -122.454026313157 | (37.7898670784577, -122.454026313157) | |||
| 47992 | 47992 | 27910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112493.47301 | 37.7813979677469 | -122.38856853840599 | (37.7813979677469, -122.388568538406) | ||
| 75154 | 75154 | 27919 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015840.17801 | 2112278.62901 | 37.7808039650097 | -122.38880879774099 | (37.7808039650097, -122.388808797741) | ||
| 80016 | 80016 | 27916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015873.81501 | 2112343.7330099996 | 37.780984590279104 | -122.388696976059 | (37.7809845902791, -122.388696976059) | ||
| 81408 | 81408 | 27915 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.38865750159401 | (37.7810567572813, -122.388657501594) | ||
| 84010 | 84010 | 27922 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | ||
| 85492 | 85492 | 27923 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.499009999 | 2112201.5890099998 | 37.780589122550204 | -122.38900987778901 | (37.7805891225502, -122.389009877789) | ||
| 86606 | 86606 | 27928 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015611.22801 | 2112036.65901 | 37.7801268774736 | -122.389583949745 | (37.7801268774736, -122.389583949745) | ||
| 93427 | 93427 | 27925 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015664.3970099995 | 2112091.99701 | 37.7802817711748 | -122.38940387795401 | (37.7802817711748, -122.389403877954) | ||
| 96010 | 96010 | 27926 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015645.95101 | 2112072.4660099996 | 37.7802271207192 | -122.38946632738501 | (37.7802271207192, -122.389466327385) | ||
| 99026 | 99026 | 27918 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015851.02901 | 2112300.33101 | 37.7808641552493 | -122.388772773994 | (37.7808641552493, -122.388772773994) | ||
| 103527 | 103527 | 27912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015910.70801 | 2112444.6450099996 | 37.781263716620394 | -122.388576389848 | (37.7812637166204, -122.388576389848) | ||
| 108615 | 108615 | 27911 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015911.79301 | 2112468.51601 | 37.781329321163504 | -122.38857430301701 | (37.7813293211635, -122.388574303017) | ||
| 113469 | 113469 | 27917 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015864.050009999 | 2112323.1170099997 | 37.780927442165705 | -122.38872931872 | (37.7809274421657, -122.38872931872) | ||
| 114113 | 114113 | 27908 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015917.21801 | 2112547.72601 | 37.781547114702896 | -122.38856106572901 | (37.7815471147029, -122.388561065729) | ||
| 115907 | 115907 | 27907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015923.72801 | 2112571.59801 | 37.7816130226275 | -122.388540210862 | (37.7816130226275, -122.388540210862) | ||
| 117247 | 117247 | 27909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112518.42901 | 37.781466491326604 | -122.388570280932 | (37.7814664913266, -122.388570280932) | ||
| 119168 | 119168 | 27914 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015893.3460099995 | 2112392.56101 | 37.7811197434466 | -122.388632817528 | (37.7811197434466, -122.388632817528) | ||
| 119191 | 119191 | 27927 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015626.41901 | 2112054.0200099996 | 37.7801753891821 | -122.38953260952299 | (37.7801753891821, -122.389532609523) | ||
| 138763 | 138763 | 27921 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015810.88101 | 2112236.31101 | 37.780686145436505 | -122.38890719588899 | (37.7806861454365, -122.388907195889) | ||
| 139701 | 139701 | 27920 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015829.32701 | 2112255.84301 | 37.7807407983373 | -122.38884474573099 | (37.7807407983373, -122.388844745731) | ||
| 141754 | 141754 | 27913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015902.02701 | 2112416.43301 | 37.781185771703704 | -122.388604452195 | (37.7811857717037, -122.388604452195) | ||
| 142572 | 142572 | 27924 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015682.84301 | 2112108.2730099997 | 37.780327484096496 | -122.389341201064 | (37.7803274840965, -122.389341201064) | ||
| 22987 | 22987 | 212768 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992900.163240001 | 2097835.01221 | 37.739847414828205 | -122.467118363816 | (37.7398474148282, -122.467118363816) | |||
| 137642 | 137642 | 212767 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992888.803180001 | 2097843.20156 | 37.7398692449767 | -122.46715823707 | (37.7398692449767, -122.46715823707) | |||
| 33796 | 33796 | 133512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 2ft | 5998496.90737 | 2116156.12675 | 37.790474040799104 | -122.44908675985701 | (37.7904740407991, -122.449086759857) |
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");