Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
27120 | 27120 | 135723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 5999974.03757 | 2115574.89722 | 37.7889625079578 | -122.44393422098699 | (37.7889625079578, -122.443934220987) | |||
31993 | 31993 | 135726 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5999972.00363 | 2115592.60206 | 37.789011004802106 | -122.443942530717 | (37.7890110048021, -122.443942530717) | |||
41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
42692 | 42692 | 139101 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2533 POST ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6000038.1797 | 2113670.6976 | 37.78373772905571 | -122.443575453886 | (37.7837377290557, -122.443575453886) | |||
130149 | 130149 | 142311 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 448 LYON ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6000194.2084 | 2110499.5828 | 37.775039556646206 | -122.442807870044 | (37.7750395566462, -122.442807870044) | |||
130535 | 130535 | 143436 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 725 STOCKTON ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6010474.6222 | 2116698.0575 | 37.792639816621 | -122.40768265432399 | (37.792639816621, -122.407682654324) | |||
53520 | 53520 | 196107 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.759414745219296 | -122.39317961614799 | (37.7594147452193, -122.393179616148) | |||
40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
52379 | 52379 | 196126 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2251 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6011345.096580001 | 2104613.5358 | 37.759507200926706 | -122.40382003306601 | (37.7595072009267, -122.403820033066) | |||
123732 | 123732 | 196127 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2251 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6011374.07778 | 2104614.45279 | 37.7595113377868 | -122.403719865702 | (37.7595113377868, -122.403719865702) | |||
173265 | 173265 | 196276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.738602740517294 | -122.38722376507499 | (37.7386027405173, -122.387223765075) | |||
131227 | 131227 | 199694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.727248236967704 | -122.38718652280701 | (37.7272482369677, -122.387186522807) | |||
169782 | 169782 | 213119 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 215 Molimo Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5997893.97953 | 2096675.0128799998 | 37.7369493288531 | -122.44976835062799 | (37.7369493288531, -122.449768350628) | |||
33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
75447 | 75447 | 218016 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990785.97144 | 2099709.33017 | 37.7448715449012 | -122.474565030958 | (37.7448715449012, -122.474565030958) | |||
155116 | 155116 | 218017 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990797.83143 | 2099709.8496 | 37.7448736582987 | -122.474524059638 | (37.7448736582987, -122.474524059638) | |||
154116 | 154116 | 218018 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.82418 | 2099712.3546 | 37.7448814050516 | -122.474472400799 | (37.7448814050516, -122.474472400799) | |||
154305 | 154305 | 218019 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990820.542769999 | 2099711.9352700002 | 37.744880700881794 | -122.474445681024 | (37.7448807008818, -122.474445681024) | |||
50974 | 50974 | 218020 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990823.88989 | 2099711.8646400003 | 37.7448807008746 | -122.474434102269 | (37.7448807008746, -122.474434102269) | |||
73699 | 73699 | 218021 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990833.9529 | 2099712.67814 | 37.744883517556 | -122.474399365956 | (37.744883517556, -122.474399365956) | |||
135318 | 135318 | 235918 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Fair Oaks St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6005429.10381 | 2102843.41595 | 37.754314589155896 | -122.424154597561 | (37.7543145891559, -122.424154597561) | |||
66040 | 66040 | 235919 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Fair Oaks St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6005429.09615 | 2102853.14802 | 37.7543413107251 | -122.42415531613301 | (37.7543413107251, -122.424155316133) | |||
186905 | 186905 | 236386 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 138 Carl St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5997744.87985 | 2107159.8634 | 37.7657296047634 | -122.451039706011 | (37.7657296047634, -122.451039706011) | |||
187989 | 187989 | 236401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 620 Belvedere St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5998688.86487 | 2105557.55466 | 37.7613840662398 | -122.44765932353701 | (37.7613840662398, -122.447659323537) | |||
132553 | 132553 | 236516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6009359.848619999 | 2097078.2444799999 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | |||
176432 | 176432 | 236680 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000047.77826 | 2100801.34251 | 37.748402239176706 | -122.442617915704 | (37.7484022391767, -122.442617915704) | |||
40197 | 40197 | 236681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6000049.04538 | 2100790.98488 | 37.7483738718507 | -122.442612790472 | (37.7483738718507, -122.442612790472) | |||
154374 | 154374 | 236703 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Clipper St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6002502.2802 | 2100944.2817700002 | 37.748934327571995 | -122.43414052836201 | (37.748934327572, -122.434140528362) | |||
71385 | 71385 | 236704 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Clipper St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002466.37628 | 2100942.47279 | 37.7489273227364 | -122.434264554764 | (37.7489273227364, -122.434264554764) | |||
30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
162013 | 162013 | 236751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.43570044651301 | (37.7555736715096, -122.435700446513) | ||||
43845 | 43845 | 236752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002107.159440001 | 2103370.74755 | 37.755574390960604 | -122.435680430326 | (37.7555743909606, -122.435680430326) | ||||
48400 | 48400 | 236754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 456 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002114.12722 | 2103211.5772 | 37.755137743137496 | -122.435644946673 | (37.7551377431375, -122.435644946673) | ||||
67962 | 67962 | 237811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1837 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6004597.73659 | 2098051.69085 | 37.7411106430416 | -122.426688472519 | (37.7411106430416, -122.426688472519) |
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");