Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125286 | 125286 | 66057 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/03/1990 12:00:00 AM | Permit Number 29097 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||
| 127969 | 127969 | 100199 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095813.0 | 37.7345948616995 | -122.44895594133499 | (37.7345948616995, -122.448955941335) | |||||
| 90564 | 90564 | 100200 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095844.0 | 37.734679980307604 | -122.448958173673 | (37.7346799803076, -122.448958173673) | |||||
| 96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 179146 | 179146 | 106256 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Permit Number 770844 | 6012014.62334 | 2105627.65597 | 37.7623291305193 | -122.401575740746 | (37.7623291305193, -122.401575740746) | |||
| 150859 | 150859 | 106257 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 770844 | 6011994.4738300005 | 2105627.58235 | 37.762327804017296 | -122.401645425613 | (37.7623278040173, -122.401645425613) | |||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 117806 | 117806 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
| 119616 | 119616 | 110560 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
| 117202 | 117202 | 113146 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||||
| 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) | ||
| 186314 | 186314 | 118191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5985457.0333 | 2109984.4342900002 | 37.7727739274481 | -122.49374826573299 | (37.7727739274481, -122.493748265733) | |||
| 48582 | 48582 | 124186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5995895.66436 | 2112512.94419 | 37.7803217205181 | -122.45782309872601 | (37.7803217205181, -122.457823098726) | ||||
| 170520 | 170520 | 133856 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3095 Pacific Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5999414.53968 | 2116633.28963 | 37.7918366440831 | -122.445946155492 | (37.7918366440831, -122.445946155492) | |||
| 179117 | 179117 | 133977 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2663 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6000628.6188900005 | 2117486.53155 | 37.7942486734821 | -122.441806717301 | (37.7942486734821, -122.441806717301) | |||
| 74075 | 74075 | 133978 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2663 Divisadero St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6000628.556580001 | 2117468.4117099997 | 37.7941989176091 | -122.44180563181801 | (37.7941989176091, -122.441805631818) | |||
| 43414 | 43414 | 134323 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1828 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6004706.30116 | 2117783.72452 | 37.795296191212 | -122.42771865761298 | (37.795296191212, -122.427718657613) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 108723 | 108723 | 134479 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6007863.31951 | 2111948.54431 | 37.7794522852199 | -122.416381321833 | (37.7794522852199, -122.416381321833) | |||
| 184684 | 184684 | 134480 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007864.8184400005 | 2111937.3228599997 | 37.779421558100296 | -122.416375341346 | (37.7794215581003, -122.416375341346) | |||
| 161601 | 161601 | 134481 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007895.361819999 | 2111951.33143 | 37.7794617397969 | -122.416270671059 | (37.7794617397969, -122.416270671059) | |||
| 47779 | 47779 | 134482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007900.29971 | 2111939.17847 | 37.7794286483426 | -122.416252727774 | (37.7794286483426, -122.416252727774) | |||
| 77098 | 77098 | 134483 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007936.08027 | 2111955.66275 | 37.7794759221066 | -122.41613011511299 | (37.7794759221066, -122.416130115113) | |||
| 136605 | 136605 | 134484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007942.834559999 | 2111947.77669 | 37.7794546486445 | -122.416106190441 | (37.7794546486445, -122.416106190441) | |||
| 186454 | 186454 | 134485 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008066.49471 | 2111979.5863799998 | 37.7795489425613 | -122.415680649242 | (37.7795489425613, -122.415680649242) | |||
| 175000 | 175000 | 134486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008067.441930001 | 2111966.18603 | 37.779512201655706 | -122.415676423323 | (37.7795122016557, -122.415676423323) | |||
| 174443 | 174443 | 134487 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008098.96465 | 2111984.39568 | 37.7795639729398 | -122.415568662085 | (37.7795639729398, -122.415568662085) | |||
| 65986 | 65986 | 134488 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008103.05176 | 2111975.1886299998 | 37.7795389223209 | -122.415553870937 | (37.7795389223209, -122.415553870937) | |||
| 50882 | 50882 | 134489 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008140.64601 | 2111978.12768 | 37.7795491053379 | -122.415424024093 | (37.7795491053379, -122.415424024093) | |||
| 147168 | 147168 | 134490 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008161.462669999 | 2111994.06404 | 37.779594032765296 | -122.41535313863001 | (37.7795940327653, -122.41535313863) | |||
| 131198 | 131198 | 134491 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6008163.020330001 | 2111980.65153 | 37.7795572927687 | -122.41534680023001 | (37.7795572927687, -122.41534680023) | |||
| 51141 | 51141 | 134492 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008187.17961 | 2111997.187 | 37.779604053022204 | -122.415264393538 | (37.7796040530222, -122.415264393538) | |||
| 30713 | 30713 | 134493 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6008191.76515 | 2111982.49606 | 37.7795639729274 | -122.41524748988998 | (37.7795639729274, -122.41524748989) | |||
| 63977 | 63977 | 134810 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007208.980819999 | 2120920.35819 | 37.8040498475794 | -122.419281577887 | (37.8040498475794, -122.419281577887) | |||
| 63037 | 63037 | 134811 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007198.08423 | 2120918.57327 | 37.8040443329535 | -122.41931915967699 | (37.8040443329535, -122.419319159677) | |||
| 31572 | 31572 | 134812 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007187.8206400005 | 2120917.39341 | 37.804040515307896 | -122.419354593866 | (37.8040405153079, -122.419354593866) | |||
| 48936 | 48936 | 134813 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007179.40852 | 2120915.71213 | 37.8040354251579 | -122.419383585305 | (37.8040354251579, -122.419383585305) | |||
| 171975 | 171975 | 134875 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2431 Jones St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6007933.92632 | 2120909.2355 | 37.8040601088597 | -122.416772058387 | (37.8040601088597, -122.416772058387) | |||
| 135484 | 135484 | 134878 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2431 Jones St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6007937.84589 | 2120885.23844 | 37.8039944394461 | -122.41675679331101 | (37.8039944394461, -122.416756793311) | |||
| 152859 | 152859 | 134880 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2431 Jones St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6007940.79089 | 2120861.50537 | 37.803929440065495 | -122.416744919547 | (37.8039294400655, -122.416744919547) | |||
| 29192 | 29192 | 134920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6008362.41303 | 2121791.60977 | 37.806506977065794 | -122.415351749199 | (37.8065069770658, -122.415351749199) | |||
| 170642 | 170642 | 134924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6008355.58408 | 2121850.16568 | 37.8066673729735 | -122.41537953014799 | (37.8066673729735, -122.415379530148) | |||
| 39613 | 39613 | 134925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6008346.87232 | 2121899.69009 | 37.8068028648324 | -122.415413187278 | (37.8068028648324, -122.415413187278) | |||
| 46742 | 46742 | 134927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008339.114519999 | 2121958.1114 | 37.80696283893221 | -122.41544417341998 | (37.8069628389322, -122.41544417342) | |||
| 160522 | 160522 | 134993 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6010728.8833099995 | 2121380.31974 | 37.8055103960545 | -122.40713309411501 | (37.8055103960545, -122.407133094115) | ||||
| 155901 | 155901 | 134994 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010728.192290001 | 2121371.2785400003 | 37.8054855324849 | -122.407134847792 | (37.8054855324849, -122.407134847792) | ||||
| 152927 | 152927 | 134995 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6010715.98412 | 2121378.57356 | 37.8055048795989 | -122.40717761058399 | (37.8055048795989, -122.407177610584) | ||||
| 181925 | 181925 | 134996 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6010722.95044 | 2121351.8218900003 | 37.8054318159892 | -122.40715161566601 | (37.8054318159892, -122.407151615666) | ||||
| 174556 | 174556 | 134997 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Francisco St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010734.89476 | 2121355.34801 | 37.8054421662741 | -122.407110529253 | (37.8054421662741, -122.407110529253) | ||||
| 160088 | 160088 | 134998 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Francisco St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010731.25418 | 2121362.44745 | 37.8054614558465 | -122.407123628772 | (37.8054614558465, -122.407123628772) | ||||
| 181550 | 181550 | 135057 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010582.3923 | 2122192.76755 | 37.807732976953396 | -122.407697370161 | (37.8077329769534, -122.407697370161) | ||||
| 25269 | 25269 | 135059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010565.46035 | 2122201.4821900004 | 37.807755957339396 | -122.40775658241999 | (37.8077559573394, -122.40775658242) | ||||
| 53299 | 53299 | 135061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010544.11345 | 2122214.47173 | 37.807790428346294 | -122.407831375437 | (37.8077904283463, -122.407831375437) | ||||
| 41895 | 41895 | 135063 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010521.57842 | 2122228.08294 | 37.807826539739104 | -122.407910324225 | (37.8078265397391, -122.407910324225) | ||||
| 73550 | 73550 | 135065 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010499.870619999 | 2122238.0904900003 | 37.8078528026406 | -122.407986155943 | (37.8078528026406, -122.407986155943) | ||||
| 42690 | 42690 | 135067 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010487.41512 | 2122245.5184 | 37.8078725004725 | -122.40802978564899 | (37.8078725004725, -122.408029785649) | ||||
| 34886 | 34886 | 135069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010465.71952 | 2122256.12348 | 37.8079004046485 | -122.408105617404 | (37.8079004046485, -122.408105617404) | ||||
| 135009 | 135009 | 135071 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010449.38794 | 2122264.82595 | 37.8079233850293 | -122.408162751324 | (37.8079233850293, -122.408162751324) | ||||
| 174780 | 174780 | 135073 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010429.76812 | 2122274.19323 | 37.807948006662 | -122.40823131203001 | (37.807948006662, -122.40823131203) | ||||
| 130521 | 130521 | 135075 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010411.666669999 | 2122284.4263400002 | 37.8079750906313 | -122.408294679165 | (37.8079750906313, -122.408294679165) | ||||
| 75529 | 75529 | 135077 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010393.83504 | 2122293.15944 | 37.8079980710226 | -122.40835700668998 | (37.8079980710226, -122.40835700669) | ||||
| 178398 | 178398 | 135079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010377.54006 | 2122303.65444 | 37.808025975171105 | -122.40841414062 | (37.8080259751711, -122.40841414062) | ||||
| 186776 | 186776 | 135081 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010360.32068 | 2122312.9728200003 | 37.8080505968189 | -122.408474390679 | (37.8080505968189, -122.408474390679) | ||||
| 151224 | 151224 | 135083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010341.3497 | 2122324.71825 | 37.8080817844136 | -122.40854087398701 | (37.8080817844136, -122.408540873987) | ||||
| 73121 | 73121 | 135085 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010323.2303 | 2122334.05501 | 37.8081064060573 | -122.408604240196 | (37.8081064060573, -122.408604240196) | ||||
| 168722 | 168722 | 135086 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010304.534990001 | 2122344.59902 | 37.808134310218705 | -122.40866968476601 | (37.8081343102187, -122.408669684766) | ||||
| 31948 | 31948 | 135088 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010288.509880001 | 2122353.59437 | 37.8081581116658 | -122.40872577909201 | (37.8081581116658, -122.408725779092) | ||||
| 130915 | 130915 | 135090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010270.120709999 | 2122364.4312 | 37.808186836917294 | -122.40879018494199 | (37.8081868369173, -122.408790184942) | ||||
| 45743 | 45743 | 135093 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010231.518209999 | 2122384.9462900003 | 37.8082410039906 | -122.408925228011 | (37.8082410039906, -122.408925228011) | ||||
| 168355 | 168355 | 135094 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010218.1810800005 | 2122393.28877 | 37.8082631632688 | -122.40897197389401 | (37.8082631632688, -122.408971973894) | ||||
| 33244 | 33244 | 135096 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010210.74566 | 2122411.37483 | 37.808312406561896 | -122.40899898321501 | (37.8083124065619, -122.408998983215) | ||||
| 34032 | 34032 | 135097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010211.1601599995 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | ||||
| 149408 | 149408 | 135098 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010217.76574 | 2122446.50226 | 37.808409250946 | -122.408977168373 | (37.808409250946, -122.408977168373) | ||||
| 173340 | 173340 | 135136 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009674.61624 | 2122497.64189 | 37.808519227256106 | -122.410860507034 | (37.8085192272561, -122.410860507034) | ||||
| 157993 | 157993 | 135137 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009675.17252 | 2122510.18452 | 37.8085536973592 | -122.41085946829901 | (37.8085536973592, -122.410859468299) | ||||
| 53095 | 53095 | 135139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009651.5635 | 2122485.8577099997 | 37.808485578225294 | -122.410939454894 | (37.8084855782253, -122.410939454894) | ||||
| 173108 | 173108 | 135141 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009636.62254 | 2122489.1519 | 37.808493785432795 | -122.410991395247 | (37.8084937854328, -122.410991395247) | ||||
| 68996 | 68996 | 135143 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009614.4871 | 2122492.8917400003 | 37.8085028128125 | -122.41106826569799 | (37.8085028128125, -122.411068265698) | ||||
| 34258 | 34258 | 135145 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | ||||
| 157851 | 157851 | 135147 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009572.95679 | 2122501.76157 | 37.8085248381209 | -122.411212620383 | (37.8085248381209, -122.411212620383) | ||||
| 174362 | 174362 | 135149 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009556.32302 | 2122505.1526099998 | 37.808533216194895 | -122.411270426102 | (37.8085332161949, -122.411270426102) | ||||
| 161852 | 161852 | 135151 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009534.78747 | 2122509.55925 | 37.8085441079032 | -122.411345267671 | (37.8085441079032, -122.411345267671) | ||||
| 184904 | 184904 | 135153 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009517.81435 | 2122514.4396599997 | 37.8085565563141 | -122.41140435313 | (37.8085565563141, -122.41140435313) | ||||
| 67415 | 67415 | 135155 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009496.8532 | 2122519.11823 | 37.808568226806706 | -122.41147722608801 | (37.8085682268067, -122.411477226088) | ||||
| 59638 | 59638 | 135156 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009480.72759 | 2122523.69804 | 37.808579897317706 | -122.411533357278 | (37.8085798973177, -122.411533357278) | ||||
| 61001 | 61001 | 135157 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009451.25096 | 2122529.40055 | 37.808593901544796 | -122.411635772999 | (37.8085939015448, -122.411635772999) | ||||
| 69245 | 69245 | 135161 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009360.267630001 | 2122546.84411 | 37.808636693089106 | -122.411951881091 | (37.8086366930891, -122.411951881091) | ||||
| 46489 | 46489 | 135163 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | ||||
| 172987 | 172987 | 135165 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009319.750469999 | 2122555.32253 | 37.808657699448105 | -122.41209270231 | (37.8086576994481, -122.41209270231) | ||||
| 136976 | 136976 | 135167 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009297.39065 | 2122561.1634400003 | 37.8086724825285 | -122.41217049819201 | (37.8086724825285, -122.412170498192) | ||||
| 185448 | 185448 | 178522 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997828.42227 | 2086900.0351099998 | 37.7101057753261 | -122.449290962629 | (37.7101057753261, -122.449290962629) | |||
| 186453 | 186453 | 178523 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997858.27775 | 2086928.7713 | 37.7101863860532 | -122.449189845558 | (37.7101863860532, -122.449189845558) | |||
| 175446 | 175446 | 178524 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5997869.35085 | 2086941.7630200002 | 37.7102226917018 | -122.44915251020599 | (37.7102226917018, -122.449152510206) | |||
| 152518 | 152518 | 178525 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997892.95524 | 2086962.1133599998 | 37.710279919152704 | -122.44907239407401 | (37.7102799191527, -122.449072394074) | |||
| 42182 | 42182 | 178526 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997920.74376 | 2086988.8754200002 | 37.710354990967105 | -122.448978278229 | (37.7103549909671, -122.448978278229) | |||
| 55872 | 55872 | 178527 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997931.98579 | 2086999.1742900002 | 37.7103839122559 | -122.448940164984 | (37.7103839122559, -122.448940164984) | |||
| 172306 | 172306 | 178528 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997956.06337 | 2087020.6353099998 | 37.7104442162958 | -122.448858493027 | (37.7104442162958, -122.448858493027) |
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");