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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
155630 | 155630 | 196373 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012066.64129 | 2105141.25616 | 37.760996487210996 | -122.40136164543101 | (37.760996487211, -122.401361645431) | ||||
157664 | 157664 | 237950 | Undocumented 2 | Prunus spp :: Cherry 84 | 3145 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008062.3853 | 2102670.45818 | 37.75398801563821 | -122.415035774193 | (37.7539880156382, -122.415035774193) | |||
165336 | 165336 | 213703 | Undocumented 2 | Prunus spp :: Cherry 84 | 27 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5999907.55727 | 2095471.26814 | 37.733759127772394 | -122.442720129024 | (37.7337591277724, -122.442720129024) | |||
165975 | 165975 | 136022 | Undocumented 2 | Prunus spp :: Cherry 84 | 60 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6008402.81482 | 2119144.69077 | 37.7992414720639 | -122.415024460715 | (37.7992414720639, -122.415024460715) | ||||
166130 | 166130 | 238535 | Undocumented 2 | Prunus spp :: Cherry 84 | 118 Saint Marys Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6003941.15849 | 2095961.17353 | 37.735333416189206 | -122.42880968543899 | (37.7353334161892, -122.428809685439) | |||
181728 | 181728 | 136027 | Undocumented 2 | Prunus spp :: Cherry 84 | 957 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6010215.88282 | 2116843.14587 | 37.7930237069305 | -122.408588145932 | (37.7930237069305, -122.408588145932) | |||
182122 | 182122 | 185047 | Undocumented 2 | Prunus spp :: Cherry 84 | 2767 34th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985832.2143 | 2096586.5348 | 37.7360089113847 | -122.491464150215 | (37.7360089113847, -122.491464150215) | |||
183108 | 183108 | 213705 | Undocumented 2 | Prunus spp :: Cherry 84 | 175 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998918.04752 | 2093764.63915 | 37.7290166671659 | -122.4460184358 | (37.7290166671659, -122.4460184358) | ||||
9515 | 9515 | 19958 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
50088 | 50088 | 1497 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 325 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5995534.5488977 | 2114067.6155393003 | 37.7845696798314 | -122.45918496626999 | (37.7845696798314, -122.45918496627) | |||
53397 | 53397 | 237946 | Undocumented 2 | Prunus spp :: Cherry 84 | 923 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008002.82503 | 2102600.12508 | 37.7537915497511 | -122.41523676997299 | (37.7537915497511, -122.415236769973) | |||
68550 | 68550 | 234921 | Undocumented 2 | Prunus spp :: Cherry 84 | 1062 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006317.5902 | 2103335.47216 | 37.7557157877704 | -122.421116917936 | (37.7557157877704, -122.421116917936) | |||
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) | |||
144726 | 144726 | 19028 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
145402 | 145402 | 19024 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
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) | |||
152816 | 152816 | 136023 | Undocumented 2 | Prunus spp :: Cherry 84 | 60 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008389.23117 | 2119145.89275 | 37.7992440090735 | -122.415071550105 | (37.7992440090735, -122.415071550105) | ||||
161934 | 161934 | 196371 | Undocumented 2 | Prunus spp :: Cherry 84 | 1797 Bancroft Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6013429.501019999 | 2092789.94242 | 37.7271583305791 | -122.395782600389 | (37.7271583305791, -122.395782600389) | |||
170723 | 170723 | 196513 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011917.55402 | 2108434.4901900003 | 37.770030649334295 | -122.402108807587 | (37.7700306493343, -122.402108807587) | |||
181165 | 181165 | 185048 | Undocumented 2 | Prunus spp :: Cherry 84 | 2767 34th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985831.6836 | 2096605.638 | 37.7360613326903 | -122.49146739069799 | (37.7360613326903, -122.491467390698) | |||
457 | 457 | 142162 | Undocumented 2 | Prunus spp :: Cherry 84 | 490X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
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) | |||
98177 | 98177 | 19029 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
136660 | 136660 | 238536 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002355.478619999 | 2096490.80035 | 37.736697774076 | -122.434329814067 | (37.736697774076, -122.434329814067) | |||
27679 | 27679 | 234916 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Albion St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005792.88209 | 2107221.84485 | 37.766357260514 | -122.423207770616 | (37.766357260514, -122.423207770616) | |||
63837 | 63837 | 234919 | Undocumented 2 | Prunus spp :: Cherry 84 | 200 Saint Marys Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6003932.02563 | 2095971.19882 | 37.735360426449105 | -122.428841975603 | (37.7353604264491, -122.428841975603) | |||
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) | |||
136216 | 136216 | 237947 | Undocumented 2 | Prunus spp :: Cherry 84 | 923 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008000.7668699995 | 2102633.77568 | 37.7538838309939 | -122.415246269499 | (37.7538838309939, -122.415246269499) | |||
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) | |||
144988 | 144988 | 20855 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
102022 | 102022 | 20856 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
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) | |||
143403 | 143403 | 122586 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
162408 | 162408 | 213702 | Undocumented 2 | Prunus spp :: Cherry 84 | 714 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | ||||
29648 | 29648 | 196372 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013890.9677099995 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | ||||
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) | |||
119551 | 119551 | 20857 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
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) | |||
177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) | |||
38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
98763 | 98763 | 249657 | Undocumented 2 | Prunus spp :: Cherry 84 | 2401 Lyon St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 10ft | 5999220.856459999 | 2117228.0712599996 | 37.7934586955217 | -122.44665911012301 | (37.7934586955217, -122.446659110123) | |||
186195 | 186195 | 196068 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013885.20395 | 2092887.6121599998 | 37.727451852204204 | -122.39421406314399 | (37.7274518522042, -122.394214063144) | ||||
147685 | 147685 | 196064 | Undocumented 2 | Prunus spp :: Cherry 84 | 1800 Illinois St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6016257.27394 | 2100629.7145700003 | 37.7488416623195 | -122.386553348372 | (37.7488416623195, -122.386553348372) | |||
183588 | 183588 | 196335 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) | ||||
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) | |||
63982 | 63982 | 247592 | Undocumented 2 | Prunus spp :: Cherry 84 | 800 Tompkins Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008994.80779 | 2096446.35961 | 37.736950368458096 | -122.41137154767799 | (37.7369503684581, -122.411371547678) | ||||
147664 | 147664 | 237972 | Undocumented 2 | Prunus spp :: Cherry 84 | 400 Prospect Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006214.1673 | 2097605.70169 | 37.7399773120135 | -122.42106776996201 | (37.7399773120135, -122.421067769962) | ||||
12896 | 12896 | 19960 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY41 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
2581 | 2581 | 107490 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1306x Montgomery St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6011447.18476 | 2119974.7633599997 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | ||||
17845 | 17845 | 21084 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 2192X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
152517 | 152517 | 196065 | Undocumented 2 | Prunus spp :: Cherry 84 | 602 Arthur Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015745.278940001 | 2099859.59173 | 37.7466987082831 | -122.388270101098 | (37.7466987082831, -122.388270101098) | ||||
47512 | 47512 | 196066 | Undocumented 2 | Prunus spp :: Cherry 84 | 602 Arthur Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015729.65904 | 2099863.28866 | 37.7467079937826 | -122.38832437158999 | (37.7467079937826, -122.38832437159) | ||||
61578 | 61578 | 238534 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 Church St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004315.939809999 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | |||
60657 | 60657 | 213701 | Undocumented 2 | Prunus spp :: Cherry 84 | 700 Junipero Serra Blvd | 130 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991210.94255 | 2091714.66662 | 37.722944834118294 | -122.47251283382201 | (37.7229448341183, -122.472512833822) |
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");