Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113240 | 113240 | 67948 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | ex3 | Permit Number 31662 | 5988736.13806 | 2111981.42447 | 37.778448401356705 | -122.48255196765498 | (37.7784484013567, -122.482551967655) |
| 36320 | 36320 | 212934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1964 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5990996.330519999 | 2102040.26003 | 37.751283858566104 | -122.47400768869801 | (37.7512838585661, -122.474007688698) | |||
| 148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
| 161733 | 161733 | 196296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 383 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012973.423830001 | 2105290.2988400003 | 37.7614562764103 | -122.398235915848 | (37.7614562764103, -122.398235915848) | |||
| 174694 | 174694 | 214258 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 5997049.83244 | 2095507.43022 | 37.7336950951374 | -122.452602689063 | (37.7336950951374, -122.452602689063) | |||
| 25908 | 25908 | 214251 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 470 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998963.14193 | 2095000.98839 | 37.7324139668331 | -122.445951428216 | (37.7324139668331, -122.445951428216) | |||
| 26039 | 26039 | 236674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4301 26th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6001900.9288 | 2100573.2486400004 | 37.747881410301 | -122.436193451291 | (37.747881410301, -122.436193451291) | |||
| 27714 | 27714 | 237848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003593.08721 | 2096850.61715 | 37.7377559191042 | -122.430076526206 | (37.7377559191042, -122.430076526206) | |||
| 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) | |||
| 30957 | 30957 | 212587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 147 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.2739699995 | 2093442.0374900002 | 37.7281200970646 | -122.446647836227 | (37.7281200970646, -122.446647836227) | |||
| 36378 | 36378 | 178800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008027.45015 | 2091896.60863 | 37.7244034301488 | -122.41439431206699 | (37.7244034301488, -122.414394312067) | |||
| 40814 | 40814 | 212668 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5992987.499559999 | 2088299.56272 | 37.713670454102896 | -122.46612364171101 | (37.7136704541029, -122.466123641711) | |||
| 41647 | 41647 | 246741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Ripley St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6008870.15252 | 2099074.1430099998 | 37.7441586945704 | -122.41198818403099 | (37.7441586945704, -122.411988184031) | |||
| 49691 | 49691 | 196149 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 6013503.97316 | 2104707.95515 | 37.759886826325705 | -122.39636013421301 | (37.7598868263257, -122.396360134213) | |||
| 50366 | 50366 | 178762 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Cotter St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6001593.80864 | 2093905.46248 | 37.7295557693705 | -122.436778218343 | (37.7295557693705, -122.436778218343) | |||
| 51919 | 51919 | 178799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008025.38045 | 2091906.1751599999 | 37.7244295815351 | -122.41440214334601 | (37.7244295815351, -122.414402143346) | |||
| 54919 | 54919 | 237847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003573.70242 | 2096850.7481 | 37.7377551807635 | -122.430143558104 | (37.7377551807635, -122.430143558104) | |||
| 132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
| 152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
| 153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
| 154255 | 154255 | 247009 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Valley St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100676996 | -122.431331435716 | (37.744170100677, -122.431331435716) | |||
| 170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
| 185688 | 185688 | 214285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 209 Edna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.83895 | 2093556.15177 | 37.728433460428 | -122.44665409012501 | (37.728433460428, -122.446654090125) | |||
| 186895 | 186895 | 196150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6013505.49575 | 2104693.9882799997 | 37.7598485610787 | -122.396353889321 | (37.7598485610787, -122.396353889321) | |||
| 36337 | 36337 | 235746 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 7ft | 6005414.222019999 | 2100184.87924 | 37.7470140204997 | -122.424017018376 | (37.7470140204997, -122.424017018376) | |||
| 167126 | 167126 | 196128 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2098 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6011883.81228 | 2104698.03976 | 37.7597693110244 | -122.401962817046 | (37.7597693110244, -122.401962817046) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
| 26387 | 26387 | 212392 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5991914.22227 | 2095632.90127 | 37.733744013755796 | -122.470366973162 | (37.7337440137558, -122.470366973162) | |||
| 27606 | 27606 | 201518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6019207.673780001 | 2094338.78719 | 37.7317309074526 | -122.37591462936199 | (37.7317309074526, -122.375914629362) | |||
| 30249 | 30249 | 212644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.09906 | 2090440.19057 | 37.7195169071729 | -122.46814706775 | (37.7195169071729, -122.46814706775) | |||
| 30287 | 30287 | 214298 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994394.90516 | 2100680.9533 | 37.7477478232146 | -122.4621565532 | (37.7477478232146, -122.4621565532) | |||
| 31098 | 31098 | 212655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 494 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993275.23376 | 2090421.34929 | 37.7195129663325 | -122.46528316408998 | (37.7195129663325, -122.46528316409) | |||
| 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) | |||
| 41930 | 41930 | 212393 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991911.35138 | 2095658.6383099998 | 37.7338145152114 | -122.470378772281 | (37.7338145152114, -122.470378772281) | |||
| 42900 | 42900 | 212547 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993748.79509 | 2096657.2738700002 | 37.736662588108395 | -122.464098699394 | (37.7366625881084, -122.464098699394) | |||
| 43286 | 43286 | 212542 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 155 Terrace Walk | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993830.43125 | 2096581.14739 | 37.736458268419206 | -122.46381092625799 | (37.7364582684192, -122.463810926258) | |||
| 43287 | 43287 | 196091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6015230.48964 | 2104060.4129 | 37.7582047379774 | -122.390343661653 | (37.7582047379774, -122.390343661653) | |||
| 44715 | 44715 | 236866 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1275 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 5997490.26756 | 2105115.32098 | 37.7601012292087 | -122.451772846854 | (37.7601012292087, -122.451772846854) | |||
| 46577 | 46577 | 212879 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1856 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5990966.76984 | 2102771.704 | 37.7532904996754 | -122.474163276836 | (37.7532904996754, -122.474163276836) | |||
| 46831 | 46831 | 212390 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991915.799819999 | 2095563.7675400001 | 37.733554281107395 | -122.47035648617799 | (37.7335542811074, -122.470356486178) | |||
| 47543 | 47543 | 201520 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6019241.773440001 | 2094383.32833 | 37.7318550858427 | -122.37579982552 | (37.7318550858427, -122.37579982552) | |||
| 48616 | 48616 | 212398 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991908.4162 | 2095789.3482700002 | 37.7341732422018 | -122.470398435959 | (37.7341732422018, -122.470398435959) | |||
| 49076 | 49076 | 213002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 5993433.63561 | 2104037.38887 | 37.756908339163104 | -122.46572436788401 | (37.7569083391631, -122.465724367884) | |||
| 50013 | 50013 | 212549 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 145 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993701.90804 | 2096690.99952 | 37.7367524879351 | -122.464263254655 | (37.7367524879351, -122.464263254655) | |||
| 50661 | 50661 | 212551 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993669.9732800005 | 2096714.1081700001 | 37.7368140977904 | -122.464375343461 | (37.7368140977904, -122.464375343461) | |||
| 50935 | 50935 | 212388 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991917.7194 | 2095510.8633700002 | 37.733409130525295 | -122.470345998274 | (37.7334091305253, -122.470345998274) | |||
| 51378 | 51378 | 212397 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991907.97112 | 2095768.2121400002 | 37.7341151819682 | -122.47039843596201 | (37.7341151819682, -122.470398435962) | |||
| 51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
| 55195 | 55195 | 212395 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5991910.09704 | 2095725.12141 | 37.7339969885736 | -122.47038794896099 | (37.7339969885736, -122.470387948961) | |||
| 57154 | 57154 | 212375 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 5994268.67075 | 2099029.19032 | 37.743205228833205 | -122.46247327105101 | (37.7432052288332, -122.462473271051) | |||
| 58235 | 58235 | 212544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 153 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993803.69689 | 2096613.4466900001 | 37.7365454136427 | -122.46390570131099 | (37.7365454136427, -122.463905701311) | |||
| 58846 | 58846 | 212555 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 135 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993610.86329 | 2096757.02043 | 37.736928516744 | -122.464582826036 | (37.736928516744, -122.464582826036) | |||
| 58909 | 58909 | 212556 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 129 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993583.13225 | 2096772.2561400002 | 37.736968751513295 | -122.46467980981899 | (37.7369687515133, -122.464679809819) | |||
| 59060 | 59060 | 178841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002067.276880001 | 2086921.00065 | 37.710404894347704 | -122.434642162998 | (37.7104048943477, -122.434642162998) | |||
| 59257 | 59257 | 212550 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993683.09574 | 2096704.06961 | 37.7367872908056 | -122.46432924510599 | (37.7367872908056, -122.464329245106) | |||
| 59577 | 59577 | 214297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994416.06125 | 2100657.44777 | 37.747684501052206 | -122.462081692735 | (37.7476845010522, -122.462081692735) | |||
| 60070 | 60070 | 124587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5995618.65925 | 2115459.66963 | 37.7883967207528 | -122.458994801868 | (37.7883967207528, -122.458994801868) | |||
| 60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
| 61650 | 61650 | 212481 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 459 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993828.6402 | 2101727.40952 | 37.7505885054617 | -122.464190611023 | (37.7505885054617, -122.464190611023) | |||
| 62016 | 62016 | 124588 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5995581.59623 | 2115458.0775 | 37.788390218589 | -122.459122917803 | (37.788390218589, -122.459122917803) | |||
| 62918 | 62918 | 235752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6006048.38845 | 2099234.02907 | 37.7444389853836 | -122.421756594908 | (37.7444389853836, -122.421756594908) | |||
| 63220 | 63220 | 135844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1155 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6007360.5897 | 2119841.38777 | 37.801095804879395 | -122.418680361323 | (37.8010958048794, -122.418680361323) | |||
| 66086 | 66086 | 212400 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991904.93528 | 2095858.14347 | 37.73436193525671 | -122.470415478999 | (37.7343619352567, -122.470415478999) | |||
| 66594 | 66594 | 178716 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 551 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6001935.516559999 | 2090267.4815 | 37.719586109087295 | -122.435336775094 | (37.7195861090873, -122.435336775094) | |||
| 67129 | 67129 | 213001 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 6ft | 5993433.46083 | 2104046.51042 | 37.75693337449479 | -122.465725635034 | (37.7569333744948, -122.465725635034) | |||
| 68530 | 68530 | 212541 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 165 Terrace Walk | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993840.6864 | 2096565.82049 | 37.73641677551571 | -122.463774358027 | (37.7364167755157, -122.463774358027) | |||
| 69187 | 69187 | 212543 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 155 Terrace Walk | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993816.76239 | 2096598.14857 | 37.7365041617454 | -122.463859418574 | (37.7365041617454, -122.463859418574) | |||
| 69355 | 69355 | 212394 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991912.09607 | 2095675.99201 | 37.7338622071685 | -122.47037746106301 | (37.7338622071685, -122.470377461063) | |||
| 69786 | 69786 | 212402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.19278 | 2095912.91043 | 37.734512268621295 | -122.470422033273 | (37.7345122686213, -122.470422033273) | |||
| 75496 | 75496 | 213000 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1624 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 6ft | 5993419.01621 | 2104404.96618 | 37.757916767851 | -122.465801633144 | (37.757916767851, -122.465801633144) | |||
| 76574 | 76574 | 124586 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5995636.20396 | 2115462.0086 | 37.7884041514593 | -122.458934269795 | (37.7884041514593, -122.458934269795) | |||
| 81147 | 81147 | 212391 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991916.69552 | 2095588.29265 | 37.7336216726882 | -122.470355174951 | (37.7336216726882, -122.470355174951) | |||
| 129214 | 129214 | 196119 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1236 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6012213.24295 | 2102617.02873 | 37.754073692255 | -122.400677278457 | (37.754073692255, -122.400677278457) | |||
| 132194 | 132194 | 124229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5996620.976869999 | 2111333.86588 | 37.7771259241055 | -122.45522868869499 | (37.7771259241055, -122.455228688695) | |||
| 132642 | 132642 | 212559 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 121 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993518.68842 | 2096812.9908200002 | 37.7370768832988 | -122.464905576542 | (37.7370768832988, -122.464905576542) | |||
| 136138 | 136138 | 212561 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 119 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993479.864130001 | 2096836.47332 | 37.7371391217766 | -122.465041513556 | (37.7371391217766, -122.465041513556) | |||
| 137051 | 137051 | 178842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | |||
| 137921 | 137921 | 124228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5996619.11206 | 2111349.85847 | 37.7771697285711 | -122.45523629563499 | (37.7771697285711, -122.455236295635) | |||
| 146492 | 146492 | 212554 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 135 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993623.06241 | 2096746.69006 | 37.736900855375204 | -122.46453989872299 | (37.7369008553752, -122.464539898723) | |||
| 146560 | 146560 | 212553 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993639.17843 | 2096736.7350400002 | 37.7368744504015 | -122.464483456341 | (37.7368744504015, -122.464483456341) | |||
| 148050 | 148050 | 214296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994436.47269 | 2100634.45899 | 37.7476225548349 | -122.46200944480199 | (37.7476225548349, -122.462009444802) | |||
| 149332 | 149332 | 212557 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 129 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993558.86058 | 2096787.99209 | 37.7370105591839 | -122.46476486952801 | (37.7370105591839, -122.464764869528) | |||
| 151358 | 151358 | 212399 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5991905.65661 | 2095820.3690099998 | 37.7342582577962 | -122.470410235049 | (37.7342582577962, -122.470410235049) | |||
| 152264 | 152264 | 246502 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 263 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6004797.9998 | 2099855.96577 | 37.7460760896468 | -122.426124451001 | (37.7460760896468, -122.426124451001) | |||
| 154535 | 154535 | 212389 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991918.06115 | 2095527.0929400001 | 37.7334537126093 | -122.47034599827101 | (37.7334537126093, -122.470345998271) | |||
| 155545 | 155545 | 178843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 316 Naylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002755.16684 | 2086552.83016 | 37.7094330059866 | -122.432238395683 | (37.7094330059866, -122.432238395683) | |||
| 157796 | 157796 | 212548 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 145 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5993718.22007 | 2096679.4381400002 | 37.7367216834608 | -122.464206018214 | (37.7367216834608, -122.464206018214) | |||
| 161423 | 161423 | 196154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1317 19th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6013683.78692 | 2105210.99248 | 37.7612780613652 | -122.395773489354 | (37.7612780613652, -122.395773489354) | |||
| 162154 | 162154 | 212552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993655.47599 | 2096724.4870799999 | 37.7368417600228 | -122.464426219908 | (37.7368417600228, -122.464426219908) | |||
| 163567 | 163567 | 212376 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994225.30573 | 2099058.0744 | 37.743282039932794 | -122.462625309526 | (37.7432820399328, -122.462625309526) | |||
| 163764 | 163764 | 201519 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6019223.74724 | 2094361.07733 | 37.7317929966527 | -122.375860604396 | (37.7317929966527, -122.375860604396) | |||
| 167416 | 167416 | 178834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001553.31629 | 2086683.73815 | 37.7097242325659 | -122.43640154631201 | (37.7097242325659, -122.436401546312) | |||
| 167551 | 167551 | 212645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.955709999 | 2090426.4922099998 | 37.7194793442858 | -122.46814311071199 | (37.7194793442858, -122.468143110712) | |||
| 172091 | 172091 | 212545 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 153 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993783.635980001 | 2096630.2116 | 37.736590289813705 | -122.463976276481 | (37.7365902898137, -122.463976276481) | |||
| 172302 | 172302 | 212403 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5991902.57817 | 2095944.2843799999 | 37.734598320237296 | -122.470429899615 | (37.7345983202373, -122.470429899615) | |||
| 172442 | 172442 | 212643 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992448.21335 | 2090456.8872900002 | 37.7195628166546 | -122.468144430025 | (37.7195628166546, -122.468144430025) | |||
| 173038 | 173038 | 212558 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 125 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993542.30176 | 2096798.75728 | 37.7370391630172 | -122.464822901877 | (37.7370391630172, -122.464822901877) | |||
| 173724 | 173724 | 212546 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 153 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993763.96302 | 2096645.96515 | 37.736632411357604 | -122.464045437042 | (37.7366324113576, -122.464045437042) | |||
| 174012 | 174012 | 212401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.4182 | 2095887.6067400002 | 37.7344428040878 | -122.470419411726 | (37.7344428040878, -122.470419411726) |
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");