Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, 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) | |||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
33240 | 33240 | 189153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012332.534469999 | 2112551.48713 | 37.781358134807796 | -122.400962694499 | (37.7813581348078, -122.400962694499) | |||
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) | |||
36697 | 36697 | 220597 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | |||
37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
43603 | 43603 | 249538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006360.10871 | 2114050.0114700003 | 37.785137754239294 | -122.421730877876 | (37.7851377542393, -122.421730877876) | |||
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) | |||
47327 | 47327 | 201923 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 125 Elmira St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.735865039640395 | -122.403662651736 | (37.7358650396404, -122.403662651736) | |||
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) | |||
55787 | 55787 | 189171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 672 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013547.271380001 | 2103937.2716200002 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | |||
56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
63274 | 63274 | 203472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 126 Howth St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.721728810427706 | -122.450411736413 | (37.7217288104277, -122.450411736413) | |||
67177 | 67177 | 249537 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006345.87488 | 2114047.3209700002 | 37.7851295641198 | -122.421779931396 | (37.7851295641198, -122.421779931396) | |||
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) | |||
130236 | 130236 | 189156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | |||
131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
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) | |||
132641 | 132641 | 250079 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005448.26526 | 2115310.78255 | 37.7885480563034 | -122.42497530809099 | (37.7885480563034, -122.424975308091) | |||
136912 | 136912 | 250078 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.78854093456471 | -122.425019237271 | (37.7885409345647, -122.425019237271) | |||
148423 | 148423 | 189174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Waterville St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011435.762019999 | 2096086.73565 | 37.7360995216629 | -122.40290674814301 | (37.7360995216629, -122.402906748143) | |||
148879 | 148879 | 249535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006279.61488 | 2114039.5342599996 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | |||
148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
149175 | 149175 | 249549 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6005525.061919999 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | |||
151339 | 151339 | 189154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.781315772258104 | -122.401025754031 | (37.7813157722581, -122.401025754031) | |||
156002 | 156002 | 220591 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005640.71146 | 2108782.82006 | 37.770634736546896 | -122.42384510757601 | (37.7706347365469, -122.423845107576) | |||
162716 | 162716 | 125448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | |||
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) | |||
168630 | 168630 | 249544 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 298 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006142.8789800005 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | |||
170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
172051 | 172051 | 249551 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.787680143969496 | -122.424807261672 | (37.7876801439695, -122.424807261672) | |||
173152 | 173152 | 249533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006226.92854 | 2114031.46887 | 37.78507932978 | -122.42219032262 | (37.78507932978, -122.42219032262) | |||
173556 | 173556 | 246911 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.766445417441204 | -122.451710064262 | (37.7664454174412, -122.451710064262) | |||
177222 | 177222 | 125447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005068.7625400005 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | |||
181941 | 181941 | 250077 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | |||
182097 | 182097 | 249536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | |||
182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
185548 | 185548 | 203447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 327 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992190.092759999 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | |||
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) | |||
187777 | 187777 | 250076 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005407.46076 | 2115305.4621099997 | 37.788531142735295 | -122.425116106829 | (37.7885311427353, -122.425116106829) |
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");