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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122115 | 122115 | 30568 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.41421491247101 | (37.8082195561589, -122.414214912471) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 45194 | 45194 | 142722 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100x COLUMBUS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6008044.6283 | 2121108.5348 | 37.804613560274504 | -122.416403090609 | (37.8046135602745, -122.416403090609) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 175051 | 175051 | 129722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007108.76695 | 2120556.6740099997 | 37.8030456187175 | -122.419602556719 | (37.8030456187175, -122.419602556719) | |||
| 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) | |||
| 178527 | 178527 | 129720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006876.11825 | 2120468.72973 | 37.802791038628705 | -122.42040139843 | (37.8027910386287, -122.42040139843) | |||
| 86026 | 86026 | 129719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006860.09044 | 2120465.9602200002 | 37.802782531050795 | -122.420456666246 | (37.8027825310508, -122.420456666246) | |||
| 28107 | 28107 | 129718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.42050619192699 | (37.8027774273877, -122.420506191927) | |||
| 69185 | 69185 | 129717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006827.222569999 | 2120461.26491 | 37.8027677866551 | -122.420570072569 | (37.8027677866551, -122.420570072569) | |||
| 27930 | 27930 | 129716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006809.35 | 2120459.5660099997 | 37.8027621146536 | -122.42063180021299 | (37.8027621146536, -122.420631800213) | |||
| 161282 | 161282 | 129715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006786.6709199995 | 2120456.10735 | 37.8027513398688 | -122.420710035851 | (37.8027513398688, -122.420710035851) | |||
| 33165 | 33165 | 129714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006770.61766 | 2120452.09935 | 37.8027394301331 | -122.420765303696 | (37.8027394301331, -122.420765303696) | |||
| 153938 | 153938 | 129713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006753.58301 | 2120450.7966299998 | 37.802734893067495 | -122.420824159811 | (37.8027348930675, -122.420824159811) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 136861 | 136861 | 129726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007892.05327 | 2119913.90484 | 37.8013248262425 | -122.41684640354299 | (37.8013248262425, -122.416846403543) | |||
| 163183 | 163183 | 129725 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007869.3354400005 | 2119911.2573599997 | 37.801316279082705 | -122.416924829814 | (37.8013162790827, -122.416924829814) | |||
| 57577 | 57577 | 129724 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007826.23151 | 2119905.33102 | 37.801297582165205 | -122.417073568702 | (37.8012975821652, -122.417073568702) | |||
| 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) | ||
| 136534 | 136534 | 129723 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007809.591659999 | 2119903.72607 | 37.801292239302796 | -122.417131036286 | (37.8012922393028, -122.417131036286) | |||
| 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) | ||
| 55431 | 55431 | 129734 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012615.27565 | 2119730.0838 | 37.801084634405896 | -122.400488942433 | (37.8010846344059, -122.400488942433) | |||
| 70203 | 70203 | 129735 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012606.41703 | 2119728.02865 | 37.8010784974329 | -122.400519452825 | (37.8010784974329, -122.400519452825) | |||
| 79897 | 79897 | 129736 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 John Maher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012597.85597 | 2119726.1652900004 | 37.80107290365589 | -122.400548947 | (37.8010729036559, -122.400548947) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 163140 | 163140 | 129737 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012370.9979 | 2119693.9388 | 37.80097176319111 | -122.40133171241501 | (37.8009717631911, -122.401331712415) | |||
| 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) | |
| 25626 | 25626 | 129738 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012361.066869999 | 2119691.7640299997 | 37.800965237719204 | -122.40136592529801 | (37.8009652377192, -122.401365925298) | |||
| 26876 | 26876 | 129739 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012352.16177 | 2119689.7384 | 37.8009591789808 | -122.401396598486 | (37.8009591789808, -122.401396598486) | |||
| 28393 | 28393 | 129742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012372.32254 | 2119675.23965 | 37.8009204937473 | -122.401325813756 | (37.8009204937473, -122.401325813756) | |||
| 177163 | 177163 | 129741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012363.448469999 | 2119674.7409900003 | 37.80091862944111 | -122.40135648692 | (37.8009186294411, -122.40135648692) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 169269 | 169269 | 129684 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3301 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999809.37988 | 2119899.55884 | 37.8008274903686 | -122.444814901012 | (37.8008274903686, -122.444814901012) | |||
| 185438 | 185438 | 129683 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3301 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5999811.38198 | 2119884.1742 | 37.8007853625219 | -122.444806866442 | (37.8007853625219, -122.444806866442) | |||
| 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) | |
| 53770 | 53770 | 38503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2442 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40494 | 6006707.70986 | 2119633.57608 | 37.8004884270583 | -122.420924848825 | (37.8004884270583, -122.420924848825) | |
| 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) | |
| 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) | ||
| 141952 | 141952 | 26685 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 610X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/27/1999 12:00:00 AM | 20 | 3 | 6009783.7006387 | 2119558.1544154 | 37.800454241984404 | -122.41027530758998 | (37.8004542419844, -122.41027530759) | ||
| 52320 | 52320 | 38502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2440 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42685 | 6006711.92416 | 2119615.77365 | 37.8004397836378 | -122.420909000977 | (37.8004397836378, -122.420909000977) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 139257 | 139257 | 75814 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | |||
| 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) | ||
| 51162 | 51162 | 129728 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011984.71612 | 2119136.5332299997 | 37.7994197033062 | -122.402629199378 | (37.7994197033062, -122.402629199378) | |||
| 45629 | 45629 | 129729 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011961.72119 | 2119134.66813 | 37.7994132983523 | -122.402708639193 | (37.7994132983523, -122.402708639193) | |||
| 71046 | 71046 | 129730 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011945.292169999 | 2119133.13593 | 37.7994081740128 | -122.40276538191999 | (37.7994081740128, -122.40276538192) | |||
| 28050 | 28050 | 129731 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011929.52293 | 2119129.4911700003 | 37.7993972859062 | -122.402819692899 | (37.7993972859062, -122.402819692899) | |||
| 64322 | 64322 | 129732 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011915.1636 | 2119126.05063 | 37.799387037239 | -122.40286913941999 | (37.799387037239, -122.40286913942) | |||
| 68065 | 68065 | 129733 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011893.56883 | 2119123.92391 | 37.7993799919624 | -122.40294371569401 | (37.7993799919624, -122.402943715694) | |||
| 131415 | 131415 | 129727 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011976.37318 | 2119087.45755 | 37.7992844875525 | -122.40265461602101 | (37.7992844875525, -122.402654616021) | |||
| 49617 | 49617 | 65056 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3033 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1989 12:00:00 AM | 8 | Permit Number 27010 | 6003374.31765 | 2118807.7930799997 | 37.7980325835968 | -122.43240070983299 | (37.7980325835968, -122.432400709833) | ||
| 70193 | 70193 | 129688 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3033 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003377.013830001 | 2118791.5959 | 37.7979882632152 | -122.43239022283001 | (37.7979882632152, -122.43239022283) | |||
| 64321 | 64321 | 69193 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1151 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1994 12:00:00 AM | 8 | Permit Number 33239 | 6008629.33261 | 2117936.9394099996 | 37.79593801218729 | -122.41415513556299 | (37.7959380121873, -122.414155135563) | ||
| 170519 | 170519 | 129687 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999194.15925 | 2118091.3418 | 37.7958274819045 | -122.44681362986499 | (37.7958274819045, -122.446813629865) | |||
| 64369 | 64369 | 129686 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999195.89502 | 2118070.58488 | 37.795770588091 | -122.44680612949499 | (37.795770588091, -122.446806129495) | |||
| 34535 | 34535 | 129708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002098.95319 | 2117845.28879 | 37.7953173972439 | -122.43674489666 | (37.7953173972439, -122.43674489666) | |||
| 158867 | 158867 | 129707 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002102.877309999 | 2117818.83227 | 37.7952449775313 | -122.43672942383499 | (37.7952449775313, -122.436729423835) | |||
| 50885 | 50885 | 65749 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28712 | 6002107.84727 | 2117793.0389799997 | 37.79517443830839 | -122.436710379777 | (37.7951744383084, -122.436710379777) | ||
| 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) | |||
| 130497 | 130497 | 129710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2384 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6002133.54538 | 2117765.5714 | 37.7951004798686 | -122.43661949341002 | (37.7951004798686, -122.43661949341) | |||
| 165854 | 165854 | 58323 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2535 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1978 12:00:00 AM | 11 | Permit Number 17348 | 6004044.87416 | 2117496.37379 | 37.7944697628231 | -122.429986793678 | (37.7944697628231, -122.429986793678) | ||
| 155420 | 155420 | 129712 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2015 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6004384.23212 | 2117333.6145200003 | 37.7940420803335 | -122.42880096471701 | (37.7940420803335, -122.428800964717) | |||
| 177208 | 177208 | 129711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2015 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6004372.94608 | 2117332.24552 | 37.7940376826321 | -122.428839917937 | (37.7940376826321, -122.428839917937) | |||
| 135316 | 135316 | 60501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1988 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1982 12:00:00 AM | 15 | Permit Number 20100 | 6004700.44951 | 2117099.10485 | 37.793416068552396 | -122.427690103237 | (37.7934160685524, -122.427690103237) | ||
| 155340 | 155340 | 66278 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1990 12:00:00 AM | 18 | Permit Number 29386 | 6002437.3174 | 2116458.1230200003 | 37.7915278222894 | -122.43547482192699 | (37.7915278222894, -122.435474821927) | ||
| 67896 | 67896 | 129691 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2300 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000857.5233 | 2116275.33013 | 37.7909360710831 | -122.44092775413701 | (37.7909360710831, -122.440927754137) | |||
| 92283 | 92283 | 95319 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 106400 | 106400 | 95318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 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) | |
| 40292 | 40292 | 95320 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000942.23432 | 2116247.30101 | 37.790863934682 | -122.440632646973 | (37.790863934682, -122.440632646973) | |
| 43341 | 43341 | 95321 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000921.95955 | 2116245.56207 | 37.7908580054302 | -122.44070267179899 | (37.7908580054302, -122.440702671799) | |
| 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) | |||
| 31751 | 31751 | 129693 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000643.07515 | 2116204.21556 | 37.7907285930009 | -122.44166462801701 | (37.7907285930009, -122.441664628017) | |||
| 131786 | 131786 | 129694 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000599.2332 | 2116202.1611599997 | 37.7907204541334 | -122.44181617097999 | (37.7907204541334, -122.44181617098) | |||
| 28612 | 28612 | 129695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000588.35894 | 2116200.69282 | 37.7907158028324 | -122.441853689821 | (37.7907158028324, -122.441853689821) | |||
| 39995 | 39995 | 129696 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000569.369419999 | 2116197.48764 | 37.7907059201805 | -122.441919162241 | (37.7907059201805, -122.441919162241) | |||
| 160515 | 160515 | 129697 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6000546.57197 | 2116195.20818 | 37.7906983622821 | -122.441997876317 | (37.7906983622821, -122.441997876317) |
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");