Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17232 | 17232 | 11705 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991287.29739 | 2092772.28865 | 37.7258532209449 | -122.47232595470601 | (37.7258532209449, -122.472325954706) | ||
17544 | 17544 | 11701 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.41051 | 2092816.87452 | 37.725975822821205 | -122.47231844174 | (37.7259758228212, -122.47231844174) | ||
17733 | 17733 | 11662 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 6X6 | 5991320.71555 | 2093015.85848 | 37.726523937110294 | -122.472228178599 | (37.7265239371103, -122.472228178599) | |||
18049 | 18049 | 11751 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2X2 | 5991273.90921 | 2092612.06859 | 37.7254125216598 | -122.47236056150801 | (37.7254125216598, -122.472360561508) | ||
18063 | 18063 | 11685 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.62257 | 2092826.93511 | 37.726003458970105 | -122.472318441739 | (37.7260034589701, -122.472318441739) | ||
18245 | 18245 | 29623 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.61835 | 2090822.9081 | 37.720494067337796 | -122.472580327015 | (37.7204940673378, -122.472580327015) | ||
18472 | 18472 | 11680 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 2X2 | 5991310.78789 | 2092904.51417 | 37.726217638817296 | -122.47225438484199 | (37.7262176388173, -122.472254384842) | |||
18628 | 18628 | 29968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991358.26425 | 2093734.7800599998 | 37.7285000893956 | -122.47215075597299 | (37.7285000893956, -122.472150755973) | ||
19373 | 19373 | 29622 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991174.87312 | 2090845.33876 | 37.720555786911 | -122.472574167584 | (37.720555786911, -122.472574167584) | ||
19688 | 19688 | 29608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991185.36807 | 2091033.22274 | 37.721072277433 | -122.472551581098 | (37.721072277433, -122.472551581098) | ||
19993 | 19993 | 29602 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991190.461069999 | 2091063.23359 | 37.721154974612105 | -122.472536163113 | (37.7211549746121, -122.472536163113) | ||
20123 | 20123 | 11745 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 2X2 | 5991283.014280001 | 2092711.56765 | 37.7256862482988 | -122.472336336474 | (37.7256862482988, -122.472336336474) | |||
20481 | 20481 | 11750 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991277.22617 | 2092626.95248 | 37.725453581094996 | -122.472350179722 | (37.725453581095, -122.472350179722) | ||
20670 | 20670 | 29597 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991190.10875 | 2091113.4372599998 | 37.7212928010996 | -122.472541039259 | (37.7212928010996, -122.472541039259) | ||
21391 | 21391 | 29595 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991193.2800900005 | 2091140.60797 | 37.721367588722295 | -122.47253205683599 | (37.7213675887223, -122.472532056836) | ||
21425 | 21425 | 11754 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991270.92454 | 2092589.2026099998 | 37.725349564621204 | -122.472369212969 | (37.7253495646212, -122.472369212969) | ||
21748 | 21748 | 11670 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991313.29096 | 2092983.304 | 37.726434120931394 | -122.472251472829 | (37.7264341209314, -122.472251472829) | ||
21943 | 21943 | 11749 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991277.44671 | 2092637.4154400001 | 37.725482322545 | -122.472350179738 | (37.725482322545, -122.472350179738) | ||
22054 | 22054 | 29619 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991173.80248 | 2090879.07845 | 37.720648365804294 | -122.47258032701599 | (37.7206483658043, -122.472580327016) | ||
24427 | 24427 | 99454 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
46169 | 46169 | 188192 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014712.4620199995 | 2089164.16636 | 37.7172739556962 | -122.391094061367 | (37.7172739556962, -122.391094061367) | |||
58921 | 58921 | 188193 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014700.6925800005 | 2089174.7091700002 | 37.7173022510631 | -122.391135479631 | (37.7173022510631, -122.391135479631) | |||
73694 | 73694 | 188195 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014470.00417 | 2089321.4715900002 | 37.717692427352 | -122.391943124797 | (37.717692427352, -122.391943124797) | |||
77822 | 77822 | 97488 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 10 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
84567 | 84567 | 99479 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650X Miramar Ave | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |||
95807 | 95807 | 2146 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100X Bosworth St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2005 12:00:00 AM | 3 | 3X3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||
101615 | 101615 | 99480 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650X Miramar Ave | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |||
107073 | 107073 | 12 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 97 12th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
119365 | 119365 | 107320 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600X JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/31/2015 12:47:00 PM | 3 | 5991349.3 | 2093478.1 | 37.7277947912967 | -122.472163043281 | (37.7277947912967, -122.472163043281) | |||
121555 | 121555 | 99465 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 550X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
134352 | 134352 | 188190 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 828x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 6014862.4902 | 2088981.3043400003 | 37.716780176644896 | -122.390562709505 | (37.7167801766449, -122.390562709505) | |||
139369 | 139369 | 97491 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 30 | 15x280 | Permit Number 768370 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |
159414 | 159414 | 188194 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014479.07323 | 2089312.06804 | 37.717667110539395 | -122.391911119697 | (37.7176671105394, -122.391911119697) | |||
161647 | 161647 | 188189 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 828x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014874.8718 | 2088959.3424900002 | 37.716720560580605 | -122.390518378346 | (37.7167205605806, -122.390518378346) | |||
163682 | 163682 | 188196 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014458.158419999 | 2089328.2197 | 37.7177102986816 | -122.39198454217698 | (37.7177102986816, -122.391984542177) | |||
175115 | 175115 | 219878 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2x Montezuma St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6007278.55035 | 2099761.42955 | 37.7459564033742 | -122.41754030963699 | (37.7459564033742, -122.417540309637) | |||
183163 | 183163 | 188197 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014447.456130001 | 2089337.65595 | 37.717735614585294 | -122.39202219499501 | (37.7177356145853, -122.392022194995) | |||
188458 | 188458 | 188191 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014720.49682 | 2089157.49571 | 37.7172560852665 | -122.39106582262501 | (37.7172560852665, -122.391065822625) |
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");