trees
2,180 rows where qSpecies_id = 57 sorted by qLegalStatus_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▲ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83738 | 85306 | - 12 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.7892313094718 | -122.423120870526 | (37.7892313094718, -122.423120870526) | 13 | 9 | 1 | 28858 | 41 | |||
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
2171 | 61848 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | 2 | 4 | 7 | 28859 | 19 | ||
2396 | 61859 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | 8 | Permit Number 21899 | 6010253.66087773 | 2102459.66274806 | 37.75353211276 | -122.407442925811 | (37.75353211276, -122.407442925811) | 2 | 4 | 7 | 28859 | 19 | |
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | 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 | ||||
5540 | 64827 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 274 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | 2 | 7 | 5 | 63 | 22 | ||
6151 | 69083 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.7618277896301 | -122.470363712817 | (37.7618277896301, -122.470363712817) | 1 | 8 | 4 | 56 | 12 |
7016 | 61846 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | 2 | 4 | 7 | 28859 | 19 | ||
7581 | 9343 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6000760.2622834 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | 2 | 7 | 5 | 63 | 7 | |||
10830 | 67725 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.7630825579563 | -122.470451434039 | (37.7630825579563, -122.470451434039) | 1 | 8 | 11 | 56 | 12 | ||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
11770 | 61941 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 178 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 21999 | 6005366.58200406 | 2100230.03647017 | 37.7471353221182 | -122.424184964624 | (37.7471353221182, -122.424184964624) | 2 | 7 | 5 | 28859 | 22 | ||
13051 | 55532 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | 11 | 8 | 11 | 56 | 12 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
15480 | 59583 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4071 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1981 12:00:00 AM | Permit Number 18981 | 6002727.56027236 | 2101791.13153415 | 37.7512723603586 | -122.433422018052 | (37.7512723603586, -122.433422018052) | 2 | 4 | 5 | 28862 | 22 | ||
18528 | 66992 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.7213364301148 | -122.457251654811 | (37.7213364301148, -122.457251654811) | 9 | 8 | 6 | 28861 | 24 | ||
20975 | 68850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | 9 | 7 | 4 | 28861 | 40 | ||
21778 | 61936 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 145 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | Permit Number 21993 | 6005587.19063437 | 2100190.09001467 | 37.7470380920929 | -122.423419277525 | (37.7470380920929, -122.423419277525) | 2 | 7 | 5 | 28859 | 22 | |
22693 | 33770 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||||
23720 | 107959 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
23849 | 65924 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 86 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28940 | 5995916.1594989 | 2113912.59060771 | 37.784165954142 | -122.457853509092 | (37.784165954142, -122.457853509092) | 11 | 6 | 1 | 54 | 31 | ||
23984 | 12171 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
25015 | 54931 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | 2 | 7 | 5 | 63 | 22 | ||
25375 | 12330 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | 7 | 9 | 11 | 29490 | 41 | ||
25770 | 61942 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 22000 | 6005289.72791626 | 2100225.80996813 | 37.7471193773829 | -122.424450419529 | (37.7471193773829, -122.424450419529) | 2 | 7 | 5 | 28859 | 22 | ||
25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
26907 | 57576 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29580 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||
28411 | 34516 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 23 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.7471452669413 | -122.421634526851 | (37.7471452669413, -122.421634526851) | 2 | 7 | 5 | 28859 | 22 | ||
30250 | 59329 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602 | 2103242.41669988 | 37.7556191813831 | -122.411337245149 | (37.7556191813831, -122.411337245149) | 2 | 4 | 7 | 28859 | 19 | ||
30922 | 61857 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | 10 | 4 | 7 | 28859 | 19 | ||
30950 | 66558 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3726 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29744 | 6005466.23183665 | 2104329.54931664 | 37.7583972608009 | -122.424131882152 | (37.7583972608009, -122.424131882152) | 2 | 4 | 5 | 28859 | 19 | ||
32214 | 61853 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.7541263174163 | -122.407320968841 | (37.7541263174163, -122.407320968841) | 10 | 4 | 7 | 28859 | 19 | ||
32432 | 34780 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.7497820686377 | -122.414823157313 | (37.7497820686377, -122.414823157313) | 2 | 4 | 7 | 28859 | 19 | ||
32961 | 34389 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | 2 | 7 | 5 | 63 | 7 | ||
33758 | 101245 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
33830 | 12207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
34136 | 61855 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066 | (37.7540649402035, -122.40731493066) | 10 | 4 | 7 | 28859 | 19 | ||
34718 | 62107 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.7510248549528 | -122.419354081346 | (37.7510248549528, -122.419354081346) | 2 | 4 | 7 | 28859 | 19 | ||
35329 | 88365 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411 | (37.7707473776731, -122.44194989411) | 15 | 5 | 11 | 29492 | 9 | |||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
39157 | 114799 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
39700 | 20264 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
41391 | 68819 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.444374381277 | (37.729117226145, -122.444374381277) | 9 | 7 | 4 | 28861 | 40 | ||
41442 | 35152 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | 15 | 9 | 11 | 29492 | 10 | ||
41981 | 57660 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | 2 | 4 | 5 | 28862 | 3 | ||
42955 | 51053 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | 2 | 4 | 5 | 28862 | 22 | |||
43516 | 61858 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1150 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21898 | 6010250.43626462 | 2102515.61174925 | 37.7536855558022 | -122.40745802144 | (37.7536855558022, -122.40745802144) | 2 | 4 | 7 | 28859 | 19 | ||
43850 | 35726 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
44319 | 96882 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
44444 | 20277 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44808 | 20275 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44926 | 103602 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
45508 | 33769 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||||
46037 | 12311 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 959X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004793.556 | 2112123.84108 | 37.7797605037857 | -122.427013427347 | (37.7797605037857, -122.427013427347) | 7 | 9 | 11 | 29490 | 41 | |||
48518 | 96883 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
49882 | 62789 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.441019917909 | (37.7234373055999, -122.441019917909) | 9 | 7 | 6 | 28861 | 25 | ||
50736 | 25291 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000743.11246 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | 9 | 7 | 6 | 28861 | 25 | |||
51373 | 6003 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
52021 | 67901 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175 | -122.45122163283 | (37.729148458175, -122.45122163283) | 9 | 7 | 4 | 28861 | 40 | ||
52203 | 7963 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1840 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005718.27737 | 2116441.98594 | 37.7916693064652 | -122.424121585933 | (37.7916693064652, -122.424121585933) | 13 | 9 | 1 | 28858 | 27 | |||
52270 | 32821 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.437639271349 | (37.7526166065877, -122.437639271349) | 2 | 4 | 5 | 28862 | 22 | ||
52357 | 6001 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
53178 | 92842 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2009 12:00:00 AM | 3x3 | 6006883 | 2101475 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | 2 | 4 | 7 | 28859 | 19 | |||
53690 | 103610 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
57313 | 44826 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.406190163796 | (37.7120713475932, -122.406190163796) | 9 | 7 | 8 | 309 | 39 | |||
59132 | 10706 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 969X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2006 12:00:00 AM | 3 | 3X3 | 6005743.4978976 | 2103345.7544707 | 37.7557116405021 | -122.423103045309 | (37.7557116405021, -122.423103045309) | 2 | 4 | 5 | 28859 | 19 | ||
61346 | 63516 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3130 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 24125 | 6009013.02136045 | 2104526.43175215 | 37.7591374742847 | -122.411879378364 | (37.7591374742847, -122.411879378364) | 2 | 4 | 7 | 28859 | 19 | ||
61550 | 61695 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 9 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21694 | 6005214.10969137 | 2107753.44919209 | 37.7677842392376 | -122.425247470035 | (37.7677842392376, -122.425247470035) | 8 | 4 | 5 | 28853 | 19 | ||
61993 | 114798 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
65894 | 34773 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1130 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 7 | Permit Number 38414 | 6008029.42163869 | 2101336.50490812 | 37.7503234289999 | -122.41505535764 | (37.7503234289999, -122.41505535764) | 2 | 4 | 7 | 28859 | 19 | |
66748 | 61850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1078 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21889 | 6010226.10973791 | 2102942.52266102 | 37.7548563965432 | -122.407572245672 | (37.7548563965432, -122.407572245672) | 2 | 4 | 7 | 28859 | 19 | ||
66842 | 38432 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498 | (37.7895138928462, -122.45834869498) | 11 | 6 | 1 | 54 | 31 | |||
67128 | 20261 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 4 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
67353 | 98678 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 4 | 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 | ||||
68456 | 61845 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21884 | 6010284.24906681 | 2102833.32009511 | 37.7545598048232 | -122.407363484663 | (37.7545598048232, -122.407363484663) | 10 | 4 | 7 | 28859 | 19 | ||
68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | 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 | |||
68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | 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 | |||
69778 | 20266 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
70145 | 62207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1985 12:00:00 AM | Permit Number 22329 | 6001115.41413851 | 2093618.10384038 | 37.728739548363 | -122.438411493533 | (37.728739548363, -122.438411493533) | 9 | 7 | 6 | 28861 | 25 | ||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
71171 | 98681 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 7 | 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 | ||||
71710 | 98240 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
71975 | 63893 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435 | 2109828 | 37.7735493586958 | -122.421171875993 | (37.7735493586958, -122.421171875993) | 8 | 2 | 9 | 28853 | 19 | ||
72579 | 68787 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.7447761070514 | -122.470428661516 | (37.7447761070514, -122.470428661516) | 1 | 8 | 4 | 29491 | 40 | ||
72943 | 96884 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
74157 | 46271 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2002 12:00:00 AM | Permit Number 44555 | 6006560.87997001 | 2097281.80561087 | 37.739107504355 | -122.419846001297 | (37.739107504355, -122.419846001297) | 2 | 7 | 7 | 28859 | 2 | |||
74464 | 20263 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
75274 | 61933 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 127 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | 36 | Permit Number 21990 | 6005702.47179 | 2100196.42976905 | 37.7470620054932 | -122.423021095147 | (37.7470620054932, -122.423021095147) | 2 | 7 | 5 | 28859 | 22 | |
75292 | 20267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
75514 | 58120 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 839 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 17101 | 6003847.07815842 | 2110734.06414103 | 37.7758909552538 | -122.430188532102 | (37.7758909552538, -122.430188532102) | 7 | 9 | 11 | 29492 | 10 | ||
76573 | 61934 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | 6x12 | Permit Number 775576 | 6005635.57133528 | 2100244.82922864 | 37.747191123988 | -122.42325587148 | (37.747191123988, -122.42325587148) | 2 | 7 | 5 | 28859 | 22 |
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
78075 | 98679 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 5 | 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 | ||||
78795 | 102165 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) | 2 | 4 | 5 | 28862 | 3 |
79334 | 33772 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||
80424 | 110186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 2 | 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 | ||||
81077 | 61842 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.4074193619 | (37.7551438802467, -122.4074193619) | 10 | 4 | 7 | 28859 | 19 |
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) );