Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2424 | 2424 | 239429 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 565 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 5 | Width 2ft | Permit Number 51470 | 6001213.70363 | 2103034.08129 | 37.7545991976029 | -122.438746149019 | (37.7545991976029, -122.438746149019) | |
24527 | 24527 | 214750 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995612.00037 | 2093456.6914400002 | 37.7279817741139 | -122.457425350319 | (37.7279817741139, -122.457425350319) | |||
26826 | 26826 | 239412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002538.56212 | 2100033.91802 | 37.7464367420653 | -122.433950001585 | (37.7464367420653, -122.433950001585) | |||
38148 | 38148 | 237309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 211 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009018.3172 | 2097311.07667 | 37.739326012187 | -122.411351334505 | (37.739326012187, -122.411351334505) | |||
38174 | 38174 | 214754 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995607.36531 | 2093372.70982 | 37.7277509145579 | -122.457435300396 | (37.7277509145579, -122.457435300396) | |||
41005 | 41005 | 196503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011737.82052 | 2112830.87734 | 37.7820920832107 | -122.40303978397499 | (37.7820920832107, -122.403039783975) | |||
42755 | 42755 | 178970 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008583.66239 | 2086910.8267599999 | 37.7107447436356 | -122.412119359132 | (37.7107447436356, -122.412119359132) | |||
45979 | 45979 | 196501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011701.40176 | 2112798.07009 | 37.7819999683719 | -122.403163468629 | (37.7819999683719, -122.403163468629) | |||
46943 | 46943 | 238057 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 413 Lily St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6004461.64769 | 2109967.10473 | 37.7738198618406 | -122.42800791104099 | (37.7738198618406, -122.428007911041) | |||
51769 | 51769 | 178969 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | |||
52601 | 52601 | 218243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5992077.34134 | 2097249.8857 | 37.7381932756065 | -122.46992071879299 | (37.7381932756065, -122.469920718793) | |||
53778 | 53778 | 239415 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1331 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003277.56126 | 2100489.89633 | 37.7477306623461 | -122.43142717303499 | (37.7477306623461, -122.431427173035) | |||
54786 | 54786 | 238038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005844.524569999 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | |||
56890 | 56890 | 178996 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000569.64733 | 2091569.3239400003 | 37.72308300956121 | -122.440151382899 | (37.7230830095612, -122.440151382899) | |||
56919 | 56919 | 239433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Carrie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002800.77676 | 2095592.1026 | 37.7342554213364 | -122.43272604769399 | (37.7342554213364, -122.432726047694) | |||
56998 | 56998 | 238518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 218 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002025.02718 | 2096169.5718200002 | 37.7357969924364 | -122.43544935400699 | (37.7357969924364, -122.435449354007) | |||
57124 | 57124 | 213298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994373.81571 | 2089911.00711 | 37.7181749819741 | -122.461448817305 | (37.7181749819741, -122.461448817305) | |||
59195 | 59195 | 237324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009324.726 | 2096749.59433 | 37.7378014841462 | -122.41025227214199 | (37.7378014841462, -122.410252272142) | |||
60897 | 60897 | 237343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007573.28307 | 2096600.4423099998 | 37.7372936135946 | -122.41629731529 | (37.7372936135946, -122.41629731529) | |||
63695 | 63695 | 214742 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995645.35981 | 2093675.42483 | 37.7285842794183 | -122.457325843925 | (37.7285842794183, -122.457325843925) | |||
68445 | 68445 | 196459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013796.36432 | 2101069.01684 | 37.7499113519264 | -122.395093999398 | (37.7499113519264, -122.395093999398) | |||
68855 | 68855 | 237344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007638.07716 | 2096593.9745599998 | 37.7372794978562 | -122.416072833696 | (37.7372794978562, -122.416072833696) | |||
74234 | 74234 | 214735 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995155.65804 | 2092771.31144 | 37.72607366365639 | -122.458953324553 | (37.7260736636564, -122.458953324553) | |||
105064 | 105064 | 238514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 319 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004352.554830001 | 2096356.5109 | 37.736442199342704 | -122.42741548983801 | (37.7364421993427, -122.427415489838) | |||
116490 | 116490 | 237349 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1327 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008183.5398699995 | 2097707.7987599997 | 37.7403684685413 | -122.414265694627 | (37.7403684685413, -122.414265694627) | |||
130078 | 130078 | 214794 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995480.84421 | 2097515.15227 | 37.739117784956605 | -122.458172366777 | (37.7391177849566, -122.458172366777) | |||
131581 | 131581 | 214736 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995136.59009 | 2093647.8547099999 | 37.728479343838394 | -122.459082682125 | (37.7284793438384, -122.459082682125) | |||
131840 | 131840 | 179002 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001822.18343 | 2090679.74768 | 37.7207116627863 | -122.43575800674 | (37.7207116627863, -122.43575800674) | |||
133641 | 133641 | 196482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012916.33928 | 2095157.16046 | 37.733629664074705 | -122.39772257563 | (37.7336296640747, -122.39772257563) | |||
135147 | 135147 | 237014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Lily St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6004527.81122 | 2109977.0125599997 | 37.7738508093129 | -122.42777974675501 | (37.7738508093129, -122.427779746755) | |||
135619 | 135619 | 214734 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995175.571830001 | 2092744.7785099999 | 37.7260019553109 | -122.45888256407801 | (37.7260019553109, -122.458882564078) | |||
147124 | 147124 | 214745 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995638.20043 | 2093638.9497200001 | 37.728483716343796 | -122.45734795645001 | (37.7284837163438, -122.45734795645) | |||
155352 | 155352 | 178968 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008554.00356 | 2086922.9270900001 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | |||
155902 | 155902 | 123062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991906.84489 | 2112217.36307 | 37.7792801711752 | -122.471600599763 | (37.7792801711752, -122.471600599763) | |||
162049 | 162049 | 179042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2913 20th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5990217.2226599995 | 2095888.7019900002 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | |||
162338 | 162338 | 237318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009544.13683 | 2097633.21679 | 37.7402400165656 | -122.409556006214 | (37.7402400165656, -122.409556006214) | |||
163704 | 163704 | 214753 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995611.1547 | 2093431.54917 | 37.7279126909161 | -122.457426455583 | (37.7279126909161, -122.457426455583) | |||
167930 | 167930 | 178995 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000596.67394 | 2091620.93611 | 37.7232262634584 | -122.440061656639 | (37.7232262634584, -122.440061656639) | |||
168285 | 168285 | 237337 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007298.22515 | 2096977.17548 | 37.7383125688774 | -122.417275008733 | (37.7383125688774, -122.417275008733) | |||
174660 | 174660 | 178999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002140.71576 | 2089748.47374 | 37.7181726806159 | -122.434590385445 | (37.7181726806159, -122.434590385445) | |||
185740 | 185740 | 237188 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 904 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004338.3422300005 | 2103543.5695 | 37.756175398901206 | -122.42797661735001 | (37.7561753989012, -122.42797661735) | |||
186561 | 186561 | 179064 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000355.465580001 | 2091781.1110900003 | 37.7236523325845 | -122.440906950114 | (37.7236523325845, -122.440906950114) |
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");