trees
5,723 rows where qSpecies_id = 14 sorted by DBH descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23 | 50211 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 834 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 9 | Permit Number 46919 | 5987605.33986 | 2110266.54313 | 37.7736739696217 | -122.486337841964 | (37.7736739696217, -122.486337841964) | 11 | 6 | 2 | 55 | 26 | |
| 1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 1487 | 73682 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2232 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5987047.2593 | 2102366.6287 | 37.7519504378009 | -122.487687815073 | (37.7519504378009, -122.487687815073) | 1 | 8 | 3 | 56 | 35 | |||
| 1738 | 75005 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5991294.36984 | 2110367.2976 | 37.7741649440769 | -122.473584395208 | (37.7741649440769, -122.473584395208) | 11 | 6 | 2 | 54 | 26 | |||
| 2179 | 78458 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5990186.88196 | 2095940.56831 | 37.7344887657249 | -122.476361303539 | (37.7344887657249, -122.476361303539) | 1 | 8 | 4 | 64 | 35 | |||
| 3553 | 175527 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 643 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009375.43654 | 2092916.22252 | 37.7272787075393 | -122.409806428744 | (37.7272787075393, -122.409806428744) | 10 | 3 | 7 | 309 | 28 | |||
| 4761 | 71613 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983838.80343 | 2111388.30802 | 37.7765337540591 | -122.499449582685 | (37.7765337540591, -122.499449582685) | 11 | 6 | 2 | 55 | 26 | |||
| 4945 | 71614 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 656 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983838.93625 | 2111360.81187 | 37.7764582653815 | -122.499447090774 | (37.7764582653815, -122.499447090774) | 11 | 6 | 2 | 55 | 26 | |||
| 7459 | 51269 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 562 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 9 | Permit Number 47644 | 5990968.52333 | 2111573.87197 | 37.7774589911551 | -122.474799629848 | (37.7774589911551, -122.474799629848) | 11 | 6 | 2 | 54 | 26 | |
| 9211 | 219896 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4005 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008892 | 2106239 | 37.7638330046272 | -122.412418981391 | (37.7638330046272, -122.412418981391) | 8 | 4 | 7 | 28859 | 19 | |||
| 9591 | 72007 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1919 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5986594.8133 | 2102174.9289 | 37.7513976822301 | -122.489238323994 | (37.7513976822301, -122.489238323994) | 1 | 8 | 3 | 29491 | 35 | |||
| 9807 | 47806 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 81 Escondido Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 9 | 2x4 | Permit Number 45574 | 5986047.258 | 2096098.209 | 37.7346806621522 | -122.490684749859 | (37.7346806621522, -122.490684749859) | 1 | 8 | 3 | 64 | 35 |
| 10499 | 219910 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3101 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008679.01418 | 2105090.20344 | 37.7606667184044 | -122.413074402284 | (37.7606667184044, -122.413074402284) | 2 | 4 | 7 | 28859 | 19 | |||
| 10832 | 44468 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1604 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | 6x6 | Permit Number 43783 | 6006204.34378 | 2092472.42947 | 37.725881925489 | -122.420737409425 | (37.725881925489, -122.420737409425) | 9 | 7 | 7 | 309 | 5 |
| 10892 | 72012 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2232 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5987028.7741 | 2102367.0306 | 37.7519504631183 | -122.487751768225 | (37.7519504631183, -122.487751768225) | 1 | 8 | 3 | 56 | 35 | |||
| 12614 | 72008 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1935 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5986597.8938 | 2102072.2457 | 37.7511159217998 | -122.489220122659 | (37.7511159217998, -122.489220122659) | 1 | 8 | 3 | 29491 | 35 | |||
| 12698 | 219893 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400 Alabama St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008892 | 2106239 | 37.7638330046272 | -122.412418981391 | (37.7638330046272, -122.412418981391) | 8 | 4 | 7 | 28859 | 19 | |||
| 13183 | 219818 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003304.2501 | 2096216.91789 | 37.7359995629199 | -122.431029959591 | (37.7359995629199, -122.431029959591) | 2 | 7 | 5 | 63 | 7 | |||
| 15817 | 73543 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 160 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 2x3 | 6008078.74105 | 2118058.42472 | 37.7962406394503 | -122.416068900977 | (37.7962406394503, -122.416068900977) | 5 | 1 | 10 | 28858 | 21 | ||
| 15989 | 75118 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1335 Griffith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6017861.446 | 2092515.1377 | 37.7266493234609 | -122.380442158707 | (37.7266493234609, -122.380442158707) | 10 | 3 | 8 | 58 | 1 | |||
| 16070 | 219894 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400 Alabama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008892 | 2106239 | 37.7638330046272 | -122.412418981391 | (37.7638330046272, -122.412418981391) | 8 | 4 | 7 | 28859 | 19 | |||
| 16673 | 71598 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 126 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5994743.91592 | 2086305.62835 | 37.7082967566677 | -122.459908520573 | (37.7082967566677, -122.459908520573) | 9 | 8 | 6 | 28861 | 25 | |||
| 16872 | 72676 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 203 04th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5994586.88347 | 2114134.74364 | 37.7846994688182 | -122.462468414589 | (37.7846994688182, -122.462468414589) | 11 | 6 | 2 | 54 | 11 | |||
| 18728 | 74742 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1335 Griffith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6017895.1835 | 2092564.7892 | 37.7267875184409 | -122.380328977275 | (37.7267875184409, -122.380328977275) | 10 | 3 | 8 | 58 | 1 | |||
| 18972 | 47799 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 44 Escondido Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 9 | Permit Number 45570 | 5986288.4361 | 2096137.2114 | 37.7348018377873 | -122.489853794137 | (37.7348018377873, -122.489853794137) | 1 | 8 | 3 | 64 | 35 | |
| 19043 | 78245 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 955 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5998556.73841 | 2089414.96807 | 37.7170528412024 | -122.446954625574 | (37.7170528412024, -122.446954625574) | 9 | 7 | 6 | 28861 | 25 | |||
| 19276 | 205020 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997130 | 2095001 | 37.7323091522192 | -122.452288997306 | (37.7323091522192, -122.452288997306) | 9 | 7 | 4 | 59 | 40 | |||
| 20951 | 219961 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 158 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004108.89316 | 2101034.81766 | 37.749273970929 | -122.428591308449 | (37.749273970929, -122.428591308449) | 2 | 4 | 5 | 28862 | 22 | |||
| 22859 | 175465 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 901 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008149.83827 | 2093022.01942 | 37.7275004425762 | -122.414050811518 | (37.7275004425762, -122.414050811518) | 9 | 3 | 7 | 309 | 28 | |||
| 28075 | 175413 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 229 Delano Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000104.20994 | 2092336.21065 | 37.725162195357 | -122.441815315746 | (37.725162195357, -122.441815315746) | 9 | 7 | 6 | 28861 | 25 | |||
| 28339 | 221097 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 155 Beacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6003306.88223 | 2097287.64909 | 37.7389396949071 | -122.431097258539 | (37.7389396949071, -122.431097258539) | 2 | 7 | 5 | 63 | 7 | |||
| 29138 | 188065 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 38 Flora St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013873.38288 | 2094548.14974 | 37.7320106937253 | -122.394371145919 | (37.7320106937253, -122.394371145919) | 10 | 3 | 8 | 58 | 1 | |||
| 30958 | 104965 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3660 21ST ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 3x4 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.7565180033839 | -122.429186559891 | (37.7565180033839, -122.429186559891) | 2 | 4 | 5 | 28862 | 3 | ||
| 32158 | 175304 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1742 Geneva Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004677.62307 | 2086954.36825 | 37.7106443595226 | -122.425622622982 | (37.7106443595226, -122.425622622982) | 9 | 7 | 6 | 309 | 5 | |||
| 32292 | 219754 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 109 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004250.0823 | 2095678.8232 | 37.7345756258565 | -122.427721510239 | (37.7345756258565, -122.427721510239) | 2 | 7 | 5 | 28861 | 25 | |||
| 32312 | 187505 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1888 Geneva Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6004874.16167 | 2086793.27995 | 37.7102131489865 | -122.42493188792 | (37.7102131489865, -122.42493188792) | 9 | 7 | 6 | 309 | 5 | |||
| 33859 | 88577 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 698 19th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51517 | 5990070.6574 | 2110655.96609 | 37.7748866043595 | -122.477838493901 | (37.7748866043595, -122.477838493901) | 11 | 6 | 2 | 55 | 26 | ||
| 35853 | 221080 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 164 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002522.34978 | 2096984.15312 | 37.7380618774462 | -122.433788120039 | (37.7380618774462, -122.433788120039) | 2 | 7 | 5 | 63 | 7 | |||
| 36248 | 219782 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 544 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002372.27678 | 2099469.77402 | 37.7448782969892 | -122.434484667426 | (37.7448782969892, -122.434484667426) | 2 | 7 | 5 | 63 | 22 | |||
| 37729 | 49301 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2746 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46310 | 5999800.44915 | 2118481.24217 | 37.7969326614763 | -122.444743800609 | (37.7969326614763, -122.444743800609) | 13 | 9 | 1 | 57 | 17 | |
| 39819 | 204864 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2442 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992367.20902 | 2098818.63643 | 37.742517419256 | -122.469032645451 | (37.742517419256, -122.469032645451) | 1 | 8 | 4 | 29491 | 40 | |||
| 40169 | 175512 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1105 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008168.11056 | 2093809.94534 | 37.7296649443629 | -122.414043361534 | (37.7296649443629, -122.414043361534) | 9 | 3 | 7 | 309 | 28 | |||
| 40214 | 175462 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1538 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006915.20841 | 2091727.21955 | 37.7238757799344 | -122.418227183048 | (37.7238757799344, -122.418227183048) | 9 | 7 | 7 | 309 | 28 | |||
| 41342 | 175415 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 229 Delano Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000135.62551 | 2092366.48345 | 37.725247107541 | -122.441708887253 | (37.725247107541, -122.441708887253) | 9 | 7 | 6 | 28861 | 25 | |||
| 42672 | 175485 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 780 Woolsey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009098.19114 | 2091433.09304 | 37.7231908058822 | -122.410660175852 | (37.7231908058822, -122.410660175852) | 9 | 3 | 7 | 309 | 28 | |||
| 43081 | 204194 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 155 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999736.82683 | 2095747.47928 | 37.7345078043757 | -122.443330225518 | (37.7345078043757, -122.443330225518) | 9 | 7 | 4 | 63 | 40 | |||
| 43087 | 204776 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1710 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5990926.33614 | 2103723.20708 | 37.7559007342403 | -122.474372532891 | (37.7559007342403, -122.474372532891) | 1 | 8 | 4 | 56 | 12 | |||
| 43095 | 218200 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 950 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5993085.15224 | 2098374.09173 | 37.7413382677543 | -122.466517926976 | (37.7413382677543, -122.466517926976) | 1 | 8 | 4 | 59 | 40 | |||
| 43545 | 204791 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1921 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5991244.35528 | 2102291.84959 | 37.7519890214998 | -122.473168346042 | (37.7519890214998, -122.473168346042) | 1 | 8 | 4 | 29491 | 12 | |||
| 44585 | 204217 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 43 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997650.6677 | 2091320.23261 | 37.7222324478469 | -122.450223718759 | (37.7222324478469, -122.450223718759) | 9 | 8 | 4 | 28861 | 24 | |||
| 44653 | 219673 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 962 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998822.81407 | 2106640.16029 | 37.7643642846032 | -122.447273971239 | (37.7643642846032, -122.447273971239) | 15 | 5 | 11 | 29492 | 9 | |||
| 44684 | 219914 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2812 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008952.08045 | 2102098.33759 | 37.7524670570319 | -122.411918558495 | (37.7524670570319, -122.411918558495) | 2 | 4 | 7 | 28859 | 19 | |||
| 44760 | 221096 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 155 Beacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6003294.70554 | 2097304.53072 | 37.7389853579742 | -122.431140564504 | (37.7389853579742, -122.431140564504) | 2 | 7 | 5 | 63 | 7 | |||
| 45476 | 204049 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 6 Geneva Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997346.16193 | 2091404.96382 | 37.7224476691055 | -122.451282424964 | (37.7224476691055, -122.451282424964) | 9 | 8 | 6 | 28861 | 24 | |||
| 47634 | 204799 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1908 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991285.36182 | 2102398.09072 | 37.7522831060881 | -122.473034287704 | (37.7522831060881, -122.473034287704) | 1 | 8 | 4 | 29491 | 12 | |||
| 48270 | 175401 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55 Still St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002677.83048 | 2094547.97056 | 37.7313814992615 | -122.433076535969 | (37.7313814992615, -122.433076535969) | 9 | 7 | 5 | 28861 | 25 | |||
| 48273 | 205005 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 381 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998853.92679 | 2094362.70165 | 37.7306551447066 | -122.446283109899 | (37.7306551447066, -122.446283109899) | 9 | 7 | 4 | 28861 | 40 | |||
| 49846 | 11662 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 9 | 6X6 | 5991320.71555 | 2093015.85848 | 37.7265239371103 | -122.472228178599 | (37.7265239371103, -122.472228178599) | 9 | 8 | 4 | 64 | 40 | |||
| 50586 | 188123 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 335 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015232.24091 | 2108218.4902 | 37.769622013562 | -122.390628163961 | (37.769622013562, -122.390628163961) | 14 | 3 | 9 | 310 | 20 | |||
| 52880 | 81640 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 145 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50850 | 6001879.52572 | 2120364.39427 | 37.8022217273062 | -122.437684651343 | (37.8022217273062, -122.437684651343) | 13 | 9 | 1 | 57 | 17 | |
| 52955 | 219751 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 309 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999815.10719 | 2103777.48684 | 37.7565607413036 | -122.443636254017 | (37.7565607413036, -122.443636254017) | 2 | 5 | 5 | 28862 | 3 | |||
| 53731 | 37791 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 310 Hamilton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 9 | Permit Number 40120 | 6009331.35664 | 2092778.71783 | 37.7268986783318 | -122.409949110666 | (37.7268986783318, -122.409949110666) | 9 | 3 | 7 | 309 | 28 | |
| 54271 | 175498 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 780 Woolsey St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008711.76356 | 2091315.11644 | 37.7228451937469 | -122.411987652526 | (37.7228451937469, -122.411987652526) | 9 | 3 | 7 | 309 | 28 | |||
| 54799 | 244195 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1649 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998643.9704 | 2108970.4274 | 37.7707523871676 | -122.448060333573 | (37.7707523871676, -122.448060333573) | 15 | 5 | 11 | 29492 | 9 | |||
| 54943 | 204847 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 850 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5991326.05921 | 2101832.87307 | 37.7507335220466 | -122.472852340468 | (37.7507335220466, -122.472852340468) | 1 | 8 | 4 | 29491 | 12 | |||
| 55637 | 204197 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 490 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998830.74018 | 2094990.78737 | 37.7323783959452 | -122.446408436708 | (37.7323783959452, -122.446408436708) | 9 | 7 | 4 | 59 | 40 | |||
| 56162 | 50304 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 371@ CLEMENT 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2003 12:00:00 AM | 9 | Permit Number 47014 | 5987440.79756 | 2113480.9282 | 37.782490171238 | -122.487143141189 | (37.782490171238, -122.487143141189) | 11 | 6 | 2 | 55 | 26 | ||
| 56429 | 219926 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 704 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001855.28914 | 2101996.29075 | 37.7517861524077 | -122.436453106231 | (37.7517861524077, -122.436453106231) | 2 | 4 | 5 | 28862 | 22 | |||
| 57154 | 219938 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4010 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003046.85111 | 2101855.42698 | 37.7514670100174 | -122.432322467002 | (37.7514670100174, -122.432322467002) | 2 | 4 | 5 | 28862 | 22 | |||
| 59626 | 219832 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 130 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002085.91176 | 2096624.75031 | 37.7370502651426 | -122.43527140066 | (37.7370502651426, -122.43527140066) | 2 | 7 | 5 | 63 | 7 | |||
| 60737 | 52317 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4000 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48473 | 6003124.28187009 | 2102445.67821433 | 37.7530920905977 | -122.432096848701 | (37.7530920905977, -122.432096848701) | 2 | 4 | 5 | 28862 | 22 |
| 60814 | 47808 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 86 Escondido Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 9 | Permit Number 45575 | 5986031.0734 | 2096127.1292 | 37.7347591239505 | -122.49074283196 | (37.7347591239505, -122.49074283196) | 1 | 8 | 3 | 64 | 35 | |
| 61546 | 52316 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4000 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48473 | 6003124.28187009 | 2102445.67821433 | 37.7530920905977 | -122.432096848701 | (37.7530920905977, -122.432096848701) | 2 | 4 | 5 | 28862 | 22 |
| 63664 | 143079 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 536 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010364.8114 | 2119950.5825 | 37.8015643098365 | -122.408292115742 | (37.8015643098365, -122.408292115742) | 3 | 1 | 10 | 308 | 23 | |||
| 64340 | 175545 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 187 Seville St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001219.37593 | 2087363.7539 | 37.7115724247979 | -122.437604368864 | (37.7115724247979, -122.437604368864) | 9 | 7 | 6 | 28861 | 5 | |||
| 65844 | 34823 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 456 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 9 | Permit Number 38710 | 5982857.51901 | 2112741.11671 | 37.780190549097 | -122.502944242938 | (37.780190549097, -122.502944242938) | 11 | 6 | 2 | 55 | 26 | |
| 66195 | 204777 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1759 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990891.4416 | 2103438.99566 | 37.7551183429548 | -122.474472468237 | (37.7551183429548, -122.474472468237) | 1 | 8 | 4 | 56 | 12 | |||
| 67152 | 247608 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Tompkins Ave | 13 | : | Tree | Private 2 | 9 | Width 3ft | 6009430.72052 | 2096395.0816 | 37.7368340096763 | -122.409860778348 | (37.7368340096763, -122.409860778348) | 10 | 7 | 7 | 28859 | 2 | |||
| 67385 | 219717 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3037 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008038.66975 | 2103256.90888 | 37.7555969432619 | -122.415159297878 | (37.7555969432619, -122.415159297878) | 2 | 4 | 7 | 28859 | 19 | |||
| 67419 | 219824 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 260 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004348.65108 | 2096890.71051 | 37.7379087696701 | -122.427467031774 | (37.7379087696701, -122.427467031774) | 2 | 7 | 5 | 63 | 7 | |||
| 69821 | 125629 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3001 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004680.60565 | 2119899.78704 | 37.8011049033356 | -122.427958429433 | (37.8011049033356, -122.427958429433) | 13 | 9 | 1 | 57 | 17 | |||
| 70161 | 219671 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1079 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998942.02036 | 2106259.44334 | 37.7633257421113 | -122.446834274691 | (37.7633257421113, -122.446834274691) | 15 | 5 | 11 | 29492 | 9 | |||
| 70650 | 204046 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 663 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994022.76133 | 2090881.04367 | 37.7208182576376 | -122.462732584258 | (37.7208182576376, -122.462732584258) | 9 | 8 | 6 | 64 | 24 | |||
| 78919 | 125579 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3006 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999469.68932 | 2119186.80379 | 37.7988510646785 | -122.445939076035 | (37.7988510646785, -122.445939076035) | 13 | 9 | 1 | 57 | 17 | |||
| 80328 | 204969 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Miramar Ave | 7 | Median : Yard | Tree | DPW 1 | 9 | 5995393.40684 | 2093932.00201 | 37.7292743040538 | -122.458215416425 | (37.7292743040538, -122.458215416425) | 9 | 7 | 4 | 28861 | 40 | ||||
| 81218 | 219626 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3600 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005645.3572 | 2102581.089 | 37.7536065079568 | -122.423388090116 | (37.7536065079568, -122.423388090116) | 2 | 4 | 5 | 28859 | 19 | |||
| 81401 | 39297 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 399X Treat Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) | 8 | 4 | 7 | 28859 | 19 |
| 84717 | 204838 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1619 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5992749.10323 | 2104420.50725 | 37.757920773446 | -122.468119584473 | (37.757920773446, -122.468119584473) | 1 | 8 | 4 | 56 | 12 | |||
| 85117 | 175479 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800 Bowdoin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008930.96028 | 2093059.17922 | 37.7276463171077 | -122.411353081898 | (37.7276463171077, -122.411353081898) | 9 | 3 | 7 | 309 | 28 | |||
| 85166 | 188008 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1301 Minnesota St | 62 | Front Yard : Yard | Tree | Private 2 | 9 | 6015360.85476 | 2102358.97833 | 37.7535401910343 | -122.389773959104 | (37.7535401910343, -122.389773959104) | 10 | 3 | 8 | 28856 | 29 | ||||
| 85595 | 219616 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3451 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005320.7571 | 2103106.84926 | 37.7550317975828 | -122.424548025768 | (37.7550317975828, -122.424548025768) | 2 | 4 | 5 | 28859 | 19 | |||
| 85824 | 51267 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 754 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 9 | Permit Number 47643 | 5991343.07914 | 2110257.10215 | 37.7738651980913 | -122.473407863681 | (37.7738651980913, -122.473407863681) | 11 | 6 | 2 | 54 | 26 | |
| 86707 | 219755 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 105 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004265.28898 | 2095671.60429 | 37.7345566645436 | -122.427668421478 | (37.7345566645436, -122.427668421478) | 2 | 7 | 5 | 28861 | 25 | |||
| 89485 | 13353 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 475X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2000 12:00:00 AM | 9 | 3X3 | 6010520.0274426 | 2090294.0678992 | 37.7201428931368 | -122.405664951367 | (37.7201428931368, -122.405664951367) | 10 | 7 | 8 | 309 | 28 | ||
| 89787 | 219865 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 52 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009273.32272 | 2097756.29375 | 37.7405627805507 | -122.410501065091 | (37.7405627805507, -122.410501065091) | 10 | 7 | 7 | 28859 | 2 | |||
| 89865 | 34821 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 420 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 9 | Permit Number 38709 | 5982850.46473 | 2112964.10634 | 37.7808023985461 | -122.502985159404 | (37.7808023985461, -122.502985159404) | 11 | 6 | 2 | 55 | 26 | |
| 89870 | 44464 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1600 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | Permit Number 43782 | 6006238.29071 | 2092483.54269 | 37.7259143532438 | -122.420620845582 | (37.7259143532438, -122.420620845582) | 9 | 7 | 7 | 309 | 5 | |
| 93917 | 219611 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 274 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006686.315 | 2104520.16561 | 37.7589894612011 | -122.419925811745 | (37.7589894612011, -122.419925811745) | 2 | 4 | 7 | 28859 | 19 | |||
| 94284 | 125652 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2080 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6004191.10424 | 2117025.98983 | 37.7931864887284 | -122.429447258884 | (37.7931864887284, -122.429447258884) | 13 | 9 | 1 | 28858 | 27 | |||
| 94319 | 175285 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 350 Olmstead St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010704.73668 | 2090949.18251 | 37.7219520302409 | -122.40507257466 | (37.7219520302409, -122.40507257466) | 10 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );