Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89 | 89 | 251189 | Permitted Site 1 | Tree(s) :: 17 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 3x3 | 6016267.45517 | 2096986.6643299998 | 37.7388391569445 | -122.38626419104999 | (37.7388391569445, -122.38626419105) | ||
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 1691 | 1691 | 251656 | Undocumented 2 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2096089.0 | 37.7354276387403 | -122.44443976141001 | (37.7354276387403, -122.44443976141) | ||||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 1967 | 1967 | 138282 | DPW Maintained 3 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | |||
| 1972 | 1972 | 252849 | Undocumented 2 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996376.0 | 2100052.0 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | ||||
| 2006 | 2006 | 252850 | Undocumented 2 | Tree(s) :: 17 | 2 Hernandez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996271.0 | 2100083.0 | 37.7462138338134 | -122.45562593978599 | (37.7462138338134, -122.455625939786) | ||||
| 2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 2816 | 2816 | 253217 | Permitted Site 1 | Tree(s) :: 17 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | 3x3 | 6001651.75029 | 2086494.56012 | 37.7092103839364 | -122.436047813177 | (37.7092103839364, -122.436047813177) | ||
| 2977 | 2977 | 10292 | DPW Maintained 3 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.43016441338301 | (37.7722102257422, -122.430164413383) | |||
| 3070 | 3070 | 116407 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | ||||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) | |||
| 4002 | 4002 | 253607 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4085 | 4085 | 101532 | Undocumented 2 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 4089 | 4089 | 253606 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4552 | 4552 | 97357 | Permitted Site 1 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 4740 | 4740 | 124733 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 4863 | 4863 | 253702 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4865 | 4865 | 253699 | Undocumented 2 | Tree(s) :: 17 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000057.0 | 2105400.0 | 37.761029556529294 | -122.44291621566002 | (37.7610295565293, -122.44291621566) | ||||
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 4871 | 4871 | 253700 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4913 | 4913 | 97358 | Permitted Site 1 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 5210 | 5210 | 83637 | Permitted Site 1 | Tree(s) :: 17 | 840 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/19/2005 12:00:00 AM | 3x3 | 6006834.966315799 | 2113631.30048912 | 37.784014842491395 | -122.420058290383 | (37.7840148424914, -122.420058290383) | ||
| 6372 | 6372 | 124739 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 6769 | 6769 | 124735 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7004 | 7004 | 124738 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7011 | 7011 | 97356 | Permitted Site 1 | Tree(s) :: 17 | 6 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 7040 | 7040 | 97351 | Permitted Site 1 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 7186 | 7186 | 124737 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7602 | 7602 | 124740 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 8467 | 8467 | 56665 | Permitted Site 1 | Tree(s) :: 17 | 4549 Callan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 8470 | 8470 | 19243 | Permitted Site 1 | Tree(s) :: 17 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2007 12:00:00 AM | 3 | 3x3 | 6002038.0023 | 2110993.4691 | 37.776500585825204 | -122.436465151941 | (37.7765005858252, -122.436465151941) | ||
| 8657 | 8657 | 97354 | Permitted Site 1 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 8812 | 8812 | 124736 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 9037 | 9037 | 169234 | Undocumented 2 | Tree(s) :: 17 | 695 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6009012.0 | 2111041.0 | 37.7770249114115 | -122.41234337077199 | (37.7770249114115, -122.412343370772) | |||
| 9920 | 9920 | 173743 | Undocumented 2 | Tree(s) :: 17 | 530 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997387.0 | 2097791.0 | 37.7399845403322 | -122.45160167056801 | (37.7399845403322, -122.451601670568) | ||||
| 9923 | 9923 | 173740 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 7 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
| 9924 | 9924 | 173738 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10133 | 10133 | 173865 | Undocumented 2 | Tree(s) :: 17 | 325 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013725.0 | 2109678.0 | 37.77354576620421 | -122.395943986686 | (37.7735457662042, -122.395943986686) | ||||
| 10135 | 10135 | 173864 | Undocumented 2 | Tree(s) :: 17 | 300 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013804.0 | 2109844.0 | 37.7740059597011 | -122.39568234515801 | (37.7740059597011, -122.395682345158) | ||||
| 10222 | 10222 | 173923 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10224 | 10224 | 173918 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10225 | 10225 | 173920 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10227 | 10227 | 173914 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10228 | 10228 | 173922 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10230 | 10230 | 173919 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10232 | 10232 | 173916 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10233 | 10233 | 173917 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10237 | 10237 | 173915 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10238 | 10238 | 173921 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10254 | 10254 | 173937 | Permitted Site 1 | Tree(s) :: 17 | 4695 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999956.94577188 | 2105141.0371168 | 37.7603128035628 | -122.44324365859501 | (37.7603128035628, -122.443243658595) | |||||
| 10631 | 10631 | 97353 | Permitted Site 1 | Tree(s) :: 17 | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 10892 | 10892 | 112910 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 11641 | 11641 | 96232 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 12744 | 12744 | 56667 | Permitted Site 1 | Tree(s) :: 17 | 495 Callan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 13253 | 13253 | 187616 | Undocumented 2 | Tree(s) :: 17 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013035.0 | 2114021.0 | 37.785432237020004 | -122.398635644163 | (37.78543223702, -122.398635644163) | ||||
| 13257 | 13257 | 187617 | Undocumented 2 | Tree(s) :: 17 | 55 Hawthorne St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013035.0 | 2114021.0 | 37.785432237020004 | -122.398635644163 | (37.78543223702, -122.398635644163) | ||||
| 14893 | 14893 | 97355 | Permitted Site 1 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 16044 | 16044 | 96231 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 16481 | 16481 | 112908 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 16895 | 16895 | 97352 | Permitted Site 1 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 16902 | 16902 | 203214 | Undocumented 2 | Tree(s) :: 17 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009653.0 | 2111431.0 | 37.778131708870504 | -122.410153484475 | (37.7781317088705, -122.410153484475) | ||||
| 16904 | 16904 | 203215 | Undocumented 2 | Tree(s) :: 17 | 603 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009653.0 | 2111431.0 | 37.778131708870504 | -122.410153484475 | (37.7781317088705, -122.410153484475) | ||||
| 17030 | 17030 | 110785 | Permitted Site 1 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | |||
| 17039 | 17039 | 97769 | Undocumented 2 | Tree(s) :: 17 | 362 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6007113.7 | 2105238.5 | 37.7609859097905 | -122.418498646119 | (37.7609859097905, -122.418498646119) | |||
| 17073 | 17073 | 112909 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 17986 | 17986 | 56452 | Permitted Site 1 | Tree(s) :: 17 | 1471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5982761.8650167 | 2105117.76871339 | 37.759253411371205 | -122.50271069963001 | (37.7592534113712, -122.50271069963) | |||||
| 17989 | 17989 | 105356 | Undocumented 2 | Tree(s) :: 17 | 207-211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006236.0 | 2101921.0 | 37.7518273734539 | -122.421298642673 | (37.7518273734539, -122.421298642673) | |||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 18486 | 18486 | 106393 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 18642 | 18642 | 106966 | Undocumented 2 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | ||||||
| 18842 | 18842 | 56690 | Permitted Site 1 | Tree(s) :: 17 | 55 Hallam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010204.858571201 | 2110471.70826771 | 37.775528634854496 | -122.408176723323 | (37.7755286348545, -122.408176723323) | |||||
| 18845 | 18845 | 56735 | Permitted Site 1 | Tree(s) :: 17 | 4601 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015154.58866017 | 2096112.48595754 | 37.736377180995206 | -122.39005094503901 | (37.7363771809952, -122.390050945039) | |||||
| 18922 | 18922 | 100994 | Undocumented 2 | Tree(s) :: 17 | 1675 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009464.0 | 2106858.0 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | ||||
| 19065 | 19065 | 99574 | Undocumented 2 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 19419 | 19419 | 109892 | Permitted Site 1 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.722030475149495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | ||
| 19505 | 19505 | 56567 | Permitted Site 1 | Tree(s) :: 17 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992136.3013071995 | 2094883.62123857 | 37.731699516032904 | -122.46954466154499 | (37.7316995160329, -122.469544661545) | |||||
| 19599 | 19599 | 106501 | Undocumented 2 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993358.0 | 2106830.8 | 37.764573953722 | -122.46618893715001 | (37.764573953722, -122.46618893715) | |||||
| 19603 | 19603 | 56564 | Permitted Site 1 | Tree(s) :: 17 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992102.77849477 | 2095182.39763056 | 37.7325179438205 | -122.46968229865699 | (37.7325179438205, -122.469682298657) | |||||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 20908 | 20908 | 100993 | Undocumented 2 | Tree(s) :: 17 | 1675 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009464.0 | 2106858.0 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | ||||
| 21195 | 21195 | 116310 | Undocumented 2 | Tree(s) :: 17 | 1599X Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001671.10835 | 2113777.6056 | 37.7841242646501 | -122.43793380735399 | (37.7841242646501, -122.437933807354) | |||||
| 22306 | 22306 | 203218 | DPW Maintained 3 | Tree(s) :: 17 | 865x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | ||||
| 22827 | 22827 | 251129 | Undocumented 2 | Tree(s) :: 17 | 32 Cross St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2017 12:00:00 AM | 3 | 12x2 | 6000049.0 | 2088229.0 | 37.7138815826944 | -122.441711543213 | (37.7138815826944, -122.441711543213) | ||
| 23155 | 23155 | 543 | DPW Maintained 3 | Tree(s) :: 17 | 2871 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6009625.4825 | 2102172.3236 | 37.7527079631855 | -122.409595033175 | (37.7527079631855, -122.409595033175) |
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");