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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114705 | 114705 | 39756 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 430 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/2002 12:00:00 AM | Permit Number 45959 | 6003532.62268975 | 2103345.12328431 | 37.755584896633295 | -122.430748907314 | (37.7555848966333, -122.430748907314) | ||
| 114867 | 114867 | 37258 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 115141 | 115141 | 110189 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 116061 | 116061 | 67902 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31604 | 5997414.89563577 | 2093860.91507447 | 37.7291950674434 | -122.451221861234 | (37.7291950674434, -122.451221861234) | ||
| 116161 | 116161 | 34044 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 116452 | 116452 | 63556 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2976 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1987 12:00:00 AM | Permit Number 24175 | 6008374.50243213 | 2103906.39946693 | 37.757399164233796 | -122.41404382523301 | (37.7573991642338, -122.414043825233) | ||
| 116688 | 116688 | 101683 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993140.0 | 2098173.0 | 37.740789285401604 | -122.466313673169 | (37.7407892854016, -122.466313673169) | ||||
| 116737 | 116737 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 116895 | 116895 | 68983 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2377 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32973 | 5999960.55241622 | 2119841.40083737 | 37.800676429994205 | -122.444287600709 | (37.8006764299942, -122.444287600709) | ||
| 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) | ||||
| 118036 | 118036 | 61939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 21996 | 6005456.24511446 | 2100234.96738966 | 37.747153923555295 | -122.42387526706499 | (37.7471539235553, -122.423875267065) | ||
| 118055 | 118055 | 63517 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3000 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24127 | 6009328.3554345 | 2104544.08998515 | 37.7592036456391 | -122.410790045257 | (37.7592036456391, -122.410790045257) | ||
| 118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
| 118809 | 118809 | 61863 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1212 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | 3x3 | Permit Number 21903 | 6010271.5831249 | 2102145.16353886 | 37.7526695708202 | -122.407358776803 | (37.7526695708202, -122.407358776803) | |
| 118858 | 118858 | 53804 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2960 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1987 12:00:00 AM | Permit Number 24179 | 6008473.78716926 | 2103911.87952165 | 37.757419787102705 | -122.413700845672 | (37.7574197871027, -122.413700845672) | ||
| 119329 | 119329 | 62781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.43943006593099 | (37.7234257900447, -122.439430065931) | ||
| 120391 | 120391 | 61844 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21883 | 6010281.13947097 | 2102889.36180769 | 37.754713508851 | -122.40737818911 | (37.754713508851, -122.40737818911) | ||
| 120523 | 120523 | 61840 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | ||
| 120775 | 120775 | 89035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 121146 | 121146 | 52481 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | ||
| 121186 | 121186 | 62592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | ||
| 121210 | 121210 | 111020 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 121711 | 121711 | 61699 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 31 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21698 | 6005220.93430093 | 2107630.2762583 | 37.76744642140179 | -122.42521509883801 | (37.7674464214018, -122.425215098838) | ||
| 122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 123474 | 123474 | 64827 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 274 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | ||
| 123597 | 123597 | 104004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.46852139722701 | (37.7475310970527, -122.468521397227) | |||||
| 124245 | 124245 | 34780 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.74978206863771 | -122.41482315731301 | (37.7497820686377, -122.414823157313) | ||
| 124281 | 124281 | 59329 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602005 | 2103242.41669988 | 37.755619181383096 | -122.411337245149 | (37.7556191813831, -122.411337245149) | ||
| 124316 | 124316 | 109993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 124552 | 124552 | 33770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 124780 | 124780 | 34389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | ||
| 125956 | 125956 | 40954 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | ||||
| 125971 | 125971 | 108151 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 126062 | 126062 | 65924 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 86 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28940 | 5995916.1594989 | 2113912.59060771 | 37.784165954142 | -122.457853509092 | (37.784165954142, -122.457853509092) | ||
| 126839 | 126839 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 127035 | 127035 | 117422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992487.0 | 2088224.0 | 37.713434088528295 | -122.467848042178 | (37.7134340885283, -122.467848042178) | ||||
| 127629 | 127629 | 60032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004008999 | (37.7817828574395, -122.39203004009) | ||
| 127865 | 127865 | 61857 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | ||
| 127908 | 127908 | 61942 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 22000 | 6005289.72791626 | 2100225.80996813 | 37.7471193773829 | -122.424450419529 | (37.7471193773829, -122.424450419529) | ||
| 128169 | 128169 | 34516 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 23 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.747145266941295 | -122.42163452685101 | (37.7471452669413, -122.421634526851) | ||
| 128219 | 128219 | 66558 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3726 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29744 | 6005466.23183665 | 2104329.54931664 | 37.7583972608009 | -122.42413188215201 | (37.7583972608009, -122.424131882152) | ||
| 128257 | 128257 | 113967 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.0 | 2107333.0 | 37.7669917162652 | -122.40292912289699 | (37.7669917162652, -122.402929122897) | ||||
| 128670 | 128670 | 122343 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994723.0 | 2112183.0 | 37.7793483429351 | -122.461855927769 | (37.7793483429351, -122.461855927769) | ||||
| 129054 | 129054 | 101245 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
| 129161 | 129161 | 57576 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29580 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||
| 138452 | 138452 | 122685 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006053.0 | 2111262.0 | 37.777465233696105 | -122.422595193091 | (37.7774652336961, -122.422595193091) | ||||
| 138925 | 138925 | 37164 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3555 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.747982034538296 | -122.420875232711 | (37.7479820345383, -122.420875232711) | ||
| 139262 | 139262 | 111081 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2811 14TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992341.0 | 2097126.0 | 37.737868354045204 | -122.469000113007 | (37.7378683540452, -122.469000113007) | ||||
| 139428 | 139428 | 67005 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | ||
| 139903 | 139903 | 37549 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | ||
| 140523 | 140523 | 62091 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1401 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | Permit Number 22178 | 6013163.83149517 | 2106111.21456306 | 37.763720934190395 | -122.397634949335 | (37.7637209341904, -122.397634949335) | ||
| 140772 | 140772 | 32771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.774318351022295 | -122.440968898129 | (37.7743183510223, -122.440968898129) | ||
| 140777 | 140777 | 66500 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 3x3 | Permit Number 29663 | 6005806.0 | 2115518.0 | 37.7891372243478 | -122.423752338781 | (37.7891372243478, -122.423752338781) | |
| 140794 | 140794 | 33186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | ||
| 140867 | 140867 | 62785 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23141 | 6000686.30847209 | 2091752.62403135 | 37.7235929509131 | -122.43976124488998 | (37.7235929509131, -122.43976124489) | ||
| 140948 | 140948 | 111019 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 141019 | 141019 | 105874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 141136 | 141136 | 60022 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 64 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | ||
| 141672 | 141672 | 37544 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | ||
| 142205 | 142205 | 68799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045272996 | -122.469175702533 | (37.742239045273, -122.469175702533) | ||
| 142722 | 142722 | 62787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.723539069470206 | -122.44023119939699 | (37.7235390694702, -122.440231199397) | ||
| 142846 | 142846 | 67008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | ||
| 142889 | 142889 | 109994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 142944 | 142944 | 61841 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.40743406658301 | (37.7552975843096, -122.407434066583) | ||
| 143030 | 143030 | 59021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25608 | 6005536.1099439 | 2104041.86258252 | 37.75761128554 | -122.423869755917 | (37.75761128554, -122.423869755917) | ||
| 143097 | 143097 | 89036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 143161 | 143161 | 62092 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | ||
| 143521 | 143521 | 67985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 212 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31709 | 5996176.45016211 | 2090576.83582112 | 37.7201067800111 | -122.455266009291 | (37.7201067800111, -122.455266009291) | ||
| 143556 | 143556 | 35620 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 271 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38974 | 6005958.6690018 | 2115368.0219754 | 37.78873403898871 | -122.42321345725901 | (37.7887340389887, -122.423213457259) | |||
| 143643 | 143643 | 65177 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 573 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27158 | 6002678.99460756 | 2090431.51316854 | 37.7200786982312 | -122.43277855471001 | (37.7200786982312, -122.43277855471) | ||
| 144898 | 144898 | 31669 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | |||
| 145171 | 145171 | 120978 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007023.0 | 2113270.0 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | ||||
| 145291 | 145291 | 64518 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 512 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25400 | 6000652.29265662 | 2110712.76052634 | 37.77565099320879 | -122.441238559661 | (37.7756509932088, -122.441238559661) | ||
| 145562 | 145562 | 60025 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 155 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.39444901599899 | (37.7813091831039, -122.394449015999) | ||
| 145645 | 145645 | 62706 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23046 | 6007274.51894323 | 2119093.66115296 | 37.7990378895325 | -122.418925141627 | (37.7990378895325, -122.418925141627) | ||
| 145692 | 145692 | 58421 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 68 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1979 12:00:00 AM | 6x3.5 | Permit Number 17560 | 5999339.95243749 | 2107930.01507988 | 37.7679354379891 | -122.44557810019501 | (37.7679354379891, -122.445578100195) | ||
| 145747 | 145747 | 101261 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989742.0 | 2106485.0 | 37.763415190264894 | -122.478670277794 | (37.7634151902649, -122.478670277794) | ||||
| 146015 | 146015 | 68829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | ||
| 146054 | 146054 | 121621 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298X Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998141.0 | 2093851.0 | 37.72920939055871 | -122.44871095421401 | (37.7292093905587, -122.448710954214) | ||||
| 146055 | 146055 | 109820 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.779331512641896 | -122.42693096158101 | (37.7793315126419, -122.426930961581) | ||||
| 146257 | 146257 | 66835 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.788824089315796 | -122.41198018251 | (37.7888240893158, -122.41198018251) | ||
| 175263 | 175263 | 226690 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 San Bruno Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 0 | 6011227.792669999 | 2101285.4147 | 37.7503623610541 | -122.40399151941901 | (37.7503623610541, -122.403991519419) | ||||
| 32208 | 32208 | 207938 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 168 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994463.39444 | 2096391.8205099998 | 37.735974878342205 | -122.461608798622 | (37.7359748783422, -122.461608798622) | |||
| 33606 | 33606 | 207898 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | |||
| 38825 | 38825 | 186910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085206998 | (37.7362848611965, -122.49372085207) | |||
| 42940 | 42940 | 227287 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6002120.490069999 | 2098829.19814 | 37.74310512978921 | -122.435309486038 | (37.7431051297892, -122.435309486038) | ||||
| 45202 | 45202 | 129576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000800.62837 | 2116707.95572 | 37.792120707554496 | -122.44115566030399 | (37.7921207075545, -122.441155660304) | |||
| 60067 | 60067 | 207405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.745630001 | 2097109.88885 | 37.737773449589795 | -122.47202854890499 | (37.7377734495898, -122.472028548905) | |||
| 64682 | 64682 | 207404 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.737752914457396 | -122.472028548874 | (37.7377529144574, -122.472028548874) | |||
| 70555 | 70555 | 102084 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) |
| 72357 | 72357 | 177142 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.71270320445571 | -122.434632613123 | (37.7127032044557, -122.434632613123) | |||
| 73012 | 73012 | 207896 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991566.326830001 | 2097072.84008 | 37.7376776007508 | -122.471674637797 | (37.7376776007508, -122.471674637797) | |||
| 147156 | 147156 | 182589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | |||
| 155137 | 155137 | 226727 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3659 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005821.54325 | 2104299.5833400004 | 37.7583350362637 | -122.42290092644501 | (37.7583350362637, -122.422900926445) | |||
| 157262 | 157262 | 207897 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991557.6312 | 2097072.51432 | 37.7376762031927 | -122.471704678736 | (37.7376762031927, -122.471704678736) | |||
| 165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
| 166208 | 166208 | 207899 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991539.23475 | 2097072.6474799998 | 37.737675504425795 | -122.47176829317101 | (37.7376755044258, -122.471768293171) | |||
| 166303 | 166303 | 227396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 5 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005864.943030001 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | |||
| 174274 | 174274 | 47892 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | |
| 181511 | 181511 | 207403 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.82157 | 2097093.68289 | 37.7377289565351 | -122.472027105478 | (37.7377289565351, -122.472027105478) |
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");