Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 4980 | 4980 | 83034 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:59:00 PM | 3 | 6018525.50747 | 2097831.43609 | 37.7412834585567 | -122.37851545254298 | (37.7412834585567, -122.378515452543) | |||
| 4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
| 4985 | 4985 | 83041 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.74089078129229 | -122.377824564564 | (37.7408907812923, -122.377824564564) | |||
| 4989 | 4989 | 83048 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.37739803950001 | (37.7406452501696, -122.3773980395) | |||
| 4998 | 4998 | 83042 | Private 5 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | |||
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 5038 | 5038 | 83035 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:50:00 AM | 3 | 6018541.89406 | 2097818.9676900003 | 37.741250126083706 | -122.37845792741501 | (37.7412501260837, -122.378457927415) | |||
| 5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
| 6222 | 6222 | 27831 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013146.80764 | 2119335.33451 | 37.8000303753641 | -122.39862188328699 | (37.8000303753641, -122.398621883287) | |||
| 7124 | 7124 | 27832 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013158.11098 | 2119319.87365 | 37.799988553278105 | -122.39858168361799 | (37.7999885532781, -122.398581683618) | |||
| 8997 | 8997 | 27829 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013118.439809999 | 2119374.83982 | 37.800137266990596 | -122.39872282141 | (37.8001372669906, -122.39872282141) | |||
| 16801 | 16801 | 22083 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 6015972.44529 | 2100358.98918 | 37.7480825346922 | -122.38751940998999 | (37.7480825346922, -122.38751940999) | |||
| 18001 | 18001 | 27903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015937.152000001 | 2112771.705 | 37.78216321542121 | -122.388507741674 | (37.7821632154212, -122.388507741674) | |||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 43784 | 43784 | 83046 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.37751250161399 | (37.740707968002, -122.377512501614) | |||
| 44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 53184 | 53184 | 27902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.38849525296699 | (37.782239240724, -122.388495252967) | |||
| 75152 | 75152 | 27904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015934.027000001 | 2112727.434 | 37.7820414840201 | -122.388515461744 | (37.7820414840201, -122.388515461744) | |||
| 77513 | 77513 | 27958 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 77564 | 77564 | 27895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015957.985 | 2112989.413 | 37.7827621471367 | -122.388450868666 | (37.7827621471367, -122.388450868666) | |||
| 79708 | 79708 | 27959 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 80438 | 80438 | 27893 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015963.194 | 2113042.017 | 37.7829068745448 | -122.388436520394 | (37.7829068745448, -122.388436520394) | |||
| 80718 | 80718 | 27834 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 82090 | 82090 | 27775 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 82424 | 82424 | 27839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 82957 | 82957 | 27840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 83311 | 83311 | 27705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 83768 | 83768 | 27906 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | |||
| 84036 | 84036 | 27864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 85814 | 85814 | 27885 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015984.5479999995 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | |||
| 86833 | 86833 | 27886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | |||
| 87036 | 87036 | 27900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | |||
| 87650 | 87650 | 27777 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 88547 | 88547 | 27883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | |||
| 89385 | 89385 | 27863 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 89834 | 89834 | 27792 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 90111 | 90111 | 27847 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 90241 | 90241 | 27861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 91142 | 91142 | 28372 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 92133 | 92133 | 27942 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 92364 | 92364 | 27782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 92652 | 92652 | 27780 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 93395 | 93395 | 27838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 93631 | 93631 | 27878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015996.527000001 | 2113472.746 | 37.784091406469 | -122.388351273372 | (37.784091406469, -122.388351273372) | |||
| 93856 | 93856 | 27960 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 94559 | 94559 | 27704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 94742 | 94742 | 27897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015953.2979999995 | 2112914.413 | 37.782555954267295 | -122.388461847258 | (37.7825559542673, -122.388461847258) | |||
| 94947 | 94947 | 27865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 95284 | 95284 | 27898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015948.61 | 2112884.725 | 37.7824741779053 | -122.388475992994 | (37.7824741779053, -122.388475992994) | |||
| 96124 | 96124 | 27767 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 97196 | 97196 | 27892 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113080.559 | 37.7830128753765 | -122.388428400104 | (37.7830128753765, -122.388428400104) | |||
| 97953 | 97953 | 22088 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 6016008.97261 | 2099546.3179900004 | 37.7458531309618 | -122.387336417288 | (37.7458531309618, -122.387336417288) | ||||
| 99547 | 99547 | 27845 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 100132 | 100132 | 27778 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 100382 | 100382 | 115402 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.42246134044301 | (37.7357803359495, -122.422461340443) | ||
| 100591 | 100591 | 27879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015993.9229999995 | 2113447.225 | 37.784021187263896 | -122.388358500511 | (37.7840211872639, -122.388358500511) | |||
| 100729 | 100729 | 27843 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 100902 | 100902 | 27706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | ||||
| 101121 | 101121 | 27717 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 101242 | 101242 | 27788 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 101348 | 101348 | 27884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.4130000002 | 37.5090039879895 | -122.38142014589701 | (37.5090039879895, -122.381420145897) | |||
| 101933 | 101933 | 27789 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 102906 | 102906 | 27894 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015959.027000001 | 2113012.85 | 37.7828265576108 | -122.388448900144 | (37.7828265576108, -122.388448900144) | |||
| 103821 | 103821 | 27836 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 104427 | 104427 | 27901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015942.36 | 2112820.142 | 37.7822965011504 | -122.38849310613999 | (37.7822965011504, -122.38849310614) | |||
| 104599 | 104599 | 27791 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 104698 | 104698 | 27952 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 105556 | 105556 | 27842 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 105677 | 105677 | 27827 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 106951 | 106951 | 27956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 107193 | 107193 | 27833 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 107973 | 107973 | 27707 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | ||||
| 108807 | 108807 | 27718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 09/11/2000 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 110061 | 110061 | 27844 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 110146 | 110146 | 27862 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 111012 | 111012 | 27882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015988.714 | 2113369.621 | 37.7838078155273 | -122.388371103678 | (37.7838078155273, -122.388371103678) | |||
| 111571 | 111571 | 27784 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 20 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 112303 | 112303 | 27790 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 112720 | 112720 | 27781 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 113231 | 113231 | 27793 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 114418 | 114418 | 27957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 114566 | 114566 | 114692 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975.0 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | ||
| 115875 | 115875 | 27841 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 116108 | 116108 | 27899 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015946.527000001 | 2112865.975 | 37.7824225791883 | -122.388481890173 | (37.7824225791883, -122.388481890173) | |||
| 116848 | 116848 | 27896 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015954.339 | 2112951.913 | 37.7826589785254 | -122.388460864103 | (37.7826589785254, -122.388460864103) | |||
| 117403 | 117403 | 27872 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016007.985 | 2113618.059 | 37.784491038096206 | -122.38832177783199 | (37.7844910380962, -122.388321777832) | |||
| 118074 | 118074 | 27961 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 118319 | 118319 | 27846 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 119897 | 119897 | 27888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015971.527000001 | 2113185.767 | 37.783302041465795 | -122.38841772800899 | (37.7833020414658, -122.388417728009) | |||
| 120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 120299 | 120299 | 27835 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 120310 | 120310 | 27785 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 121752 | 121752 | 27776 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 123233 | 123233 | 27887 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015976.214 | 2113235.246 | 37.7834381593837 | -122.38840496731301 | (37.7834381593837, -122.388404967313) | |||
| 124273 | 124273 | 27877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016000.1729999995 | 2113494.1 | 37.78415024176871 | -122.388340150307 | (37.7841502417687, -122.388340150307) | |||
| 124835 | 124835 | 27837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) |
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");