Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
151681 | 151681 | 118454 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8350 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5981044.43167 | 2112373.0207700003 | 37.7790731383894 | -122.50918908645399 | (37.7790731383894, -122.509189086454) | ||||
72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
87632 | 87632 | 104648 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 833 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5997625.0 | 2107698.0 | 37.767200326764005 | -122.451493160886 | (37.767200326764, -122.451493160886) | ||||
150640 | 150640 | 248598 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 833 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997636.9186 | 2107601.8364 | 37.7669369685535 | -122.45144499969801 | (37.7669369685535, -122.451444999698) | |||
73104 | 73104 | 200264 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014856.837309999 | 2088987.16565 | 37.716795957049996 | -122.390582658263 | (37.71679595705, -122.390582658263) | |||
134358 | 134358 | 200263 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014881.06262 | 2088948.3619 | 37.7166907534629 | -122.39049621274799 | (37.7166907534629, -122.390496212748) | |||
150577 | 150577 | 191133 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 827 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012775.54197 | 2103646.6748599997 | 37.7569322215662 | -122.398804956499 | (37.7569322215662, -122.398804956499) | |||
52705 | 52705 | 245961 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997192.3655 | 2107614.858 | 37.7669472561331 | -122.452983569947 | (37.7669472561331, -122.452983569947) | |||
171735 | 171735 | 245960 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997194.7881 | 2107596.3855 | 37.7668966742107 | -122.45297385706002 | (37.7668966742107, -122.45297385706) | |||
69341 | 69341 | 227807 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5999163.0579699995 | 2107440.67936 | 37.7665817447879 | -122.44615475326201 | (37.7665817447879, -122.446154753262) | |||
106233 | 106233 | 58432 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17579 | 5999154.89175324 | 2107511.77145677 | 37.7667764794344 | -122.44618811299601 | (37.7667764794344, -122.446188112996) | |||
34010 | 34010 | 123582 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5994285.08275 | 2115071.4711700003 | 37.7872540838992 | -122.463580543309 | (37.7872540838992, -122.463580543309) | |||
106871 | 106871 | 59867 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1981 12:00:00 AM | 10 | Permit Number 19326 | 5994285.52331 | 2115052.43823 | 37.7872018500152 | -122.463577637239 | (37.7872018500152, -122.463577637239) | ||
180981 | 180981 | 123583 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994285.44541 | 2115062.1508 | 37.7872285135982 | -122.46357861191002 | (37.7872285135982, -122.46357861191) | |||
88746 | 88746 | 11784 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 810X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991252.992504 | 2092079.9575241 | 37.7239502662313 | -122.472394094235 | (37.7239502662313, -122.472394094235) | ||
130730 | 130730 | 227714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 810 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998667.9308400005 | 2107484.0655799997 | 37.7666725844083 | -122.447870427698 | (37.7666725844083, -122.447870427698) | |||
132081 | 132081 | 227715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 810 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998667.5284 | 2107500.97988 | 37.7667190037984 | -122.447873037525 | (37.7667190037984, -122.447873037525) | |||
157953 | 157953 | 227716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 810 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998663.42523 | 2107521.35267 | 37.7667747077998 | -122.447888696528 | (37.7667747077998, -122.447888696528) | |||
186000 | 186000 | 227717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 810 Clayton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998661.93056 | 2107540.16812 | 37.7668262848355 | -122.447895221086 | (37.7668262848355, -122.447895221086) | |||
108678 | 108678 | 102936 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80X Julian Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006373.3 | 2107441.5 | 37.7669931200198 | -122.421215808838 | (37.7669931200198, -122.421215808838) | |||
114209 | 114209 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
158837 | 158837 | 227965 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 801 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010184.43875 | 2104508.21043 | 37.7591530919555 | -122.40782675382201 | (37.7591530919555, -122.407826753822) | |||
41327 | 41327 | 140552 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x WEBSTER ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6003932.6516 | 2111661.4845 | 37.7784422689986 | -122.429958681781 | (37.7784422689986, -122.429958681781) | |||
70273 | 70273 | 140551 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x WEBSTER ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6003947.0899 | 2111598.2308 | 37.778269407656495 | -122.42990422118 | (37.7782694076565, -122.42990422118) | |||
25223 | 25223 | 208086 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991357.47228 | 2092905.4597099999 | 37.7262229367261 | -122.472093069866 | (37.7262229367261, -122.472093069866) | |||
38457 | 38457 | 208084 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991354.011469999 | 2092835.9648 | 37.726031920722605 | -122.47209997035 | (37.7260319207226, -122.47209997035) | |||
150230 | 150230 | 208085 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991358.2999 | 2092881.5903900003 | 37.726157445407296 | -122.47208846980301 | (37.7261574454073, -122.472088469803) | |||
890 | 890 | 23729 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.42991768322901 | (37.7783296231018, -122.429917683229) | ||
6262 | 6262 | 23731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6003929.9014 | 2111682.7982 | 37.7785006353915 | -122.429969716521 | (37.7785006353915, -122.429969716521) | |||
6398 | 6398 | 23727 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003949.8401 | 2111575.542 | 37.7782072655707 | -122.429893088415 | (37.7782072655707, -122.429893088415) | ||
7325 | 7325 | 23732 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6003928.5263 | 2111708.2372 | 37.7785704067109 | -122.429976288631 | (37.7785704067109, -122.429976288631) | |||
18117 | 18117 | 11765 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991272.34511 | 2091581.45548 | 37.7225826231682 | -122.47229087392 | (37.7225826231682, -122.47229087392) | ||
20128 | 20128 | 11766 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991273.54078 | 2091606.60865 | 37.72265175674929 | -122.47228857348101 | (37.7226517567493, -122.472288573481) | ||
21942 | 21942 | 11767 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991276.05264 | 2091631.0711599998 | 37.7227190701221 | -122.472281672976 | (37.7227190701221, -122.472281672976) | ||
123544 | 123544 | 95666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 800 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
37582 | 37582 | 208152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80 Nordhoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000435.90571 | 2095588.3603299998 | 37.7341107411125 | -122.44090187344999 | (37.7341107411125, -122.44090187345) | |||
73467 | 73467 | 227539 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6006384.70017 | 2107452.44319 | 37.7670238101177 | -122.421177154504 | (37.7670238101177, -122.421177154504) | |||
113595 | 113595 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 HIGUERA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
75672 | 75672 | 227962 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6005350.15285 | 2103584.35946 | 37.7563445892338 | -122.42448033021999 | (37.7563445892338, -122.42448033022) | |||
66990 | 66990 | 245930 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997897.9572 | 2107873.0198 | 37.7676965134568 | -122.45056166580099 | (37.7676965134568, -122.450561665801) | |||
77005 | 77005 | 69406 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 791 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33510 | 6002424.30927 | 2087088.10255 | 37.7108839820803 | -122.43342011837 | (37.7108839820803, -122.43342011837) | |
95218 | 95218 | 33847 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
98836 | 98836 | 33838 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
115034 | 115034 | 33841 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
124510 | 124510 | 33843 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
124554 | 124554 | 33846 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
141275 | 141275 | 33842 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
5701 | 5701 | 35451 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
6310 | 6310 | 35452 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
7488 | 7488 | 35443 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
7802 | 7802 | 35460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
8146 | 8146 | 35450 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
8797 | 8797 | 35455 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9539 | 9539 | 35456 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9554 | 9554 | 35448 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9594 | 9594 | 35445 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10262 | 10262 | 35446 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10483 | 10483 | 35442 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10753 | 10753 | 35454 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
11629 | 11629 | 35449 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
12085 | 12085 | 35458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
14341 | 14341 | 35444 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
14595 | 14595 | 35457 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
16105 | 16105 | 35453 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
16221 | 16221 | 35459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
17025 | 17025 | 35447 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
171446 | 171446 | 45471 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44250 | 5987593.6437099995 | 2110560.6661900003 | 37.7744808674341 | -122.48639989849501 | (37.7744808674341, -122.486399898495) | |
2568 | 2568 | 227812 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.44548913263701 | (37.765232827359, -122.445489132637) | |||
1513 | 1513 | 251580 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | ||||
14627 | 14627 | 115035 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012851.17431 | 2112502.5973400003 | 37.781252811600794 | -122.39916500906601 | (37.7812528116008, -122.399165009066) | |||
66678 | 66678 | 115037 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | |||
167127 | 167127 | 115036 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012815.58198 | 2112468.56489 | 37.7811573827547 | -122.399285752038 | (37.7811573827547, -122.399285752038) | |||
54783 | 54783 | 115038 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 HARRISON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777510 | 6012725.0 | 2112521.0 | 37.7812963087062 | -122.399602805279 | (37.7812963087062, -122.399602805279) | |
164056 | 164056 | 248509 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 784 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999110.4849 | 2107801.0979 | 37.767568360809705 | -122.44636252424 | (37.7675683608097, -122.44636252424) | |||
103617 | 103617 | 15137 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 780X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6011914.84635 | 2114325.58433 | 37.7862060830296 | -122.40253249015801 | (37.7862060830296, -122.402532490158) | |||
73021 | 73021 | 227798 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5997129.95127 | 2106058.68083 | 37.762670813522604 | -122.453087101682 | (37.7626708135226, -122.453087101682) | |||
160654 | 160654 | 227797 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5997131.78555 | 2106048.44481 | 37.762642813136 | -122.453080018655 | (37.762642813136, -122.453080018655) | |||
46626 | 46626 | 59336 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 775 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31976 | 5982585.1174 | 2110516.14744 | 37.774065420371706 | -122.50372176444999 | (37.7740654203717, -122.50372176445) | ||
50881 | 50881 | 191138 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011596.13889 | 2113930.29234 | 37.7851029064102 | -122.403607318248 | (37.7851029064102, -122.403607318248) | |||
14635 | 14635 | 15136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 766 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2008 12:00:00 AM | 3 | 3x3 | 6011623.78991 | 2113963.56505 | 37.7851958099766 | -122.40351399557699 | (37.7851958099766, -122.403513995577) | ||
184120 | 184120 | 191139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011643.5293 | 2113893.61304 | 37.7850048407399 | -122.403440779973 | (37.7850048407399, -122.403440779973) | |||
45512 | 45512 | 59134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | 7x7 | Permit Number 18439 | 5992554.02664 | 2110259.06028 | 37.7739406226936 | -122.469219178519 | (37.7739406226936, -122.469219178519) | |
111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
142779 | 142779 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
149194 | 149194 | 191140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 761 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011668.442480001 | 2113913.34766 | 37.7850604188475 | -122.40335597660801 | (37.7850604188475, -122.403355976608) | |||
133746 | 133746 | 248490 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 761 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998568.8751 | 2107887.5556 | 37.7677748035101 | -122.448242100604 | (37.7677748035101, -122.448242100604) | |||
177099 | 177099 | 248491 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 761 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998570.692000001 | 2107873.0198 | 37.767734995757706 | -122.44823476937701 | (37.7677349957577, -122.448234769377) | |||
34401 | 34401 | 248476 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 757 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998566.1496 | 2107908.4508 | 37.767832020618 | -122.44825303255101 | (37.767832020618, -122.448253032551) | |||
40953 | 40953 | 245956 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 753 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997593.1598 | 2107917.3843 | 37.76780087666 | -122.45161911748 | (37.76780087666, -122.45161911748) | |||
151190 | 151190 | 248471 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 753 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998562.8185 | 2107931.7687 | 37.7678958552223 | -122.448266233683 | (37.7678958552223, -122.448266233683) | |||
93415 | 93415 | 32851 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 752 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 6 | Permit Number 38103 | 6001544.36482173 | 2102066.64624639 | 37.7519616591584 | -122.437533360465 | (37.7519616591584, -122.437533360465) | |
180813 | 180813 | 227843 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 752 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001510.70701 | 2102061.19954 | 37.7519447901408 | -122.437649363754 | (37.7519447901408, -122.437649363754) | |||
50162 | 50162 | 32664 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
81868 | 81868 | 32668 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
85965 | 85965 | 32663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
101973 | 101973 | 32666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
116718 | 116718 | 32665 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
123994 | 123994 | 32669 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) |
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");