Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
6803 | 6803 | 19590 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7231 | 7231 | 19588 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7407 | 7407 | 19591 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
12970 | 12970 | 19589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
105098 | 105098 | 30048 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
105889 | 105889 | 30047 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
146267 | 146267 | 30049 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
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) | |||
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) | |||
157992 | 157992 | 200265 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014784.79531 | 2089078.0954900002 | 37.7170416356268 | -122.390838025257 | (37.7170416356268, -122.390838025257) | |||
63521 | 63521 | 200266 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014773.14657 | 2089094.60205 | 37.7170863130726 | -122.39087944264999 | (37.7170863130726, -122.39087944265) | |||
26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
151014 | 151014 | 200268 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014637.958740001 | 2089223.7051900001 | 37.7174333029868 | -122.39135574608801 | (37.7174333029868, -122.391355746088) | |||
50356 | 50356 | 200269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014632.09061 | 2089229.7896900002 | 37.7174496841459 | -122.39137645477501 | (37.7174496841459, -122.391376454775) | |||
51688 | 51688 | 200270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014621.84489 | 2089234.87823 | 37.717463087626705 | -122.39141222532 | (37.7174630876267, -122.39141222532) | |||
34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
30755 | 30755 | 208080 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991162.63824 | 2089810.37082 | 37.7177133113937 | -122.472541042839 | (37.7177133113937, -122.472541042839) | |||
164766 | 164766 | 200273 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014418.93045 | 2089354.50359 | 37.7177802911084 | -122.392121973844 | (37.7177802911084, -122.392121973844) | |||
49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
109022 | 109022 | 29640 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
110556 | 110556 | 29641 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
144121 | 144121 | 29639 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
42602 | 42602 | 208081 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991233.74878 | 2090918.35178 | 37.720759670396106 | -122.47237597496999 | (37.7207596703961, -122.47237597497) | |||
33216 | 33216 | 208082 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991232.009819999 | 2090962.1201799999 | 37.720879746979705 | -122.47238517505 | (37.7208797469797, -122.47238517505) | |||
65001 | 65001 | 208083 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991231.056580001 | 2090980.0304 | 37.720928868853896 | -122.472389775075 | (37.7209288688539, -122.472389775075) | |||
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) | ||
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) | ||
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) | |||
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) | |||
19955 | 19955 | 29580 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991386.6913 | 2093344.7747799999 | 37.7274308773069 | -122.47202406848 | (37.7274308773069, -122.47202406848) | ||
19813 | 19813 | 29581 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991390.5187800005 | 2093368.54568 | 37.7274963677541 | -122.47201256884199 | (37.7274963677541, -122.472012568842) | ||
90967 | 90967 | 208087 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500x Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991392.30049 | 2093421.51137 | 37.7276419014288 | -122.472010268365 | (37.7276419014288, -122.472010268365) | |||
140520 | 140520 | 29589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991336.987432401 | 2093443.9543843998 | 37.7277003234109 | -122.472203119704 | (37.7277003234109, -122.472203119704) | ||
91557 | 91557 | 29978 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658001 | (37.7277012826104, -122.47220652658) | ||
101082 | 101082 | 29979 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658001 | (37.7277012826104, -122.47220652658) | ||
66612 | 66612 | 208088 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500x Junipero Serra Blvd | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991446.48536 | 2094319.42031 | 37.7301104703116 | -122.471888366152 | (37.7301104703116, -122.471888366152) | |||
68520 | 68520 | 208089 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500x Junipero Serra Blvd | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991450.70341 | 2094361.7324599999 | 37.730226892943705 | -122.471876866532 | (37.7302268929437, -122.471876866532) | |||
112719 | 112719 | 21073 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
115970 | 115970 | 21074 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
140920 | 140920 | 21075 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
147762 | 147762 | 208136 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 255x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993099.62509 | 2100246.71576 | 37.746480853819 | -122.466603967821 | (37.746480853819, -122.466603967821) | |||
187159 | 187159 | 208135 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 15x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | |||
20957 | 20957 | 4302 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4378 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001457.95867 | 2100305.5079 | 37.747121080269295 | -122.437706046203 | (37.7471210802693, -122.437706046203) | |||
17242 | 17242 | 4298 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4350 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001589.80492 | 2100313.4171 | 37.7471502929454 | -122.437250699681 | (37.7471502929454, -122.437250699681) | |||
21155 | 21155 | 2419 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2822 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009803.315230001 | 2100866.84766 | 37.7491333789981 | -122.408887954717 | (37.7491333789981, -122.408887954717) | |||
104820 | 104820 | 2417 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2818 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009805.0388946 | 2100942.8610594 | 37.7493421915499 | -122.408887356555 | (37.7493421915499, -122.408887356555) | |||
21126 | 21126 | 2414 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2786 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009786.496590001 | 2101143.3199400003 | 37.749891568653496 | -122.408965618395 | (37.7498915686535, -122.408965618395) | |||
10217 | 10217 | 2412 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2770 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/1996 12:00:00 AM | 6 | 3X3 | 6009783.25197 | 2101219.12721 | 37.7500995368852 | -122.40898218658998 | (37.7500995368852, -122.40898218659) | ||
18937 | 18937 | 2410 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2753 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2003 12:00:00 AM | 3 | 3x3 | 6009844.62689 | 2101286.4895200003 | 37.7502879367387 | -122.40877469949 | (37.7502879367387, -122.40877469949) | ||
18300 | 18300 | 2394 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2661 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 7X6 | 6009814.716440001 | 2101845.61428 | 37.7518214939686 | -122.408917576591 | (37.7518214939686, -122.408917576591) | |||
17306 | 17306 | 2392 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009810.34614 | 2101884.53168 | 37.751928107698 | -122.408935435327 | (37.751928107698, -122.408935435327) | |||
21060 | 21060 | 2380 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009717.08187 | 2102390.53262 | 37.7533122488659 | -122.409293662278 | (37.7533122488659, -122.409293662278) | |||
17278 | 17278 | 2375 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2547 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009774.35605 | 2102523.0562 | 37.753679337750604 | -122.409104945855 | (37.7536793377506, -122.409104945855) | |||
123006 | 123006 | 2373 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2530 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009713.5161975 | 2102600.278568 | 37.7538879646488 | -122.409320793751 | (37.7538879646488, -122.409320793751) | |||
119180 | 119180 | 2371 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2520 BRYANT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009678.5 | 2102633.3 | 37.753976672205894 | -122.40944421875601 | (37.7539766722059, -122.409444218756) | |||
80959 | 80959 | 27484 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2509 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009754.968576999 | 2102712.0209772997 | 37.754197106715296 | -122.40918532566099 | (37.7541971067153, -122.409185325661) | |||
19206 | 19206 | 2364 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009753.556480001 | 2102901.70574 | 37.754717859559996 | -122.40920359338499 | (37.75471785956, -122.409203593385) | |||
21374 | 21374 | 2362 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2473 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009749.23862 | 2102948.41566 | 37.7548458726476 | -122.40922182173 | (37.7548458726476, -122.40922182173) | |||
20543 | 20543 | 2353 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2413 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2013 12:00:00 AM | 3 | 4X4 | 6009731.35926 | 2103287.7886799998 | 37.7557767132463 | -122.409307601761 | (37.7557767132463, -122.409307601761) | ||
17542 | 17542 | 2343 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2385 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6009722.48016 | 2103476.08894 | 37.7562932460395 | -122.40935159661501 | (37.7562932460395, -122.409351596615) | |||
112335 | 112335 | 2341 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2372 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009654.94661 | 2103556.3659 | 37.756509884537 | -122.409590817662 | (37.756509884537, -122.409590817662) | |||
123013 | 123013 | 10137 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005656.6056289 | 2103722.2710656 | 37.7567405635363 | -122.423430312617 | (37.7567405635363, -122.423430312617) | |||
20799 | 20799 | 2336 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2350 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009647.84885 | 2103642.0545799998 | 37.7567447686625 | -122.40962141212201 | (37.7567447686625, -122.409621412122) | |||
20167 | 20167 | 2332 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2318 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X6 | 6009643.236190001 | 2103731.69198 | 37.7569906343237 | -122.409643691024 | (37.7569906343237, -122.409643691024) | |||
21137 | 21137 | 2330 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2312 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009640.84961 | 2103785.73358 | 37.7571388866594 | -122.409655759023 | (37.7571388866594, -122.409655759023) | |||
122592 | 122592 | 12943 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 725X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | ||||
17519 | 17519 | 2314 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2253 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009680.74998 | 2104241.2199 | 37.7583917852794 | -122.409549914219 | (37.7583917852794, -122.409549914219) | |||
18776 | 18776 | 2310 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2227 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009672.2386 | 2104377.81978 | 37.758766380788 | -122.409588991562 | (37.758766380788, -122.409588991562) | |||
21487 | 21487 | 2309 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2213 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009668.22468 | 2104416.43849 | 37.7588721941234 | -122.409605599315 | (37.7588721941234, -122.409605599315) | |||
82063 | 82063 | 21900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
114646 | 114646 | 21898 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
139049 | 139049 | 21899 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
21192 | 21192 | 3896 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 60 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5X5 | 6002168.7084800005 | 2107927.71258 | 37.7680902055206 | -122.435793601904 | (37.7680902055206, -122.435793601904) | |||
108719 | 108719 | 19149 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 49 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003514.43662 | 2108031.11939 | 37.7684504857975 | -122.431146254215 | (37.7684504857975, -122.431146254215) | |||
21559 | 21559 | 19144 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003508.29583 | 2108036.92775 | 37.768466086156394 | -122.431167909289 | (37.7684660861564, -122.431167909289) | |||
87847 | 87847 | 19146 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003500.9045907995 | 2108066.1860563997 | 37.76854600349329 | -122.431195563592 | (37.7685460034933, -122.431195563592) | |||
146177 | 146177 | 19145 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003500.9045907995 | 2108066.1860563997 | 37.76854600349329 | -122.431195563592 | (37.7685460034933, -122.431195563592) | |||
90522 | 90522 | 19141 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003499.5609963 | 2108090.4356538 | 37.76861251084271 | -122.43120194209 | (37.7686125108427, -122.43120194209) | |||
106174 | 106174 | 19140 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003499.5609963 | 2108090.4356538 | 37.76861251084271 | -122.43120194209 | (37.7686125108427, -122.43120194209) | |||
7804 | 7804 | 1666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000356.4682 | 2109956.4177 | 37.7735574116821 | -122.44220758007401 | (37.7735574116821, -122.442207580074) | |||
551 | 551 | 1664 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000454.8566 | 2109968.1462 | 37.7735952220186 | -122.441868082855 | (37.7735952220186, -122.441868082855) | |||
8492 | 8492 | 1663 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000501.7702 | 2109972.7072 | 37.773610418483 | -122.44170612948601 | (37.773610418483, -122.441706129486) | |||
8814 | 8814 | 1661 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000589.0817 | 2109986.3904 | 37.773652963463796 | -122.441405088647 | (37.7736529634638, -122.441405088647) | |||
6547 | 6547 | 1660 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000641.8596 | 2109991.603 | 37.7736702824704 | -122.441222896356 | (37.7736702824704, -122.441222896356) | |||
179520 | 179520 | 140602 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700x WEBSTER ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003984.6897 | 2111298.7883 | 37.7774493417916 | -122.429752786414 | (37.7774493417916, -122.429752786414) | |||
8325 | 8325 | 23708 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6003978.3577 | 2111349.4443 | 37.77758807209621 | -122.429778304865 | (37.7775880720962, -122.429778304865) | ||||
2297 | 2297 | 23709 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 20 | 6003970.4427 | 2111382.6873 | 37.7776789009548 | -122.429808057223 | (37.7776789009548, -122.429808057223) | |||
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) | ||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
125018 | 125018 | 23756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003937.3073429 | 2111811.4900601003 | 37.7788544107823 | -122.42995327885001 | (37.7788544107823, -122.42995327885) |
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");