trees
725 rows where qCaretaker_id = 6 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60693 | 254809 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 571 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/29/2018 12:00:00 AM | 3 | Permit Number 781555 | 5985946.54219 | 2112020.89571 | 37.778394097385 | -122.492205001438 | (37.778394097385, -122.492205001438) | 11 | 6 | 2 | 55 | 26 | |||
165984 | 108830 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Port 6 | FUF | 3x3 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | ||||
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
13263 | 27467 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 10 | 3 | 8 | 58 | 1 | ||
18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
18521 | 25799 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | 3 | 1 | 10 | 28860 | 6 | ||
20512 | 25787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.84401 | 37.8037556344242 | -122.401747862284 | (37.8037556344242, -122.401747862284) | 3 | 1 | 10 | 28860 | 6 | ||
23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
27365 | 27871 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016012.152 | 2113641.496 | 37.7845556217057 | -122.388308997614 | (37.7845556217057, -122.388308997614) | 6 | 2 | 9 | 28856 | 6 | |||
28610 | 25736 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
30214 | 25674 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
32855 | 25683 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481 | -122.388411289639 | (37.781564418481, -122.388411289639) | 6 | 2 | 9 | 28856 | 20 | ||
33243 | 27860 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
36777 | 27795 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | 3 | 1 | 10 | 28860 | 6 | |||
41101 | 27541 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1390 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 6 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | 10 | 3 | 8 | 28856 | 29 | ||
44069 | 25731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
52938 | 28045 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
58595 | 114506 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 1 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
61352 | 27964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
62199 | 25837 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.398398105913 | (37.7997852642353, -122.398398105913) | 3 | 1 | 10 | 28860 | 6 | ||
63944 | 25748 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
69869 | 25615 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.08301 | 37.7934997349939 | -122.392506866704 | (37.7934997349939, -122.392506866704) | 12 | 2 | 9 | 28855 | 6 | ||
74716 | 27997 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
75860 | 26029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | 3 | 1 | 10 | 28860 | 6 | ||
78382 | 121470 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 8 | 4x4 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | |||
80135 | 121444 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3x3 | 6013767 | 2118587 | 37.7980101597556 | -122.396423283327 | (37.7980101597556, -122.396423283327) | 3 | 1 | 10 | 28860 | 6 | ||||
82496 | 27535 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.14698 | 2102787.87807 | 37.7547603233662 | -122.38715384385 | (37.7547603233662, -122.38715384385) | 10 | 3 | 8 | 28856 | 29 | ||
85583 | 27704 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
87626 | 25648 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
91496 | 26017 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
93163 | 25628 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.395457184304 | (37.796375512586, -122.395457184304) | 3 | 2 | 10 | 28860 | 6 | ||
94064 | 27767 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
97718 | 27717 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
98286 | 27706 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | 1 | 10 | 308 | 23 | |||||
100477 | 22088 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6016008.97261 | 2099546.31799 | 37.7458531309618 | -122.387336417288 | (37.7458531309618, -122.387336417288) | 10 | 3 | 8 | 58 | 1 | ||||
103125 | 115402 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.422461340443 | (37.7357803359495, -122.422461340443) | 2 | 7 | 7 | 28859 | 2 | ||
113657 | 22077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3x3 | 6015962.92433 | 2100554.91453 | 37.748619977641 | -122.387566000296 | (37.748619977641, -122.387566000296) | 10 | 3 | 8 | 58 | 1 | ||
116516 | 27866 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.7935388882384 | -122.39231180375 | (37.7935388882384, -122.39231180375) | 12 | 2 | 9 | 28855 | 6 | ||
119843 | 28004 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014041.13301 | 2117989.35001 | 37.7963844052449 | -122.39543280592 | (37.7963844052449, -122.39543280592) | 3 | 2 | 10 | 28860 | 6 | ||
119938 | 25746 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
125354 | 253413 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.480002935505 | (37.7422296590049, -122.480002935505) | 1 | 8 | 3 | 29491 | 35 | |||
128626 | 25636 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
129323 | 27718 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
129709 | 27827 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
131066 | 27543 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
132646 | 25668 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.07497 | 2117868.41683 | 37.796059744426 | -122.394964320767 | (37.796059744426, -122.394964320767) | 3 | 2 | 10 | 28860 | 6 | ||
133273 | 25782 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | 3 | 1 | 10 | 28860 | 6 | ||
136674 | 25798 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.399607344202 | (37.801354716114, -122.399607344202) | 3 | 1 | 10 | 28860 | 6 | ||
139606 | 27907 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015923.72801 | 2112571.59801 | 37.7816130226275 | -122.388540210862 | (37.7816130226275, -122.388540210862) | 6 | 2 | 9 | 28856 | 20 | ||
141256 | 25884 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
141898 | 25643 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
144539 | 25677 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
157357 | 27940 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
157848 | 15086 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
158836 | 28033 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011830.13261 | 2121113.31246 | 37.8048388264002 | -122.403303252939 | (37.8048388264002, -122.403303252939) | 3 | 1 | 10 | 28860 | 6 | ||
159542 | 25825 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
166227 | 121471 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102X King St | 1 | Median : Cutout | Tree | Port 6 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.7797530158304 | -122.389799446797 | (37.7797530158304, -122.389799446797) | 6 | 2 | 9 | 28856 | 20 | |||
179338 | 25632 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
184011 | 27550 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
190550 | 25805 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012220.32724 | 2120713.92747 | 37.8037639971768 | -122.401924842279 | (37.8037639971768, -122.401924842279) | 3 | 1 | 10 | 28860 | 6 | ||
190744 | 27469 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016045.2641 | 2100630.70669 | 37.7488326475194 | -122.387286553937 | (37.7488326475194, -122.387286553937) | 10 | 3 | 8 | 58 | 1 | ||
190771 | 26025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | ||
11134 | 28042 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012004.18493 | 2120947.51548 | 37.804393307678 | -122.4026892561 | (37.804393307678, -122.4026892561) | 3 | 1 | 10 | 28860 | 6 | ||
31099 | 27559 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
31627 | 25624 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015065.65701 | 2116724.16701 | 37.7929674371429 | -122.391799197633 | (37.7929674371429, -122.391799197633) | 12 | 2 | 9 | 28855 | 6 | ||
33759 | 83042 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | 10 | 3 | 8 | 58 | 1 | |||
36585 | 27837 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
39934 | 25796 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012816.95901 | 2119901.25001 | 37.8015658608918 | -122.399803052325 | (37.8015658608918, -122.399803052325) | 3 | 1 | 10 | 28860 | 6 | ||
43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
44203 | 3575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
51761 | 27916 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015873.81501 | 2112343.73301 | 37.7809845902791 | -122.388696976059 | (37.7809845902791, -122.388696976059) | 6 | 2 | 9 | 28856 | 20 | ||
83896 | 25657 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
89848 | 28013 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014214.74401 | 2117682.27501 | 37.7955509040886 | -122.394810554146 | (37.7955509040886, -122.394810554146) | 4 | 2 | 10 | 28860 | 6 | ||
92245 | 25834 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
118598 | 27811 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
122549 | 25814 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
137815 | 27793 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
172485 | 28054 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
173267 | 25846 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012374.25001 | 2120498.90601 | 37.8031821896403 | -122.401377060666 | (37.8031821896403, -122.401377060666) | 3 | 1 | 10 | 28860 | 6 | ||
182430 | 27973 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
186984 | 27880 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015993.402 | 2113417.017 | 37.7839382140346 | -122.388358193918 | (37.7839382140346, -122.388358193918) | 6 | 2 | 9 | 28856 | 6 | |||
111516 | 3664 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 100 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017168.62408 | 2098888.98032 | 37.7441123713802 | -122.383280718132 | (37.7441123713802, -122.383280718132) | 10 | 3 | 8 | 58 | 1 | ||
26841 | 3665 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017153.34624 | 2098900.71457 | 37.7441437469313 | -122.383334362693 | (37.7441437469313, -122.383334362693) | 10 | 3 | 8 | 58 | 1 | |||
10393 | 3666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.7441802162386 | -122.383400533034 | (37.7441802162386, -122.383400533034) | 10 | 3 | 8 | 58 | 1 | ||
28445 | 3667 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.7442173915214 | -122.383463247242 | (37.7442173915214, -122.383463247242) | 10 | 3 | 8 | 58 | 1 | ||
191598 | 3668 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 104 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017100.61527 | 2098941.7519 | 37.7442535127858 | -122.38351955288 | (37.7442535127858, -122.38351955288) | 10 | 3 | 8 | 58 | 1 | |||
140108 | 3669 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 105 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 17 | 3X3 | 6017084.93156 | 2098953.56707 | 37.7442850879842 | -122.383574606702 | (37.7442850879842, -122.383574606702) | 10 | 3 | 8 | 58 | 1 | |||
44228 | 3670 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 106 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017067.53558 | 2098965.30929 | 37.7443163682077 | -122.383635576218 | (37.7443163682077, -122.383635576218) | 10 | 3 | 8 | 58 | 1 | |||
40398 | 3671 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | 10 | 3 | 8 | 58 | 1 | |||
131819 | 3672 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 108 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017032.37511 | 2098991.89434 | 37.7443874218329 | -122.383759005485 | (37.7443874218329, -122.383759005485) | 10 | 3 | 8 | 58 | 1 | |||
11481 | 3673 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.62034 | 37.7444159222737 | -122.383819238476 | (37.7444159222737, -122.383819238476) | 10 | 3 | 8 | 58 | 1 | ||
20337 | 28014 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.23301 | 37.7954800625202 | -122.394767428538 | (37.7954800625202, -122.394767428538) | 4 | 2 | 10 | 28860 | 6 | ||
25332 | 25835 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
32127 | 25894 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1996 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 |
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) );