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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
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 | ||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
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 | ||
10883 | 62592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
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 | ||
16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
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 | ||
19574 | 261987 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599x Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014919 | 2092067 | 37.7252560234082 | -122.390582878929 | (37.7252560234082, -122.390582878929) | 10 | 3 | 8 | 58 | 1 | ||||
19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
20799 | 108149 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
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 | ||
21324 | 173925 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997414 | 2094357 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | 9 | 7 | 4 | 28861 | 40 | ||||
22668 | 251576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998892 | 2109203 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||
24777 | 121592 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002342 | 2100313 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | 2 | 4 | 5 | 63 | 22 | ||||
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 | ||
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 | ||
27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | 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 | |||
27836 | 99747 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002274 | 2100636 | 37.7480748999105 | -122.434907877013 | (37.7480748999105, -122.434907877013) | 2 | 4 | 5 | 28862 | 22 | ||||
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
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 | ||
29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | 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 | |||
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 | ||
31107 | 111019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | ||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
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 | ||
35312 | 251230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 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 | |||
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 | ||
43654 | 114877 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||||
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 | ||||
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 | ||
51837 | 113436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
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 | ||
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 | ||||
53881 | 254253 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Grove St | 1 | Front Yard : Yard | Tree | Private 2 | 6004708 | 2111182 | 37.777169601607 | -122.427242295103 | (37.777169601607, -122.427242295103) | 7 | 9 | 11 | 28852 | 10 | |||||
55964 | 105875 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 3 | 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 | ||||
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 | |||
57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | 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 | |||
58177 | 117520 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601 PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
58400 | 113437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
59499 | 114431 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2787 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000638 | 2114779 | 37.7868150321065 | -122.441579867848 | (37.7868150321065, -122.441579867848) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | ||||
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 | |||
67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||||
67747 | 255499 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1837 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998183 | 2109231 | 37.771441491369 | -122.449673611464 | (37.771441491369, -122.449673611464) | 15 | 5 | 11 | 29492 | 9 | ||||
68439 | 99103 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006380 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
69299 | 121398 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4098x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002425 | 2104765 | 37.7594207214866 | -122.434680934086 | (37.7594207214866, -122.434680934086) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
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 | ||
72925 | 116811 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3660x 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005401 | 2102665 | 37.7538231135776 | -122.42423909942 | (37.7538231135776, -122.42423909942) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | |||
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 | ||
77227 | 173926 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997414 | 2094357 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | 9 | 7 | 4 | 28861 | 40 |
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) );