Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5325 | 5325 | 40088 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41311 | |||||||||
137899 | 137899 | 84640 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1363 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52752 | 5988634.2057 | 2106032.7782 | 37.7621091296561 | -122.482468596885 | (37.7621091296561, -122.482468596885) |
115861 | 115861 | 96677 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1701 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767971 | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
88192 | 88192 | 50440 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
138887 | 138887 | 50441 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
141592 | 141592 | 50443 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
145839 | 145839 | 50442 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
92134 | 92134 | 56560 | Permitted Site 1 | Prunus spp :: Cherry 84 | 298X SAN FERNANDO WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5992129.0 | 2095185.0 | 37.7325266047982 | -122.46959183484199 | (37.7325266047982, -122.469591834842) | |||
86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
111429 | 111429 | 82056 | Permitted Site 1 | Prunus spp :: Cherry 84 | 447 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2011 12:00:00 AM | 3x3 | Permit Number 767285 | 5993745.17939928 | 2090171.13367763 | 37.718853024691896 | -122.463640596127 | (37.7188530246919, -122.463640596127) | ||
116225 | 116225 | 49367 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1328@ 4th & 5t Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | Permit Number 47977 | 5994585.78557071 | 2112147.74022661 | 37.7792436288989 | -122.46232804837099 | (37.7792436288989, -122.462328048371) | |||
82397 | 82397 | 45454 | Permitted Site 1 | Prunus spp :: Cherry 84 | 219 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2001 12:00:00 AM | Permit Number 44239 | 5994709.07342911 | 2090056.25354598 | 37.7185930847656 | -122.460300500781 | (37.7185930847656, -122.460300500781) | |||
111732 | 111732 | 50308 | Permitted Site 1 | Prunus spp :: Cherry 84 | 701 (REVISED) Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.719949548569396 | -122.46024830726499 | (37.7199495485694, -122.460248307265) | |||
77997 | 77997 | 53523 | Permitted Site 1 | Prunus spp :: Cherry 84 | 221 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 4 | 3x3 | Permit Number 775251 | 5994812.01878897 | 2088373.36040249 | 37.7139781801866 | -122.45982282724701 | (37.7139781801866, -122.459822827247) | |
94724 | 94724 | 84725 | Permitted Site 1 | Prunus spp :: Cherry 84 | 20 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2007 12:00:00 AM | Permit No. 49296 | 5996092.0 | 2115960.0 | 37.7897976912986 | -122.457393340224 | (37.7897976912986, -122.457393340224) | |||
107994 | 107994 | 39201 | Permitted Site 1 | Prunus spp :: Cherry 84 | 36 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 3x3 | Permit Number 40852 | 5996541.64157093 | 2114326.11365116 | 37.7853372927938 | -122.455719478601 | (37.7853372927938, -122.455719478601) | ||
140252 | 140252 | 93987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 200 Belgrave Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 53411 | 5997460.5 | 2104904.0 | 37.759519290122 | -122.45186055280199 | (37.759519290122, -122.451860552802) | |||
97214 | 97214 | 17372 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1050X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 6 | 3X3 | Permit Number 769300 | 5999379.151930001 | 2109268.47217 | 37.771612740675394 | -122.44553877169399 | (37.7716127406754, -122.445538771694) | |
90536 | 90536 | 19034 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 2X2 | 5999529.89099 | 2115397.3219999997 | 37.7884495878023 | -122.445458129536 | (37.7884495878023, -122.445458129536) | |||
144369 | 144369 | 19033 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999542.700669999 | 2115392.3027 | 37.7884365373764 | -122.44541344917101 | (37.7884365373764, -122.445413449171) | |||
112476 | 112476 | 19031 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3190 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 5999568.0947900005 | 2115476.97835 | 37.7886704841429 | -122.445331680485 | (37.7886704841429, -122.445331680485) | |||
113713 | 113713 | 19022 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
94149 | 94149 | 58408 | Permitted Site 1 | Prunus spp :: Cherry 84 | 755 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1979 12:00:00 AM | 5 | Permit Number 17543 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.44400294123699 | (37.7683780948237, -122.444002941237) | ||
117786 | 117786 | 109243 | Permitted Site 1 | Prunus spp :: Cherry 84 | 755 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.44400294123699 | (37.7683780948237, -122.444002941237) | ||||
92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
78119 | 78119 | 105781 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1631 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 772613 | 6001347.6 | 2111440.1 | 37.7776876665107 | -122.43888545994 | (37.7776876665107, -122.43888545994) | |||
40011 | 40011 | 88560 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
143271 | 143271 | 88559 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
106210 | 106210 | 56999 | Permitted Site 1 | Prunus spp :: Cherry 84 | 4206 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | Permit Number 14257 | 6001838.61131344 | 2101787.92307498 | 37.7512130767933 | -122.43649586805401 | (37.7512130767933, -122.436495868054) | |||
153027 | 153027 | 80867 | Permitted Site 1 | Prunus spp :: Cherry 84 | 123 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50655 | 6003213.7924 | 2092811.2834 | 37.7266433347113 | -122.431099707385 | (37.7266433347113, -122.431099707385) | |
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) | ||||
140754 | 140754 | 53304 | Permitted Site 1 | Prunus spp :: Cherry 84 | 47 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/1969 12:00:00 AM | 2 | 4x4 | Permit Number 6194 | 6004117.25840717 | 2102785.08371789 | 37.7540802654829 | -122.42868713344 | (37.7540802654829, -122.42868713344) | |
100159 | 100159 | 52194 | Permitted Site 1 | Prunus spp :: Cherry 84 | 415 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | ||
125784 | 125784 | 42766 | Permitted Site 1 | Prunus spp :: Cherry 84 | 415 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |
81568 | 81568 | 40117 | Permitted Site 1 | Prunus spp :: Cherry 84 | 51 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/2001 12:00:00 AM | Permit Number 41332 | 6004835.9770779 | 2101026.68937802 | 37.7492927732201 | -122.42607645855 | (37.7492927732201, -122.42607645855) | ||
104294 | 104294 | 43986 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43550 | 6005547.87197183 | 2117529.65351428 | 37.7946461451301 | -122.42478860010799 | (37.7946461451301, -122.424788600108) | |||
91181 | 91181 | 51065 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
105516 | 105516 | 51062 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
111577 | 111577 | 51061 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
115880 | 115880 | 51064 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
141391 | 141391 | 51063 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
141745 | 141745 | 51060 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
47974 | 47974 | 43350 | Permitted Site 1 | Prunus spp :: Cherry 84 | 651 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2000 12:00:00 AM | 8 | Permit Number 43102 | 6007249.157459999 | 2091540.3167400002 | 37.7233813767346 | -122.417059535679 | (37.7233813767346, -122.417059535679) | ||
85877 | 85877 | 103517 | Permitted Site 1 | Prunus spp :: Cherry 84 | 55X MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 770452 | 6008432.0 | 2119159.0 | 37.7992824016355 | -122.41492448290899 | (37.7992824016355, -122.414924482909) | ||||
145578 | 145578 | 40428 | Permitted Site 1 | Prunus spp :: Cherry 84 | 29 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | Permit Number 41523 | 6007969.10251409 | 2094049.49213596 | 37.730311508750404 | -122.414748301777 | (37.7303115087504, -122.414748301777) | |||
124426 | 124426 | 41411 | Permitted Site 1 | Prunus spp :: Cherry 84 | 531 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | Permit Number 42023 | 6007932.96070428 | 2088253.06472002 | 37.7143937182098 | -122.414463253601 | (37.7143937182098, -122.414463253601) | |||
90214 | 90214 | 50019 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46753 | 6009308.17778689 | 2101227.80950502 | 37.750096752782504 | -122.410625639874 | (37.7500967527825, -122.410625639874) | ||
93929 | 93929 | 49741 | Permitted Site 1 | Prunus spp :: Cherry 84 | 646@ 18th Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | Permit Number 46540 | 6010086.91434322 | 2105281.03537103 | 37.761269634638296 | -122.408218548113 | (37.7612696346383, -122.408218548113) | |||
104487 | 104487 | 53181 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2784 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/2006 12:00:00 AM | 3x3 | Permit Number 49099 | 6010077.71172244 | 2102830.43618978 | 37.7545403242811 | -122.408077545352 | (37.7545403242811, -122.408077545352) | |
98329 | 98329 | 40636 | Permitted Site 1 | Prunus spp :: Cherry 84 | 142 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41636 | 6010372.94752615 | 2111469.26002805 | 37.7782770896065 | -122.40766561205099 | (37.7782770896065, -122.407665612051) | |||
19474 | 19474 | 51214 | Permitted Site 1 | Prunus spp :: Cherry 84 | 111 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47578 | 6014394.74626942 | 2116530.73461445 | 37.7923990500381 | -122.39410705418699 | (37.7923990500381, -122.394107054187) |
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");