Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85180 | 85180 | 85312 | Lophostemon confertus :: Brisbane Box 11 | 1366 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6003535.852940001 | 2112477.60862 | 37.780660663043605 | -122.431389631549 | (37.7806606630436, -122.431389631549) | ||||
| 105765 | 105765 | 87423 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009092.517833999 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | |||
| 119540 | 119540 | 85436 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/17/2007 12:00:00 AM | 3 | 3x3 | Maintenance agreement ends 8/17/2010 | 6004184.830731 | 2113056.513958 | 37.782286952179 | -122.429185796304 | (37.782286952179, -122.429185796304) | |
| 128811 | 128811 | 87422 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 6009092.517833999 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | |||||
| 138815 | 138815 | 87410 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.783884515657896 | -122.42096977598499 | (37.7838845156579, -122.420969775985) | |||
| 39 | 39 | 3558 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2017 05:52:00 PM | 6 | 3X3 | 6018773.865780001 | 2097541.9761 | 37.7405023461002 | -122.377636624239 | (37.7405023461002, -122.377636624239) | ||
| 170 | 170 | 48827 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | 3x3 | Permit Number 46051 | 6011929.23024 | 2118387.60951 | 37.79736024144329 | -122.402768502565 | (37.7973602414433, -122.402768502565) | |
| 268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
| 374 | 374 | 117614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010658.32467 | 2115339.45675 | 37.788919706525704 | -122.406951233227 | (37.7889197065257, -122.406951233227) | ||
| 381 | 381 | 122664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 424 | 424 | 122666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 506 | 506 | 4706 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 950 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:29:00 PM | 3 | 4x4 | 6008667.8262 | 2120581.3066 | 37.8032009492885 | -122.414209123056 | (37.8032009492885, -122.414209123056) | ||
| 524 | 524 | 4705 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | ||
| 609 | 609 | 13247 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2372X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 40 | 4x4 | 6001031.9779 | 2119351.2951 | 37.7993917986357 | -122.44054486433201 | (37.7993917986357, -122.440544864332) | ||
| 650 | 650 | 11111 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2015 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | 5 | 3x3 | 6007199.704059999 | 2119289.07559 | 37.7995702354477 | -122.419197895967 | (37.7995702354477, -122.419197895967) | ||
| 876 | 876 | 192614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2016 12:00:00 AM | 4 | Width 3ft | 6007548.67256 | 2110072.64933 | 37.774283827466896 | -122.417336847918 | (37.7742838274669, -122.417336847918) | ||
| 1053 | 1053 | 21992 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2013 12:00:00 AM | 2 | 3x3 | 6015915.41358 | 2103336.7634099997 | 37.756255719130394 | -122.387924381009 | (37.7562557191304, -122.387924381009) | ||
| 1224 | 1224 | 59196 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 272 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1980 12:00:00 AM | 8 | Permit Number 779761 | 6009046.37885 | 2109959.18695 | 37.7740564365968 | -122.41214796834998 | (37.7740564365968, -122.41214796835) | ||
| 1565 | 1565 | 29772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1329 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2006 12:00:00 AM | 8 | 3x3 | 6007229.90871 | 2121805.15578 | 37.8064804551638 | -122.419271958731 | (37.8064804551638, -122.419271958731) | ||
| 1569 | 1569 | 29756 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008576.3352 | 2120666.0433 | 37.8034284755503 | -122.414531731143 | (37.8034284755503, -122.414531731143) | |||
| 1610 | 1610 | 7740 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 12 | 3X3 | 6006360.17596 | 2111335.26582 | 37.777683728843996 | -122.42153777275101 | (37.777683728844, -122.421537772751) | ||
| 1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1788 | 1788 | 108703 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2436 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772910 | 6001246.11089 | 2119029.77225 | 37.798521172675294 | -122.439780826226 | (37.7985211726753, -122.439780826226) |
| 2325 | 2325 | 47569 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 6 | 3x4 | Permit Number 778941 | 6014634.6306 | 2115001.8072 | 37.788214299095294 | -122.39317000993499 | (37.7882142990953, -122.393170009935) | |
| 2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | |
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
| 2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | |
| 2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
| 2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
| 2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | |
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
| 2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | |
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 2425 | 2425 | 7814 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2015 12:00:00 AM | 4 | 4X4 | 6006210.87703 | 2112746.5205200003 | 37.7815502713788 | -122.422154535912 | (37.7815502713788, -122.422154535912) | ||
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2543 | 2543 | 141333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 14 | Width 0ft | 6002078.0816 | 2110492.0692 | 37.7751261444639 | -122.43629061453998 | (37.7751261444639, -122.43629061454) | ||
| 2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
| 2781 | 2781 | 6959 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 653 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2017 12:00:00 AM | 3 | 3X3 | Permit Number 774555 | 6004285.9375 | 2110448.2406 | 37.775131000756396 | -122.428650025136 | (37.7751310007564, -122.428650025136) | |
| 3117 | 3117 | 38667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 3287 | 3287 | 253411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3292 | 3292 | 253409 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3295 | 3295 | 253410 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3296 | 3296 | 192598 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 104 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 775218 | 6008374.8011300005 | 2110658.1789 | 37.77593799816621 | -122.41452055078301 | (37.7759379981662, -122.414520550783) | |
| 3300 | 3300 | 192597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 104 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 775218 | 6008360.61035 | 2110669.96624 | 37.775969566167795 | -122.414570474841 | (37.7759695661678, -122.414570474841) | |
| 3305 | 3305 | 253412 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3395 | 3395 | 46141 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3539 | 3539 | 46147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3595 | 3595 | 229132 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 869 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1983 12:00:00 AM | 19 | Width 3ft | Permit Number 21019 | 6007588.0617 | 2104611.24937 | 37.759290317716 | -122.41681359176901 | (37.759290317716, -122.416813591769) | |
| 3670 | 3670 | 253512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 3x3 | 6000414.87165 | 2119245.42001 | 37.7990659347341 | -122.442672656788 | (37.7990659347341, -122.442672656788) | |||
| 3790 | 3790 | 51840 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 421 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2014 12:00:00 AM | 3 | Permit Number 774213 | 6007959.333430001 | 2113036.66888 | 37.7824454124529 | -122.416126251649 | (37.7824454124529, -122.416126251649) | ||
| 3894 | 3894 | 52352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1078 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 11 | 3x3 | Permit Number 48492 | 6009562.81073 | 2117112.1754400004 | 37.793725799570396 | -122.41086683016701 | (37.7937257995704, -122.410866830167) |
| 4418 | 4418 | 52886 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2833 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | 14 | 3x3 | Permit Number 53458 | 6003898.28713 | 2118559.6074599996 | 37.797380826909 | -122.43056990597601 | (37.797380826909, -122.430569905976) | |
| 4441 | 4441 | 35439 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 4597 | 4597 | 4651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 579 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 08:45:00 AM | 3 | 3X3 | 6009810.3555 | 2119456.6231 | 37.800176956117895 | -122.41017589842501 | (37.8001769561179, -122.410175898425) | ||
| 4738 | 4738 | 7742 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 355X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53119 | 6006346.51452 | 2111392.48149 | 37.77784005890471 | -122.421589097069 | (37.7778400589047, -122.421589097069) | |
| 4835 | 4835 | 253522 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429.0 | 2110577.0 | 37.7757181448456 | -122.41432731709801 | (37.7757181448456, -122.414327317098) | |
| 4839 | 4839 | 253523 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429.0 | 2110577.0 | 37.7757181448456 | -122.41432731709801 | (37.7757181448456, -122.414327317098) | |
| 4890 | 4890 | 117618 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010671.67618 | 2115248.31215 | 37.78867019232371 | -122.40689861210501 | (37.7886701923237, -122.406898612105) | ||
| 4915 | 4915 | 7094 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1944 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/2016 07:16:00 AM | 3 | 3X3 | 5998113.0 | 2109666.0 | 37.7726318847498 | -122.449947100062 | (37.7726318847498, -122.449947100062) | ||
| 4931 | 4931 | 3597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018273.82586 | 2098018.1543799997 | 37.7417822729228 | -122.37939865514299 | (37.7417822729228, -122.379398655143) | ||
| 4969 | 4969 | 3585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:02:00 PM | 3 | 3x3 | 6018473.32905 | 2097868.47388 | 37.7413822805579 | -122.37869844028299 | (37.7413822805579, -122.378698440283) | ||
| 4972 | 4972 | 3572 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:42:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 4975 | 4975 | 47475 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 4978 | 4978 | 3596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:07:00 PM | 3 | 3X3 | 6018288.66955 | 2098007.43076 | 37.7417536466133 | -122.379346585295 | (37.7417536466133, -122.379346585295) | ||
| 4987 | 4987 | 27477 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:59:00 AM | 3 | 3X3 | 6018492.70308 | 2097854.80306 | 37.7413458112573 | -122.378630501891 | (37.7413458112573, -122.378630501891) | ||
| 5040 | 5040 | 3573 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:44:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 5322 | 5322 | 4644 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 515 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 07:54:00 AM | 3 | 3x3 | 6009980.4182 | 2119301.0102 | 37.7997592122125 | -122.40957642369301 | (37.7997592122125, -122.409576423693) | ||
| 5460 | 5460 | 7804 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 699X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 3 | 3x3 | 6006203.156 | 2112429.9943 | 37.7806807321683 | -122.422158752843 | (37.7806807321683, -122.422158752843) | ||
| 5479 | 5479 | 23280 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 840 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2008 12:00:00 AM | 3 | 3X3 | 6006622.47227 | 2113461.31493 | 37.7835361291442 | -122.42078137187299 | (37.7835361291442, -122.420781371873) | ||
| 5509 | 5509 | 29751 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007205.020769999 | 2121826.2812 | 37.806537058492395 | -122.41935958779 | (37.8065370584924, -122.41935958779) | ||
| 5594 | 5594 | 47610 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 5684 | 5684 | 34899 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2530 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | Permit Number 38504 | 6002713.84084 | 2116933.67027 | 37.7928492537523 | -122.434552073422 | (37.7928492537523, -122.434552073422) | ||
| 5710 | 5710 | 9929 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2221 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1990 12:00:00 AM | 9 | 3X3 | 6005046.52749 | 2117287.74508 | 37.79395359692471 | -122.426506085481 | (37.7939535969247, -122.426506085481) | ||
| 5712 | 5712 | 14629 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166001 | (37.7800133326755, -122.42137953166) | |||
| 6008 | 6008 | 58349 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | Permit Number 17374 | 6010655.85992 | 2115362.95788 | 37.7889840970931 | -122.40696141805599 | (37.7889840970931, -122.406961418056) | ||
| 6201 | 6201 | 87987 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300x Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:33:00 PM | 3 | 3x3 | Permit Number 51027 | 6008990.567000001 | 2113714.34992 | 37.7843640908799 | -122.41260654257201 | (37.7843640908799, -122.412606542572) | |
| 6217 | 6217 | 83680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:26:00 PM | 3 | 6008994.04445 | 2113694.03545 | 37.784308507385504 | -122.412593075226 | (37.7843085073855, -122.412593075226) | |||
| 6254 | 6254 | 26164 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1801 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 8 | 3x3 | 6003687.1584 | 2119638.1147 | 37.80033016620771 | -122.43137749451999 | (37.8003301662077, -122.43137749452) | ||
| 6412 | 6412 | 116643 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6005704.65442 | 2112915.07382 | 37.7819845117139 | -122.42391781507601 | (37.7819845117139, -122.423917815076) | |||
| 6474 | 6474 | 65480 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1060 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28362 | 6008428.0601699995 | 2115588.49024 | 37.7894784400251 | -122.41468530120702 | (37.7894784400251, -122.414685301207) | |
| 6598 | 6598 | 9706 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2005 12:00:00 AM | 3 | 4X4 | 6005904.98118 | 2111477.12508 | 37.7780475630877 | -122.423122534696 | (37.7780475630877, -122.423122534696) | ||
| 6616 | 6616 | 43072 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 6 | 3x3 | 6008014.74915 | 2114436.68155 | 37.7862926240458 | -122.41603371409799 | (37.7862926240458, -122.416033714098) | |
| 6657 | 6657 | 61988 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3242 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773928 | 6004185.8821 | 2120324.60751 | 37.80224334970121 | -122.429700703119 | (37.8022433497012, -122.429700703119) | |
| 6660 | 6660 | 41451 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42044 | 6006045.39578 | 2110879.4024400003 | 37.7764142845255 | -122.422594304391 | (37.7764142845255, -122.422594304391) | |||
| 6723 | 6723 | 36868 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6775 | 6775 | 22607 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005711.80884 | 2112867.84958 | 37.7818552494496 | -122.42388970496799 | (37.7818552494496, -122.423889704968) | ||
| 6786 | 6786 | 83606 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 59X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2014 12:00:00 AM | 3 | Permit Number 773870 | 6009071.055480001 | 2112812.89668 | 37.7818934328697 | -122.412264344238 | (37.7818934328697, -122.412264344238) |
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");