Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
86072 | 86072 | 54809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Carmel St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.760876867329294 | -122.449709427273 | (37.7608768673293, -122.449709427273) | |
140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
142230 | 142230 | 120534 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2043 32nd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5986293.0 | 2101328.0 | 37.7490546230695 | -122.49021972232599 | (37.7490546230695, -122.490219722326) | ||
148125 | 148125 | 79257 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 571 35th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 11 | 3x3 | Permit Number 49957 | 5985010.61242 | 2111991.22713 | 37.7782578784089 | -122.495440495889 | (37.7782578784089, -122.495440495889) | |
8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
79626 | 79626 | 94583 | Permitted Site 1 | Tree(s) :: 17 | 90 Joost Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6001518.0 | 2094975.2 | 37.732488714298 | -122.43711685564699 | (37.732488714298, -122.437116855647) | ||||
80984 | 80984 | 88447 | Permitted Site 1 | Tree(s) :: 17 | 93 Prentiss St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51413 | 6008891.7 | 2098141.7 | 37.7415996198956 | -122.411847801096 | (37.7415996198956, -122.411847801096) | ||
85057 | 85057 | 115566 | Permitted Site 1 | Tree(s) :: 17 | 2026 36TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777529 | 5985134.0 | 2101392.0 | 37.7491625951009 | -122.49423221215099 | (37.7491625951009, -122.494232212151) | |
85532 | 85532 | 108239 | Permitted Site 1 | Tree(s) :: 17 | 15 ASHBURY TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 5x50 | Permit Number 774721 | 5999554.7 | 2106911.6 | 37.7651513833487 | -122.444762103204 | (37.7651513833487, -122.444762103204) | |
102290 | 102290 | 31648 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
113764 | 113764 | 31646 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
114285 | 114285 | 96183 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||||
127496 | 127496 | 36443 | Permitted Site 1 | Tree(s) :: 17 | 1260 Plymouth Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/20/2009 12:00:00 AM | 3x3 | Permit Number 53041 | 5995883.45550893 | 2092448.59347632 | 37.725229366758 | -122.456414062747 | (37.725229366758, -122.456414062747) | ||
127767 | 127767 | 31647 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
129263 | 129263 | 63301 | Permitted Site 1 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.745892263304896 | -122.411424351246 | (37.7458922633049, -122.411424351246) | |
138475 | 138475 | 96182 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||
89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
104759 | 104759 | 87819 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 390 Lansdale Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 50681 | 5995630.7 | 2096410.1 | 37.736092191921294 | -122.457574304331 | (37.7360921919213, -122.457574304331) | ||||
11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
95797 | 95797 | 114729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1930 35TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/03/2015 12:00:00 AM | 4x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
117993 | 117993 | 108442 | Permitted Site 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 750 12th Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773771 | 5992283.6285 | 2110333.09253 | 37.7741282667999 | -122.470159914203 | (37.7741282667999, -122.470159914203) | |||
124233 | 124233 | 114680 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 54 Colby St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861.0 | 37.729793151999395 | -122.414784067206 | (37.7297931519994, -122.414784067206) | |||
104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
95257 | 95257 | 93959 | Permitted Site 1 | Prunus spp :: Cherry 84 | 419 Elizabeth St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 53399 | 6003681.0 | 2102149.0 | 37.752309029626495 | -122.430150445418 | (37.7523090296265, -122.430150445418) | ||||
66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
139591 | 139591 | 87070 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
143622 | 143622 | 87071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
89776 | 89776 | 98528 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
118464 | 118464 | 98529 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
56651 | 56651 | 31242 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2523 17th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50225 | 5991071.12499 | 2098214.14208 | 37.7407826611875 | -122.473469993967 | (37.7407826611875, -122.473469993967) | |
2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
85808 | 85808 | 98327 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 143 Alhambra St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49254 | 6001613.1 | 2120268.4 | 37.8019430002039 | -122.43859972925199 | (37.8019430002039, -122.438599729252) | ||
134828 | 134828 | 114679 | Permitted Site 1 | Malus :: Crab Apple 235 | 836 Brussels St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | ||
80053 | 80053 | 109497 | Permitted Site 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 785 Mangels Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438.0 | 2095245.0 | 37.732939449865896 | -122.45469900823 | (37.7329394498659, -122.45469900823) |
117945 | 117945 | 104498 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
128374 | 128374 | 104497 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) |
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");