trees
2,180 rows where qSpecies_id = 57 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131683 | 107463 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | 5 | 1 | 10 | 308 | 21 | |||||
132435 | 109819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
132714 | 37584 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40015 | 5999640.19520847 | 2104544.9581721 | 37.7586580511622 | -122.444296310612 | (37.7586580511622, -122.444296310612) | 2 | 4 | 5 | 28862 | 3 | ||
132761 | 61040 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 237 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 20864 | 6003739.14918424 | 2109203.826412 | 37.771683184708 | -122.430452677761 | (37.771683184708, -122.430452677761) | 15 | 9 | 11 | 29492 | 10 | ||
136276 | 61944 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 28 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 22003 | 6006088.71912986 | 2100269.74948978 | 37.7472851127708 | -122.421690689107 | (37.7472851127708, -122.421690689107) | 2 | 7 | 7 | 28859 | 22 | ||
136335 | 61937 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 154 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1985 12:00:00 AM | Permit Number 21994 | 6005520.29020359 | 2100238.48947557 | 37.7471672098 | -122.423654054391 | (37.7471672098, -122.423654054391) | 2 | 7 | 5 | 28859 | 22 | |||
136955 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
138352 | 114878 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
138967 | 61938 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 160 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 21995 | 6005481.86313575 | 2100236.37622324 | 37.7471592381001 | -122.423786782054 | (37.7471592381001, -122.423786782054) | 2 | 7 | 5 | 28859 | 22 | ||
139092 | 60030 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 19 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | 6 | 2 | 9 | 28856 | 6 | ||
140336 | 67902 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31604 | 5997414.89563577 | 2093860.91507447 | 37.7291950674434 | -122.451221861234 | (37.7291950674434, -122.451221861234) | 9 | 7 | 4 | 28861 | 40 | ||
141801 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
142017 | 37534 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1138 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | Permit Number 39980 | 6008135.8621207 | 2116394.85818942 | 37.7916761076557 | -122.415753397731 | (37.7916761076557, -122.415753397731) | 5 | 1 | 10 | 28858 | 21 | |||
142314 | 54212 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | 1 | 8 | 11 | 56 | 12 | |||
142467 | 34044 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | 8 | 4 | 7 | 28853 | 19 | ||
143802 | 110189 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||||
144851 | 52006 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1489 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48222 | 6011774.4965411 | 2101419.07057833 | 37.7507598806074 | -122.402110363809 | (37.7507598806074, -122.402110363809) | 10 | 3 | 8 | 28856 | 29 | ||||
145375 | 89007 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558 | 2104034 | 37.757590932481 | -122.42379349206 | (37.757590932481, -122.42379349206) | 2 | 4 | 5 | 28859 | 19 | ||
146369 | 98326 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5999516.2 | 2114621.9 | 37.7863197000983 | -122.445449719271 | (37.7863197000983, -122.445449719271) | 15 | 6 | 1 | 29490 | 31 | |||
146790 | 92634 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
146819 | 61862 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1208 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21902 | 6010270.34996768 | 2102167.49523516 | 37.7527308196896 | -122.407364615493 | (37.7527308196896, -122.407364615493) | 2 | 4 | 7 | 28859 | 19 | ||
147107 | 65629 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2555 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1990 12:00:00 AM | Permit Number 28537 | 6001294.02640189 | 2114543.2007519 | 37.7862049421015 | -122.439293267044 | (37.7862049421015, -122.439293267044) | 15 | 6 | 1 | 29490 | 27 | ||
147961 | 37258 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
148591 | 68862 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | 9 | 7 | 4 | 28861 | 40 | ||
148884 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
149383 | 66498 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29661 | 5999602.83353685 | 2114377.91240421 | 37.7856547189649 | -122.445132443034 | (37.7856547189649, -122.445132443034) | 15 | 6 | 1 | 29490 | 31 | ||
149548 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
149901 | 256348 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
150936 | 39756 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 430 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/2002 12:00:00 AM | Permit Number 45959 | 6003532.62268975 | 2103345.12328431 | 37.7555848966333 | -122.430748907314 | (37.7555848966333, -122.430748907314) | 2 | 4 | 5 | 28862 | 22 | ||
151604 | 63556 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2976 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1987 12:00:00 AM | Permit Number 24175 | 6008374.50243213 | 2103906.39946693 | 37.7573991642338 | -122.414043825233 | (37.7573991642338, -122.414043825233) | 2 | 4 | 7 | 28859 | 19 | ||
151945 | 34242 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.475125051391 | (37.7643605962692, -122.475125051391) | 11 | 8 | 3 | 56 | 12 | |||
153068 | 61699 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 31 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21698 | 6005220.93430093 | 2107630.2762583 | 37.7674464214018 | -122.425215098838 | (37.7674464214018, -122.425215098838) | 8 | 4 | 5 | 28853 | 19 | ||
153759 | 251232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
156461 | 61840 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | 10 | 4 | 7 | 28859 | 19 | ||
159407 | 61844 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21883 | 6010281.13947097 | 2102889.36180769 | 37.754713508851 | -122.40737818911 | (37.754713508851, -122.40737818911) | 10 | 4 | 7 | 28859 | 19 | ||
160772 | 53804 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2960 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1987 12:00:00 AM | Permit Number 24179 | 6008473.78716926 | 2103911.87952165 | 37.7574197871027 | -122.413700845672 | (37.7574197871027, -122.413700845672) | 2 | 4 | 7 | 28859 | 19 | ||
161700 | 52481 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | 2 | 7 | 7 | 28859 | 2 | ||
162404 | 63517 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3000 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 24127 | 6009328.3554345 | 2104544.08998515 | 37.7592036456391 | -122.410790045257 | (37.7592036456391, -122.410790045257) | 2 | 4 | 7 | 28859 | 19 | ||
162950 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
163617 | 89035 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
164581 | 61863 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1212 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | 3x3 | Permit Number 21903 | 6010271.5831249 | 2102145.16353886 | 37.7526695708202 | -122.407358776803 | (37.7526695708202, -122.407358776803) | 2 | 4 | 7 | 28859 | 19 | |
165008 | 98682 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
165070 | 61939 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 164 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 21996 | 6005456.24511446 | 2100234.96738966 | 37.7471539235553 | -122.423875267065 | (37.7471539235553, -122.423875267065) | 2 | 7 | 5 | 28859 | 22 | ||
165390 | 62781 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.439430065931 | (37.7234257900447, -122.439430065931) | 9 | 7 | 6 | 28861 | 25 | ||
165636 | 101683 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 16 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993140 | 2098173 | 37.7407892854016 | -122.466313673169 | (37.7407892854016, -122.466313673169) | 1 | 8 | 4 | 59 | 40 | ||||
165711 | 122685 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006053 | 2111262 | 37.7774652336961 | -122.422595193091 | (37.7774652336961, -122.422595193091) | 7 | 9 | 11 | 28852 | 10 | ||||
169851 | 68983 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2377 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32973 | 5999960.55241622 | 2119841.40083737 | 37.8006764299942 | -122.444287600709 | (37.8006764299942, -122.444287600709) | 13 | 9 | 1 | 57 | 17 | ||
171918 | 89036 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
172933 | 62092 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | 10 | 3 | 8 | 28856 | 29 | ||
173064 | 67985 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 212 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31709 | 5996176.45016211 | 2090576.83582112 | 37.7201067800111 | -122.455266009291 | (37.7201067800111, -122.455266009291) | 9 | 8 | 6 | 28861 | 24 | ||
174197 | 37544 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 825 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | 13 | 1 | 9 | 28858 | 36 | ||
174575 | 35620 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 271 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38974 | 6005958.6690018 | 2115368.0219754 | 37.7887340389887 | -122.423213457259 | (37.7887340389887, -122.423213457259) | 13 | 9 | 1 | 28858 | 41 | |||
174750 | 59021 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1988 12:00:00 AM | Permit Number 25608 | 6005536.1099439 | 2104041.86258252 | 37.75761128554 | -122.423869755917 | (37.75761128554, -122.423869755917) | 2 | 4 | 5 | 28859 | 19 | ||
174910 | 67008 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | 9 | 8 | 6 | 28861 | 24 | ||
175127 | 68799 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045273 | -122.469175702533 | (37.742239045273, -122.469175702533) | 1 | 8 | 4 | 29491 | 40 | ||
175755 | 62091 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1401 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22178 | 6013163.83149517 | 2106111.21456306 | 37.7637209341904 | -122.397634949335 | (37.7637209341904, -122.397634949335) | 14 | 3 | 8 | 28856 | 29 | ||
177165 | 109994 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
177487 | 105874 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
178028 | 37164 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3555 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.7479820345383 | -122.420875232711 | (37.7479820345383, -122.420875232711) | 2 | 4 | 7 | 28859 | 2 | ||
179487 | 66500 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 3x3 | Permit Number 29663 | 6005806 | 2115518 | 37.7891372243478 | -122.423752338781 | (37.7891372243478, -122.423752338781) | 13 | 9 | 1 | 28858 | 41 | |
180329 | 62785 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23141 | 6000686.30847209 | 2091752.62403135 | 37.7235929509131 | -122.43976124489 | (37.7235929509131, -122.43976124489) | 9 | 7 | 6 | 28861 | 25 | ||
181135 | 33186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | 1 | 5 | 4 | 59 | 40 | ||
181602 | 60022 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 64 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | 6 | 2 | 9 | 28856 | 6 | ||
183933 | 37549 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | 5 | 1 | 10 | 28852 | 36 | ||
184447 | 61841 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.407434066583 | (37.7552975843096, -122.407434066583) | 10 | 4 | 7 | 28859 | 19 | ||
185308 | 65177 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27158 | 6002678.99460756 | 2090431.51316854 | 37.7200786982312 | -122.43277855471 | (37.7200786982312, -122.43277855471) | 9 | 7 | 6 | 28861 | 5 | ||
185483 | 32771 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.7743183510223 | -122.440968898129 | (37.7743183510223, -122.440968898129) | 15 | 5 | 11 | 29492 | 10 | ||
186136 | 62787 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.7235390694702 | -122.440231199397 | (37.7235390694702, -122.440231199397) | 9 | 7 | 6 | 28861 | 25 | ||
186317 | 111081 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2811 14TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992341 | 2097126 | 37.7378683540452 | -122.469000113007 | (37.7378683540452, -122.469000113007) | 1 | 8 | 4 | 59 | 40 | ||||
187349 | 67005 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | 9 | 8 | 6 | 28861 | 24 | ||
189254 | 31669 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | 10 | 3 | 8 | 309 | 1 | |||
190312 | 62706 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23046 | 6007274.51894323 | 2119093.66115296 | 37.7990378895325 | -122.418925141627 | (37.7990378895325, -122.418925141627) | 5 | 1 | 10 | 28858 | 32 | ||
190472 | 60025 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 155 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.394449015999 | (37.7813091831039, -122.394449015999) | 6 | 2 | 9 | 28856 | 6 | ||
190561 | 58421 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 68 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1979 12:00:00 AM | 6x3.5 | Permit Number 17560 | 5999339.95243749 | 2107930.01507988 | 37.7679354379891 | -122.445578100195 | (37.7679354379891, -122.445578100195) | 15 | 5 | 11 | 29492 | 9 | ||
191231 | 101261 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989742 | 2106485 | 37.7634151902649 | -122.478670277794 | (37.7634151902649, -122.478670277794) | 1 | 8 | 3 | 56 | 35 | ||||
191692 | 121621 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
192754 | 66835 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.7888240893158 | -122.41198018251 | (37.7888240893158, -122.41198018251) | 5 | 1 | 10 | 28858 | 21 | ||
192971 | 64518 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 512 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | Permit Number 25400 | 6000652.29265662 | 2110712.76052634 | 37.7756509932088 | -122.441238559661 | (37.7756509932088, -122.441238559661) | 15 | 5 | 11 | 29492 | 10 | ||
193216 | 68829 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | 9 | 7 | 4 | 63 | 40 | ||
193809 | 109820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
193853 | 256349 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 28 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
194010 | 120978 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
59010 | 226690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 San Bruno Ave | 0 | Front Yard : Yard | Tree | Private 2 | 0 | 6011227.79267 | 2101285.4147 | 37.7503623610541 | -122.403991519419 | (37.7503623610541, -122.403991519419) | 10 | 4 | 8 | 28859 | 19 | ||||
19846 | 207404 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.7377529144574 | -122.472028548874 | (37.7377529144574, -122.472028548874) | 1 | 8 | 4 | 29491 | 40 | |||
28641 | 129576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2434 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000800.62837 | 2116707.95572 | 37.7921207075545 | -122.441155660304 | (37.7921207075545, -122.441155660304) | 13 | 6 | 1 | 29490 | 27 | |||
34581 | 207899 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991539.23475 | 2097072.64748 | 37.7376755044258 | -122.471768293171 | (37.7376755044258, -122.471768293171) | 1 | 8 | 4 | 29491 | 40 | |||
37244 | 177142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.7127032044557 | -122.434632613123 | (37.7127032044557, -122.434632613123) | 9 | 7 | 6 | 28861 | 5 | |||
46976 | 227396 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005864.94303 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | 2 | 7 | 5 | 28859 | 22 | |||
52763 | 207897 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991557.6312 | 2097072.51432 | 37.7376762031927 | -122.471704678736 | (37.7376762031927, -122.471704678736) | 1 | 8 | 4 | 29491 | 40 | |||
53929 | 207403 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2692 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991464.82157 | 2097093.68289 | 37.7377289565351 | -122.472027105478 | (37.7377289565351, -122.472027105478) | 1 | 8 | 4 | 29491 | 40 | |||
66551 | 227287 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 689 29th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6002120.49007 | 2098829.19814 | 37.7431051297892 | -122.435309486038 | (37.7431051297892, -122.435309486038) | 2 | 7 | 5 | 63 | 7 | ||||
82424 | 207896 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991566.32683 | 2097072.84008 | 37.7376776007508 | -122.471674637797 | (37.7376776007508, -122.471674637797) | 1 | 8 | 4 | 29491 | 40 | |||
92012 | 182589 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | 1 | 8 | 3 | 29491 | 35 | |||
102984 | 102084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) | 11 | 6 | 2 | 54 | 26 |
123526 | 207938 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 168 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994463.39444 | 2096391.82051 | 37.7359748783422 | -122.461608798622 | (37.7359748783422, -122.461608798622) | 9 | 8 | 4 | 59 | 40 | |||
133788 | 226727 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3659 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005821.54325 | 2104299.58334 | 37.7583350362637 | -122.422900926445 | (37.7583350362637, -122.422900926445) | 2 | 4 | 5 | 28859 | 19 | |||
134547 | 47892 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | 15 | 5 | 11 | 29490 | 16 | |
138357 | 207898 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | 1 | 8 | 4 | 29491 | 40 | |||
141228 | 191435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1310 Indiana St | 1 | : Yard | Tree | Private 2 | 1 | 6014946.60084 | 2102566.45751 | 37.7540869042097 | -122.391221052827 | (37.7540869042097, -122.391221052827) | 10 | 3 | 8 | 28856 | 29 |
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) );