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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
27164 | 27164 | 187561 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.40405920239401 | (37.7143031001696, -122.404059202394) | ||||
29771 | 29771 | 249766 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | Width 0ft | 6011007.58004 | 2120722.18976 | 37.80371892584 | -122.40612222558201 | (37.80371892584, -122.406122225582) | |||
37362 | 37362 | 189286 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1301 Minnesota St | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | ||||
37660 | 37660 | 245587 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3949 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002176.37234 | 2103519.1436900003 | 37.755985782226205 | -122.43545168597 | (37.7559857822262, -122.43545168597) | ||||
40618 | 40618 | 245485 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1300 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 5ft | 6003516.634869999 | 2095667.30987 | 37.7345024965788 | -122.430256461687 | (37.7345024965788, -122.430256461687) | |||
41306 | 41306 | 249697 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2400 Baker St | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999686.57454 | 2117300.49372 | 37.79368414027 | -122.445052904783 | (37.79368414027, -122.445052904783) | ||||
42031 | 42031 | 245600 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 91 Saint Germain Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5998015.018019999 | 2104129.8015900003 | 37.757425279379994 | -122.44988696761601 | (37.75742527938, -122.449886967616) | |||
45993 | 45993 | 245793 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002836.40816 | 2098357.0124 | 37.7418492481435 | -122.432800311009 | (37.7418492481435, -122.432800311009) | ||||
48319 | 48319 | 249971 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | Width 0ft | 6011749.26924 | 2120132.42748 | 37.8021410392439 | -122.403514037858 | (37.8021410392439, -122.403514037858) | |||
48408 | 48408 | 187498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.42398018305599 | (37.7093929151184, -122.423980183056) | ||||
49402 | 49402 | 187559 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6010948.12811 | 2088162.00128 | 37.714312602426894 | -122.404035178792 | (37.7143126024269, -122.404035178792) | ||||
49444 | 49444 | 249767 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 0ft | 6010996.518680001 | 2120736.58117 | 37.8037578224149 | -122.406161518736 | (37.8037578224149, -122.406161518736) | |||
50291 | 50291 | 245792 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002825.04242 | 2098363.5292 | 37.7418664971384 | -122.43284007543501 | (37.7418664971384, -122.432840075435) | ||||
52882 | 52882 | 189285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1301 Minnesota St | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015362.8739599995 | 2102344.01113 | 37.7534992062408 | -122.389765930873 | (37.7534992062408, -122.389765930873) | ||||
54092 | 54092 | 249690 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2400 Baker St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999737.36235 | 2117301.9106 | 37.793690929232795 | -122.444877277083 | (37.7936909292328, -122.444877277083) | ||||
60503 | 60503 | 187503 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005106.379430001 | 2086503.4563099998 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | ||||
65420 | 65420 | 247861 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 81 Bradford St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6009580.66804 | 2098127.95413 | 37.741600504664 | -122.409464602736 | (37.741600504664, -122.409464602736) | ||||
72756 | 72756 | 245795 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002841.82377 | 2098354.17483 | 37.7418417639849 | -122.43278138295601 | (37.7418417639849, -122.432781382956) | ||||
73009 | 73009 | 187502 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | ||||
73734 | 73734 | 245790 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002818.16213 | 2098366.55064 | 37.7418744030785 | -122.432864081016 | (37.7418744030785, -122.432864081016) | ||||
75494 | 75494 | 187560 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010944.5891 | 2088158.85993 | 37.7143037791818 | -122.40404719012699 | (37.7143037791818, -122.404047190127) | ||||
75817 | 75817 | 247835 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Nevada St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 58 | 6009027.31415 | 2098119.1381900003 | 37.7415452773025 | -122.411377297935 | (37.7415452773025, -122.411377297935) | ||||
77979 | 77979 | 111520 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 800x BOSWORTH ST | 15 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 7 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
100652 | 100652 | 101029 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1010X Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
126950 | 126950 | 104523 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 51X BONVIEW ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | |||||
130805 | 130805 | 245715 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 190 Storrie St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 3ft | 6000794.80265 | 2105326.21075 | 37.760868985837604 | -122.440359191023 | (37.7608689858376, -122.440359191023) | |||
133455 | 133455 | 126127 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 956 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 57 | 6008898.21639 | 2118715.7176599996 | 37.798091444229605 | -122.41327984251001 | (37.7980914442296, -122.41327984251) | ||||
134081 | 134081 | 187501 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005123.3425 | 2086496.8566299998 | 37.7094133054443 | -122.42404960170099 | (37.7094133054443, -122.424049601701) | ||||
135317 | 135317 | 245748 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 172 States St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 3ft | 6001078.73649 | 2106349.47009 | 37.763694767223704 | -122.43945054392599 | (37.7636947672237, -122.439450543926) | |||
146574 | 146574 | 124274 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5994910.91331 | 2114969.48118 | 37.7870100866839 | -122.46140792196002 | (37.7870100866839, -122.46140792196) | ||||
147302 | 147302 | 249859 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 235 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011602.10875 | 2120412.3489 | 37.802901414233496 | -122.404042997489 | (37.8029014142335, -122.404042997489) | |||
157296 | 157296 | 245714 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 190 Storrie St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6000760.42696 | 2105281.17625 | 37.7607433748224 | -122.440474851044 | (37.7607433748224, -122.440474851044) | |||
159692 | 159692 | 189313 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2094 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6012465.80761 | 2096393.5196200002 | 37.736999349139296 | -122.39936696983601 | (37.7369993491393, -122.399366969836) | ||||
162383 | 162383 | 86947 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 283 Athens St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Permit Number 49915 | 6004370.91908 | 2091607.61661 | 37.7234038337052 | -122.42701386610099 | (37.7234038337052, -122.427013866101) | |||
163215 | 163215 | 245716 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 190 Storrie St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 3ft | 6000826.49409 | 2105355.82769 | 37.760952111073706 | -122.440251708571 | (37.7609521110737, -122.440251708571) | |||
164451 | 164451 | 245791 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002821.2281599995 | 2098364.56274 | 37.741869118664496 | -122.43285333771001 | (37.7418691186645, -122.43285333771) | ||||
168359 | 168359 | 250206 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 212 Union St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011790.69838 | 2119796.4125 | 37.801220737809295 | -122.40334702027 | (37.8012207378093, -122.40334702027) | |||
168485 | 168485 | 246744 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Ripley St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008911.682130001 | 2099076.13806 | 37.744166502486294 | -122.411844724161 | (37.7441665024863, -122.411844724161) | ||||
176277 | 176277 | 189284 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1301 Minnesota St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015381.32425 | 2102392.4486700003 | 37.7536332285927 | -122.389705508116 | (37.7536332285927, -122.389705508116) | ||||
179948 | 179948 | 249973 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 23 Napier Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011640.89127 | 2120262.65175 | 37.802492549159204 | -122.403898248899 | (37.8024925491592, -122.403898248899) | |||
181447 | 181447 | 245794 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 601 30th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002837.91517 | 2098354.25557 | 37.741841763999204 | -122.43279490337099 | (37.7418417639992, -122.432794903371) | ||||
181736 | 181736 | 249699 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2400 Baker St | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5999692.345380001 | 2117233.07075 | 37.793499343978795 | -122.445028087992 | (37.7934993439788, -122.445028087992) | ||||
184411 | 184411 | 245588 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3937 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6002234.37005 | 2103520.06292 | 37.7559915999457 | -122.43525117671801 | (37.7559915999457, -122.435251176718) | ||||
184802 | 184802 | 249765 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | Width 0ft | 6010998.40684 | 2120702.14433 | 37.8036633729317 | -122.406152556991 | (37.8036633729317, -122.406152556991) |
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");