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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24517 | 24517 | 129740 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012353.73266 | 2119674.7684299997 | 37.8009181627066 | -122.401390109871 | (37.8009181627066, -122.401390109871) | |||
| 24770 | 24770 | 227722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 845 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999121.83175 | 2107384.4786900003 | 37.7664250774754 | -122.44629330369601 | (37.7664250774754, -122.446293303696) | |||
| 25393 | 25393 | 228021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1054 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998157.054409999 | 2106607.36365 | 37.7642361689933 | -122.44957427424102 | (37.7642361689933, -122.449574274241) | |||
| 25463 | 25463 | 200261 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 243 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009424.87449 | 2110575.33974 | 37.7757694778185 | -122.410882207661 | (37.7757694778185, -122.410882207661) | |||
| 25465 | 25465 | 208048 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2344 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992344.38135 | 2099463.27392 | 37.74428611053071 | -122.469158483081 | (37.7442861105307, -122.469158483081) | |||
| 25894 | 25894 | 227929 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3110 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002869.05371 | 2095746.24255 | 37.7346825264594 | -122.432500998617 | (37.7346825264594, -122.432500998617) | |||
| 26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
| 26311 | 26311 | 227767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000143.14107 | 2101645.6357400003 | 37.7507259002966 | -122.442348757612 | (37.7507259002966, -122.442348757612) | |||
| 26610 | 26610 | 228013 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1343 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998231.8221 | 2105759.10992 | 37.76191135493279 | -122.449254558076 | (37.7619113549328, -122.449254558076) | |||
| 26653 | 26653 | 208094 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993960.310959999 | 2106767.61522 | 37.7644351970401 | -122.46410113478001 | (37.7644351970401, -122.46410113478) | |||
| 27352 | 27352 | 227958 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3627 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6005410.5124699995 | 2104865.85603 | 37.7598666869207 | -122.42436272946199 | (37.7598666869207, -122.424362729462) | |||
| 27545 | 27545 | 140410 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1325 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003227.817000001 | 2112933.649 | 37.7818953731726 | -122.43248785744301 | (37.7818953731726, -122.432487857443) | |||
| 27923 | 27923 | 208116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994839.35424 | 2100452.13911 | 37.747145137147704 | -122.460603103876 | (37.7471451371477, -122.460603103876) | |||
| 28215 | 28215 | 247280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998954.6357 | 2108912.2879 | 37.7706105046931 | -122.446981556392 | (37.7706105046931, -122.446981556392) | |||
| 28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
| 28803 | 28803 | 227813 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 168 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999428.13676 | 2107230.4029200003 | 37.7660195129085 | -122.445222775925 | (37.7660195129085, -122.445222775925) | |||
| 29061 | 29061 | 95316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870@Divisadero Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000971.60034 | 2116251.73043 | 37.7908777689321 | -122.44053135994899 | (37.7908777689321, -122.440531359949) | |
| 29224 | 29224 | 227995 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 321 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004807.15163 | 2101805.7755 | 37.7514303338561 | -122.426231597132 | (37.7514303338561, -122.426231597132) | |||
| 29235 | 29235 | 33862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 281 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | 7 | Permit Number 37859 | 6011395.19215 | 2111355.67015 | 37.778022368579 | -122.404121275373 | (37.778022368579, -122.404121275373) | ||
| 29318 | 29318 | 248428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 130 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998278.3106 | 2108020.0433 | 37.768121965532295 | -122.449256670048 | (37.7681219655323, -122.449256670048) | |||
| 30224 | 30224 | 227891 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 58 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003143.30655 | 2107929.00611 | 37.7681490697424 | -122.432422664995 | (37.7681490697424, -122.432422664995) | |||
| 30357 | 30357 | 227761 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.61046 | 2099602.37866 | 37.745415306472204 | -122.42393276538601 | (37.7454153064722, -122.423932765386) | |||
| 30431 | 30431 | 208020 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1285 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994218.151430001 | 2106814.05581 | 37.7645775678277 | -122.463212712505 | (37.7645775678277, -122.463212712505) | |||
| 30462 | 30462 | 58671 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 5 | Permit Number 17896 | 6014367.3263 | 2104224.98671 | 37.7586087044554 | -122.39334039516199 | (37.7586087044554, -122.393340395162) | |
| 30507 | 30507 | 129709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002148.23302 | 2117769.42382 | 37.795111892265 | -122.436568947899 | (37.795111892265, -122.436568947899) | |||
| 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) | |||
| 31015 | 31015 | 59108 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 616 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18411 | 5993182.92211 | 2111277.08736 | 37.7767721716598 | -122.46711777381901 | (37.7767721716598, -122.467117773819) | ||
| 31143 | 31143 | 41824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1540 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42210 | 6001764.9422 | 2111535.9598 | 37.7779746089121 | -122.43744859967501 | (37.7779746089121, -122.437448599675) | |
| 31262 | 31262 | 177151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 183 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004046.6041 | 2092611.27045 | 37.7261413007669 | -122.428206457066 | (37.7261413007669, -122.428206457066) | |||
| 31295 | 31295 | 227823 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 316 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006968.36013 | 2096533.98003 | 37.737077088338 | -122.41838410663799 | (37.737077088338, -122.418384106638) | |||
| 31533 | 31533 | 43679 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 540 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43322 | 5994712.920030001 | 2111843.24303 | 37.7784148808037 | -122.461866155284 | (37.7784148808037, -122.461866155284) | |
| 31548 | 31548 | 227788 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003786.51974 | 2096596.76601 | 37.7370698550876 | -122.42938963933099 | (37.7370698550876, -122.429389639331) | |||
| 31555 | 31555 | 67316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 746 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 6 | Permit Number 30797 | 5992906.05892 | 2110364.3272599997 | 37.7742499931706 | -122.468009109205 | (37.7742499931706, -122.468009109205) | |
| 31816 | 31816 | 37984 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40206 | 6013786.428309999 | 2104612.00312 | 37.759639076609396 | -122.39537653041401 | (37.7596390766094, -122.395376530414) | |
| 31979 | 31979 | 129746 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1310 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011484.09994 | 2119879.99013 | 37.801433092922004 | -122.40441387701401 | (37.801433092922, -122.404413877014) | |||
| 32066 | 32066 | 208129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 14 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994035.372909999 | 2102011.52015 | 37.751380514111396 | -122.463496334396 | (37.7513805141114, -122.463496334396) | |||
| 32656 | 32656 | 123589 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 32 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994275.31768 | 2115360.29886 | 37.7880465633309 | -122.463635298323 | (37.7880465633309, -122.463635298323) | |||
| 33184 | 33184 | 227781 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 585 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001575.56604 | 2102446.1042 | 37.7530053336508 | -122.437452632547 | (37.7530053336508, -122.437452632547) | |||
| 33495 | 33495 | 105991 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 997 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x9 | 6015541.70538 | 2104536.18595 | 37.7595283673583 | -122.389300555992 | (37.7595283673583, -122.389300555992) | |||
| 33653 | 33653 | 208029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993680.14998 | 2104375.72277 | 37.7578515328401 | -122.464896406148 | (37.7578515328401, -122.464896406148) | |||
| 33972 | 33972 | 227821 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 73 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006832.17705 | 2099290.0553200003 | 37.7446369891207 | -122.419050382891 | (37.7446369891207, -122.419050382891) | |||
| 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) | |||
| 34476 | 34476 | 191143 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 75 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014816.78786 | 2113152.41079 | 37.7831463971164 | -122.39241036486 | (37.7831463971164, -122.39241036486) | |||
| 35374 | 35374 | 32812 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 421 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 5x5 | Permit Number 37171 | 6000142.4606 | 2110508.5779 | 37.7750613046635 | -122.442987522526 | (37.7750613046635, -122.442987522526) |
| 35873 | 35873 | 191145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011725.25965 | 2110070.9002900003 | 37.77451312312171 | -122.402889063888 | (37.7745131231217, -122.402889063888) | |||
| 35927 | 35927 | 117079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1520 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5x5 | 6003184.5706 | 2113558.6463 | 37.7836090062437 | -122.43268212910499 | (37.7836090062437, -122.432682129105) | |||
| 35946 | 35946 | 227866 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 380 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003553.996119999 | 2106069.13806 | 37.7630656015193 | -122.430869384713 | (37.7630656015193, -122.430869384713) | |||
| 36027 | 36027 | 123795 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5993809.03734 | 2112124.4569200003 | 37.7791349418605 | -122.465013428941 | (37.7791349418605, -122.465013428941) | |||
| 36101 | 36101 | 140335 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1551 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003125.8973 | 2113652.5551 | 37.783863528484396 | -122.432891827231 | (37.7838635284844, -122.432891827231) | |||
| 36142 | 36142 | 227851 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3969 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003362.6525 | 2102409.9690099997 | 37.7530075531701 | -122.431269967934 | (37.7530075531701, -122.431269967934) | |||
| 36174 | 36174 | 140357 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1529 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003133.078 | 2113592.2375 | 37.783698318826104 | -122.432862674177 | (37.7836983188261, -122.432862674177) | |||
| 36206 | 36206 | 191526 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.766879529196295 | -122.387914043316 | (37.7668795291963, -122.387914043316) | |||
| 36217 | 36217 | 227899 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003491.00028 | 2108069.42997 | 37.7685543492205 | -122.43123005333 | (37.7685543492205, -122.43123005333) | |||
| 36287 | 36287 | 227888 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 129 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002659.7336 | 2107360.61662 | 37.7665609785316 | -122.434054656597 | (37.7665609785316, -122.434054656597) | |||
| 36379 | 36379 | 142721 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100x COLUMBUS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6008079.1516 | 2121077.7294 | 37.804530917755706 | -122.416281435895 | (37.8045309177557, -122.416281435895) | |||
| 36435 | 36435 | 227741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1234 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997486.846 | 2105477.27302 | 37.7610948622513 | -122.451810791941 | (37.7610948622513, -122.451810791941) | |||
| 36630 | 36630 | 227914 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999872.11976 | 2106925.98957 | 37.7652090025309 | -122.44366526256701 | (37.7652090025309, -122.443665262567) | |||
| 36745 | 36745 | 227758 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006546.26985 | 2104086.6296200003 | 37.757791181125995 | -122.42037938302 | (37.757791181126, -122.42037938302) | |||
| 36840 | 36840 | 228015 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1224 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5998227.909 | 2106103.56312 | 37.7628569129495 | -122.44929290966199 | (37.7628569129495, -122.449292909662) | |||
| 36858 | 36858 | 227859 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004104.47801 | 2102871.3530599996 | 37.75431641748921 | -122.428737480655 | (37.7543164174892, -122.428737480655) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 37214 | 37214 | 191135 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6015829.2920699995 | 2099737.9733599997 | 37.7463694242077 | -122.387971104383 | (37.7463694242077, -122.387971104383) | ||||
| 37279 | 37279 | 227906 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000029.07257 | 2105659.56527 | 37.761740666326205 | -122.443031445545 | (37.7617406663262, -122.443031445545) | |||
| 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) | |||
| 37835 | 37835 | 247317 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002750.0987 | 2109384.7475 | 37.7721238731083 | -122.433886794778 | (37.7721238731083, -122.433886794778) | |||
| 37926 | 37926 | 129692 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6000656.11857 | 2116207.7557599996 | 37.790739056615706 | -122.441619752742 | (37.7907390566157, -122.441619752742) | |||
| 38079 | 38079 | 140412 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1315 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003232.5898 | 2112885.9212 | 37.7817645952487 | -122.43246793575899 | (37.7817645952487, -122.432467935759) | |||
| 38283 | 38283 | 227736 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1248 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997502.04655 | 2105374.80245 | 37.7608143745065 | -122.45175082785101 | (37.7608143745065, -122.451750827851) | |||
| 38638 | 38638 | 227968 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009987.14395 | 2099953.044 | 37.7466345704296 | -122.408187829802 | (37.7466345704296, -122.408187829802) | |||
| 38744 | 38744 | 227771 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 464 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002129.73865 | 2101510.34926 | 37.7504674639107 | -122.43546926501101 | (37.7504674639107, -122.435469265011) | |||
| 39152 | 39152 | 227713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 869 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998668.89091 | 2107167.7132099997 | 37.765804015560605 | -122.447844329357 | (37.7658040155606, -122.447844329357) | |||
| 40649 | 40649 | 227918 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.26174 | 2109058.8456 | 37.771288960948894 | -122.430206727358 | (37.7712889609489, -122.430206727358) | |||
| 40839 | 40839 | 208110 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5993194.87968 | 2099514.9753099997 | 37.744477176897504 | -122.466221422307 | (37.7444771768975, -122.466221422307) | |||
| 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) | |||
| 41045 | 41045 | 48885 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 3 | 3x3 | Permit Number 46091 | 6009414.4878 | 2110585.56643 | 37.7757969754933 | -122.410918860444 | (37.7757969754933, -122.410918860444) | |
| 41137 | 41137 | 191119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014052.7163 | 2105909.00339 | 37.7632151632714 | -122.39454638782301 | (37.7632151632714, -122.394546387823) | |||
| 41216 | 41216 | 227969 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010032.30789 | 2099922.75582 | 37.746553934526794 | -122.40802952125799 | (37.7465539345268, -122.408029521258) | |||
| 41487 | 41487 | 208150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 210 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000776.72095 | 2094702.6231900002 | 37.7316981172754 | -122.439660093143 | (37.7316981172754, -122.439660093143) | |||
| 41501 | 41501 | 109608 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | |||
| 41780 | 41780 | 208153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 435 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999203.01227 | 2094950.2253400001 | 37.732288277587706 | -122.445118495046 | (37.7322882775877, -122.445118495046) | |||
| 42186 | 42186 | 228008 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998158.99229 | 2106286.14081 | 37.7633542830094 | -122.449544423956 | (37.7633542830094, -122.449544423956) | |||
| 42241 | 42241 | 227982 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3858 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004756.65854 | 2101362.944 | 37.7502115672126 | -122.426374681956 | (37.7502115672126, -122.426374681956) | |||
| 42466 | 42466 | 227858 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 132 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004094.70808 | 2102310.5679200003 | 37.7527760802641 | -122.428731293332 | (37.7527760802641, -122.428731293332) | |||
| 42595 | 42595 | 129690 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3498 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997573.73789 | 2116108.4846099997 | 37.7902903857379 | -122.45227741238199 | (37.7902903857379, -122.452277412382) | |||
| 42659 | 42659 | 31690 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 720 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35194 | 5997967.7593 | 2107982.3411 | 37.7680006769011 | -122.45032811149599 | (37.7680006769011, -122.450328111496) | |
| 42724 | 42724 | 227852 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004384.0702 | 2101006.82199 | 37.749212670433295 | -122.427637746503 | (37.7492126704333, -122.427637746503) | |||
| 43596 | 43596 | 129685 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3301 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5999807.325669999 | 2119912.42287 | 37.8008626943206 | -122.444822934625 | (37.8008626943206, -122.444822934625) | |||
| 43808 | 43808 | 208021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1684 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993741.97238 | 2104049.76533 | 37.7569601023484 | -122.464658931187 | (37.7569601023484, -122.464658931187) | |||
| 43843 | 43843 | 55312 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1972 12:00:00 AM | 6 | Permit Number 11241 | 6012672.97117 | 2112433.28595 | 37.7810525658564 | -122.399776639786 | (37.7810525658564, -122.399776639786) | ||
| 44079 | 44079 | 41678 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
| 44337 | 44337 | 103160 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||
| 44840 | 44840 | 208096 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1504 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993391.51426 | 2105173.9377900003 | 37.760026577386206 | -122.465952620345 | (37.7600265773862, -122.465952620345) | |||
| 44961 | 44961 | 208090 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994177.92287 | 2090747.0249299998 | 37.720459209606396 | -122.46218652760099 | (37.7204592096064, -122.462186527601) | |||
| 45043 | 45043 | 227773 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002625.86544 | 2100734.86833 | 37.7483663409473 | -122.43369820581499 | (37.7483663409473, -122.433698205815) | |||
| 45180 | 45180 | 227959 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3470 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005235.72016 | 2103729.4555900004 | 37.7567365263755 | -122.424886401099 | (37.7567365263755, -122.424886401099) | |||
| 45277 | 45277 | 208077 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 338 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995744.67706 | 2091237.28528 | 37.7218954350055 | -122.456806235434 | (37.7218954350055, -122.456806235434) | |||
| 45329 | 45329 | 227943 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2526 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009705.19097 | 2102597.95155 | 37.753881108735705 | -122.40934942024599 | (37.7538811087357, -122.409349420246) | |||
| 45352 | 45352 | 139767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003238.1177 | 2113143.656 | 37.7824725838131 | -122.432467226219 | (37.7824725838131, -122.432467226219) | |||
| 45438 | 45438 | 58034 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 49 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1982 12:00:00 AM | 17 | Permit Number 19534 | 6011578.8271699995 | 2109918.45412 | 37.7740863633284 | -122.403384878125 | (37.7740863633284, -122.403384878125) | ||
| 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) |
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");