trees
1,521 rows where qSpecies_id = 37 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194087 | 227978 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 200 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005155.75456 | 2099046.13918 | 37.7438727047738 | -122.424829777096 | (37.7438727047738, -122.424829777096) | 2 | 7 | 5 | 63 | 22 | |
| 194046 | 208037 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1794 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993763.2785 | 2103312.19081 | 37.7549361412039 | -122.464531693303 | (37.7549361412039, -122.464531693303) | 1 | 8 | 4 | 56 | 12 | |||
| 193980 | 191145 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 44 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011725.25965 | 2110070.90029 | 37.7745131231217 | -122.402889063888 | (37.7745131231217, -122.402889063888) | 14 | 2 | 9 | 28853 | 34 | |||
| 193941 | 227955 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 19 Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005250.99369 | 2105400.57172 | 37.761325881014 | -122.424952471599 | (37.761325881014, -122.424952471599) | 2 | 4 | 5 | 28859 | 19 | |||
| 193789 | 30049 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1400X Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 193734 | 70136 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.7383166546264 | -122.414084485151 | (37.7383166546264, -122.414084485151) | 2 | 7 | 7 | 28859 | 2 | ||
| 193676 | 50458 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.464504569218 | (37.7548110540457, -122.464504569218) | 1 | 8 | 4 | 56 | 12 | |||
| 193579 | 248367 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 714 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999062.3351 | 2108141.4778 | 37.768500207911 | -122.446553559197 | (37.768500207911, -122.446553559197) | 15 | 5 | 11 | 29492 | 9 | |||
| 193571 | 227853 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004399.30217 | 2101007.45313 | 37.7492152649744 | -122.427585119054 | (37.7492152649744, -122.427585119054) | 2 | 4 | 5 | 28862 | 22 | |||
| 193232 | 121717 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.93211 | 2103065.57675 | 37.7554288033143 | -122.393035836151 | (37.7554288033143, -122.393035836151) | 10 | 3 | 8 | 28856 | 29 | ||
| 193223 | 61069 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2011 12:00:00 AM | 3x3 | Permit Number 54089 | 6000057.45151415 | 2105676.05314863 | 37.7617875559763 | -122.442934478534 | (37.7617875559763, -122.442934478534) | 15 | 5 | 5 | 28862 | 3 | ||
| 193159 | 227752 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 609 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6008645.38555 | 2096952.29887 | 37.7383199631034 | -122.412615415271 | (37.7383199631034, -122.412615415271) | 10 | 7 | 7 | 28859 | 2 | |||
| 193059 | 227991 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1419 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003954.54323 | 2099918.21821 | 37.7461993120526 | -122.429045451712 | (37.7461993120526, -122.429045451712) | 2 | 7 | 5 | 63 | 22 | |||
| 192910 | 105849 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1025 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 19016 | 6015551.36754 | 2104359.72868 | 37.7590443891103 | -122.389254817379 | (37.7590443891103, -122.389254817379) | 10 | 3 | 8 | 28856 | 29 | ||
| 192740 | 18165 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1450 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6005168.5828 | 2114444.09 | 37.7861525326871 | -122.425881250092 | (37.7861525326871, -122.425881250092) | 13 | 9 | 11 | 28858 | 13 | |||
| 192674 | 227967 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1521 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008757.48735 | 2099882.37849 | 37.7463716086597 | -122.41243487547 | (37.7463716086597, -122.41243487547) | 2 | 7 | 7 | 28859 | 2 | |||
| 192570 | 228012 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1317 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998216.16813 | 2105874.44581 | 37.7622271428915 | -122.449317008786 | (37.7622271428915, -122.449317008786) | 15 | 5 | 11 | 29492 | 9 | |||
| 192511 | 121713 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6014428.12864 | 2103144.99804 | 37.7556466658656 | -122.393054546545 | (37.7556466658656, -122.393054546545) | 10 | 3 | 8 | 28856 | 29 | ||||
| 192300 | 129741 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1 John Maher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012363.44847 | 2119674.74099 | 37.8009186294411 | -122.40135648692 | (37.8009186294411, -122.40135648692) | 3 | 1 | 10 | 28860 | 6 | |||
| 192214 | 26755 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005555.38127 | 2114442.57214 | 37.7861702164197 | -122.424542920326 | (37.7861702164197, -122.424542920326) | 13 | 9 | 1 | 28858 | 41 | |||
| 191985 | 244034 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1925 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997320.7945 | 2108781.1554 | 37.7701569687817 | -122.452623537471 | (37.7701569687817, -122.452623537471) | 15 | 5 | 11 | 29492 | 9 | |||
| 191955 | 40139 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 217X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41403 | 6002772.91216813 | 2109249.02186594 | 37.7717524985867 | -122.433798178586 | (37.7717524985867, -122.433798178586) | 15 | 5 | 11 | 29492 | 9 | |
| 191760 | 208135 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 15x San Marcos Ave | 21 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | 1 | 8 | 4 | 29491 | 40 | |||
| 191698 | 129728 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 332 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011984.71612 | 2119136.53323 | 37.7994197033062 | -122.402629199378 | (37.7994197033062, -122.402629199378) | 3 | 1 | 10 | 308 | 23 | |||
| 191620 | 94467 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4128 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
| 191588 | 191140 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 761 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011668.44248 | 2113913.34766 | 37.7850604188475 | -122.403355976608 | (37.7850604188475, -122.403355976608) | 12 | 2 | 9 | 28853 | 6 | |||
| 191584 | 4677 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 700X Columbus Ave | 4 | Median : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009299.7627 | 2119967.4935 | 37.8015510467699 | -122.411978876948 | (37.8015510467699, -122.411978876948) | 3 | 1 | 10 | 308 | 23 | |||
| 191556 | 182302 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2535 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986906.12 | 2105029.3143 | 37.7592532139832 | -122.488371553614 | (37.7592532139832, -122.488371553614) | 1 | 8 | 3 | 56 | 35 | |||
| 191387 | 2318 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2270 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6009620.42845 | 2104139.7744 | 37.7581098586044 | -122.40975137313 | (37.7581098586044, -122.40975137313) | 2 | 4 | 7 | 28859 | 19 | |||
| 191329 | 59231 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 732 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1980 12:00:00 AM | 14 | Permit Number 18553 | 5994760.56149 | 2110552.22329 | 37.7748728265586 | -122.461607720764 | (37.7748728265586, -122.461607720764) | 11 | 6 | 2 | 54 | 11 | ||
| 191239 | 177145 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 646 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001109.07997 | 2090060.71566 | 37.7189714080838 | -122.438178657041 | (37.7189714080838, -122.438178657041) | 9 | 7 | 6 | 28861 | 5 | |||
| 191109 | 208137 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 41 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993786.87978 | 2100730.78266 | 37.7478496147728 | -122.464262673683 | (37.7478496147728, -122.464262673683) | 1 | 8 | 4 | 29491 | 40 | |||
| 190809 | 191141 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 3 Bryant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6015816.86409 | 2114381.01819 | 37.7865753592109 | -122.389036284815 | (37.7865753592109, -122.389036284815) | 6 | 2 | 9 | 28855 | 6 | |||
| 190790 | 103166 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1201X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
| 190710 | 129735 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2 John Maher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012606.41703 | 2119728.02865 | 37.8010784974329 | -122.400519452825 | (37.8010784974329, -122.400519452825) | 3 | 1 | 10 | 28860 | 6 | |||
| 190277 | 129733 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 332 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6011893.56883 | 2119123.92391 | 37.7993799919624 | -122.402943715694 | (37.7993799919624, -122.402943715694) | 3 | 1 | 10 | 308 | 23 | |||
| 190204 | 129742 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1 John Maher St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012372.32254 | 2119675.23965 | 37.8009204937473 | -122.401325813756 | (37.8009204937473, -122.401325813756) | 3 | 1 | 10 | 28860 | 6 | |||
| 190193 | 65749 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2800 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28712 | 6002107.84727 | 2117793.03898 | 37.7951744383084 | -122.436710379777 | (37.7951744383084, -122.436710379777) | 13 | 9 | 1 | 57 | 17 | ||
| 190098 | 19145 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 45 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003500.9045908 | 2108066.1860564 | 37.7685460034933 | -122.431195563592 | (37.7685460034933, -122.431195563592) | 7 | 9 | 5 | 28862 | 3 | |||
| 189921 | 227974 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 200X 29th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005213.325 | 2099049.95145 | 37.7438864239343 | -122.424630982854 | (37.7438864239343, -122.424630982854) | 2 | 7 | 5 | 63 | 22 | |
| 189847 | 191133 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 827 Wisconsin St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6012775.54197 | 2103646.67486 | 37.7569322215662 | -122.398804956499 | (37.7569322215662, -122.398804956499) | 10 | 3 | 8 | 28856 | 29 | |||
| 189713 | 227870 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 137 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003364.20801 | 2105044.49788 | 37.7602414308096 | -122.431452646343 | (37.7602414308096, -122.431452646343) | 2 | 4 | 5 | 28862 | 3 | |||
| 189623 | 58491 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 100x BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1978 12:00:00 AM | 4x4 | Permit Number 17662 | 5998324 | 2108210 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | 15 | 5 | 11 | 29492 | 9 | ||
| 189567 | 67610 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1095 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 9 | Permit Number 31188 | 6015569.94295 | 2104025.3864 | 37.7581273863874 | -122.389167228807 | (37.7581273863874, -122.389167228807) | 10 | 3 | 8 | 28856 | 29 | |
| 189460 | 227971 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 355 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008783.05116 | 2100218.42191 | 37.7472957438977 | -122.412370226806 | (37.7472957438977, -122.412370226806) | 2 | 7 | 7 | 28859 | 2 | |||
| 189276 | 45692 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 399 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.399819117907 | (37.7810548194134, -122.399819117907) | 6 | 2 | 9 | 28856 | 34 | |||
| 189046 | 121708 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6014420.07237 | 2103257.32043 | 37.7559546315195 | -122.393090266722 | (37.7559546315195, -122.393090266722) | 10 | 3 | 8 | 28856 | 29 | ||||
| 189013 | 51642 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.7822683041268 | -122.432423068554 | (37.7822683041268, -122.432423068554) | 15 | 9 | 11 | 29490 | 41 | |||
| 188979 | 208058 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992246.20583 | 2101062.80127 | 37.7486723289665 | -122.469614369217 | (37.7486723289665, -122.469614369217) | 1 | 8 | 4 | 29491 | 40 | |||
| 188970 | 228006 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1057 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998117.27341 | 2106573.00208 | 37.7641395449332 | -122.449709388403 | (37.7641395449332, -122.449709388403) | 15 | 5 | 11 | 29492 | 9 | |||
| 188963 | 227956 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 19 Oakwood St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6005249.63454 | 2105418.98824 | 37.7613763716539 | -122.424958482665 | (37.7613763716539, -122.424958482665) | 2 | 4 | 5 | 28859 | 19 | |||
| 188962 | 103137 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993979.5 | 2106772.5 | 37.7644497152943 | -122.464035120318 | (37.7644497152943, -122.464035120318) | 11 | 5 | 11 | 56 | 12 | ||||
| 188896 | 30588 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 109 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34558 | 6003337.11539 | 2108646.47834 | 37.7701300612941 | -122.431803534827 | (37.7701300612941, -122.431803534827) | 15 | 9 | 5 | 29492 | 9 | ||
| 188748 | 32660 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 750 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | 14 | 2 | 9 | 28853 | 34 | ||
| 187964 | 191142 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 3 Bryant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6015882.39445 | 2114438.56847 | 37.7867370114514 | -122.388813583003 | (37.7867370114514, -122.388813583003) | 6 | 2 | 9 | 28855 | 6 | |||
| 187705 | 129722 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 998 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6007108.76695 | 2120556.67401 | 37.8030456187175 | -122.419602556719 | (37.8030456187175, -122.419602556719) | 5 | 1 | 1 | 28858 | 32 | |||
| 187684 | 227764 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 4314 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001842.53618 | 2100618.06148 | 37.7480011379615 | -122.436398576738 | (37.7480011379615, -122.436398576738) | 2 | 4 | 5 | 28862 | 22 | |||
| 187674 | 64458 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 41 Chabot Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1988 12:00:00 AM | 7 | Permit Number 25325 | 5997700.9521 | 2111423.6839 | 37.7774344440641 | -122.451499212614 | (37.7774344440641, -122.451499212614) | 15 | 6 | 2 | 54 | 16 | ||
| 187635 | 26758 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1399 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.7861347715201 | -122.42479560486 | (37.7861347715201, -122.42479560486) | 13 | 9 | 1 | 28858 | 41 | |||
| 187442 | 218329 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 480 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5993003.09698 | 2099944.16622 | 37.7456445589479 | -122.466915757358 | (37.7456445589479, -122.466915757358) | 1 | 8 | 4 | 29491 | 40 | |||
| 187278 | 227966 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 329 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009444.02265 | 2099567.83625 | 37.7455464483177 | -122.410038704746 | (37.7455464483177, -122.410038704746) | 2 | 7 | 7 | 28859 | 2 | |||
| 187207 | 227541 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 141 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006449.92183 | 2107026.17298 | 37.7658570494855 | -122.420921294707 | (37.7658570494855, -122.420921294707) | 8 | 4 | 7 | 28853 | 19 | |||
| 187066 | 39563 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1102 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40984 | 6012176.35989 | 2103275.1391 | 37.7558786621771 | -122.400851063421 | (37.7558786621771, -122.400851063421) | 10 | 3 | 8 | 28856 | 29 | |
| 186967 | 59706 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1001 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19136 | 6015543.40178 | 2104492.11293 | 37.7594074463272 | -122.389291611327 | (37.7594074463272, -122.389291611327) | 10 | 3 | 8 | 28856 | 29 | ||
| 186889 | 67532 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 209 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 12 | Permit Number 31070 | 6014045.34257 | 2106049.86131 | 37.7636015183281 | -122.394581755439 | (37.7636015183281, -122.394581755439) | 14 | 3 | 8 | 28856 | 29 | |
| 186799 | 129709 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2384 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002148.23302 | 2117769.42382 | 37.795111892265 | -122.436568947899 | (37.795111892265, -122.436568947899) | 13 | 9 | 1 | 57 | 17 | |||
| 186764 | 227913 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2 Mars St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999590.52655 | 2105633.368 | 37.7616437212123 | -122.444546312179 | (37.7616437212123, -122.444546312179) | 15 | 5 | 5 | 28862 | 3 | |||
| 186611 | 227833 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 3024 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009323.67684 | 2101616.89265 | 37.7511659574416 | -122.410599515649 | (37.7511659574416, -122.410599515649) | 2 | 4 | 7 | 28859 | 19 | |||
| 186259 | 121711 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6014421.63917 | 2103213.20868 | 37.7558335971581 | -122.393081761812 | (37.7558335971581, -122.393081761812) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186170 | 53169 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 200@ DOLORES 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | 2 | 7 | 5 | 63 | 22 | ||
| 185683 | 84799 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49306 | 6003755 | 2096568 | 37.7369890856012 | -122.429496566415 | (37.7369890856012, -122.429496566415) | 2 | 7 | 5 | 63 | 7 | |||
| 185385 | 111132 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
| 185316 | 21075 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2192X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
| 185283 | 4715 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1000X Columbus Ave | 2 | Median : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008330.3273 | 2120843.4941 | 37.8039018871772 | -122.415395624015 | (37.8039018871772, -122.415395624015) | 5 | 1 | 10 | 308 | 32 | ||
| 185272 | 246067 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 3 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999950.6842 | 2108423.8659 | 37.7693262765559 | -122.443501133674 | (37.7693262765559, -122.443501133674) | 15 | 5 | 11 | 29492 | 9 | |||
| 184783 | 227840 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1850 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008700.15569 | 2107375.73959 | 37.7669434610994 | -122.41316290096 | (37.7669434610994, -122.41316290096) | 8 | 4 | 7 | 28853 | 19 | |||
| 184392 | 138693 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2511 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001245.0361 | 2114535.45 | 37.7861808725601 | -122.439462204459 | (37.7861808725601, -122.439462204459) | 15 | 6 | 1 | 29490 | 27 | |||
| 184379 | 191139 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 763 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011643.5293 | 2113893.61304 | 37.7850048407399 | -122.403440779973 | (37.7850048407399, -122.403440779973) | 12 | 2 | 9 | 28853 | 6 | |||
| 184020 | 208113 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 293 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5994585.68235 | 2100211.44576 | 37.7464696563432 | -122.461462827849 | (37.7464696563432, -122.461462827849) | 1 | 8 | 4 | 29491 | 40 | |||
| 183992 | 21899 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2065 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015783.09058 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | 14 | 3 | 8 | 28856 | 29 | |||
| 183972 | 218320 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 400 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993320.26177 | 2099984.60198 | 37.7457738859626 | -122.465821995605 | (37.7457738859626, -122.465821995605) | 1 | 8 | 4 | 29491 | 40 | |||
| 183949 | 129739 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 6 John Maher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012352.16177 | 2119689.7384 | 37.8009591789808 | -122.401396598486 | (37.8009591789808, -122.401396598486) | 3 | 1 | 10 | 28860 | 6 | |||
| 183782 | 227863 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 12 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004062.73699 | 2102929.44749 | 37.7544735686269 | -122.42888597313 | (37.7544735686269, -122.42888597313) | 2 | 4 | 5 | 28862 | 22 | |||
| 183709 | 191134 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2200 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010446.9321 | 2107891.83414 | 37.7684584473369 | -122.407157433385 | (37.7684584473369, -122.407157433385) | 8 | 4 | 8 | 28853 | 19 | |||
| 183345 | 110258 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 1199x 22ND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6014477 | 2103943 | 37.7578405224149 | -122.392941361895 | (37.7578405224149, -122.392941361895) | 10 | 3 | 8 | 28856 | 29 | ||||
| 183301 | 227921 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1870 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004572.09923 | 2097821.31291 | 37.7404766282059 | -122.426760715047 | (37.7404766282059, -122.426760715047) | 2 | 7 | 5 | 63 | 7 | |||
| 183252 | 227947 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2700 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 7ft | 6009924.71933 | 2103404.59086 | 37.7561082572986 | -122.408647136979 | (37.7561082572986, -122.408647136979) | 2 | 4 | 7 | 28859 | 19 | |||
| 183229 | 227885 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 280 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004498.87593 | 2103979.46258 | 37.7573813393853 | -122.427452488844 | (37.7573813393853, -122.427452488844) | 2 | 4 | 5 | 28862 | 3 | |||
| 183081 | 26685 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 610X Columbus Ave | 6 | Median : Cutout | Tree | DPW 1 | 01/27/1999 12:00:00 AM | 20 | 3 | 6009783.7006387 | 2119558.1544154 | 37.8004542419844 | -122.41027530759 | (37.8004542419844, -122.41027530759) | 3 | 1 | 10 | 308 | 23 | ||
| 182943 | 29589 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 610X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991336.9874324 | 2093443.9543844 | 37.7277003234109 | -122.472203119704 | (37.7277003234109, -122.472203119704) | 9 | 8 | 4 | 64 | 40 | ||
| 182868 | 35413 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1496 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | 2 | 7 | 5 | 63 | 22 | ||
| 182835 | 75814 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | 3 | 1 | 10 | 308 | 23 | |||
| 182825 | 58614 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1052 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | 3x3 | Permit Number 17828 | 5998153.64010117 | 2106679.35024276 | 37.7644336306622 | -122.449591270882 | (37.7644336306622, -122.449591270882) | 15 | 5 | 11 | 29492 | 9 | ||
| 182751 | 37993 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 650 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.7582593719727 | -122.395232549515 | (37.7582593719727, -122.395232549515) | 10 | 3 | 8 | 28856 | 29 | |||
| 182489 | 227803 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1253 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5997459.41778 | 2105347.40102 | 37.7607366955736 | -122.451896284206 | (37.7607366955736, -122.451896284206) | 15 | 5 | 11 | 29492 | 12 | |||
| 182474 | 208112 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992037.32657 | 2098038.78616 | 37.7403570831075 | -122.470116497588 | (37.7403570831075, -122.470116497588) | 1 | 8 | 4 | 59 | 40 | |||
| 182382 | 37049 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 151 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.7428935184664 | -122.425466888297 | (37.7428935184664, -122.425466888297) | 2 | 7 | 5 | 63 | 22 | ||
| 181963 | 227998 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1187 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997369.80314 | 2106003.72483 | 37.7625336615227 | -122.452253578551 | (37.7625336615227, -122.452253578551) | 15 | 5 | 11 | 29492 | 12 | |||
| 181934 | 26757 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1399 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005593.49204 | 2114448.7926 | 37.7861894484292 | -122.424411509581 | (37.7861894484292, -122.424411509581) | 13 | 9 | 1 | 28858 | 41 | |||
| 181681 | 191522 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1089 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015567.39851 | 2104058.65501 | 37.7582185938385 | -122.389178351619 | (37.7582185938385, -122.389178351619) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );