trees
1,377 rows where qSpecies_id = 61 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
4257 | 4614 | DPW Maintained 1 | Tristania conferta :: 61 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | 3 | 1 | 10 | 308 | 4 | ||
4802 | 65984 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | 3 | 1 | 10 | 308 | 23 | |
5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
11172 | 82387 | DPW Maintained 1 | Tristania conferta :: 61 | 615 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010004.402 | 2119511.4587 | 37.8003383958996 | -122.409508291437 | (37.8003383958996, -122.409508291437) | 3 | 1 | 10 | 308 | 23 | |||
21423 | 143427 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.7932130339503 | -122.407090272453 | (37.7932130339503, -122.407090272453) | 3 | 1 | 10 | 28857 | 4 | |||
21708 | 30437 | DPW Maintained 1 | Tristania conferta :: 61 | 567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046 | (37.8004413456091, -122.40871589046) | 3 | 1 | 10 | 308 | 23 | ||
39132 | 143429 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | 3 | 1 | 10 | 28857 | 4 | |||
49007 | 142626 | DPW Maintained 1 | Tristania conferta :: 61 | 735 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009290.0663 | 2119929.1695 | 37.8014452745633 | -122.412009721134 | (37.8014452745633, -122.412009721134) | 3 | 1 | 10 | 308 | 4 | |||
51824 | 142500 | DPW Maintained 1 | Tristania conferta :: 61 | 629 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009964.6425 | 2119505.3419 | 37.8003193727849 | -122.409645443683 | (37.8003193727849, -122.409645443683) | 3 | 1 | 10 | 308 | 23 | |||
55003 | 142704 | DPW Maintained 1 | Tristania conferta :: 61 | 540 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008680.9196 | 2121106.7911 | 37.804644533379 | -122.414201013023 | (37.804644533379, -122.414201013023) | 3 | 1 | 10 | 308 | 23 | |||
56029 | 142485 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010091.845 | 2119435.9713 | 37.8001360252908 | -122.409200372911 | (37.8001360252908, -122.409200372911) | 3 | 1 | 10 | 308 | 23 | |||
56090 | 143431 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010731.6396 | 2116914.7262 | 37.7932491208157 | -122.406808637133 | (37.7932491208157, -122.406808637133) | 3 | 1 | 10 | 28857 | 4 | |||
58162 | 142689 | DPW Maintained 1 | Tristania conferta :: 61 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | 3 | 1 | 10 | 308 | 23 | |||
59790 | 142498 | DPW Maintained 1 | Tristania conferta :: 61 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.7998366945829 | -122.409693853229 | (37.7998366945829, -122.409693853229) | 3 | 1 | 10 | 308 | 4 | |||
60842 | 143430 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010708.6813 | 2116911.5375 | 37.7932390808025 | -122.406887849913 | (37.7932390808025, -122.406887849913) | 3 | 1 | 10 | 28857 | 4 | |||
65594 | 98674 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6010134.1069 | 2119364.7936 | 37.7999429563689 | -122.409049104677 | (37.7999429563689, -122.409049104677) | 3 | 1 | 10 | 308 | 23 | |||
66530 | 122823 | Permitted Site 7 | Tristania conferta :: 61 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | 3 | 1 | 10 | 308 | 23 | ||
68806 | 142719 | DPW Maintained 1 | Tristania conferta :: 61 | 1150 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008016.4786 | 2121177.0503 | 37.8048001035106 | -122.416505361905 | (37.8048001035106, -122.416505361905) | 5 | 1 | 10 | 308 | 23 | |||
69266 | 64367 | DPW Maintained 1 | Tristania conferta :: 61 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | 3 | 1 | 10 | 308 | 23 | |
74581 | 143104 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.409429532928 | (37.8020031344426, -122.409429532928) | 3 | 1 | 10 | 308 | 23 | |||
75868 | 28074 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | 3 | 1 | 10 | 308 | 32 | ||
76380 | 50978 | DPW Maintained 1 | Tristania conferta :: 61 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | 3 | 1 | 10 | 308 | 32 | ||
105426 | 142501 | DPW Maintained 1 | Tristania conferta :: 61 | 601 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010024.9768 | 2119514.2391 | 37.8003471830213 | -122.409437290498 | (37.8003471830213, -122.409437290498) | 3 | 1 | 10 | 308 | 23 | |||
112653 | 28076 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.414178492558 | (37.8029610933815, -122.414178492558) | 3 | 1 | 10 | 308 | 32 | ||
117314 | 64341 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1988 12:00:00 AM | 11 | Permit Number 25170 | 6010046.9071 | 2120063.9383 | 37.8018577502609 | -122.409400217983 | (37.8018577502609, -122.409400217983) | 3 | 1 | 10 | 308 | 23 | |
129700 | 32359 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36912 | 6010078.2473 | 2119834.5139 | 37.8012295633542 | -122.409275566389 | (37.8012295633542, -122.409275566389) | 3 | 1 | 10 | 308 | 23 | |
130647 | 32360 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 12 | Permit Number 36912 | 6010075.9386 | 2119846.6344 | 37.8012627139137 | -122.409284411348 | (37.8012627139137, -122.409284411348) | 3 | 1 | 10 | 308 | 23 | ||
138915 | 38378 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | 3 | 1 | 10 | 308 | 23 | ||
143756 | 65429 | DPW Maintained 1 | Tristania conferta :: 61 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.7912814481387 | -122.406942874303 | (37.7912814481387, -122.406942874303) | 5 | 1 | 10 | 28857 | 6 | |
158633 | 64370 | DPW Maintained 1 | Tristania conferta :: 61 | 525 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 7 | Permit Number 25209 | 6010332.9517 | 2120250.0174 | 37.8023847002257 | -122.408423498481 | (37.8023847002257, -122.408423498481) | 3 | 1 | 10 | 308 | 23 | |
163692 | 12987 | DPW Maintained 1 | Tristania conferta :: 61 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | 3 | 1 | 10 | 308 | 23 | ||
169804 | 26540 | DPW Maintained 1 | Tristania conferta :: 61 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | 3 | 1 | 10 | 308 | 23 | |||
179871 | 28075 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.414260542242 | (37.8030103621977, -122.414260542242) | 3 | 1 | 10 | 308 | 32 | ||
183503 | 142654 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6007961.2413 | 2121229.1008 | 37.8049399144717 | -122.416700206529 | (37.8049399144717, -122.416700206529) | 5 | 1 | 10 | 308 | 23 | |||
193240 | 143432 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.7932591248157 | -122.406731631165 | (37.7932591248157, -122.406731631165) | 3 | 1 | 10 | 28857 | 4 | |||
193951 | 142653 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007975.5818 | 2121216.8848 | 37.8049071789669 | -122.416649713579 | (37.8049071789669, -122.416649713579) | 5 | 1 | 10 | 308 | 23 | |||
2490 | 195264 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 771659 | 6011775.98455 | 2114888.82062 | 37.7877448438967 | -122.403052549837 | (37.7877448438967, -122.403052549837) | 12 | 2 | 9 | 28855 | 6 | |
10110 | 13676 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011822.15902 | 2114934.32739 | 37.7878723731553 | -122.402895995877 | (37.7878723731553, -122.402895995877) | 12 | 2 | 9 | 28855 | 6 | |
10885 | 13675 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011805.84433 | 2114919.40836 | 37.7878304980227 | -122.402951392291 | (37.7878304980227, -122.402951392291) | 12 | 2 | 9 | 28855 | 6 | |
11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
11906 | 13674 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011788.8197 | 2114903.8104 | 37.787786719038 | -122.403009197144 | (37.787786719038, -122.403009197144) | 12 | 2 | 9 | 28855 | 6 | |
13390 | 200988 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015383.195 | 2115715.4111 | 37.7902152482092 | -122.390629967009 | (37.7902152482092, -122.390629967009) | 6 | 2 | 9 | 28855 | 6 | |||
16824 | 13677 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011836.71983 | 2114948.58904 | 37.7879123453203 | -122.402846621288 | (37.7879123453203, -122.402846621288) | 12 | 2 | 9 | 28855 | 6 | |
23416 | 201883 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015205.3081 | 2115545.7503 | 37.7897395282145 | -122.391233582889 | (37.7897395282145, -122.391233582889) | 6 | 2 | 9 | 28855 | 6 | |||
26846 | 15288 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.7721477499918 | -122.419195888407 | (37.7721477499918, -122.419195888407) | 8 | 2 | 9 | 28853 | 19 | ||
27103 | 200991 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015446.9463 | 2115775.0495 | 37.7903825381625 | -122.390413559192 | (37.7903825381625, -122.390413559192) | 6 | 2 | 9 | 28855 | 6 | |||
31069 | 50648 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | 6 | 2 | 9 | 28856 | 34 | ||
32803 | 61380 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1984 12:00:00 AM | 4 | Permit Number 21292 | 6014918.427 | 2115358.6091 | 37.7892097566572 | -122.392213077943 | (37.7892097566572, -122.392213077943) | 6 | 2 | 9 | 28855 | 6 | ||
33383 | 15283 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007077.8589 | 2109462.9776 | 37.7725833140899 | -122.418922232447 | (37.7725833140899, -122.418922232447) | 8 | 2 | 9 | 28853 | 19 | ||
33612 | 201232 | DPW Maintained 1 | Tristania conferta :: 61 | 405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014397.1053 | 2114774.0503 | 37.7875757331087 | -122.393975863907 | (37.7875757331087, -122.393975863907) | 6 | 2 | 9 | 28855 | 6 | |||
36622 | 121011 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015164.1782 | 2115507.7051 | 37.7896327822139 | -122.391373228803 | (37.7896327822139, -122.391373228803) | 6 | 2 | 9 | 28855 | 6 | |||
37205 | 200987 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015359.5453 | 2115694.8462 | 37.790157469647 | -122.390710356157 | (37.790157469647, -122.390710356157) | 6 | 2 | 9 | 28855 | 6 | |||
42383 | 200998 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014896.8338 | 2115334.9594 | 37.7891436210461 | -122.392286133642 | (37.7891436210461, -122.392286133642) | 6 | 2 | 9 | 28855 | 6 | |||
43164 | 15285 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007055.561 | 2109424.3851 | 37.7724760926839 | -122.4189966256 | (37.7724760926839, -122.4189966256) | 8 | 2 | 9 | 28853 | 19 | ||
47562 | 200989 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015396.5622 | 2115726.7219 | 37.7902470466473 | -122.390584507815 | (37.7902470466473, -122.390584507815) | 6 | 2 | 9 | 28855 | 6 | |||
52692 | 121010 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6015151.8392 | 2115494.3379 | 37.7895953941333 | -122.391414985971 | (37.7895953941333, -122.391414985971) | 6 | 2 | 9 | 28855 | 6 | |||
54256 | 121008 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015113.794 | 2115458.3492 | 37.7894944658082 | -122.391544102374 | (37.7894944658082, -122.391544102374) | 6 | 2 | 9 | 28855 | 6 | |||
64219 | 15286 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007046.1273 | 2109405.5176 | 37.7724237557967 | -122.419027919285 | (37.7724237557967, -122.419027919285) | 8 | 2 | 9 | 28853 | 19 | ||
64950 | 15284 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007065.8524 | 2109440.6797 | 37.7725214132882 | -122.418962182475 | (37.7725214132882, -122.418962182475) | 8 | 2 | 9 | 28853 | 19 | ||
74845 | 50647 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.7814777846222 | -122.401696004131 | (37.7814777846222, -122.401696004131) | 6 | 2 | 9 | 28856 | 34 | ||
76410 | 50649 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51399 | 6012160.9197 | 2112637.3571 | 37.7815843393908 | -122.401562438489 | (37.7815843393908, -122.401562438489) | 6 | 2 | 9 | 28856 | 34 | |
83278 | 121007 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6015091.1726 | 2115438.8125 | 37.7894395668943 | -122.391621004116 | (37.7894395668943, -122.391621004116) | 6 | 2 | 9 | 28855 | 6 | |||
91017 | 15287 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007004.1044 | 2109328.3326 | 37.7722094576916 | -122.41916780485 | (37.7722094576916, -122.41916780485) | 8 | 2 | 9 | 28853 | 19 | ||
92479 | 200993 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015477.7938 | 2115806.9252 | 37.7904717726346 | -122.390309056024 | (37.7904717726346, -122.390309056024) | 6 | 2 | 9 | 28855 | 6 | |||
95836 | 246309 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007064.7803 | 2109330.2021 | 37.772218007718 | -122.418958053835 | (37.772218007718, -122.418958053835) | 8 | 2 | 9 | 28853 | 19 | |||
97328 | 47567 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014670.6192 | 2115035.7393 | 37.7883094680316 | -122.393047869568 | (37.7883094680316, -122.393047869568) | 6 | 2 | 9 | 28855 | 6 | ||
102435 | 200999 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014874.2123 | 2115316.451 | 37.7890915451143 | -122.392363106769 | (37.7890915451143, -122.392363106769) | 6 | 2 | 9 | 28855 | 6 | |||
104500 | 200992 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015461.3418 | 2115791.5015 | 37.7904285101106 | -122.390364901286 | (37.7904285101106, -122.390364901286) | 6 | 2 | 9 | 28855 | 6 | |||
104575 | 246310 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.418922111123 | (37.7722678469563, -122.418922111123) | 8 | 2 | 9 | 28853 | 19 | ||
104677 | 111746 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
105762 | 200990 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015409.9294 | 2115740.0891 | 37.7902844914695 | -122.390539192334 | (37.7902844914695, -122.390539192334) | 6 | 2 | 9 | 28855 | 6 | |||
109061 | 121009 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015134.359 | 2115477.8859 | 37.7895492505351 | -122.391474315503 | (37.7895492505351, -122.391474315503) | 6 | 2 | 9 | 28855 | 6 | |||
111514 | 15321 | DPW Maintained 1 | Tristania conferta :: 61 | 1695 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1995 12:00:00 AM | 16 | 3x3 | 6006859.38 | 2108800.5123 | 37.7707520374067 | -122.419630964143 | (37.7707520374067, -122.419630964143) | 8 | 2 | 9 | 28853 | 19 | ||
112871 | 246313 | DPW Maintained 1 | Tristania conferta :: 61 | 1655 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007004.876 | 2109202.9434 | 37.771865212234 | -122.41915623997 | (37.771865212234, -122.41915623997) | 8 | 2 | 9 | 28853 | 19 | |||
115865 | 201877 | DPW Maintained 1 | Tristania conferta :: 61 | 491 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014316.902 | 2114695.3893 | 37.7873552903964 | -122.394247844153 | (37.7873552903964, -122.394247844153) | 6 | 2 | 9 | 28855 | 6 | |||
127592 | 47606 | DPW Maintained 1 | Tristania conferta :: 61 | 965 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45442 | 6011251.7668 | 2111767.4922 | 37.7791451213921 | -122.404646435966 | (37.7791451213921, -122.404646435966) | 14 | 2 | 9 | 28856 | 34 | |
133170 | 50650 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | 6 | 2 | 9 | 28856 | 34 | ||
137676 | 200986 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015348.2345 | 2115680.4507 | 37.7901173153756 | -122.390748484543 | (37.7901173153756, -122.390748484543) | 6 | 2 | 9 | 28855 | 6 | |||
138564 | 47574 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014716.8904 | 2115082.0105 | 37.7884390883158 | -122.392891016069 | (37.7884390883158, -122.392891016069) | 6 | 2 | 9 | 28855 | 6 | ||
141864 | 246311 | Undocumented 4 | Tristania conferta :: 61 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.418874102872 | (37.772331017243, -122.418874102872) | 8 | 2 | 9 | 28853 | 19 | |||
154630 | 201231 | DPW Maintained 1 | Tristania conferta :: 61 | 405 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014377.5686 | 2114753.9994 | 37.7875195921585 | -122.394042053329 | (37.7875195921585, -122.394042053329) | 6 | 2 | 9 | 28855 | 6 | |||
161469 | 47570 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 8 | Permit Number 45427 | 6014687.0712 | 2115049.1066 | 37.788347085442 | -122.392991883527 | (37.788347085442, -122.392991883527) | 6 | 2 | 9 | 28855 | 6 | ||
161583 | 47581 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 10 | Permit Number 45427 | 6014732.3141 | 2115093.3212 | 37.7884710015858 | -122.392838443698 | (37.7884710015858, -122.392838443698) | 6 | 2 | 9 | 28855 | 6 | ||
162722 | 246308 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6007054.0219 | 2109305.099 | 37.7721484747698 | -122.418993487345 | (37.7721484747698, -122.418993487345) | 8 | 2 | 9 | 28853 | 19 | |||
169675 | 121013 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.7897076153927 | -122.391286156841 | (37.7897076153927, -122.391286156841) | 6 | 2 | 9 | 28855 | 6 | |||
170430 | 47568 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014701.4667 | 2115063.502 | 37.7883874115209 | -122.392943084604 | (37.7883874115209, -122.392943084604) | 6 | 2 | 9 | 28855 | 6 | ||
171298 | 200994 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015517.8954 | 2115843.9421 | 37.7905756368486 | -122.390172893022 | (37.7905756368486, -122.390172893022) | 6 | 2 | 9 | 28855 | 6 | |||
172109 | 111747 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
172373 | 246307 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007039.6773 | 2109281.1913 | 37.7720820221483 | -122.419041410572 | (37.7720820221483, -122.419041410572) | 8 | 2 | 9 | 28853 | 19 | |||
188253 | 246306 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007027.7234 | 2109258.4791 | 37.7720189866936 | -122.419081148892 | (37.7720189866936, -122.419081148892) | 8 | 2 | 9 | 28853 | 19 | |||
192834 | 201884 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015227.9296 | 2115567.3435 | 37.7898000735545 | -122.391156824011 | (37.7898000735545, -122.391156824011) | 6 | 2 | 9 | 28855 | 6 | |||
303 | 87474 | DPW Maintained 1 | Tristania conferta :: 61 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x5 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726989 | (37.7209087510834, -122.39647726989) | 10 | 3 | 8 | 58 | 1 | |||
788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
3625 | 22438 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.7233608886837 | -122.395066921688 | (37.7233608886837, -122.395066921688) | 10 | 3 | 8 | 58 | 1 | |||
3757 | 29485 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | 10 | 3 | 8 | 58 | 1 | ||
4020 | 22395 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.7260194067343 | -122.394144192498 | (37.7260194067343, -122.394144192498) | 10 | 3 | 8 | 58 | 1 | ||
4210 | 29504 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.385374410624 | (37.7276800583286, -122.385374410624) | 10 | 3 | 8 | 58 | 1 | ||
5894 | 29427 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 |
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) );