Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3100 | 3100 | 124475 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 1 | Width 3ft | Permit Number 51142 | 5996295.75285 | 2110564.44719 | 37.7749946376288 | -122.456298087251 | (37.7749946376288, -122.456298087251) | |
10315 | 10315 | 47259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770986 | 5989591.7291 | 2105266.36 | 37.7600604072843 | -122.479100863475 | (37.7600604072843, -122.479100863475) |
23166 | 23166 | 26519 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2851 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | 1X1 | Permit Number 777140 | 6009004.2746 | 2101873.01384 | 37.751851296609296 | -122.411722142074 | (37.7518512966093, -122.411722142074) | |
26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
44697 | 44697 | 103496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989840.04595 | 2110621.50302 | 37.7747785915425 | -122.478633697845 | (37.7747785915425, -122.478633697845) | |
46285 | 46285 | 65280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | |
48514 | 48514 | 50297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.4982599998 | 37.7341725865769 | -122.48029267728701 | (37.7341725865769, -122.480292677287) | |
50531 | 50531 | 96079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767703 | 5983226.11153 | 2111277.81973 | 37.7761944189321 | -122.501560849986 | (37.7761944189321, -122.501560849986) |
53314 | 53314 | 95695 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 523 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767449 | 5992184.07474 | 2111863.6623299997 | 37.7783250403386 | -122.47061578659999 | (37.7783250403386, -122.4706157866) |
54653 | 54653 | 51291 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2020 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | 1 | Permit Number 47663 | 5989189.38676 | 2113364.18569 | 37.7822714342333 | -122.481085302679 | (37.7822714342333, -122.481085302679) | ||
56087 | 56087 | 58297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1978 12:00:00 AM | 1 | Permit Number 17314 | 5995266.20192 | 2113689.20735 | 37.783515241763894 | -122.46008592615101 | (37.7835152417639, -122.460085926151) | ||
57170 | 57170 | 114542 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011944.84803 | 2103714.6650900003 | 37.757072587740296 | -122.401682603564 | (37.7570725877403, -122.401682603564) | ||
63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
64127 | 64127 | 105980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772437 | 5989466.7948900005 | 2110227.47578 | 37.7736750233383 | -122.479895995237 | (37.7736750233383, -122.479895995237) | |
68025 | 68025 | 95831 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767565 | 6010225.581130001 | 2112036.57812 | 37.7798265614898 | -122.408215431797 | (37.7798265614898, -122.408215431797) |
73545 | 73545 | 30881 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 1 | Permit Number 34714 | 6004013.78951 | 2108865.19521 | 37.7707689396642 | -122.42947852651301 | (37.7707689396642, -122.429478526513) | ||
125064 | 125064 | 32691 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010795.05101 | 2111971.34075 | 37.7796793055824 | -122.406240776896 | (37.7796793055824, -122.406240776896) | |
126323 | 126323 | 103499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989789.80565 | 2110619.51755 | 37.774770222886204 | -122.478807342211 | (37.7747702228862, -122.478807342211) | |
132392 | 132392 | 41910 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 595 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | 1 | Permit Number 42273 | 5992200.00918 | 2111450.35788 | 37.7771911401531 | -122.470530554439 | (37.7771911401531, -122.470530554439) | ||
135433 | 135433 | 96081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767704 | 5983251.84023 | 2110453.37841 | 37.773932253218 | -122.501410848383 | (37.773932253218, -122.501410848383) |
135464 | 135464 | 88201 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 436 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011209.66735 | 2112097.91592 | 37.780050034925104 | -122.404815345178 | (37.7800500349251, -122.404815345178) | |
136410 | 136410 | 82431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 650 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52680 | 5982600.56645 | 2111346.95635 | 37.7763474878375 | -122.503729865488 | (37.7763474878375, -122.503729865488) | |
138481 | 138481 | 106920 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6006764.0 | 2107336.0 | 37.76672546023 | -122.419856949025 | (37.76672546023, -122.419856949025) | ||||
146930 | 146930 | 103497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989824.39083 | 2110619.3957 | 37.7747718964667 | -122.47868769738001 | (37.7747718964667, -122.47868769738) | |
147133 | 147133 | 68292 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 1 | Permit Number 32101 | 5991174.54811 | 2115022.5246200003 | 37.7869399743547 | -122.47433864858101 | (37.7869399743547, -122.474338648581) | |
148645 | 148645 | 34700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52703 | 5981644.97521 | 2112008.50675 | 37.7781076783894 | -122.507084551143 | (37.7781076783894, -122.507084551143) | |
155442 | 155442 | 88202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 436 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011181.036719999 | 2112067.6395 | 37.779965302598704 | -122.404912259701 | (37.7799653025987, -122.404912259701) | |
158832 | 158832 | 114543 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011964.29912 | 2103715.1701700003 | 37.7570750599871 | -122.401615369369 | (37.7570750599871, -122.401615369369) | ||
160586 | 160586 | 95194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 517 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767108 | 5985627.976369999 | 2112321.20657 | 37.7792000368481 | -122.49332915492701 | (37.7792000368481, -122.493329154927) | |
163678 | 163678 | 81982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49998 | 5982533.65676 | 2111927.12728 | 37.7779365331701 | -122.504004303472 | (37.7779365331701, -122.504004303472) | |
170172 | 170172 | 59138 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18444 | 5992185.73773 | 2111803.62567 | 37.7781602921817 | -122.47060565987302 | (37.7781602921817, -122.470605659873) | ||
170297 | 170297 | 65278 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205633999 | (37.7806943784819, -122.40481205634) | |
171618 | 171618 | 68224 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 1 | Permit Number 769229 | 5990833.387490001 | 2113424.07906 | 37.782531317215295 | -122.47540222511999 | (37.7825313172153, -122.47540222512) | |
177092 | 177092 | 94734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53865 | 5992586.2471199995 | 2110603.0007 | 37.7748868521692 | -122.46913276056002 | (37.7748868521692, -122.46913276056) |
180014 | 180014 | 100870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769325 | 5995481.9791 | 2111446.40578 | 37.7773695144675 | -122.45917696584299 | (37.7773695144675, -122.459176965843) | |
180438 | 180438 | 103498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.1422900003 | 37.774770222887604 | -122.478745931564 | (37.7747702228876, -122.478745931564) | |
184129 | 184129 | 32690 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.622359999 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | |
185481 | 185481 | 51890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 1 | Permit Number 48103 | 6010867.53759 | 2112000.42013 | 37.779763205136206 | -122.40599206220301 | (37.7797632051362, -122.405992062203) | ||
186347 | 186347 | 47388 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 476Howard Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | 1 | Permit Number 45304 | 6010838.51311 | 2112011.8477 | 37.7797929592141 | -122.406093276399 | (37.7797929592141, -122.406093276399) |
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");