Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6294 | 6294 | 23536 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005728.741 | 2119933.47422 | 37.801256640539606 | -122.424333821661 | (37.8012566405396, -122.424333821661) | |||
13361 | 13361 | 117223 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013667.943030001 | 2111389.10897 | 37.7782409101283 | -122.39626130683997 | (37.7782409101283, -122.39626130684) | |
15881 | 15881 | 6819 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016343.96785 | 2097693.33127 | 37.7407837556653 | -122.386048891651 | (37.7407837556653, -122.386048891651) | |||
25967 | 25967 | 128688 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 270 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012957.31948 | 2117915.86722 | 37.7961222985589 | -122.39917789456699 | (37.7961222985589, -122.399177894567) | |||
25995 | 25995 | 189634 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 11th St | 11 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007263.01198 | 2110493.68646 | 37.7754238188976 | -122.41835486160299 | (37.7754238188976, -122.418354861603) | |||
27785 | 27785 | 126716 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2350 Green St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6001651.6937 | 2118053.9111099998 | 37.7958647911841 | -122.43830743725 | (37.7958647911841, -122.43830743725) | |||
28641 | 28641 | 128657 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013049.87065 | 2118876.68015 | 37.7987656191896 | -122.398925115818 | (37.7987656191896, -122.398925115818) | |||
29333 | 29333 | 190214 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Main St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013883.04706 | 2116660.73522 | 37.79272754757721 | -122.395886673545 | (37.7927275475772, -122.395886673545) | |||
31162 | 31162 | 247033 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6002285.13208 | 2099166.02387 | 37.7440393230544 | -122.434764280156 | (37.7440393230544, -122.434764280156) | ||||
33625 | 33625 | 128699 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012737.94775 | 2117884.6806099997 | 37.7960244397396 | -122.399934778363 | (37.7960244397396, -122.399934778363) | |||
34803 | 34803 | 128280 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011130.34295 | 2121394.1548099997 | 37.805570842188395 | -122.40574475584101 | (37.8055708421884, -122.405744755841) | |||
36607 | 36607 | 128120 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2300 Stockton St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009750.7882199995 | 2122191.39184 | 37.8076826122205 | -122.410575251057 | (37.8076826122205, -122.410575251057) | |||
37060 | 37060 | 128137 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Jones St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007847.301519999 | 2121919.41738 | 37.8068289397758 | -122.417143454113 | (37.8068289397758, -122.417143454113) | |||
37965 | 37965 | 192091 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 09th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6010609.75651 | 2108415.5498900004 | 37.7699055617172 | -122.406631146523 | (37.7699055617172, -122.406631146523) | |||
44630 | 44630 | 128580 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013003.72729 | 2117867.35902 | 37.795991692727796 | -122.39901390676901 | (37.7959916927278, -122.399013906769) | |||
47922 | 47922 | 117414 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010099.515980001 | 2122295.55675 | 37.807988167691 | -122.409375746091 | (37.807988167691, -122.409375746091) | |||
48518 | 48518 | 128177 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009075.68899 | 2122156.17098 | 37.8075480331694 | -122.41290910959101 | (37.8075480331694, -122.412909109591) | |||
50687 | 50687 | 225349 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 204 Addison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002618.3825900005 | 2097557.08683 | 37.739640470019104 | -122.433497019365 | (37.7396404700191, -122.433497019365) | |||
51905 | 51905 | 190183 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014115.34831 | 2116840.69938 | 37.793234607838 | -122.395095506674 | (37.793234607838, -122.395095506674) | |||
61562 | 61562 | 189676 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 11 | : Yard 23 | Tree 1 | Private 1 | 11 | 6017209.44087 | 2102637.39107 | 37.754406991811294 | -122.383400462871 | (37.7544069918113, -122.383400462871) | ||||
63166 | 63166 | 189620 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Harrison St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 6010860.68443 | 2110512.08897 | 37.7756762109182 | -122.405910897479 | (37.7756762109182, -122.405910897479) | |||
66214 | 66214 | 190163 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6014455.57349 | 2117002.88092 | 37.7936988342994 | -122.39392965433599 | (37.7936988342994, -122.393929654336) | |||
74184 | 74184 | 128191 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009576.83604 | 2122228.49008 | 37.8077747208047 | -122.41117987875401 | (37.8077747208047, -122.411179878754) | |||
76629 | 76629 | 128296 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6011760.219769999 | 2120791.0173 | 37.8039499778675 | -122.403522505873 | (37.8039499778675, -122.403522505873) | |||
115382 | 115382 | 192129 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 807 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6011264.88778 | 2113530.28638 | 37.7839860752403 | -122.40472517911999 | (37.7839860752403, -122.40472517912) | |||
121819 | 121819 | 102345 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401X Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |||
132143 | 132143 | 112706 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010019.71915 | 2121991.50115 | 37.8071488358223 | -122.40963042961901 | (37.8071488358223, -122.409630429619) | |||
151466 | 151466 | 224418 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Treat Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008535.7948199995 | 2106067.28042 | 37.763341506337795 | -122.41363884466001 | (37.7633415063378, -122.41363884466) | |||
153056 | 153056 | 128606 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Clay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012684.30695 | 2117566.96 | 37.7951490639233 | -122.40009806289 | (37.7951490639233, -122.40009806289) | |||
153824 | 153824 | 128228 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 68 Green St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012427.80626 | 2119545.10328 | 37.800566266079294 | -122.40112466597 | (37.8005662660793, -122.40112466597) | |||
155095 | 155095 | 225375 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 33 Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6006573.69851 | 2109211.00653 | 37.7718630602758 | -122.42064828841002 | (37.7718630602758, -122.42064828841) | |||
164609 | 164609 | 225511 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Church St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004201.159109999 | 2106105.10523 | 37.7632010052443 | -122.428633631453 | (37.7632010052443, -122.428633631453) | |||
164937 | 164937 | 128536 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6012154.62208 | 2116811.37451 | 37.79304485897129 | -122.401877725876 | (37.7930448589713, -122.401877725876) | |||
166852 | 166852 | 128020 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007980.399 | 2121368.92687 | 37.805324918966896 | -122.41664382046301 | (37.8053249189669, -122.416643820463) | |||
168294 | 168294 | 190108 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Utah St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010612.76141 | 2107213.91569 | 37.76660631694929 | -122.406536064782 | (37.7666063169493, -122.406536064782) | |||
172658 | 172658 | 127603 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7 Ada Ct | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008101.77795 | 2114166.01166 | 37.7855543229052 | -122.41571344391701 | (37.7855543229052, -122.415713443917) | |||
174085 | 174085 | 43304 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 19 | Permit Number 43072 | 6011287.96925 | 2105166.37556 | 37.7610219838923 | -122.404056515205 | (37.7610219838923, -122.404056515205) | |
175188 | 175188 | 128675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013334.73327 | 2117968.4564 | 37.7962877216558 | -122.39787564926 | (37.7962877216558, -122.39787564926) | |||
175412 | 175412 | 189054 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1498 Fairfax Ave | 11 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6016089.14176 | 2097873.9953400004 | 37.7412657158495 | -122.38694258933701 | (37.7412657158495, -122.386942589337) | |||
175543 | 175543 | 127071 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001367.07131 | 2119617.7708 | 37.800142546002796 | -122.439404437467 | (37.8001425460028, -122.439404437467) | |||
176184 | 176184 | 127929 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Leavenworth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007307.98439 | 2122001.97658 | 37.807025271655505 | -122.41901573201599 | (37.8070252716555, -122.419015732016) | |||
177348 | 177348 | 192115 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 367 Tehama St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011529.30578 | 2112635.54245 | 37.7815440930161 | -122.40374740562099 | (37.7815440930161, -122.403747405621) | |||
180350 | 180350 | 128759 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010976.350869999 | 2114853.25005 | 37.7876024893156 | -122.40581663775 | (37.7876024893156, -122.40581663775) | |||
181158 | 181158 | 190250 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012289.08769 | 2114973.00943 | 37.7880046463444 | -122.401283218273 | (37.7880046463444, -122.401283218273) |
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");