Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
23630 | 23630 | 222878 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003263.67356 | 2105959.60231 | 37.7627483890498 | -122.431865689655 | (37.7627483890498, -122.431865689655) | |||
23700 | 23700 | 222864 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.753232969139795 | -122.413002991602 | (37.7532329691398, -122.413002991602) | |||
25929 | 25929 | 188459 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017898.8154 | 2096917.7474099998 | 37.7387400867836 | -122.38061886067499 | (37.7387400867836, -122.380618860675) | |||
33784 | 33784 | 125959 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.41655895865401 | (37.802457811042, -122.416558958654) | |||
34939 | 34939 | 175832 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994691.10568 | 2086786.7003099998 | 37.709614630390604 | -122.460125866041 | (37.7096146303906, -122.460125866041) | |||
35226 | 35226 | 222879 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | |||
39299 | 39299 | 125958 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.802248350842795 | -122.41705558676901 | (37.8022483508428, -122.417055586769) | |||
40338 | 40338 | 222869 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997758.85551 | 2107160.25032 | 37.765731467257396 | -122.45099139535299 | (37.7657314672574, -122.450991395353) | |||
40399 | 40399 | 125952 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.79789841912879 | -122.437172562074 | (37.7978984191288, -122.437172562074) | |||
43209 | 43209 | 188465 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011787.2831 | 2109744.8541900003 | 37.773621338281295 | -122.402651578111 | (37.7736213382813, -122.402651578111) | |||
43647 | 43647 | 205976 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1701 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990268.09461 | 2106501.35163 | 37.763490619320294 | -122.476851900801 | (37.7634906193203, -122.476851900801) | |||
46416 | 46416 | 125961 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.134880001 | 2120318.93587 | 37.802440037726 | -122.41668450579999 | (37.802440037726, -122.4166845058) | |||
46896 | 46896 | 175829 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994644.581040001 | 2086786.22758 | 37.709610656266996 | -122.460286627948 | (37.709610656267, -122.460286627948) | |||
47462 | 47462 | 188462 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | |||
55877 | 55877 | 175834 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994720.17465 | 2086786.5738400002 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | |||
58112 | 58112 | 125960 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007965.18699 | 2120322.0284599997 | 37.8024495444817 | -122.416622255608 | (37.8024495444817, -122.416622255608) | |||
60072 | 60072 | 188463 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011854.3498599995 | 2109717.34943 | 37.773549560687705 | -122.402417648277 | (37.7735495606877, -122.402417648277) | |||
60521 | 60521 | 222880 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003225.6095199995 | 2105960.03054 | 37.7627474070019 | -122.431997370179 | (37.7627474070019, -122.431997370179) | |||
61421 | 61421 | 175833 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994704.65642 | 2086785.9340000001 | 37.709613305686 | -122.46007897716999 | (37.709613305686, -122.46007897717) | |||
67016 | 67016 | 205980 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | |||
67587 | 67587 | 175828 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010182.474880001 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | |||
72455 | 72455 | 125964 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007746.87512 | 2120288.68768 | 37.8023457186479 | -122.41737536049999 | (37.8023457186479, -122.4173753605) | |||
73171 | 73171 | 222867 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005333.3615 | 2101936.42428 | 37.751818794216206 | -122.424421190788 | (37.7518187942162, -122.424421190788) | |||
96110 | 96110 | 222863 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008222.11657 | 2107958.0474099996 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | |||
120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) | |||
129865 | 129865 | 222882 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.740738898373706 | -122.42665275413201 | (37.7407388983737, -122.426652754132) | |||
130456 | 130456 | 205978 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 26 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993683.84565 | 2099240.9868799997 | 37.7437530733501 | -122.464510801149 | (37.7437530733501, -122.464510801149) | |||
131181 | 131181 | 125965 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 960 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007714.843640001 | 2120286.14045 | 37.8023369223605 | -122.41748602476801 | (37.8023369223605, -122.417486024768) | |||
133142 | 133142 | 125957 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1047 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009453.06953 | 2117007.5192299997 | 37.7934322851104 | -122.41123914946199 | (37.7934322851104, -122.411239149462) | |||
136942 | 136942 | 188460 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011827.042669999 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | |||
137261 | 137261 | 222859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004077.69446 | 2108250.00646 | 37.76908339881629 | -122.429213605151 | (37.7690833988163, -122.429213605151) | |||
147749 | 147749 | 188458 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158001 | (37.7386016766138, -122.38038486158) | |||
149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
150703 | 150703 | 222868 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005340.76956 | 2101936.5260900003 | 37.7518194920941 | -122.42439557991699 | (37.7518194920941, -122.424395579917) | |||
151386 | 151386 | 125962 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 952 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007785.23718 | 2120295.4388099997 | 37.802366413836204 | -122.41724308731001 | (37.8023664138362, -122.41724308731) | |||
151433 | 151433 | 125953 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999000.411280001 | 2115755.88881 | 37.7894038772406 | -122.44731585625799 | (37.7894038772406, -122.447315856258) | |||
152099 | 152099 | 188457 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.738562560606105 | -122.38033159384199 | (37.7385625606061, -122.380331593842) | |||
155799 | 155799 | 222877 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003276.24685 | 2105959.7003900004 | 37.7627493711059 | -122.43182221013001 | (37.7627493711059, -122.43182221013) | |||
159956 | 159956 | 188461 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011834.924330001 | 2109696.1650799997 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | |||
162239 | 162239 | 125954 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999004.62741 | 2115731.3369 | 37.7893367050801 | -122.447299501178 | (37.7893367050801, -122.447299501178) | |||
162578 | 162578 | 205979 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.743715225367104 | -122.46489100842301 | (37.7437152253671, -122.464891008423) | |||
164782 | 164782 | 125963 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007766.23356 | 2120291.4942799998 | 37.8023545140073 | -122.41730856964399 | (37.8023545140073, -122.417308569644) | |||
166330 | 166330 | 175839 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009068.666680001 | 2092869.3876 | 37.7271329121485 | -122.41086362855101 | (37.7271329121485, -122.410863628551) | |||
168575 | 168575 | 222862 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008204.356240001 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | |||
170113 | 170113 | 222875 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.43182793522301 | (37.7340120027534, -122.431827935223) | |||
171265 | 171265 | 175835 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | |||
172727 | 172727 | 175831 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994675.09306 | 2086785.5883900002 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | |||
174401 | 174401 | 175830 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | |||
175884 | 175884 | 125955 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999006.9985 | 2115714.87548 | 37.789291641844 | -122.447290112255 | (37.789291641844, -122.447290112255) | |||
177839 | 177839 | 125956 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1047 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009450.24252 | 2117026.36812 | 37.793483881020705 | -122.41125026328899 | (37.7934838810207, -122.411250263289) | |||
180660 | 180660 | 222861 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 77 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008184.4457 | 2107955.63736 | 37.7685067598049 | -122.414987714411 | (37.7685067598049, -122.414987714411) | |||
180911 | 180911 | 222881 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3844 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004001.37732 | 2104831.96458 | 37.759693956822204 | -122.429233822808 | (37.7596939568222, -122.429233822808) | |||
186635 | 186635 | 222873 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000914.513259999 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | |||
187802 | 187802 | 188464 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.40238525827499 | (37.7735766257899, -122.402385258275) |
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");