trees
194,517 rows sorted by TreeID descending
This data as json, CSV (advanced)
| rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 182794 | 99891 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 118066 | 99890 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 25064 | 9989 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 28 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6005374.86669 | 2108638.02007 | 37.7702221392707 | -122.424754366229 | (37.7702221392707, -122.424754366229) | 8 | 2 | 5 | 28853 | 19 | |||
| 192701 | 99889 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 80615 | 99888 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 140023 | 99887 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 82371 | 99886 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2686 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 768942 | 6000183.60551 | 2117840.03857 | 37.7951939436976 | -122.4433719127 | (37.7951939436976, -122.4433719127) | 13 | 9 | 1 | 57 | 17 | |||
| 179415 | 99885 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
| 180655 | 99884 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
| 29206 | 99883 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
| 127658 | 99882 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
| 138846 | 99881 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 0 | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | ||
| 171788 | 99880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 768615 | 5999995.5 | 2091667 | 37.7233185016187 | -122.442143097817 | (37.7233185016187, -122.442143097817) | 9 | 7 | 6 | 28861 | 25 | ||
| 177220 | 9988 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005434.58987 | 2108720.51419 | 37.7704520212643 | -122.424553652838 | (37.7704520212643, -122.424553652838) | 8 | 2 | 5 | 28853 | 19 | |||
| 140555 | 99879 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768149 | 6004987.5 | 2096139.2 | 37.7358814033012 | -122.425204756431 | (37.7358814033012, -122.425204756431) | 2 | 7 | 5 | 28859 | 2 | |||
| 134287 | 99878 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 261 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 6x8 | 5998035.65095 | 2115667.71588 | 37.7891066027242 | -122.450647442448 | (37.7891066027242, -122.450647442448) | 11 | 6 | 1 | 54 | 31 | |||
| 39482 | 99877 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 261 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5998033.46832 | 2115684.09977 | 37.789151463605 | -122.450656175749 | (37.789151463605, -122.450656175749) | 11 | 6 | 1 | 54 | 31 | |||
| 184096 | 99876 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1295X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003506.1 | 2095452.4 | 37.7339118061219 | -122.430277556689 | (37.7339118061219, -122.430277556689) | 2 | 7 | 5 | 28861 | 25 | |||
| 50988 | 99875 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1301X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003616.3 | 2095455.7 | 37.7339271085192 | -122.429896797189 | (37.7339271085192, -122.429896797189) | 2 | 7 | 5 | 28861 | 25 | |||
| 73814 | 99874 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.7339271085192 | -122.429896797189 | (37.7339271085192, -122.429896797189) | 2 | 7 | 5 | 28861 | 25 |
| 188408 | 99873 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 50960 | 99872 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 146139 | 99871 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 55256 | 99870 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2244 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768957 | 6002355.52291 | 2116016.09819 | 37.7903094900332 | -122.435726190525 | (37.7903094900332, -122.435726190525) | 13 | 9 | 1 | 29490 | 27 | |
| 161440 | 9987 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | |||
| 89530 | 99869 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 28969 | 6007604.2335 | 2113225.7913 | 37.7829447244363 | -122.417368152144 | (37.7829447244363, -122.417368152144) | 7 | 9 | 9 | 28852 | 36 | |||
| 91253 | 99868 | DPW Maintained 1 | Tristania conferta :: 61 | 532 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 28966 | 6007610.0526 | 2113183.9663 | 37.7828302105112 | -122.417345055476 | (37.7828302105112, -122.417345055476) | 7 | 9 | 9 | 28852 | 36 | |||
| 25135 | 99865 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 566 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2012 12:00:00 AM | 3x3 | Permit Number 768884 | 5986943.1 | 2112080 | 37.7786145879683 | -122.488761926719 | (37.7786145879683, -122.488761926719) | 11 | 6 | 2 | 55 | 26 | ||
| 30463 | 99864 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768887 | 5981306.2 | 2111092.9 | 37.7755737343962 | -122.508188499048 | (37.7755737343962, -122.508188499048) | 11 | 6 | 2 | 55 | 26 | ||||
| 78924 | 99863 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 5981324.99313 | 2111098.19167 | 37.7755893711796 | -122.508123883044 | (37.7755893711796, -122.508123883044) | 11 | 6 | 2 | 55 | 26 | ||||
| 165954 | 99862 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 4444x 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001291.6 | 2104678.2 | 37.7591179803285 | -122.438594559919 | (37.7591179803285, -122.438594559919) | 2 | 4 | 5 | 28862 | 3 | ||||
| 136489 | 99861 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 4444x 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001291.6 | 2104678.2 | 37.7591179803285 | -122.438594559919 | (37.7591179803285, -122.438594559919) | 2 | 4 | 5 | 28862 | 3 | ||||
| 178376 | 99860 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 4444x 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001291.6 | 2104678.2 | 37.7591179803285 | -122.438594559919 | (37.7591179803285, -122.438594559919) | 2 | 4 | 5 | 28862 | 3 | ||||
| 64957 | 9986 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | ||
| 40225 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | ||||
| 162549 | 99856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
| 104052 | 99855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
| 111262 | 99854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
| 23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
| 68299 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 86 Nordhoff St | 1 | Front Yard : Yard | Tree | Private 2 | 6000395 | 2095652 | 37.7342831509698 | -122.441047861045 | (37.7342831509698, -122.441047861045) | 9 | 7 | 5 | 63 | 40 | |||||
| 42287 | 99851 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 191 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988632 | 2114084 | 37.7842154230523 | -122.483066364805 | (37.7842154230523, -122.483066364805) | 11 | 6 | 2 | 55 | 26 | |||
| 163733 | 99848 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 754 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6x9 | 5985724.77782 | 2110753.56839 | 37.7749014117299 | -122.492878783679 | (37.7749014117299, -122.492878783679) | 11 | 6 | 2 | 55 | 26 | |||
| 99362 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
| 170311 | 99846 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 850@14th Ave Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
| 134121 | 99845 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 850@14th Ave Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
| 134950 | 99844 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 850@14th Ave Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
| 54866 | 99843 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 25128 | 99842 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 184220 | 99841 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 171418 | 99840 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 140700 | 9984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 699X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999124.13341 | 2110521.95513 | 37.7750399229531 | -122.446511088309 | (37.7750399229531, -122.446511088309) | 15 | 5 | 11 | 29492 | 16 | |||
| 59229 | 99839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 26866 | 99838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 134457 | 99837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 50351 | 99836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 122538 | 99835 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 66026 | 99833 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1610 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3x | 6007914 | 2117933 | 37.7958869904292 | -122.416630050903 | (37.7958869904292, -122.416630050903) | 5 | 1 | 10 | 28858 | 21 | ||||
| 100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 30713 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2398 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 62300 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2398 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 185053 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Cascade Walk | 1 | Front Yard : Yard | Tree | Private 2 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | 1 | 8 | 4 | 56 | 12 | |||||
| 152441 | 99822 | Permitted Site 7 | Tree(s) :: 17 | 1499X 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769141 | 5994283 | 2105334 | 37.7605174549789 | -122.462881035671 | (37.7605174549789, -122.462881035671) | 1 | 5 | 11 | 56 | 12 | |||
| 81460 | 99821 | Undocumented 4 | Salix spp :: Willow 203 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
| 135010 | 99820 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 8 | 3x3 | Permit Number 768974 | 6007364.7 | 2097747 | 37.7404300763526 | -122.417099703218 | (37.7404300763526, -122.417099703218) | 2 | 7 | 7 | 28859 | 2 |
| 4162 | 9982 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 660X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999273.00844 | 2110518.1825 | 37.7750380665947 | -122.44599582765 | (37.7750380665947, -122.44599582765) | 15 | 5 | 11 | 29492 | 16 | |||
| 96540 | 99819 | Permitted Site 7 | Elaeocarpus decipiens :: Japanese Blueberry Tree 321 | 618 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768974 | 6007328.1 | 2097732.5 | 37.7403882035532 | -122.417225224725 | (37.7403882035532, -122.417225224725) | 2 | 7 | 7 | 28859 | 2 |
| 33717 | 99818 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
| 3509 | 99817 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
| 193536 | 99816 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 660-662 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Most likely permitted for planting at same time as tree no. 1 | 6002127 | 2102089 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | 2 | 4 | 5 | 28862 | 22 | |||
| 31732 | 99815 | Undocumented 4 | Tree(s) :: 17 | 730 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769053 | 6001682 | 2102065 | 37.7519649632224 | -122.437057281239 | (37.7519649632224, -122.437057281239) | 2 | 4 | 5 | 28862 | 22 | ||
| 23526 | 99814 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 709 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001253 | 2102268 | 37.7524979583971 | -122.438555365412 | (37.7524979583971, -122.438555365412) | 2 | 4 | 5 | 28862 | 22 | ||||
| 87430 | 99813 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 721x Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 795-797 Elizabeth St same address; corner property | 6001267.3 | 2102059 | 37.751924908035 | -122.438490940634 | (37.751924908035, -122.438490940634) | 2 | 4 | 5 | 28862 | 22 | |||
| 28909 | 99810 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4201-4203 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102333 | 37.7527109432388 | -122.436460912327 | (37.7527109432388, -122.436460912327) | 2 | 4 | 5 | 28862 | 22 | ||||
| 95886 | 99808 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 4143 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002228 | 2102353 | 37.7527867625939 | -122.435189734753 | (37.7527867625939, -122.435189734753) | 2 | 4 | 5 | 28862 | 22 | ||||
| 162365 | 99806 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4141 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002241 | 2102354 | 37.7527902465656 | -122.435144849965 | (37.7527902465656, -122.435144849965) | 2 | 4 | 5 | 28862 | 22 | |||
| 145320 | 99804 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 4288-4298 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001333 | 2101754 | 37.75109118813 | -122.438241893494 | (37.75109118813, -122.438241893494) | 2 | 4 | 5 | 28862 | 22 | ||||
| 104801 | 99803 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 4288-4298 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001333 | 2101754 | 37.75109118813 | -122.438241893494 | (37.75109118813, -122.438241893494) | 2 | 4 | 5 | 28862 | 22 | ||||
| 168864 | 99802 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001292.8 | 2101960.5 | 37.7516559011478 | -122.438395701912 | (37.7516559011478, -122.438395701912) | 2 | 4 | 5 | 28862 | 22 | ||||
| 122777 | 99801 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001292.8 | 2101960.5 | 37.7516559011478 | -122.438395701912 | (37.7516559011478, -122.438395701912) | 2 | 4 | 5 | 28862 | 22 | ||||
| 32798 | 99800 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 795-797 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001281 | 2102008 | 37.7517856535599 | -122.438439910597 | (37.7517856535599, -122.438439910597) | 2 | 4 | 5 | 28862 | 22 | ||||
| 146392 | 9980 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 24 | 3X3 | Permit Number 54082 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
| 26697 | 998 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1720 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6001400.68712 | 2092099.77207 | 37.7245867776358 | -122.437316613686 | (37.7245867776358, -122.437316613686) | 9 | 7 | 6 | 28861 | 25 | |||
| 62127 | 99799 | Undocumented 4 | Malus :: Crab Apple 82 | 795-797 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001281 | 2102008 | 37.7517856535599 | -122.438439910597 | (37.7517856535599, -122.438439910597) | 2 | 4 | 5 | 28862 | 22 | ||||
| 14565 | 99798 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 723-725 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001735 | 2102034 | 37.7518828570558 | -122.436871780919 | (37.7518828570558, -122.436871780919) | 2 | 4 | 5 | 28862 | 22 | ||||
| 162055 | 99797 | Undocumented 4 | Schinus molle :: California Pepper 91 | 703-705 Elizabeth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
| 18844 | 99796 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 703-705 Elizabeth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
| 122834 | 99795 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 703-705 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
| 141039 | 99794 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 703-705 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
| 170610 | 99793 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
| 173521 | 99792 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4120-4124 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
| 126696 | 99791 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
| 105912 | 99790 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4140-4124 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Most likely planted when tree 1 was planted/permitted. | 6002271 | 2101809 | 37.7512955097612 | -122.435002130134 | (37.7512955097612, -122.435002130134) | 2 | 4 | 5 | 28862 | 22 | |||
| 130885 | 9979 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
| 85703 | 99789 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 832 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001877 | 2101668 | 37.7508859779493 | -122.436354534162 | (37.7508859779493, -122.436354534162) | 2 | 4 | 5 | 28862 | 22 | ||||
| 172214 | 99787 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 542 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001639 | 2101477 | 37.750348011432 | -122.437163885099 | (37.750348011432, -122.437163885099) | 2 | 4 | 5 | 28862 | 22 | ||||
| 55193 | 99785 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 803-805 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001281.6 | 2101711.5 | 37.7509715697707 | -122.438416595038 | (37.7509715697707, -122.438416595038) | 2 | 4 | 5 | 28862 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );