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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 139460 | 139460 | 2739 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2290X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1992 12:00:00 AM | 8 | 3x3 | 6002556.047619999 | 2114770.51181 | 37.7869008162884 | -122.434943272404 | (37.7869008162884, -122.434943272404) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 3829 | 3829 | 4634 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 8 | 3 | 6010031.5482 | 2119295.5915 | 37.799747198685004 | -122.40939911161502 | (37.799747198685, -122.409399111615) | ||
| 5524 | 5524 | 4635 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/05/1990 12:00:00 AM | 35 | 3 | 6010009.8735 | 2119314.4873 | 37.7997978674726 | -122.409475448708 | (37.7997978674726, -122.409475448708) | ||
| 7577 | 7577 | 4636 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 3 | 6009974.2224 | 2119345.7236 | 37.7998816370329 | -122.409601021151 | (37.7998816370329, -122.409601021151) | |||
| 8911 | 8911 | 4637 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009937.8119 | 2119380.0857 | 37.7999739465801 | -122.409729442456 | (37.7999739465801, -122.409729442456) | |||
| 7107 | 7107 | 4638 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009905.4204 | 2119408.7236 | 37.8000507639755 | -122.40984355245001 | (37.8000507639755, -122.40984355245) | |||
| 7946 | 7946 | 4639 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 75 | 3 | 6009873.723999999 | 2119435.9713 | 37.8001238030697 | -122.40995515916201 | (37.8001238030697, -122.409955159162) | |||
| 7649 | 7649 | 4666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 60 | 3 | Permit Number 769286 | 6009738.4106 | 2119565.7843 | 37.8004726529456 | -122.41043256902 | (37.8004726529456, -122.41043256902) | |
| 6589 | 6589 | 4667 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 12 | 3 | Permit Number 769286 | 6009690.8519 | 2119608.7257 | 37.80058789320879 | -122.410600176031 | (37.8005878932088, -122.410600176031) | |
| 6297 | 6297 | 4668 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009590.6555 | 2119701.3035 | 37.8008364710267 | -122.41095344028601 | (37.8008364710267, -122.410953440286) | |||
| 1597 | 1597 | 4669 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2014 12:00:00 AM | 8 | 3 | Permit Number 769286 | 6009537.0943 | 2119751.1708 | 37.8009703907309 | -122.411142309711 | (37.8009703907309, -122.411142309711) | |
| 85181 | 85181 | 4670 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/13/2003 12:00:00 AM | 12 | 3 | 6009783.7006387 | 2119558.1544154 | 37.800454241984404 | -122.41027530758998 | (37.8004542419844, -122.41027530759) | ||
| 5830 | 5830 | 4674 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/05/1991 12:00:00 AM | 15 | 3x4 | 6009400.8826 | 2119872.8379 | 37.8012968187356 | -122.411622263241 | (37.8012968187356, -122.411622263241) | ||
| 82870 | 82870 | 4675 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 3x3 | 6009477.5527626 | 2119836.3917306997 | 37.8012010470299 | -122.41135437342 | (37.8012010470299, -122.41135437342) | ||
| 8177 | 8177 | 4676 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3x4 | 6009334.3928 | 2119933.7869 | 37.8014604396574 | -122.411856657471 | (37.8014604396574, -122.411856657471) | |||
| 9026 | 9026 | 4677 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3x3 | 6009299.7627 | 2119967.4935 | 37.8015510467699 | -122.411978876948 | (37.8015510467699, -122.411978876948) | |||
| 5646 | 5646 | 4679 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009212.7257 | 2120043.2180000003 | 37.801754083871295 | -122.412285420728 | (37.8017540838713, -122.412285420728) | ||
| 6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
| 8454 | 8454 | 4715 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008330.3273 | 2120843.4941 | 37.803901887177204 | -122.415395624015 | (37.8039018871772, -122.415395624015) | ||
| 5299 | 5299 | 4716 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008306.8566 | 2120868.0824 | 37.803968081269204 | -122.415478587922 | (37.8039680812692, -122.415478587922) | |||
| 6383 | 6383 | 4717 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008242.0329 | 2120925.0825 | 37.804120945419 | -122.415706953629 | (37.804120945419, -122.415706953629) | ||
| 1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
| 124851 | 124851 | 4719 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008486.129587 | 2120728.7244 | 37.803595514004 | -122.41484833114401 | (37.803595514004, -122.414848331144) | |||
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 1594 | 1594 | 4731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 3x3 | 6007886.219880001 | 2121257.05551 | 37.8050124513131 | -122.416961809043 | (37.8050124513131, -122.416961809043) | |||
| 8587 | 8587 | 4732 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 3x3 | 6008014.3541 | 2121137.2157 | 37.8046906082857 | -122.41650989053801 | (37.8046906082857, -122.416509890538) | |||
| 8565 | 8565 | 4733 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3x3 | 6007980.3619 | 2121165.8966 | 37.80476744709579 | -122.416629557244 | (37.8047674470958, -122.416629557244) | |||
| 7054 | 7054 | 4734 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6007950.0877 | 2121194.0464 | 37.80484303663339 | -122.416736319981 | (37.8048430366334, -122.416736319981) | |||
| 87462 | 87462 | 4736 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.804423590750396 | -122.41601752221001 | (37.8044235907504, -122.41601752221) | |||
| 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) | |||
| 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) | ||
| 127535 | 127535 | 12849 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2412 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 12 | 3X3 | 5987958.93678 | 2114680.36581 | 37.7858136848869 | -122.48543867329501 | (37.7858136848869, -122.485438673295) | ||
| 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) | ||||
| 7156 | 7156 | 13002 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 359 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/1995 12:00:00 AM | 8 | 3X3 | 6010611.1408 | 2120633.1017 | 37.8034521300977 | -122.40748784681101 | (37.8034521300977, -122.407487846811) | ||
| 103617 | 103617 | 15137 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 780X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6011914.84635 | 2114325.58433 | 37.7862060830296 | -122.40253249015801 | (37.7862060830296, -122.402532490158) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 5931 | 5931 | 22784 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1880 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001016.5841 | 2112130.2222 | 37.7795637284835 | -122.440080052813 | (37.7795637284835, -122.440080052813) | |||
| 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) | ||
| 890 | 890 | 23729 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.42991768322901 | (37.7783296231018, -122.429917683229) | ||
| 6262 | 6262 | 23731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6003929.9014 | 2111682.7982 | 37.7785006353915 | -122.429969716521 | (37.7785006353915, -122.429969716521) | |||
| 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) | |||
| 1958 | 1958 | 23757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003900.3372 | 2111922.0621 | 37.7791559204238 | -122.43008906318701 | (37.7791559204238, -122.430089063187) | |||
| 2284 | 2284 | 23758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003894.1493 | 2111953.6889 | 37.7792424093118 | -122.43011272647199 | (37.7792424093118, -122.430112726472) | |||
| 8475 | 8475 | 23759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003889.3366 | 2111985.3157 | 37.7793289760816 | -122.430131632423 | (37.7793289760816, -122.430131632423) | |||
| 8513 | 8513 | 23760 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003885.2113 | 2112011.4423 | 37.7794004795956 | -122.430147767922 | (37.7794004795956, -122.430147767922) | |||
| 6949 | 6949 | 23761 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003883.1487 | 2112042.3815 | 37.7794853141392 | -122.430157111124 | (37.7794853141392, -122.430157111124) | |||
| 1722 | 1722 | 23787 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003801.3315 | 2112607.883 | 37.781033406276705 | -122.430480512141 | (37.7810334062767, -122.430480512141) | ||
| 7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) |
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");