Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133637 | 133637 | 189200 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 625 Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.38607986071699 | (37.7392011179238, -122.386079860717) | |||
| 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) | |||
| 66225 | 66225 | 99400 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 67476 | 67476 | 99401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 79982 | 79982 | 99408 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 92011 | 92011 | 99403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 100451 | 100451 | 99404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 105779 | 105779 | 99406 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 119818 | 119818 | 99405 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 120185 | 120185 | 99407 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 160003 | 160003 | 99402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 185192 | 185192 | 189165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | |||
| 164200 | 164200 | 189164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6014453.294530001 | 2102557.3777799997 | 37.754034584334605 | -122.392926403935 | (37.7540345843346, -122.392926403935) | ||||
| 186805 | 186805 | 34852 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.6555699995 | 2104887.53933 | 37.760413499914996 | -122.394284848775 | (37.760413499915, -122.394284848775) | ||
| 124918 | 124918 | 50533 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | |||
| 171692 | 171692 | 189197 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.78206677001071 | -122.39473742989401 | (37.7820667700107, -122.394737429894) | |||
| 186976 | 186976 | 62043 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.240119999 | 2112760.57959 | 37.782031980627295 | -122.394782327659 | (37.7820319806273, -122.394782327659) | ||
| 55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 109567 | 109567 | 92782 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 527 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52999 | 6013573.0 | 2112256.0 | 37.780615911778604 | -122.396650538079 | (37.7806159117786, -122.396650538079) | |||
| 121657 | 121657 | 92783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 527 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52999 | 6013573.0 | 2112256.0 | 37.780615911778604 | -122.396650538079 | (37.7806159117786, -122.396650538079) | ||
| 50380 | 50380 | 189181 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013494.8789800005 | 2110935.49205 | 37.7769857497279 | -122.39682819267901 | (37.7769857497279, -122.396828192679) | |||
| 188318 | 188318 | 189182 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6013480.92655 | 2110921.9311900004 | 37.776947738078206 | -122.3968755078 | (37.7769477380782, -122.3968755078) | |||
| 131790 | 131790 | 189183 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6013471.29582 | 2110911.4086700003 | 37.7769183095594 | -122.396908085761 | (37.7769183095594, -122.396908085761) | |||
| 166425 | 166425 | 189184 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013459.66135 | 2110901.5969 | 37.776890721054 | -122.396947645136 | (37.776890721054, -122.396947645136) | |||
| 24476 | 24476 | 189185 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013378.5695400005 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | |||
| 41206 | 41206 | 189186 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013353.399019999 | 2110803.04971 | 37.776614217315505 | -122.39730832904199 | (37.7766142173155, -122.397308329042) | |||
| 77274 | 77274 | 189187 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013322.92845 | 2110771.0682 | 37.7765247068749 | -122.39741149296499 | (37.7765247068749, -122.397411492965) | |||
| 38661 | 38661 | 189188 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6013301.8737 | 2110750.05964 | 37.776465849843895 | -122.39748285416799 | (37.7764658498439, -122.397482854168) | |||
| 46441 | 46441 | 189189 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6013286.37012 | 2110737.4235099996 | 37.776430290657004 | -122.397535599396 | (37.776430290657, -122.397535599396) | |||
| 52510 | 52510 | 189190 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013250.96845 | 2110705.54176 | 37.7763407793478 | -122.39765582795499 | (37.7763407793478, -122.397655827955) | |||
| 173406 | 173406 | 189191 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013220.726430001 | 2110673.77845 | 37.7762518804538 | -122.39775821576599 | (37.7762518804538, -122.397758215766) | |||
| 175547 | 175547 | 189180 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.39907951143101 | (37.7845788525671, -122.399079511431) | |||
| 89567 | 89567 | 33006 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 93445 | 93445 | 33004 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 144926 | 144926 | 33001 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 43773 | 43773 | 189175 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012666.59913 | 2115298.5353200003 | 37.788919518565706 | -122.39999995672599 | (37.7889195185657, -122.399999956726) | |||
| 43884 | 43884 | 189176 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012661.31608 | 2115304.6540900003 | 37.7889360247231 | -122.40001866534901 | (37.7889360247231, -122.400018665349) | |||
| 133155 | 133155 | 189177 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | |||
| 152559 | 152559 | 189178 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012651.667780001 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | |||
| 48020 | 48020 | 189179 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012646.32236 | 2115321.2423900003 | 37.788980736331794 | -122.400071707361 | (37.7889807363318, -122.400071707361) | |||
| 30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
| 183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) | ||||
| 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) | |||
| 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) | |||
| 174841 | 174841 | 114540 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.4450199995 | 2104594.7801900003 | 37.7594980943773 | -122.40119249645299 | (37.7594980943773, -122.401192496453) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 72887 | 72887 | 189192 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012099.2034599995 | 2107516.8442700002 | 37.767521137926394 | -122.401415981588 | (37.7675211379264, -122.401415981588) | |||
| 188590 | 188590 | 189193 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012073.860090001 | 2107513.44954 | 37.767510402696296 | -122.401503402873 | (37.7675104026963, -122.401503402873) | |||
| 51580 | 51580 | 189194 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843001 | (37.7675077191257, -122.40157469843) | |||
| 140459 | 140459 | 95587 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153.0 | 2112651.0 | 37.781621357712396 | -122.401590796207 | (37.7816213577124, -122.401590796207) | |
| 178536 | 178536 | 189195 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.767506377346294 | -122.401629018386 | (37.7675063773463, -122.401629018386) | |||
| 148949 | 148949 | 189196 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012020.7847 | 2107509.88543 | 37.767497654832894 | -122.401686734167 | (37.7674976548329, -122.401686734167) | |||
| 75833 | 75833 | 41617 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.40176253082501 | (37.7456927230357, -122.401762530825) | |
| 147992 | 147992 | 189169 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2098 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6011892.76134 | 2104699.04319 | 37.75977256567371 | -122.40193193701401 | (37.7597725656737, -122.401931937014) | |||
| 149030 | 149030 | 79776 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.0863799998 | 37.75191893911521 | -122.401951552136 | (37.7519189391152, -122.401951552136) | |
| 49765 | 49765 | 94178 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1379 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53590 | 6011748.15969 | 2101956.8719099998 | 37.752235095787704 | -122.402239247057 | (37.7522350957877, -122.402239247057) | |
| 14649 | 14649 | 67492 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.40256406509701 | (37.7556157939465, -122.402564065097) | |
| 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) | |||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 76778 | 76778 | 189168 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013001 | (37.7619199120061, -122.40337783013) | |||
| 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) | |||
| 185067 | 185067 | 189199 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Clementina St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011498.9088 | 2112374.96394 | 37.780826907074704 | -122.40383422349701 | (37.7808269070747, -122.403834223497) | |||
| 70754 | 70754 | 249984 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | |||
| 133037 | 133037 | 249983 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.40401748554301 | (37.8020985894405, -122.404017485543) | |||
| 183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) | |||
| 45739 | 45739 | 249986 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | |||
| 159610 | 159610 | 249987 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | |||
| 61458 | 61458 | 249988 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.802054326596206 | -122.404084315938 | (37.8020543265962, -122.404084315938) | |||
| 35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
| 184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
| 61770 | 61770 | 249991 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.802049668108396 | -122.404102989475 | (37.8020496681084, -122.404102989475) | |||
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 74131 | 74131 | 249946 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011346.83837 | 2120055.6582400003 | 37.801907763181205 | -122.404901241218 | (37.8019077631812, -122.404901241218) | |||
| 41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
| 148756 | 148756 | 249948 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820376998 | (37.8018992421182, -122.40492820377) | |||
| 63040 | 63040 | 249939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 331 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.801856051265204 | -122.40512593233 | (37.8018560512652, -122.40512593233) | |||
| 75383 | 75383 | 125524 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011207.6846199995 | 2120726.9389400003 | 37.8037431562814 | -122.40543008395201 | (37.8037431562814, -122.405430083952) | |||
| 35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
| 160138 | 160138 | 125525 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | |||
| 150893 | 150893 | 189163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010839.472159999 | 2105097.2568200002 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | |||
| 175671 | 175671 | 220601 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.40576983700501 | (37.7468607265348, -122.405769837005) | |||
| 176141 | 176141 | 189198 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 450 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010926.82993 | 2112099.93954 | 37.780039778165495 | -122.405793955035 | (37.7800397781655, -122.405793955035) | |||
| 52592 | 52592 | 220600 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010666.22738 | 2100038.82593 | 37.7469081100366 | -122.405845659758 | (37.7469081100366, -122.405845659758) | |||
| 46865 | 46865 | 249820 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.40647720057301 | (37.8034168633488, -122.406477200573) | |||
| 39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | |||
| 78317 | 78317 | 96059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 100078 | 100078 | 94131 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | ||
| 101834 | 101834 | 96061 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 122429 | 122429 | 94132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | ||
| 143899 | 143899 | 96060 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 118016 | 118016 | 53452 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010475.69688316 | 2099901.56098952 | 37.7465205531872 | -122.406494829187 | (37.7465205531872, -122.406494829187) | ||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 137536 | 137536 | 249818 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284601996 | -122.40653352599399 | (37.803542284602, -122.406533525994) | |||
| 154615 | 154615 | 249823 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) |
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");