Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132918 | 132918 | 191519 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.355280001 | 2102287.9269 | 37.7533451820439 | -122.38976380757 | (37.7533451820439, -122.38976380757) | ||||
| 49482 | 49482 | 191518 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.96067 | 2102295.09834 | 37.7533649068725 | -122.38976221485201 | (37.7533649068725, -122.389762214852) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 177285 | 177285 | 200285 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017066.92688 | 2097055.31943 | 37.739071888953795 | -122.38350474196699 | (37.7390718889538, -122.383504741967) | |||
| 175173 | 175173 | 200284 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017057.48354 | 2097042.3029900002 | 37.739035626492296 | -122.38353648713199 | (37.7390356264923, -122.383536487132) | |||
| 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) | |||
| 187429 | 187429 | 200283 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017069.557019999 | 2097033.93305 | 37.7390133116224 | -122.383494159632 | (37.7390133116224, -122.383494159632) | |||
| 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 | ||||||||
| 69648 | 69648 | 191550 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014425.29285 | 2102980.5331200003 | 37.7551949229254 | -122.39305284682301 | (37.7551949229254, -122.393052846823) | ||||
| 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 | ||||||||
| 148441 | 148441 | 121722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014436.80562 | 2102990.4188599996 | 37.7552227065741 | -122.39301372360599 | (37.7552227065741, -122.393013723606) | ||||
| 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 | ||||||||
| 34090 | 34090 | 200282 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.10078 | 2097031.29718 | 37.7390049434275 | -122.383564705169 | (37.7390049434275, -122.383564705169) | |||
| 88170 | 88170 | 121721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 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 | ||||||||
| 54747 | 54747 | 121720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6014432.547780001 | 2103023.07571 | 37.755312138768204 | -122.39303073340099 | (37.7553121387682, -122.393030733401) | ||||
| 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) | ||
| 181542 | 181542 | 200281 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017058.90214 | 2097021.55085 | 37.7389787236965 | -122.38353013790702 | (37.7389787236965, -122.383530137907) | |||
| 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 | ||||||||
| 166932 | 166932 | 121719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014433.09577 | 2103038.00285 | 37.7553531559357 | -122.39302988263799 | (37.7553531559357, -122.393029882638) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 71250 | 71250 | 129745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012618.68817 | 2119711.1441 | 37.8010328208639 | -122.400475802435 | (37.8010328208639, -122.400475802435) | |||
| 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) | ||
| 131597 | 131597 | 121718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014431.62012 | 2103050.15485 | 37.7553864407519 | -122.393035836129 | (37.7553864407519, -122.393035836129) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
| 27635 | 27635 | 129744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012609.98453 | 2119710.6419 | 37.801030956563395 | -122.400505885653 | (37.8010309565634, -122.400505885653) | |||
| 78241 | 78241 | 38273 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 22nd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 80400 | 80400 | 28651 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 104554 | 104554 | 38282 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 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) | ||
| 156641 | 156641 | 191548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014408.452930001 | 2103463.35948 | 37.7565197250148 | -122.393144867255 | (37.7565197250148, -122.393144867255) | |||
| 162256 | 162256 | 177150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991357.8727400005 | 2088731.5467 | 37.7147624226096 | -122.471787632218 | (37.7147624226096, -122.471787632218) | |||
| 7873 | 7873 | 28650 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003539.955 | 2114426.6147 | 37.786012377283896 | -122.431514620567 | (37.7860123772839, -122.431514620567) | |||
| 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 | ||||||||
| 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 | ||||||||
| 15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
| 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) | |||
| 52418 | 52418 | 177149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991352.53535 | 2088761.3617099999 | 37.714843978538205 | -122.47180825186301 | (37.7148439785382, -122.471808251863) | |||
| 132012 | 132012 | 191547 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014407.91394 | 2103482.91236 | 37.7565733830779 | -122.393148099399 | (37.7565733830779, -122.393148099399) | |||
| 141177 | 141177 | 45692 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 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) | ||
| 153586 | 153586 | 200280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017039.14807 | 2097019.94402 | 37.7389732198275 | -122.383598327225 | (37.7389732198275, -122.383598327225) | |||
| 162698 | 162698 | 200278 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017026.25444 | 2097031.5540099998 | 37.739004385852795 | -122.383643715978 | (37.7390043858528, -122.383643715978) | |||
| 171510 | 171510 | 129743 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012600.30896 | 2119709.91151 | 37.8010284114971 | -122.400539316148 | (37.8010284114971, -122.400539316148) | |||
| 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 | ||||||||
| 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 | ||||||||
| 16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 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) | |||
| 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) | |||
| 77861 | 77861 | 45693 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 103771 | 103771 | 111426 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 11 | Median : Yard 3 | Tree 1 | Private 1 | 6 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 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) | |
| 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) | |||
| 166981 | 166981 | 191546 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014404.175 | 2103529.05124 | 37.756699862813605 | -122.39316425845101 | (37.7566998628136, -122.393164258451) | |||
| 173001 | 173001 | 200279 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.91134 | 2097012.03507 | 37.7389520983484 | -122.383560561973 | (37.7389520983484, -122.383560561973) | |||
| 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 | ||||||||
| 45673 | 45673 | 191560 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011774.48817 | 2106453.32112 | 37.7645828198606 | -122.402464343748 | (37.7645828198606, -122.402464343748) | |||
| 58641 | 58641 | 191545 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014404.98086 | 2103545.7850599997 | 37.7567458550525 | -122.393162642344 | (37.7567458550525, -122.393162642344) | |||
| 64416 | 64416 | 142192 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000600.1586 | 2110278.2975 | 37.7744550977244 | -122.44138772192301 | (37.7744550977244, -122.441387721923) | |||
| 108928 | 108928 | 37989 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 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) | |||
| 124802 | 124802 | 32662 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 10 | 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) | ||
| 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) | |
| 141853 | 141853 | 45694 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 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) | |||
| 160043 | 160043 | 218388 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 50 San Marcos Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5993887.93086 | 2100247.90665 | 37.7465295835701 | -122.463878201824 | (37.7465295835701, -122.463878201824) | |||
| 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) | |||
| 170615 | 170615 | 140278 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2066 Hayes St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997973.3758 | 2109963.7906 | 37.7734415509696 | -122.450451544256 | (37.7734415509696, -122.450451544256) | |||
| 175212 | 175212 | 121714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014427.84636 | 2103131.0451599997 | 37.755608338569104 | -122.39305454654699 | (37.7556083385691, -122.393054546547) | ||||
| 176023 | 176023 | 129701 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6000500.44634 | 2116185.5793 | 37.7906692952944 | -122.442156776619 | (37.7906692952944, -122.442156776619) | |||
| 181104 | 181104 | 227905 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbin Pl | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000059.13401 | 2105667.04747 | 37.7617629245349 | -122.442928012733 | (37.7617629245349, -122.442928012733) | |||
| 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 | ||||||||
| 76689 | 76689 | 191544 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014401.68997 | 2103590.98438 | 37.756869779843505 | -122.39317718618 | (37.7568697798435, -122.39317718618) | |||
| 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) | ||
| 87759 | 87759 | 37998 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 96700 | 96700 | 45695 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 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) | |||
| 126528 | 126528 | 111776 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 146669 | 146669 | 101221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012019.899180001 | 2106139.93997 | 37.763736042505 | -122.401593500559 | (37.763736042505, -122.401593500559) | |||
| 147342 | 147342 | 76428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | ||
| 161087 | 161087 | 129700 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000509.65087 | 2116188.56402 | 37.790678015119205 | -122.442125143875 | (37.7906780151192, -122.442125143875) | |||
| 163311 | 163311 | 191559 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011776.16151 | 2106411.778 | 37.7644688451864 | -122.40245563471399 | (37.7644688451864, -122.402455634714) | |||
| 166660 | 166660 | 191534 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016265.973669999 | 2107216.92727 | 37.7669292347089 | -122.386982621765 | (37.7669292347089, -122.386982621765) | |||
| 177856 | 177856 | 121713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014428.12864 | 2103144.99804 | 37.755646665865605 | -122.39305454654499 | (37.7556466658656, -122.393054546545) | ||||
| 178469 | 178469 | 129721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006892.13335 | 2120470.8795 | 37.8027978438157 | -122.420346130572 | (37.8027978438157, -122.420346130572) | |||
| 180211 | 180211 | 140277 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2064 Hayes St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997990.6776 | 2109965.9876 | 37.773448573595296 | -122.45039185353599 | (37.7734485735953, -122.450391853536) |
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");