Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
26824 | 26824 | 125535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | |||
30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
33829 | 33829 | 189162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036411998 | (37.7724260745213, -122.41525036412) | |||
35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
38916 | 38916 | 125482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.41113140348499 | (37.7914679787239, -122.411131403485) | |||
43952 | 43952 | 221766 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002158.80169 | 2108813.78872 | 37.770522589268204 | -122.43589127638799 | (37.7705225892682, -122.435891276388) | |||
44557 | 44557 | 119343 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 462 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985960.41468 | 2112779.42827 | 37.7804776215792 | -122.49221287963199 | (37.7804776215792, -122.492212879632) | |||
46216 | 46216 | 189159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | |||
47631 | 47631 | 221761 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4441 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001542.762080001 | 2104063.39418 | 37.75744415704379 | -122.437681892224 | (37.7574441570438, -122.437681892224) | |||
47885 | 47885 | 125511 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008625.76186 | 2119029.2242099997 | 37.7989369553212 | -122.41424481055799 | (37.7989369553212, -122.414244810558) | |||
48850 | 48850 | 246960 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2177 15th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003038.46952 | 2107086.92585 | 37.7658309772437 | -122.432725124067 | (37.7658309772437, -122.432725124067) | |||
49294 | 49294 | 221759 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001360.92884 | 2104054.05926 | 37.7574081850601 | -122.438310074049 | (37.7574081850601, -122.438310074049) | |||
49806 | 49806 | 221764 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3809 16th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6001727.44948 | 2106346.3994299998 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | |||
54829 | 54829 | 221760 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.43826897865101 | (37.7574116654297, -122.438268978651) | |||
55188 | 55188 | 203461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 409 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998653.32929 | 2094365.51359 | 37.7306514071182 | -122.446976805539 | (37.7306514071182, -122.446976805539) | |||
60116 | 60116 | 248097 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010442.71302 | 2099823.47595 | 37.7463043033989 | -122.406603382656 | (37.7463043033989, -122.406603382656) | |||
61770 | 61770 | 249991 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.802049668108396 | -122.404102989475 | (37.8020496681084, -122.404102989475) | |||
63403 | 63403 | 221758 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001348.5727699995 | 2104052.2530799997 | 37.757402522937 | -122.438352676761 | (37.757402522937, -122.438352676761) | |||
70634 | 70634 | 189160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008158.83722 | 2109400.5814099996 | 37.772472797918 | -122.415178587445 | (37.772472797918, -122.415178587445) | |||
71399 | 71399 | 125537 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.43392 | 2116876.79887 | 37.7931084671277 | -122.409062644443 | (37.7931084671277, -122.409062644443) | |||
74953 | 74953 | 125514 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008590.31929 | 2119027.3925900003 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | |||
77178 | 77178 | 220638 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 222 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 5997115.15152 | 2106725.56313 | 37.7645010544003 | -122.453186433611 | (37.7645010544003, -122.453186433611) | |||
132055 | 132055 | 189161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.41521025345699 | (37.7724477670719, -122.415210253457) | |||
132179 | 132179 | 220641 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007571.590369999 | 2095340.9683400001 | 37.7338352787826 | -122.416213992189 | (37.7338352787826, -122.416213992189) | |||
134395 | 134395 | 125517 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008575.41519 | 2119026.3782099998 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | |||
149721 | 149721 | 125500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.41895432719299 | (37.7995302219096, -122.418954327193) | ||||
150359 | 150359 | 125533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010078.6629 | 2116885.41787 | 37.7931320896218 | -122.40906592066901 | (37.7931320896218, -122.409065920669) | |||
150893 | 150893 | 189163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010839.472159999 | 2105097.2568200002 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | |||
155489 | 155489 | 125460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | |||
159071 | 159071 | 125499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007355.47144 | 2119286.0885099997 | 37.799570804701396 | -122.418658671469 | (37.7995708047014, -122.418658671469) | ||||
161599 | 161599 | 125530 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010077.8438099995 | 2116891.68093 | 37.7931492405824 | -122.40906919691002 | (37.7931492405824, -122.40906919691) | |||
161762 | 161762 | 220642 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008547.4442300005 | 2096175.62445 | 37.7361818869891 | -122.41289915230101 | (37.7361818869891, -122.412899152301) | |||
163457 | 163457 | 189152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1665 Hudson Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6015368.44602 | 2097645.0372099997 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | |||
164035 | 164035 | 203455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | |||
164200 | 164200 | 189164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6014453.294530001 | 2102557.3777799997 | 37.754034584334605 | -122.392926403935 | (37.7540345843346, -122.392926403935) | ||||
167745 | 167745 | 220613 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 919 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007605.87187 | 2104275.7103 | 37.7583700063988 | -122.416728224545 | (37.7583700063988, -122.416728224545) | |||
172712 | 172712 | 125518 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | |||
184003 | 184003 | 125521 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008568.41134 | 2119026.0619799998 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | |||
184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
186515 | 186515 | 189172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1947 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013391.6303 | 2095988.7563900002 | 37.735939510689605 | -122.396137605077 | (37.7359395106896, -122.396137605077) | |||
186745 | 186745 | 189158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008181.208740001 | 2109420.17856 | 37.7725278642987 | -122.41510258932301 | (37.7725278642987, -122.415102589323) |
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");