Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
85159 | 85159 | 108793 | Permitted Site 1 | :: 54 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
85310 | 85310 | 105043 | Permitted Site 1 | :: 54 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x4 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
99156 | 99156 | 33410 | Permitted Site 1 | :: 54 | 100 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
99690 | 99690 | 108992 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
100611 | 100611 | 116945 | Undocumented 2 | :: 54 | 3676 23RD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005238.0 | 2102584.0 | 37.753591501312705 | -122.424797029407 | (37.7535915013127, -122.424797029407) | ||||
109941 | 109941 | 114620 | Undocumented 2 | :: 54 | 2400X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
110291 | 110291 | 105085 | Significant Tree 6 | :: 54 | 344 Fulton St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
110696 | 110696 | 115065 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
112628 | 112628 | 116325 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
115373 | 115373 | 108811 | Undocumented 2 | :: 54 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
119911 | 119911 | 121130 | Undocumented 2 | :: 54 | 201 Bemis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||||
138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
141077 | 141077 | 39090 | Permitted Site 1 | :: 54 | 3140102 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
36871 | 36871 | 141519 | Undocumented 2 | :: 54 | 200 STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996701.0904 | 2111096.9463 | 37.7764800010927 | -122.454934429435 | (37.7764800010927, -122.454934429435) | |||
39009 | 39009 | 183902 | Undocumented 2 | :: 54 | 2101 22nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989433.6077 | 2100684.129 | 37.7474696361105 | -122.479312499521 | (37.7474696361105, -122.479312499521) | |||
43339 | 43339 | 182305 | Undocumented 2 | :: 54 | 2529 Kirkham St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986947.9231 | 2105031.9269 | 37.759262826435105 | -122.488227172206 | (37.7592628264351, -122.488227172206) | |||
45921 | 45921 | 184684 | Undocumented 2 | :: 54 | 3341 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983838.0977 | 2104243.1006 | 37.7569150061 | -122.498924003867 | (37.7569150061, -122.498924003867) | |||
46286 | 46286 | 138648 | Undocumented 2 | :: 54 | 600 PRESIDIO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999215.949 | 2114570.5132 | 37.786161460452796 | -122.446484808381 | (37.7861614604528, -122.446484808381) | |||
47025 | 47025 | 200502 | Undocumented 2 | :: 54 | 1500 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014797.5113 | 2092210.0981 | 37.7256422016088 | -122.39101285389098 | (37.7256422016088, -122.391012853891) | |||
55459 | 55459 | 183884 | Undocumented 2 | :: 54 | 2130 24th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988848.761 | 2100992.7334 | 37.748282996547104 | -122.48135743371799 | (37.7482829965471, -122.481357433718) | |||
60847 | 60847 | 183475 | Undocumented 2 | :: 54 | 2543 24th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988910.1133 | 2097942.5592 | 37.739911585859296 | -122.480921992881 | (37.7399115858593, -122.480921992881) | |||
60875 | 60875 | 138281 | Undocumented 2 | :: 54 | 2181 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001824.7124 | 2113924.8454 | 37.784537281287896 | -122.437412940551 | (37.7845372812879, -122.437412940551) | |||
66270 | 66270 | 140637 | Undocumented 2 | :: 54 | 478 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996867.0986 | 2109948.9271 | 37.7733373613011 | -122.454277220711 | (37.7733373613011, -122.454277220711) | |||
105066 | 105066 | 141940 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004067.7741 | 2112149.004 | 37.7797885282032 | -122.42952601949499 | (37.7797885282032, -122.429526019495) | |||
151800 | 151800 | 142762 | Undocumented 2 | :: 54 | 400 FILBERT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010787.7026 | 2120010.8966 | 37.8017535888682 | -122.40683296646999 | (37.8017535888682, -122.40683296647) | |||
164079 | 164079 | 244369 | Undocumented 2 | :: 54 | 301 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005524.5535 | 2110345.3319 | 37.774918458756396 | -122.424358051661 | (37.7749184587564, -122.424358051661) | |||
182893 | 182893 | 185839 | Undocumented 2 | :: 54 | 2000 35th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985427.385 | 2101213.0209999997 | 37.748688331560395 | -122.493204513888 | (37.7486883315604, -122.493204513888) | |||
185128 | 185128 | 185827 | Undocumented 2 | :: 54 | 2041 34th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985688.7443 | 2101313.9256 | 37.748980671146604 | -122.49230817773899 | (37.7489806711466, -122.492308177739) | |||
10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
83254 | 83254 | 110159 | Permitted Site 1 | :: 54 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | |||
116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
169919 | 169919 | 183889 | Undocumented 2 | :: 54 | 1390 Quintara St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5988959.6443 | 2101014.682 | 37.748349707800706 | -122.480975613562 | (37.7483497078007, -122.480975613562) | |||
181915 | 181915 | 246180 | Undocumented 2 | :: 54 | 1588 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997959.8858 | 2108225.8157 | 37.768668745448295 | -122.450372898384 | (37.7686687454483, -122.450372898384) |
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");