Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
32222 | 32222 | 219278 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994659.22206 | 2100668.89439 | 37.747729927596396 | -122.46124169176001 | (37.7477299275964, -122.46124169176) | |||
39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) | |||
42674 | 42674 | 219277 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994666.162690001 | 2100675.76794 | 37.74774920006679 | -122.46121818977501 | (37.7477492000668, -122.461218189775) | |||
46210 | 46210 | 226966 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 17 Temple St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000015.92856 | 2105901.5883400002 | 37.7624044523192 | -122.443094287484 | (37.7624044523192, -122.443094287484) | |||
47837 | 47837 | 219366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992883.56621 | 2099683.9790000003 | 37.7449232514072 | -122.46731015773999 | (37.7449232514072, -122.46731015774) | |||
53868 | 53868 | 219242 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995302.90929 | 2090039.9744900002 | 37.718582527746705 | -122.45824668854799 | (37.7185825277467, -122.458246688548) | |||
53919 | 53919 | 218142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.717992043688895 | -122.449490525783 | (37.7179920436889, -122.449490525783) | |||
54353 | 54353 | 190762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1540 Newhall St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6014201.85219 | 2095471.1202599998 | 37.7345632359036 | -122.39330011180901 | (37.7345632359036, -122.393300111809) | |||
56355 | 56355 | 190820 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2301 Silver Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6012984.546630001 | 2096381.0531099997 | 37.7369940170607 | -122.397572570511 | (37.7369940170607, -122.397572570511) | |||
65273 | 65273 | 219243 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995302.33675 | 2090036.07608 | 37.718571790736796 | -122.45824838556601 | (37.7185717907368, -122.458248385566) | |||
73223 | 73223 | 118055 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 499 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5984683.022969999 | 2112541.9282299997 | 37.7797507575988 | -122.496614381059 | (37.7797507575988, -122.496614381059) | |||
73904 | 73904 | 219369 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994238.9129800005 | 2101823.0990400002 | 37.750874882880396 | -122.46277880671002 | (37.7508748828804, -122.46277880671) | |||
97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
152524 | 152524 | 219341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 176 Margaret Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 10ft | 5996604.57651 | 2089160.1054 | 37.7162413244539 | -122.45368388192101 | (37.7162413244539, -122.453683881921) | |||
155247 | 155247 | 190819 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2301 Silver Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6013014.89599 | 2096394.0221900002 | 37.7370313173328 | -122.397468547752 | (37.7370313173328, -122.397468547752) | |||
156857 | 156857 | 176639 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994551.36715 | 2086753.98013 | 37.7095167499667 | -122.460606453835 | (37.7095167499667, -122.460606453835) | |||
158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
160189 | 160189 | 185221 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | |||
168701 | 168701 | 182592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2489 26th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988273.3615 | 2098387.8742 | 37.7410972704537 | -122.483156220906 | (37.7410972704537, -122.483156220906) | |||
169609 | 169609 | 190818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Helena St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6011192.32656 | 2096261.9333400002 | 37.7365669811865 | -122.403760731784 | (37.7365669811865, -122.403760731784) | |||
175801 | 175801 | 219367 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992906.92509 | 2099685.21793 | 37.74492800164 | -122.46722947778 | (37.74492800164, -122.46722947778) | |||
182427 | 182427 | 219370 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994548.062390001 | 2100959.98911 | 37.748522802305004 | -122.461647175376 | (37.748522802305, -122.461647175376) |
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");