Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186216 | 186216 | 250997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | |||
| 30707 | 30707 | 250995 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 44th Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.780160200984604 | -122.505239820464 | (37.7801602009846, -122.505239820464) | |||
| 40407 | 40407 | 250787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 277 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985873.31121 | 2114054.8468299997 | 37.7839744613866 | -122.49260816604601 | (37.7839744613866, -122.492608166046) | |||
| 66286 | 66286 | 250757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 206 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985901.09635 | 2114492.32613 | 37.785177277657496 | -122.492544270121 | (37.7851772776575, -122.492544270121) | |||
| 170118 | 170118 | 250758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 214 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985901.94322 | 2114466.62788 | 37.785106767213705 | -122.49253944703699 | (37.7851067672137, -122.492539447037) | |||
| 147077 | 147077 | 250761 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985903.37202 | 2114379.41265 | 37.7848673829594 | -122.49252807871001 | (37.7848673829594, -122.49252807871) | |||
| 73215 | 73215 | 250760 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985903.61307 | 2114361.31306 | 37.7848177008131 | -122.492525911365 | (37.7848177008131, -122.492525911365) | |||
| 134897 | 134897 | 250785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 270 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5985911.734180001 | 2114095.33531 | 37.784087877591794 | -122.492478221206 | (37.7840878775918, -122.492478221206) | |||
| 135875 | 135875 | 250645 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987300.52243 | 2114656.77456 | 37.78571052885479 | -122.48771483877199 | (37.7857105288548, -122.487714838772) | |||
| 39473 | 39473 | 250644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987312.1046400005 | 2114657.5756599996 | 37.785713403992 | -122.487674827026 | (37.785713403992, -122.487674827026) | |||
| 27074 | 27074 | 250328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 27th Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | |||
| 53509 | 53509 | 178760 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3077 25th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5988826.827409999 | 2094817.3494900002 | 37.7313257268874 | -122.48098119462601 | (37.7313257268874, -122.480981194626) | |||
| 149184 | 149184 | 178761 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3025 25th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5988853.53072 | 2095119.96102 | 37.7321581726532 | -122.480911025024 | (37.7321581726532, -122.480911025024) | |||
| 179239 | 179239 | 178758 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3092 25th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5988865.41335 | 2094809.6423099998 | 37.7313068078649 | -122.480847233437 | (37.7313068078649, -122.480847233437) | |||
| 173510 | 173510 | 178759 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3092 25th Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5988865.63691 | 2094820.20281 | 37.731335817282705 | -122.480847233436 | (37.7313358172827, -122.480847233436) | |||
| 56297 | 56297 | 179040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5989055.545969999 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | |||
| 75532 | 75532 | 179037 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.57419 | 2095644.9365599998 | 37.733611362859605 | -122.480250933435 | (37.7336113628596, -122.480250933435) | |||
| 155549 | 155549 | 179039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.72291 | 2095627.1595 | 37.7335625602678 | -122.48024911859699 | (37.7335625602678, -122.480249118597) | |||
| 119487 | 119487 | 179038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.733585526248795 | -122.480249118607 | (37.7335855262488, -122.480249118607) | |||
| 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) | |||
| 74997 | 74997 | 187551 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2441 19th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5990426.260480001 | 2098774.7795 | 37.7422846621229 | -122.475740599546 | (37.7422846621229, -122.475740599546) | |||
| 72650 | 72650 | 213363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990931.27665 | 2094545.31392 | 37.7307008923171 | -122.473685962554 | (37.7307008923171, -122.473685962554) | |||
| 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) | |||
| 152228 | 152228 | 213360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5991212.62572 | 2094437.93395 | 37.7304223444182 | -122.47270547849399 | (37.7304223444182, -122.472705478494) | |||
| 24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
| 30069 | 30069 | 215263 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991309.897609999 | 2093234.8571099997 | 37.727124626686795 | -122.47228153268298 | (37.7271246266868, -122.472281532683) | |||
| 34648 | 34648 | 215261 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991310.9639 | 2093247.2582599998 | 37.7271587388628 | -122.47227875017799 | (37.7271587388628, -122.472278750178) | |||
| 68758 | 68758 | 215262 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 68 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991312.446330001 | 2093241.21549 | 37.72714223271821 | -122.472273185176 | (37.7271422327182, -122.472273185176) | |||
| 33080 | 33080 | 215260 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991332.77888 | 2093518.51077 | 37.7279047930719 | -122.472223101042 | (37.7279047930719, -122.472223101042) | |||
| 185858 | 185858 | 215259 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991333.88736 | 2093532.9142200002 | 37.7279444054996 | -122.472220318525 | (37.7279444054996, -122.472220318525) | |||
| 152229 | 152229 | 215258 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 32 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991336.01745 | 2093595.78763 | 37.7281171634535 | -122.472217536006 | (37.7281171634535, -122.472217536006) | |||
| 131828 | 131828 | 215256 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991343.9516199995 | 2093743.0967700002 | 37.728522096709796 | -122.47220084099101 | (37.7285220967098, -122.472200840991) | |||
| 69249 | 69249 | 215257 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991347.16075 | 2093685.3212 | 37.728363645153706 | -122.47218553726002 | (37.7283636451537, -122.47218553726) | |||
| 28326 | 28326 | 215253 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991347.53031 | 2093798.3248599998 | 37.7286739463434 | -122.47219249348998 | (37.7286739463434, -122.47219249349) | |||
| 27049 | 27049 | 215254 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991351.0324800005 | 2093792.6407400002 | 37.7286585418478 | -122.472179972231 | (37.7286585418478, -122.472179972231) | |||
| 34816 | 34816 | 215255 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991357.82029 | 2093790.0929299998 | 37.7286519390174 | -122.47215632095501 | (37.7286519390174, -122.472156320955) | |||
| 43064 | 43064 | 212621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.718152032178295 | -122.471700124589 | (37.7181520321783, -122.471700124589) | |||
| 157855 | 157855 | 212625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991672.936319999 | 2090117.5673599998 | 37.71858632198371 | -122.470799552451 | (37.7185863219837, -122.470799552451) | |||
| 53955 | 53955 | 213335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991917.8551 | 2088918.99095 | 37.715309483835 | -122.469865758501 | (37.715309483835, -122.469865758501) | |||
| 149708 | 149708 | 213331 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991924.78555 | 2089552.6251599998 | 37.7170496899626 | -122.469887910591 | (37.7170496899626, -122.469887910591) | |||
| 31801 | 31801 | 213330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991929.42464 | 2089936.9124 | 37.7181051172336 | -122.46989983921101 | (37.7181051172336, -122.469899839211) | |||
| 54772 | 54772 | 213329 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991930.7925 | 2089955.0472 | 37.718154990039295 | -122.46989643078999 | (37.7181549900393, -122.46989643079) | |||
| 133217 | 133217 | 213328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991931.18505 | 2089973.6935 | 37.7182062109212 | -122.469896430786 | (37.7182062109212, -122.469896430786) | |||
| 31968 | 31968 | 213326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991939.8499300005 | 2090759.9353900002 | 37.7203655398194 | -122.46992369461701 | (37.7203655398194, -122.469923694617) | |||
| 56542 | 56542 | 213324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 355 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | |||
| 154951 | 154951 | 213325 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991942.4704599995 | 2090861.00435 | 37.7206432019019 | -122.46992199131701 | (37.7206432019019, -122.469921991317) | |||
| 41983 | 41983 | 212629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.717631996493395 | -122.46977033503599 | (37.7176319964934, -122.469770335036) | |||
| 38214 | 38214 | 212630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991963.5826 | 2089803.15651 | 37.7177398306004 | -122.46977203837099 | (37.7177398306004, -122.469772038371) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 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) | |||
| 183426 | 183426 | 212632 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992190.56348 | 2089982.3550900002 | 37.718244983411296 | -122.46900050817499 | (37.7182449834113, -122.469000508175) | |||
| 174187 | 174187 | 212635 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992191.77345 | 2090130.53473 | 37.7186519185263 | -122.46900710379299 | (37.7186519185263, -122.469007103793) | |||
| 75207 | 75207 | 212634 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992192.8402 | 2090144.9525 | 37.7186915678454 | -122.46900446519301 | (37.7186915678454, -122.469004465193) | |||
| 65836 | 65836 | 213340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992193.1878 | 2090324.6899599999 | 37.719185103182895 | -122.469016337141 | (37.7191851031829, -122.469016337141) | |||
| 157491 | 157491 | 213339 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992194.5826900005 | 2090348.43318 | 37.7192503768696 | -122.46901324258499 | (37.7192503768696, -122.469013242585) | |||
| 160505 | 160505 | 212638 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992196.84729 | 2090552.9971900003 | 37.7198121905699 | -122.469020294172 | (37.7198121905699, -122.469020294172) | |||
| 32448 | 32448 | 212637 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992197.26293 | 2090572.74875 | 37.719866447546394 | -122.469020294145 | (37.7198664475464, -122.469020294145) | |||
| 58888 | 58888 | 212636 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992198.0920400005 | 2090594.0117 | 37.7199248783202 | -122.46901897484301 | (37.7199248783202, -122.469018974843) | |||
| 175837 | 175837 | 212640 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 466 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992234.12475 | 2090946.27568 | 37.7208941910027 | -122.468920044935 | (37.7208941910027, -122.468920044935) | |||
| 175071 | 175071 | 212639 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 466 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992234.36824 | 2090921.5704 | 37.72082637041321 | -122.468917406335 | (37.7208263704132, -122.468917406335) | |||
| 32294 | 32294 | 213357 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992244.95419 | 2088111.9424400001 | 37.7131124256698 | -122.468676481533 | (37.7131124256698, -122.468676481533) | |||
| 26547 | 26547 | 212674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 641 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.89136 | 2090473.0375 | 37.719596745362395 | -122.46876890666 | (37.7195967453624, -122.46876890666) | |||
| 179000 | 179000 | 212675 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992291.80794 | 2090471.78917 | 37.7195946994221 | -122.468686145643 | (37.7195946994221, -122.468686145643) | |||
| 157684 | 157684 | 212673 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 632 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992300.25819 | 2090517.80546 | 37.7197215370933 | -122.468660282939 | (37.7197215370933, -122.468660282939) | |||
| 71316 | 71316 | 212671 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 615 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992392.42852 | 2090471.1623 | 37.719598790441296 | -122.468338294185 | (37.7195987904413, -122.468338294185) | |||
| 186947 | 186947 | 212672 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.719600836394704 | -122.468263292533 | (37.7196008363947, -122.468263292533) | |||
| 69640 | 69640 | 213344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992432.58541 | 2088617.0275700002 | 37.7145101052228 | -122.468064688059 | (37.7145101052228, -122.468064688059) | |||
| 31639 | 31639 | 213343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | |||
| 159828 | 159828 | 212651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 313 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992449.87546 | 2089900.8969700001 | 37.718036298411995 | -122.46809826243 | (37.718036298412, -122.46809826243) | |||
| 179534 | 179534 | 212650 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992450.00346 | 2089979.5572 | 37.718252287693794 | -122.46810353875 | (37.7182522876938, -122.46810353875) | |||
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 46317 | 46317 | 212648 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 359 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992453.38509 | 2090231.05356 | 37.7189430308699 | -122.468110134397 | (37.7189430308699, -122.468110134397) | |||
| 134316 | 134316 | 212646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 375 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992454.85135 | 2090337.04535 | 37.7192341432212 | -122.46811277210101 | (37.7192341432212, -122.468112772101) | |||
| 59221 | 59221 | 212641 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 451 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992462.511419999 | 2090828.2308 | 37.7205832611878 | -122.468122005451 | (37.7205832611878, -122.468122005451) | |||
| 40323 | 40323 | 212653 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 238 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.716813391295204 | -122.467970312297 | (37.7168133912952, -122.467970312297) | |||
| 135613 | 135613 | 212654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 234 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.54875 | 2089420.3525900003 | 37.71671843819129 | -122.467967674587 | (37.7167184381913, -122.467967674587) | |||
| 149348 | 149348 | 212647 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 374 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992487.75131 | 2090340.9136 | 37.719246664489 | -122.467999331607 | (37.719246664489, -122.467999331607) | |||
| 133184 | 133184 | 213342 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 442 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992492.2832 | 2090792.26428 | 37.7204862252464 | -122.468016479897 | (37.7204862252464, -122.468016479897) | |||
| 42959 | 42959 | 213345 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 542 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992754.74517 | 2090800.4755 | 37.7205239248105 | -122.46710983737499 | (37.7205239248105, -122.467109837375) | |||
| 56569 | 56569 | 213355 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992826.5059 | 2090512.32679 | 37.7197368804329 | -122.466840849243 | (37.7197368804329, -122.466840849243) | |||
| 173982 | 173982 | 213346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.82489 | 2088699.8094099998 | 37.7147676656708 | -122.466258733373 | (37.7147676656708, -122.466258733373) | |||
| 49983 | 49983 | 218202 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993100.98429 | 2098296.8432 | 37.7411270763539 | -122.466457572568 | (37.7411270763539, -122.466457572568) | |||
| 158862 | 158862 | 218203 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993117.83154 | 2098288.66702 | 37.741105598756704 | -122.466398727241 | (37.7411055987567, -122.466398727241) | |||
| 73686 | 73686 | 218204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993128.32647 | 2098280.97709 | 37.741085089718496 | -122.46636188111601 | (37.7410850897185, -122.466361881116) | |||
| 37111 | 37111 | 212660 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 229 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993215.92884 | 2088803.0771700002 | 37.7150661605497 | -122.46537066722401 | (37.7150661605497, -122.465370667224) | |||
| 51455 | 51455 | 215251 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 401 Victoria St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5993228.9557 | 2089914.8953 | 37.7181196970457 | -122.46540635862 | (37.7181196970457, -122.46540635862) | |||
| 130595 | 130595 | 213349 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 382 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993261.23034 | 2089739.3179799998 | 37.71763946535779 | -122.465282053445 | (37.7176394653578, -122.465282053445) | |||
| 76611 | 76611 | 212656 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993265.19823 | 2090019.9682900002 | 37.7184102922832 | -122.46528871291201 | (37.7184102922832, -122.465288712912) | |||
| 147855 | 147855 | 213348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993267.15159 | 2090112.97171 | 37.7186657698839 | -122.46528871291599 | (37.7186657698839, -122.465288712916) | |||
| 31599 | 31599 | 218216 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5993396.63989 | 2098589.94545 | 37.7419489172986 | -122.465456597447 | (37.7419489172986, -122.465456597447) | |||
| 184114 | 184114 | 218215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993412.17188 | 2098613.00635 | 37.74201313250371 | -122.465404568079 | (37.7420131325037, -122.465404568079) | |||
| 115956 | 115956 | 212670 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 215 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993431.79105 | 2090458.25949 | 37.719623340138504 | -122.46474468602501 | (37.7196233401385, -122.464744686025) | |||
| 181822 | 181822 | 212661 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 542 Head St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993519.05172 | 2089481.7984900002 | 37.716947243693795 | -122.46437220211399 | (37.7169472436938, -122.464372202114) | |||
| 181827 | 181827 | 213350 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 610 Head St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993524.58129 | 2089927.1808799999 | 37.7181704754556 | -122.464385407781 | (37.7181704754556, -122.464385407781) | |||
| 56482 | 56482 | 212662 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 718 Head St | 6 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993530.84896 | 2090554.84493 | 37.7198942509911 | -122.464409290177 | (37.7198942509911, -122.464409290177) | |||
| 166901 | 166901 | 212663 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 718 Head St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993531.69255 | 2090595.02777 | 37.7200046319988 | -122.464409290166 | (37.7200046319988, -122.464409290166) | |||
| 31680 | 31680 | 212666 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 772 Head St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993533.344330001 | 2090952.0360299998 | 37.72098498564 | -122.464429488032 | (37.72098498564, -122.464429488032) | |||
| 147151 | 147151 | 213352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993533.94375 | 2090828.7779700002 | 37.7206465833581 | -122.464418471345 | (37.7206465833581, -122.464418471345) | |||
| 56714 | 56714 | 212665 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 772 Head St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993534.0623 | 2090935.62343 | 37.7209399619961 | -122.464425815196 | (37.7209399619961, -122.464425815196) | |||
| 165465 | 165465 | 213351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993534.806030001 | 2090819.23886 | 37.7206204409725 | -122.46441479849899 | (37.7206204409725, -122.464414798499) |
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");