Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
| 171311 | 171311 | 67223 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | |
| 70184 | 70184 | 67244 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.50757954173599 | (37.7772032645806, -122.507579541736) | |
| 70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
| 50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
| 154101 | 154101 | 62594 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.8986299997 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | |
| 159008 | 159008 | 62593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.2368799997 | 37.7750775975018 | -122.49734715750401 | (37.7750775975018, -122.497347157504) | |
| 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) | ||
| 64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
| 41938 | 41938 | 62597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.49730988283301 | (37.7744677278845, -122.497309882833) | |
| 65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
| 57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 158754 | 158754 | 67388 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | |
| 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) |
| 34069 | 34069 | 61665 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | Permit Number 21661 | 5992088.12386 | 2114525.07918 | 37.78562701181829 | -122.47114165946199 | (37.7856270118183, -122.471141659462) | |
| 44656 | 44656 | 61666 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 182 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 10 | Permit Number 21662 | 5992143.35704 | 2114256.7455 | 37.7848934361496 | -122.470931016199 | (37.7848934361496, -122.470931016199) | |
| 54141 | 54141 | 67725 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.763082557956295 | -122.470451434039 | (37.7630825579563, -122.470451434039) | ||
| 89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
| 19690 | 19690 | 69083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.761827789630104 | -122.470363712817 | (37.7618277896301, -122.470363712817) |
| 174916 | 174916 | 61663 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.9849400003 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) |
| 57084 | 57084 | 59130 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | |
| 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) | ||
| 32183 | 32183 | 36981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39606 | 5993043.99125 | 2113791.1250299998 | 37.783667016157295 | -122.46778126318199 | (37.7836670161573, -122.467781263182) | |
| 104072 | 104072 | 65909 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1371 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28918 | 5994237.48770801 | 2106190.93763502 | 37.762867761658605 | -122.46310061891899 | (37.7628677616586, -122.463100618919) | ||
| 146966 | 146966 | 30911 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34732 | 5994801.07425 | 2091932.47974 | 37.7237500448081 | -122.460118346802 | (37.7237500448081, -122.460118346802) | |
| 28719 | 28719 | 65929 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 35 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28948 | 5995849.4697199995 | 2114245.46982 | 37.7850761197315 | -122.45810832997 | (37.7850761197315, -122.45810832997) | |
| 167683 | 167683 | 65928 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 41 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 4 | Permit Number 28947 | 5995850.771380001 | 2114206.39787 | 37.7849689134171 | -122.45810099794 | (37.7849689134171, -122.45810099794) | |
| 60857 | 60857 | 65931 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 115 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 7 | Permit Number 28950 | 5995872.00692 | 2113664.41853 | 37.7834820032566 | -122.45798829440201 | (37.7834820032566, -122.457988294402) | |
| 45437 | 45437 | 71814 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 68 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/1990 12:00:00 AM | 18 | 5995915.832219999 | 2114038.69637 | 37.7845121880339 | -122.45786376992201 | (37.7845121880339, -122.457863769922) | ||
| 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) | ||
| 47966 | 47966 | 65893 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 116 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 9 | Permit Number 28900 | 5995931.63622 | 2113606.82428 | 37.7833272906212 | -122.457777832601 | (37.7833272906212, -122.457777832601) | |
| 156275 | 156275 | 65934 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 150 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 7 | Permit Number 28953 | 5995941.68563 | 2113369.58328 | 37.782676467432 | -122.45772589379801 | (37.782676467432, -122.457725893798) | |
| 129940 | 129940 | 65896 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 152 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 6 | Permit Number 28903 | 5995943.06706 | 2113318.17907 | 37.7825354045306 | -122.457717393964 | (37.7825354045306, -122.457717393964) | |
| 179367 | 179367 | 65899 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 166 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28906 | 5995945.57364 | 2113203.14409 | 37.782219693115394 | -122.45770039603998 | (37.7822196931154, -122.45770039604) | |
| 59630 | 59630 | 65900 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 168 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28907 | 5995947.205130001 | 2113189.79047 | 37.782183121353896 | -122.457693785315 | (37.7821831213539, -122.457693785315) | |
| 35039 | 35039 | 65901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 180 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1990 12:00:00 AM | 11 | Permit Number 28908 | 5995949.76859 | 2113077.47191 | 37.7818748717492 | -122.457676787407 | (37.7818748717492, -122.457676787407) | |
| 44078 | 44078 | 66992 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.721336430114796 | -122.457251654811 | (37.7213364301148, -122.457251654811) | ||
| 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) | ||
| 104680 | 104680 | 67018 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | ||
| 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) | ||
| 52188 | 52188 | 36155 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.1283 | 2114145.8086 | 37.784842652821496 | -122.45568053932399 | (37.7848426528215, -122.455680539324) | |
| 179791 | 179791 | 36154 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.8051 | 2114133.6254 | 37.7848092398389 | -122.45567731688699 | (37.7848092398389, -122.455677316887) | |
| 50348 | 50348 | 36156 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996550.482000001 | 2114121.4423 | 37.7847758271364 | -122.455674094114 | (37.7847758271364, -122.455674094114) | |
| 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) | ||
| 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) | ||
| 138046 | 138046 | 66383 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 73 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | Permit Number 29509 | 5997500.2628 | 2113257.2822 | 37.782457530461 | -122.452325802952 | (37.782457530461, -122.452325802952) | |
| 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) | ||
| 79967 | 79967 | 67901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175004 | -122.45122163283001 | (37.729148458175, -122.45122163283) | ||
| 51284 | 51284 | 31133 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 212 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 12 | Permit Number 34848 | 5997464.63581 | 2094208.8725700001 | 37.7301533239181 | -122.451074988218 | (37.7301533239181, -122.451074988218) | |
| 76042 | 76042 | 70030 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | ||
| 107291 | 107291 | 58390 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.44875969912201 | (37.7290972609549, -122.448759699122) | ||
| 176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
| 134922 | 134922 | 31105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.3076400002 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | |
| 5410 | 5410 | 41173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.7499700002 | 37.801161655947396 | -122.446569707626 | (37.8011616559474, -122.446569707626) | |
| 93483 | 93483 | 68881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | ||
| 96628 | 96628 | 67501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | ||
| 91213 | 91213 | 68860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.554712901 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | ||
| 114292 | 114292 | 98326 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5999516.2 | 2114621.9 | 37.786319700098296 | -122.445449719271 | (37.7863197000983, -122.445449719271) | |||
| 110734 | 110734 | 68862 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | ||
| 52162 | 52162 | 66502 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1631 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29665 | 5999570.2909 | 2114608.6731 | 37.7862864702045 | -122.445261627973 | (37.7862864702045, -122.445261627973) | |
| 186959 | 186959 | 66501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | |
| 164215 | 164215 | 62019 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1617 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29660 | 5999580.2026 | 2114540.2826 | 37.7860992534846 | -122.445222417327 | (37.7860992534846, -122.445222417327) | |
| 165245 | 165245 | 62020 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1615 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 9 | Permit Number 29670 | 5999582.1849 | 2114512.53 | 37.786023165226496 | -122.44521356308901 | (37.7860231652265, -122.445213563089) | |
| 111064 | 111064 | 66498 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29661 | 5999602.83353685 | 2114377.91240421 | 37.7856547189649 | -122.445132443034 | (37.7856547189649, -122.445132443034) | ||
| 78044 | 78044 | 68850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | ||
| 97232 | 97232 | 66503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1700X LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 6 | 3x3 | Permit Number 29666 | 5999626.0 | 2114704.0 | 37.7865513928089 | -122.445075745226 | (37.7865513928089, -122.445075745226) |
| 59917 | 59917 | 66499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1608 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 12 | Permit Number 29662 | 5999635.4257 | 2114496.7899 | 37.7859829858425 | -122.445028233013 | (37.7859829858425, -122.445028233013) | |
| 56944 | 56944 | 68985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.0114700003 | 37.804602105955404 | -122.44453584225 | (37.8046021059554, -122.44453584225) | |
| 30079 | 30079 | 65628 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1330 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | Permit Number 28536 | 5999777.227000001 | 2113475.6396 | 37.783187264222796 | -122.44446422560301 | (37.7831872642228, -122.444464225603) | |
| 93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | ||
| 84112 | 84112 | 68819 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.44437438127702 | (37.729117226145, -122.444374381277) | ||
| 104091 | 104091 | 37584 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40015 | 5999640.19520847 | 2104544.9581721 | 37.75865805116221 | -122.44429631061199 | (37.7586580511622, -122.444296310612) | ||
| 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) | ||
| 60821 | 60821 | 68981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2365 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 6 | Permit Number 32971 | 6000015.55575 | 2119854.08532 | 37.8007143961175 | -122.444098179086 | (37.8007143961175, -122.444098179086) | |
| 97971 | 97971 | 62791 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.44308579022301 | (37.7232016241068, -122.443085790223) | ||
| 129831 | 129831 | 33112 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2628 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37349 | 6000339.44764 | 2118557.8977900003 | 37.7971738812189 | -122.44288425081601 | (37.7971738812189, -122.442884250816) | |
| 107661 | 107661 | 64553 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 363 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25442 | 6000196.58694342 | 2110119.71759225 | 37.7739966786528 | -122.442772359687 | (37.7739966786528, -122.442772359687) | ||
| 36676 | 36676 | 65829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 9 | Permit Number 28819 | 6000416.29807 | 2119955.15085 | 37.8010147480994 | -122.442718709912 | (37.8010147480994, -122.442718709912) | |
| 5561 | 5561 | 63512 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1912 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 24121 | 6000303.945 | 2111684.2477 | 37.7782986006192 | -122.442513341395 | (37.7782986006192, -122.442513341395) |
| 45623 | 45623 | 65828 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 5 | Permit Number 28818 | 6000482.650780001 | 2119964.5331599996 | 37.8010442917326 | -122.44248977580601 | (37.8010442917326, -122.442489775806) | |
| 70598 | 70598 | 65826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | |
| 156948 | 156948 | 65824 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2261 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 7 | Permit Number 28814 | 6000527.32419 | 2119926.01796 | 37.800941085523 | -122.442332420517 | (37.800941085523, -122.442332420517) | |
| 187844 | 187844 | 64559 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.774506509156204 | -122.442246634385 | (37.7745065091562, -122.442246634385) | |
| 164136 | 164136 | 64560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1556 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 9 | Permit Number 25451 | 6000388.6712 | 2110305.5423 | 37.7745178548342 | -122.442121251164 | (37.7745178548342, -122.442121251164) | |
| 55221 | 55221 | 73723 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | ||
| 44989 | 44989 | 72175 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 9 | 6000606.57902 | 2119937.60106 | 37.80097740645329 | -122.44205899784201 | (37.8009774064533, -122.442058997842) | ||
| 26110 | 26110 | 64561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1542 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 10 | Permit Number 25452 | 6000444.413 | 2110313.5657 | 37.774543061584794 | -122.441929006028 | (37.7745430615848, -122.441929006028) | |
| 45147 | 45147 | 65822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | |
| 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) | |
| 34553 | 34553 | 71312 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2015 12:00:00 AM | 13 | 6000471.9495 | 2110316.0552 | 37.7745514662119 | -122.44183393088998 | (37.7745514662119, -122.44183393089) | ||
| 61002 | 61002 | 60588 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | |
| 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) | ||
| 96364 | 96364 | 62794 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | ||
| 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) | ||
| 104134 | 104134 | 62790 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | ||
| 82598 | 82598 | 62789 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.44101991790899 | (37.7234373055999, -122.441019917909) | ||
| 75056 | 75056 | 32770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | |
| 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) | ||
| 76450 | 76450 | 32769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) |
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");