Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28877 | 28877 | 188060 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017512.496169999 | 2097088.9484700002 | 37.7391888439962 | -122.381966489387 | (37.7391888439962, -122.381966489387) | |||
39264 | 39264 | 204069 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991925.79364 | 2089647.35065 | 37.7173098413624 | -122.469891319037 | (37.7173098413624, -122.469891319037) | |||
39356 | 39356 | 204071 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991926.528080001 | 2089611.9892799999 | 37.7172127901068 | -122.469886207299 | (37.7172127901068, -122.469886207299) | |||
41931 | 41931 | 204135 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 114 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991224.97526 | 2091857.93043 | 37.72333901327 | -122.47247476549299 | (37.72333901327, -122.472474765493) | |||
64961 | 64961 | 202040 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 350 Salinas Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012278.04252 | 2090758.61512 | 37.7215165973918 | -122.399620645181 | (37.7215165973918, -122.399620645181) | |||
69075 | 69075 | 204067 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991926.95794 | 2089679.2355799999 | 37.717397456914796 | -122.469889614813 | (37.7173974569148, -122.469889614813) | |||
70012 | 70012 | 204132 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 110 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991228.632230001 | 2091912.6848400002 | 37.7234895669738 | -122.47246611402001 | (37.7234895669738, -122.47246611402) | |||
73826 | 73826 | 188066 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1766 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014246.7994 | 2095052.7708599998 | 37.7334170310536 | -122.39311545041599 | (37.7334170310536, -122.393115450416) | |||
132631 | 132631 | 204077 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 207 Arch St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992694.39377 | 2088603.9622 | 37.7144893470695 | -122.46715883152599 | (37.7144893470695, -122.467158831526) | |||
133469 | 133469 | 250983 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 145 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5981179.0028800005 | 2112933.49353 | 37.780619963167204 | -122.508765181767 | (37.7806199631672, -122.508765181767) | |||
134590 | 134590 | 204065 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991927.94965 | 2089726.34257 | 37.71752685855721 | -122.469889614814 | (37.7175268585572, -122.469889614814) | |||
136989 | 136989 | 247605 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Tompkins Ave | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009347.11446 | 2096403.2051099997 | 37.7368516291864 | -122.410150415814 | (37.7368516291864, -122.410150415814) | |||
148168 | 148168 | 188078 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 28 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012505.18891 | 2096292.6832 | 37.7367246682956 | -122.399223733893 | (37.7367246682956, -122.399223733893) | |||
150832 | 150832 | 204103 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Junipero Serra Blvd | 14 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991407.75535 | 2094527.8682 | 37.7306805748458 | -122.472037446768 | (37.7306805748458, -122.472037446768) | |||
154655 | 154655 | 188079 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 29 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012534.30778 | 2096270.76721 | 37.73666611435429 | -122.399121518759 | (37.7366661143543, -122.399121518759) | |||
161329 | 161329 | 204155 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991146.25454 | 2090417.6717700001 | 37.7193798621823 | -122.47264192698 | (37.7193798621823, -122.47264192698) | |||
162914 | 162914 | 204064 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991927.921680001 | 2089748.4341799999 | 37.717587515118 | -122.46989131904499 | (37.717587515118, -122.469891319045) | |||
164810 | 164810 | 188062 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1649 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6015099.661859999 | 2096448.66175 | 37.737297204609106 | -122.390264331527 | (37.7372972046091, -122.390264331527) | |||
165588 | 165588 | 204070 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991926.35575 | 2089627.2113400002 | 37.7172545762149 | -122.469887910622 | (37.7172545762149, -122.469887910622) | |||
165761 | 165761 | 204063 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991928.61684 | 2089804.8745400002 | 37.71774252677329 | -122.469893023248 | (37.7177425267733, -122.469893023248) | |||
167766 | 167766 | 204134 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 112 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991228.00205 | 2091882.78985 | 37.7234074462669 | -122.472466114014 | (37.7234074462669, -122.472466114014) | |||
172323 | 172323 | 204078 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 516 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993011.249 | 2090617.45713 | 37.7200362035765 | -122.466209899293 | (37.7200362035765, -122.466209899293) | |||
173476 | 173476 | 202039 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 350 Salinas Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012297.61112 | 2090750.98182 | 37.721496728686 | -122.39955246577601 | (37.721496728686, -122.399552465776) | |||
175436 | 175436 | 204152 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991169.92245 | 2090751.38969 | 37.7202975393725 | -122.472584434247 | (37.7202975393725, -122.472584434247) | |||
177462 | 177462 | 204058 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 247 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991672.76031 | 2090179.42511 | 37.718756158047206 | -122.470804664228 | (37.7187561580472, -122.470804664228) | |||
182072 | 182072 | 204153 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 52 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991161.67549 | 2090655.1387900002 | 37.720032780762104 | -122.47260592714198 | (37.7200327807621, -122.472605927142) | |||
184601 | 184601 | 204062 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991928.03433 | 2089824.0323400002 | 37.71779509575 | -122.469896430779 | (37.71779509575, -122.469896430779) | |||
186725 | 186725 | 247729 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 39 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6001344.58941 | 2108869.46097 | 37.770629165242894 | -122.438711626759 | (37.7706291652429, -122.438711626759) | |||
188232 | 188232 | 204068 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991927.09954 | 2089662.54158 | 37.7173516274427 | -122.46988791059499 | (37.7173516274427, -122.469887910595) | |||
188457 | 188457 | 204057 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991692.74622 | 2089138.75635 | 37.7158998914375 | -122.47065982389299 | (37.7158998914375, -122.470659823893) |
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");