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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
6941 | 6941 | 87735 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.063999999 | 2121526.81323 | 37.8056161950061 | -122.42538739630501 | (37.8056161950061, -122.425387396305) | ||
12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
13018 | 13018 | 15903 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | TR20 | 5998269.83738 | 2087060.55751 | 37.7105717725495 | -122.44777690001101 | (37.7105717725495, -122.447776900011) | ||
15839 | 15839 | 18557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1700X Quesada Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014589.42489 | 2095117.7447900001 | 37.733614463738604 | -122.391935430178 | (37.7336144637386, -122.391935430178) | |||
16013 | 16013 | 22114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3650X 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5X5 | 6015872.240569999 | 2098764.87252 | 37.7436998694469 | -122.38775470773999 | (37.7436998694469, -122.38775470774) | |||
17312 | 17312 | 29983 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1622X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005924.09258 | 2099580.5471799998 | 37.7453834354083 | -122.42221099896001 | (37.7453834354083, -122.42221099896) | ||
18005 | 18005 | 29702 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005878.4786 | 2100373.84581 | 37.747559079794996 | -122.42242508166099 | (37.747559079795, -122.422425081661) | |||
19265 | 19265 | 29699 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.42240805210399 | (37.747401343192, -122.422408052104) | |||
19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
19586 | 19586 | 29705 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005872.46136 | 2100440.5238200002 | 37.747741822942 | -122.422450626014 | (37.747741822942, -122.422450626014) | |||
20311 | 20311 | 29991 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 681X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005873.40419 | 2099356.34635 | 37.744764971617705 | -122.422370344434 | (37.7447649716177, -122.422370344434) | ||
21165 | 21165 | 30006 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 795X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005619.53854 | 2098557.61175 | 37.742557503841205 | -122.42319139937099 | (37.7425575038412, -122.423191399371) | ||
23843 | 23843 | 233645 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005912.55723 | 2099806.72525 | 37.7460038183146 | -122.422266952984 | (37.7460038183146, -122.422266952984) | |||
26941 | 26941 | 233639 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 738x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005705.797780001 | 2098817.87018 | 37.743276982150604 | -122.42291163287099 | (37.7432769821506, -122.422911632871) | |||
32672 | 32672 | 233640 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 738x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005718.0637 | 2098849.84637 | 37.7433654736312 | -122.422871492542 | (37.7433654736312, -122.422871492542) | |||
36608 | 36608 | 107488 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6011453.59321 | 2119920.31769 | 37.80154211772779 | -122.40452228489599 | (37.8015421177278, -122.404522284896) | ||||
48474 | 48474 | 233642 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005819.20445 | 2099183.8335 | 37.74428823292521 | -122.422545500883 | (37.7442882329252, -122.422545500883) | |||
50406 | 50406 | 233644 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005913.286069999 | 2099739.4537 | 37.7458191470481 | -122.422259654081 | (37.7458191470481, -122.422259654081) | |||
51946 | 51946 | 233643 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005840.60494 | 2099248.2230599998 | 37.7444662393403 | -122.422476076803 | (37.7444662393403, -122.422476076803) | |||
54766 | 54766 | 117843 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.776949922870294 | -122.49956003685301 | (37.7769499228703, -122.499560036853) | |||
55578 | 55578 | 107482 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.97806 | 2119852.64786 | 37.801356557918794 | -122.404502345126 | (37.8013565579188, -122.404502345126) | ||||
55643 | 55643 | 107485 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.40450512760401 | (37.8013944904094, -122.404505127604) | ||||
56556 | 56556 | 87733 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.4175299997 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | ||
56671 | 56671 | 233635 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 795x San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005628.854669999 | 2098582.9928 | 37.74262772020089 | -122.42316099060699 | (37.7426277202009, -122.423160990607) | |||
62152 | 62152 | 107486 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 6011455.57226 | 2119886.9035799997 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | ||||
69761 | 69761 | 117845 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.49954924088199 | (37.7768809995382, -122.499549240882) | |||
75483 | 75483 | 233649 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005892.8899 | 2100133.60175 | 37.746900237356 | -122.422358181107 | (37.746900237356, -122.422358181107) | |||
76029 | 76029 | 117836 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.776232607542504 | -122.499507291354 | (37.7762326075425, -122.499507291354) | |||
76768 | 76768 | 233647 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005899.49267 | 2100009.81347 | 37.7465607153996 | -122.42232655552799 | (37.7465607153996, -122.422326555528) | |||
84021 | 84021 | 30019 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 710X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
87352 | 87352 | 87731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
88228 | 88228 | 87736 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
89578 | 89578 | 11198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 186 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
101078 | 101078 | 30018 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 710X San Jose Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
105087 | 105087 | 813 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
111465 | 111465 | 810 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
113375 | 113375 | 30002 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 610X San Jose Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
113968 | 113968 | 87734 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | |||
114988 | 114988 | 812 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
125002 | 125002 | 87737 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
128619 | 128619 | 22523 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6600 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
133687 | 133687 | 233648 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005895.98726 | 2100078.89273 | 37.7467501935748 | -122.422343584206 | (37.7467501935748, -122.422343584206) | |||
136451 | 136451 | 233641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005830.56896 | 2099219.38294 | 37.74438648474779 | -122.42250873031799 | (37.7443864847478, -122.422508730318) | |||
136461 | 136461 | 233650 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005893.26396 | 2100151.80931 | 37.7469502522662 | -122.422358181105 | (37.7469502522662, -122.422358181105) | |||
145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
150249 | 150249 | 233646 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005909.2658400005 | 2099851.98083 | 37.746127894184106 | -122.422281548977 | (37.7461278941841, -122.422281548977) | |||
150462 | 150462 | 210768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 8x Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994536.81883 | 2106004.59746 | 37.7623733582716 | -122.46205183074 | (37.7623733582716, -122.46205183074) | |||
154625 | 154625 | 117847 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 640x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 5983816.430369999 | 2111419.8653700002 | 37.7766190887274 | -122.49952930905701 | (37.7766190887274, -122.499529309057) | |||
167005 | 167005 | 233636 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005636.68539 | 2098604.551 | 37.7426873560463 | -122.42313544624399 | (37.7426873560463, -122.423135446244) | |||
167503 | 167503 | 117838 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | |||
169348 | 169348 | 210767 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994619.5923 | 2106010.48038 | 37.7623942765042 | -122.46176597673599 | (37.7623942765042, -122.461765976736) | |||
182264 | 182264 | 233638 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005667.10941 | 2098695.24621 | 37.7429381014114 | -122.42303669349899 | (37.7429381014114, -122.423036693499) | |||
186073 | 186073 | 233637 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.74272486946911 | -122.423117200821 | (37.7427248694691, -122.423117200821) |
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");