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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 159024 | 159024 | 3587 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.3984199995 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | ||
| 153213 | 153213 | 83039 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 12 | 6018611.72965 | 2097767.00037 | 37.741111283369705 | -122.378212851336 | (37.7411112833697, -122.378212851336) | |||
| 146321 | 146321 | 25753 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.40473704035801 | (37.805854321699, -122.404737040358) | ||
| 146287 | 146287 | 25622 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015012.27101 | 2116778.85401 | 37.7931146312154 | -122.391987743488 | (37.7931146312154, -122.391987743488) | ||
| 146059 | 146059 | 25898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 146030 | 146030 | 27967 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 145792 | 145792 | 25880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012790.91701 | 2119868.69801 | 37.8014750291394 | -122.399890882882 | (37.8014750291394, -122.399890882882) | ||
| 145710 | 145710 | 27554 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 145407 | 145407 | 27787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 145325 | 145325 | 25827 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 145142 | 145142 | 27954 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 4 | 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) | |||
| 145048 | 145048 | 27996 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 144979 | 144979 | 28028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | ||
| 144953 | 144953 | 26025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
| 144869 | 144869 | 26027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
| 144544 | 144544 | 27779 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 2 | 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) | |||
| 144540 | 144540 | 27808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 144512 | 144512 | 25863 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012533.10401 | 2120250.2080099997 | 37.8025081869215 | -122.40080985566001 | (37.8025081869215, -122.40080985566) | ||
| 144442 | 144442 | 26021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113668997 | 37.8026699057947 | -122.40098537237499 | (37.8026699057947, -122.400985372375) | ||
| 144322 | 144322 | 27547 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1301X Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
| 144240 | 144240 | 27945 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 144070 | 144070 | 28054 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 143848 | 143848 | 25852 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 143792 | 143792 | 27934 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 143685 | 143685 | 25832 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 143432 | 143432 | 28051 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 143314 | 143314 | 25864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012543.52101 | 2120234.5830099997 | 37.802465865475604 | -122.40077270907301 | (37.8024658654756, -122.400772709073) | ||
| 142949 | 142949 | 25680 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 350X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 142720 | 142720 | 28009 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014164.83101 | 2117791.8670099997 | 37.795849042613604 | -122.394990942689 | (37.7958490426136, -122.394990942689) | ||
| 142639 | 142639 | 25836 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 142572 | 142572 | 27924 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015682.84301 | 2112108.2730099997 | 37.780327484096496 | -122.389341201064 | (37.7803274840965, -122.389341201064) | ||
| 142246 | 142246 | 25740 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
| 142220 | 142220 | 27550 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 142211 | 142211 | 28029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.7420099997 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | ||
| 142110 | 142110 | 25902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 142037 | 142037 | 25850 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 141929 | 141929 | 27794 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 141928 | 141928 | 25882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012807.84401 | 2119847.86501 | 37.801418770405505 | -122.39983084376999 | (37.8014187704055, -122.39983084377) | ||
| 141888 | 141888 | 25751 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.40473704035801 | (37.805854321699, -122.404737040358) | ||
| 141887 | 141887 | 27880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015993.402000001 | 2113417.017 | 37.7839382140346 | -122.388358193918 | (37.7839382140346, -122.388358193918) | |||
| 141754 | 141754 | 27913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015902.02701 | 2112416.43301 | 37.781185771703704 | -122.388604452195 | (37.7811857717037, -122.388604452195) | ||
| 141748 | 141748 | 27890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015967.881 | 2113137.85 | 37.783170270129396 | -122.388426996246 | (37.7831702701294, -122.388426996246) | |||
| 141250 | 141250 | 27881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015990.277000001 | 2113394.1 | 37.78387511595479 | -122.388367405327 | (37.7838751159548, -122.388367405327) | |||
| 141109 | 141109 | 25617 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014889.87501 | 2116893.4380099997 | 37.7934224562927 | -122.39241926264401 | (37.7934224562927, -122.392419262644) | ||
| 141092 | 141092 | 27891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113109.725 | 37.7830929586512 | -122.388430436483 | (37.7830929586512, -122.388430436483) | |||
| 140893 | 140893 | 27783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 6 | 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) | |||
| 140891 | 140891 | 25896 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 140710 | 140710 | 27962 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 6 | 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) | |||
| 140645 | 140645 | 27955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 5 | 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) | |||
| 140643 | 140643 | 27786 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 140583 | 140583 | 28007 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014117.08801 | 2117880.84301 | 37.7960906948417 | -122.395162379187 | (37.7960906948417, -122.395162379187) | ||
| 140551 | 140551 | 25801 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 140237 | 140237 | 26020 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113668997 | 37.8026699057947 | -122.40098537237499 | (37.8026699057947, -122.400985372375) | ||
| 140224 | 140224 | 27874 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016004.339 | 2113576.913 | 37.784377858434404 | -122.388331519124 | (37.7843778584344, -122.388331519124) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 140032 | 140032 | 25632 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 139983 | 139983 | 27851 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.5390099995 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | ||
| 139961 | 139961 | 27873 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016004.86 | 2113595.663 | 37.784429370574 | -122.388331025715 | (37.784429370574, -122.388331025715) | |||
| 139789 | 139789 | 25846 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012374.25001 | 2120498.90601 | 37.803182189640296 | -122.40137706066601 | (37.8031821896403, -122.401377060666) | ||
| 139779 | 139779 | 27853 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.780403982219205 | -122.389031454309 | (37.7804039822192, -122.389031454309) | ||
| 139701 | 139701 | 27920 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015829.32701 | 2112255.84301 | 37.7807407983373 | -122.38884474573099 | (37.7807407983373, -122.388844745731) | ||
| 139560 | 139560 | 25824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 139514 | 139514 | 27905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015930.902000001 | 2112710.767 | 37.7819955470034 | -122.388525109177 | (37.7819955470034, -122.388525109177) | |||
| 139503 | 139503 | 25875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012723.209009999 | 2119979.37501 | 37.801775146535604 | -122.400132961793 | (37.8017751465356, -122.400132961793) | ||
| 139415 | 139415 | 27774 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 2 | 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) | |||
| 139337 | 139337 | 28015 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014236.44501 | 2117630.19201 | 37.795409102976606 | -122.39473181516001 | (37.7954091029766, -122.39473181516) | ||
| 139278 | 139278 | 25883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012823.46901 | 2119825.72901 | 37.8013588613344 | -122.39977521873001 | (37.8013588613344, -122.39977521873) | ||
| 139187 | 139187 | 27973 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 138776 | 138776 | 25867 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012598.209009999 | 2120160.36501 | 37.8022651309127 | -122.400578243689 | (37.8022651309127, -122.400578243689) | ||
| 138764 | 138764 | 3571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 138763 | 138763 | 27921 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015810.88101 | 2112236.31101 | 37.780686145436505 | -122.38890719588899 | (37.7806861454365, -122.388907195889) | ||
| 138724 | 138724 | 25656 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 138547 | 138547 | 27994 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 138363 | 138363 | 25645 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 138353 | 138353 | 27569 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 10 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 128919 | 128919 | 27889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015968.9229999995 | 2113162.33 | 37.783237544441704 | -122.388425100514 | (37.7832375444417, -122.388425100514) | |||
| 128885 | 128885 | 28014 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.2330099996 | 37.795480062520205 | -122.394767428538 | (37.7954800625202, -122.394767428538) | ||
| 128742 | 128742 | 25879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012777.89601 | 2119890.8330099997 | 37.8015350805856 | -122.399937496957 | (37.8015350805856, -122.399937496957) | ||
| 128727 | 128727 | 25674 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 128560 | 128560 | 26023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113668997 | 37.8026699057947 | -122.40098537237499 | (37.8026699057947, -122.400985372375) | ||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128446 | 128446 | 27860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | 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) | |||
| 128307 | 128307 | 25736 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
| 128222 | 128222 | 27953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 3 | 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) | |||
| 128206 | 128206 | 27931 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 128178 | 128178 | 25831 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 128103 | 128103 | 25877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012751.85401 | 2119935.10401 | 37.80165518616639 | -122.400030725403 | (37.8016551861664, -122.400030725403) | ||
| 128043 | 128043 | 27975 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 127961 | 127961 | 25903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 127947 | 127947 | 26028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
| 127945 | 127945 | 25787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.8440099997 | 37.803755634424206 | -122.401747862284 | (37.8037556344242, -122.401747862284) | ||
| 127804 | 127804 | 25792 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012611.22901 | 2120208.54201 | 37.802398139421705 | -122.400536574048 | (37.8023981394217, -122.400536574048) | ||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127310 | 127310 | 25820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | 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) | |||
| 126905 | 126905 | 27876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6016002.256 | 2113521.705 | 37.784226154296 | -122.38833487113001 | (37.784226154296, -122.38833487113) | |||
| 126813 | 126813 | 25644 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 126784 | 126784 | 25835 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) |
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");