Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25205 | 25205 | 195981 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6018524.13374 | 2099557.3325900002 | 37.746022348857295 | -122.37864001312799 | (37.7460223488573, -122.378640013128) | ||||
26910 | 26910 | 195984 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | ||||
29206 | 29206 | 195983 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | ||||
46984 | 46984 | 195986 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018468.61509 | 2099561.7634900003 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | ||||
49096 | 49096 | 212850 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999489.821880001 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | |||
51068 | 51068 | 201994 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013316.6056 | 2092506.69666 | 37.7263743142142 | -122.396153039251 | (37.7263743142142, -122.396153039251) | ||||
61850 | 61850 | 195989 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.37921477706699 | (37.7460562901585, -122.379214777067) | ||||
69871 | 69871 | 195990 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018348.89198 | 2099575.3229 | 37.746062084515295 | -122.379247231793 | (37.7460620845153, -122.379247231793) | ||||
78277 | 78277 | 98312 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | |||||
120047 | 120047 | 195988 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018362.603680001 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | ||||
130066 | 130066 | 195985 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018474.359130001 | 2099556.32192 | 37.74601682971289 | -122.378812058831 | (37.7460168297129, -122.378812058831) | ||||
130871 | 130871 | 195987 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | ||||
132662 | 132662 | 201996 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013312.67339 | 2092499.74696 | 37.7263550129554 | -122.396166145968 | (37.7263550129554, -122.396166145968) | ||||
137250 | 137250 | 201997 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.39616384100201 | (37.7264024081338, -122.396163841002) | ||||
149276 | 149276 | 195992 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | ||||
157844 | 157844 | 201995 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013319.20907 | 2092521.7003099998 | 37.726415656052104 | -122.396145090149 | (37.7264156560521, -122.396145090149) | ||||
164241 | 164241 | 201993 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013314.351009999 | 2092488.44605 | 37.726324076294205 | -122.396159554816 | (37.7263240762942, -122.396159554816) | ||||
176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
177923 | 177923 | 195991 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018339.20952 | 2099575.6179 | 37.7460623605839 | -122.379280733321 | (37.7460623605839, -122.379280733321) | ||||
187127 | 187127 | 195982 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6018502.102580001 | 2099556.87815 | 37.746019886521296 | -122.378716163238 | (37.7460198865213, -122.378716163238) |
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");