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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
12879 | 12879 | 108784 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005634.22998 | 2088024.3237700001 | 37.7136362375916 | -122.42239234634899 | (37.7136362375916, -122.422392346349) |
13106 | 13106 | 108782 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005606.4158 | 2088034.4515 | 37.713662477117 | -122.422489201534 | (37.713662477117, -122.422489201534) |
17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
26614 | 26614 | 98657 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002607.56666 | 2119218.5959900003 | 37.7991170337862 | -122.43508328318701 | (37.7991170337862, -122.435083283187) | ||
29249 | 29249 | 60892 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/11/1983 12:00:00 AM | 16 | 5x5 | Permit Number 20677 | 6008514.66964 | 2119698.45237 | 37.8007682484075 | -122.414676612845 | (37.8007682484075, -122.414676612845) |
29352 | 29352 | 110960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008419.49323 | 2119686.5094 | 37.8007301081687 | -122.415005118088 | (37.8007301081687, -122.415005118088) | ||
31571 | 31571 | 98656 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.799126161900396 | -122.435006269744 | (37.7991261619004, -122.435006269744) | ||
33468 | 33468 | 95148 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 5988724.779619999 | 2113566.5271900003 | 37.78279998730721 | -122.482707449869 | (37.7827999873072, -122.482707449869) | |||
33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
41571 | 41571 | 95149 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 5988721.12033 | 2113580.3815900004 | 37.7828378146839 | -122.48272112492901 | (37.7828378146839, -122.482721124929) | |||
42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
44207 | 44207 | 98648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | ||
52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
53064 | 53064 | 98650 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002693.158 | 2119231.9709099997 | 37.799158617543604 | -122.43478806542801 | (37.7991586175436, -122.434788065428) | ||
60314 | 60314 | 95147 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988726.59645 | 2113538.2792 | 37.7827225319963 | -122.48269909375901 | (37.7827225319963, -122.482699093759) | |||
61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
63647 | 63647 | 95150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 5988721.361169999 | 2113591.74757 | 37.7828690364709 | -122.482721124926 | (37.7828690364709, -122.482721124926) | |||
67897 | 67897 | 110959 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008435.0253800005 | 2119688.1206900002 | 37.800735405160296 | -122.414951484348 | (37.8007354051603, -122.414951484348) | ||
69128 | 69128 | 98649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.799162328147794 | -122.434737597267 | (37.7991623281478, -122.434737597267) | ||
70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
71504 | 71504 | 98651 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.799148474973705 | -122.434853527066 | (37.7991484749737, -122.434853527066) | ||
72275 | 72275 | 110957 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008462.007069999 | 2119690.6551900003 | 37.800743880377205 | -122.41485829568998 | (37.8007438803772, -122.41485829569) | ||
73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
73786 | 73786 | 94516 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.9473599996 | 37.753402573178896 | -122.39867255379299 | (37.7534025731789, -122.398672553793) | ||
73832 | 73832 | 110956 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 5x5 | 6008474.06115 | 2119692.72385 | 37.800750237701294 | -122.414816729923 | (37.8007502377013, -122.414816729923) | ||
74427 | 74427 | 67860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.43439798360501 | (37.7992088356751, -122.434397983605) |
78104 | 78104 | 92958 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
84977 | 84977 | 98681 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
87723 | 87723 | 43903 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) | |
88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
89609 | 89609 | 79386 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008491.21757684 | 2104497.38565881 | 37.7590284322587 | -122.4136819767 | (37.7590284322587, -122.4136819767) | |||
92729 | 92729 | 98679 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
94772 | 94772 | 98675 | Permitted Site 1 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
100074 | 100074 | 43904 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
101631 | 101631 | 94927 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 325 Sanchez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/07/2010 12:00:00 AM | 3x3 | Permit Number 53976 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||
105652 | 105652 | 98659 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | ||
111986 | 111986 | 108780 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6006878.58529 | 2087505.45215 | 37.7122816418905 | -122.418054633195 | (37.7122816418905, -122.418054633195) |
113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
115759 | 115759 | 92960 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
116407 | 116407 | 92806 | Permitted Site 1 | Tree(s) :: 17 | 2355 Folsom St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008199.4 | 2104720.1 | 37.7596235634815 | -122.414706984191 | (37.7596235634815, -122.414706984191) | |||
117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
120054 | 120054 | 95152 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5988720.65561 | 2113620.6282200003 | 37.7829482935383 | -122.482725682965 | (37.7829482935383, -122.482725682965) | |||
131687 | 131687 | 98655 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.799141375727295 | -122.434934390513 | (37.7991413757273, -122.434934390513) | ||
133902 | 133902 | 34692 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) |
139294 | 139294 | 92959 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
139752 | 139752 | 92963 | Permitted Site 1 | Tree(s) :: 17 | 1515 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53121 | 5988690.8 | 2100920.9 | 37.7480765758445 | -122.481898390884 | (37.7480765758445, -122.481898390884) | ||
141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
151441 | 151441 | 70932 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 14 | 5988727.46903 | 2113517.2675099997 | 37.7826648905872 | -122.48269453478301 | (37.7826648905872, -122.482694534783) | ||
152078 | 152078 | 110955 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008486.881990001 | 2119694.39066 | 37.8007555347125 | -122.41477248237699 | (37.8007555347125, -122.414772482377) | ||
153048 | 153048 | 98645 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.799200885676605 | -122.434457791187 | (37.7992008856766, -122.434457791187) | ||
159681 | 159681 | 73495 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | ||
161870 | 161870 | 98647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | ||
163336 | 163336 | 95153 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 5988721.4522400005 | 2113658.22406 | 37.783051567455004 | -122.482725682991 | (37.783051567455, -122.482725682991) | |||
166820 | 166820 | 110958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | ||
166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
183769 | 183769 | 95151 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) |
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");