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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10369 | 10369 | 83563 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.8721199995 | 2090986.9240400002 | 37.721584152666104 | -122.434011205875 | (37.7215841526661, -122.434011205875) | |
11369 | 11369 | 83554 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.5974299998 | 37.728188908672294 | -122.428695428367 | (37.7281889086723, -122.428695428367) |
11687 | 11687 | 83518 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) |
12350 | 12350 | 83555 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.8249699995 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) |
13067 | 13067 | 83533 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.43185274573099 | (37.724446620113, -122.431852745731) |
13749 | 13749 | 68842 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.39337550020399 | (37.7588942535933, -122.393375500204) |
31529 | 31529 | 52954 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.1163299999 | 37.7224704120511 | -122.43945112037399 | (37.7224704120511, -122.439451120374) | |
33778 | 33778 | 52557 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | |
39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
56096 | 56096 | 65853 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.44150173651501 | (37.8013609996628, -122.441501736515) | |
56157 | 56157 | 95935 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.48758207690001 | (37.7758745231149, -122.4875820769) |
56854 | 56854 | 88482 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014826.8932300005 | 2096240.8429 | 37.7367114428676 | -122.391192904038 | (37.7367114428676, -122.391192904038) | |
66540 | 66540 | 83309 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.758207981102295 | -122.50369693305099 | (37.7582079811023, -122.503696933051) | |
71687 | 71687 | 50032 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 5 | Permit Number 46764 | 6007353.74197 | 2093754.84576 | 37.729467879523895 | -122.416854825683 | (37.7294678795239, -122.416854825683) | |
73444 | 73444 | 34680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.43129571912701 | (37.7996008996227, -122.431295719127) | |
78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
118167 | 118167 | 43321 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 283 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49915 | 6004368.565719999 | 2091597.24704 | 37.7233752280736 | -122.427021263027 | (37.7233752280736, -122.427021263027) | |
118839 | 118839 | 88270 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346.0 | 2106829.0 | 37.764969709442504 | -122.44201926680701 | (37.7649697094425, -122.442019266807) | ||
150165 | 150165 | 88483 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.5284900002 | 37.7367412859786 | -122.39116233337201 | (37.7367412859786, -122.391162333372) | |
150847 | 150847 | 52442 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.43150359293301 | (37.7920224826905, -122.431503592933) | |
153309 | 153309 | 88186 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51193 | 6008751.52799 | 2109978.60624 | 37.774093208961204 | -122.41316928526001 | (37.7740932089612, -122.41316928526) | |
167979 | 167979 | 95712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) |
176002 | 176002 | 95742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.443109999 | 2091416.58174 | 37.7229052675357 | -122.42541178684799 | (37.7229052675357, -122.425411786848) |
176219 | 176219 | 88398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.923219999 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | |
178000 | 178000 | 95108 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 445 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54037 | 6002085.32525 | 2093826.71651 | 37.7293674729177 | -122.435073368138 | (37.7293674729177, -122.435073368138) |
181980 | 181980 | 60927 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.9694599998 | 37.732166840331104 | -122.406288313254 | (37.7321668403311, -122.406288313254) |
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");