Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158279 | 158279 | 124566 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3943 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5995914.73243 | 2114852.9465900003 | 37.7867478376308 | -122.457926519067 | (37.7867478376308, -122.457926519067) | |||
42403 | 42403 | 124334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5995958.15323 | 2113125.95358 | 37.782008471168 | -122.457651289636 | (37.782008471168, -122.457651289636) | |||
32960 | 32960 | 124335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.78196742074471 | -122.457646568088 | (37.7819674207447, -122.457646568088) | |||
29718 | 29718 | 130970 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002945.56276 | 2118345.7946599997 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | |||
56993 | 56993 | 130971 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6002947.99505 | 2118332.47012 | 37.7967032866916 | -122.43384191568998 | (37.7967032866916, -122.43384191569) | |||
148594 | 148594 | 130972 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002950.18497 | 2118317.4913 | 37.7966622830002 | -122.433833266913 | (37.7966622830002, -122.433833266913) | |||
35821 | 35821 | 130973 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.796619571497104 | -122.43382461811501 | (37.7966195714971, -122.433824618115) | |||
167026 | 167026 | 130974 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6002954.53886 | 2118286.2899 | 37.796576859099105 | -122.433815970239 | (37.7965768590991, -122.433815970239) | |||
184007 | 184007 | 130975 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002956.23707 | 2118277.75105 | 37.796553509993 | -122.43380948344101 | (37.796553509993, -122.433809483441) | |||
69069 | 69069 | 130976 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002956.82977 | 2118266.12381 | 37.796521618235005 | -122.433806601098 | (37.796521618235, -122.433806601098) | |||
165318 | 165318 | 130977 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6002958.5494099995 | 2118258.6214900003 | 37.7965011163873 | -122.43380011427901 | (37.7965011163873, -122.433800114279) | |||
182271 | 182271 | 130978 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002959.932159999 | 2118244.90398 | 37.7964635301195 | -122.433794348725 | (37.7964635301195, -122.433794348725) | |||
171243 | 171243 | 177432 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 66 Gladstone Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6006350.82649 | 2094014.80407 | 37.730125204807 | -122.420340452271 | (37.730125204807, -122.420340452271) | |||
22953 | 22953 | 103852 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
105404 | 105404 | 103863 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1435 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | ||
112678 | 112678 | 103864 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1435 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | ||
22940 | 22940 | 103859 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677.0 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | ||
22958 | 22958 | 103860 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677.0 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | ||
86852 | 86852 | 103869 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.42073037630101 | (37.7899185422019, -122.420730376301) | ||
103601 | 103601 | 103866 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.42073037630101 | (37.7899185422019, -122.420730376301) | ||
115999 | 115999 | 103868 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.42073037630101 | (37.7899185422019, -122.420730376301) | ||
22965 | 22965 | 103768 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757.0 | 2115467.0 | 37.7890508291132 | -122.42045837028401 | (37.7890508291132, -122.420458370284) | ||
90280 | 90280 | 103767 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757.0 | 2115467.0 | 37.7890508291132 | -122.42045837028401 | (37.7890508291132, -122.420458370284) | ||
83122 | 83122 | 103782 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | ||
122302 | 122302 | 103861 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1436 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.42045688909701 | (37.7902248822442, -122.420456889097) | ||
91623 | 91623 | 103865 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775.0 | 2115831.4 | 37.790052395748404 | -122.420421968076 | (37.7900523957484, -122.420421968076) | ||
4899 | 4899 | 109487 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 10/31/2017 02:27:00 PM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
101450 | 101450 | 109486 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | DPW 2 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
112063 | 112063 | 109488 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 01/23/2016 04:53:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
127048 | 127048 | 103773 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | |||
77434 | 77434 | 81367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.41983039718201 | (37.7858955407321, -122.419830397182) | |||
125641 | 125641 | 113226 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006956.0 | 2114756.0 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | ||||
25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
112214 | 112214 | 230331 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 217 Montcalm St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 6009886.65194 | 2099610.71375 | 37.745688979177 | -122.40851117835699 | (37.745688979177, -122.408511178357) |
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");