trees
54 rows where qSpecies_id = 249
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3050 | 224139 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 823 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009938.67843 | 2104230.67643 | 37.7583772846027 | -122.408657135627 | (37.7583772846027, -122.408657135627) | 2 | 4 | 7 | 28859 | 19 | |||
| 7462 | 34682 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1901X Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38348 | 6003792.36789 | 2118989.44278 | 37.79855504295 | -122.430967106869 | (37.79855504295, -122.430967106869) | 13 | 9 | 1 | 57 | 17 | ||
| 7564 | 207740 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 2143 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991830.49119 | 2095410.82981 | 37.7331294197717 | -122.470640284347 | (37.7331294197717, -122.470640284347) | 9 | 8 | 4 | 59 | 40 | |||
| 8405 | 72417 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 3826 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996568.86146 | 2114984.59947 | 37.787146881061 | -122.455672920594 | (37.787146881061, -122.455672920594) | 11 | 6 | 1 | 54 | 31 | |||
| 9235 | 224141 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1710 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002582.50392 | 2100474.56891 | 37.74764915948 | -122.4338295464 | (37.74764915948, -122.4338295464) | 2 | 4 | 5 | 63 | 22 | |||
| 11281 | 176294 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 362 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009691.47044 | 2092633.9804 | 37.72652143609 | -122.408693993438 | (37.72652143609, -122.408693993438) | 10 | 3 | 7 | 309 | 28 | |||
| 12091 | 259093 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 643 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6010453.37722 | 2086874.53559 | 37.7107498270326 | -122.40565461356 | (37.7107498270326, -122.40565461356) | 9 | 7 | 8 | 309 | 39 | |||
| 12423 | 126575 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 325 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001787.63929 | 2121824.00234 | 37.806224198747 | -122.438107240054 | (37.806224198747, -122.438107240054) | 13 | 9 | 1 | 57 | 17 | |||
| 14242 | 260619 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1433 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016097.60746 | 2095015.8946 | 37.7334184181838 | -122.386714057545 | (37.7334184181838, -122.386714057545) | 10 | 3 | 8 | 58 | 1 | ||
| 14997 | 176293 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 362 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009682.37539 | 2092661.2957 | 37.7265959287463 | -122.408727360996 | (37.7265959287463, -122.408727360996) | 10 | 3 | 7 | 309 | 28 | |||
| 16832 | 207739 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 2143 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991821.25203 | 2095410.74534 | 37.733128653567 | -122.470672220147 | (37.733128653567, -122.470672220147) | 9 | 8 | 4 | 59 | 40 | |||
| 21078 | 26007 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1635 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014718.17822 | 2095686.56355 | 37.7351834713331 | -122.391530042775 | (37.7351834713331, -122.391530042775) | 10 | 3 | 8 | 58 | 1 | ||
| 22940 | 207742 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1725 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5992710.54126 | 2095355.79342 | 37.7330291543647 | -122.46759374096 | (37.7330291543647, -122.46759374096) | 9 | 8 | 4 | 59 | 40 | |||
| 26623 | 224140 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 307 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004804.2724 | 2101852.61428 | 37.7515587795164 | -122.426244888214 | (37.7515587795164, -122.426244888214) | 2 | 4 | 5 | 28862 | 22 | |||
| 27915 | 126576 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 325 Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001797.43315 | 2121825.18922 | 37.8062280145861 | -122.43807343187 | (37.8062280145861, -122.43807343187) | 13 | 9 | 1 | 57 | 17 | |||
| 31923 | 254756 | Permitted Site 7 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | |
| 36786 | 224142 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 131 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002676.55661 | 2096767.72169 | 37.737476355858 | -122.433239490431 | (37.737476355858, -122.433239490431) | 2 | 7 | 5 | 63 | 7 | |||
| 37221 | 123926 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 289 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993049.75162 | 2113556.441 | 37.7830229705077 | -122.467744260704 | (37.7830229705077, -122.467744260704) | 11 | 6 | 2 | 54 | 11 | |||
| 40822 | 207735 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5990558.70316 | 2106517.89568 | 37.7635528982634 | -122.475847997488 | (37.7635528982634, -122.475847997488) | 1 | 8 | 3 | 56 | 12 | |||
| 47214 | 191712 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 18 Robblee Ave | 1 | : | Tree | Private 2 | 6 | Width 1ft | 6012627.22621 | 2095983.93227 | 37.7358837032551 | -122.398780133395 | (37.7358837032551, -122.398780133395) | 10 | 3 | 8 | 58 | 1 | |||
| 53111 | 26541 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 530 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1997 12:00:00 AM | 6 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | ||
| 71468 | 37637 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 610 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 4 | Permit Number 40054 | 5989743.37976 | 2111156.49557 | 37.7762419203796 | -122.479007222729 | (37.7762419203796, -122.479007222729) | 11 | 6 | 2 | 55 | 26 | |
| 77271 | 224138 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1201 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 2 | 6004507.41985 | 2096122.23395 | 37.7358076853729 | -122.426863376241 | (37.7358076853729, -122.426863376241) | 2 | 7 | 5 | 28861 | 2 | ||||
| 89532 | 207745 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 180 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994809.53759 | 2099391.37362 | 37.7442308255831 | -122.460629349683 | (37.7442308255831, -122.460629349683) | 1 | 8 | 4 | 59 | 40 | |||
| 89571 | 176296 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 825 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009213.60928 | 2092296.4174 | 37.7255677833202 | -122.410322123362 | (37.7255677833202, -122.410322123362) | 9 | 3 | 7 | 309 | 28 | |||
| 89873 | 37798 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 408 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 4 | Permit Number 40125 | 6010028.60183 | 2092562.93187 | 37.7263452283273 | -122.407523531213 | (37.7263452283273, -122.407523531213) | 10 | 3 | 7 | 309 | 28 | |
| 99646 | 224133 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1318 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010305.21423 | 2101543.86136 | 37.7510204102685 | -122.407200090933 | (37.7510204102685, -122.407200090933) | 2 | 4 | 7 | 28859 | 19 | |||
| 107172 | 123925 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 289 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993050.59003 | 2113538.51045 | 37.7829737865208 | -122.467740055688 | (37.7829737865208, -122.467740055688) | 11 | 6 | 2 | 54 | 11 | |||
| 108774 | 207737 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1635 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990638.38318 | 2106515.75866 | 37.7635516500133 | -122.475572256352 | (37.7635516500133, -122.475572256352) | 1 | 8 | 3 | 56 | 12 | |||
| 115244 | 224136 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1317 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010899.68167 | 2102068.50097 | 37.752494206641 | -122.405181291899 | (37.752494206641, -122.405181291899) | 10 | 4 | 8 | 28859 | 19 | |||
| 119616 | 176292 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 569 Sweeny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008031.15782 | 2094283.22052 | 37.7309567629318 | -122.414550300382 | (37.7309567629318, -122.414550300382) | 9 | 3 | 7 | 309 | 28 | |||
| 123367 | 14747 | Permitted Site 7 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 920 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 6 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
| 125441 | 224135 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 100 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005379.8522 | 2103070.55506 | 37.7549354793107 | -122.424341076487 | (37.7549354793107, -122.424341076487) | 2 | 4 | 5 | 28859 | 19 | |||
| 128621 | 224134 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 3321 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007612.00747 | 2100891.05038 | 37.7490768458284 | -122.416467258378 | (37.7490768458284, -122.416467258378) | 2 | 4 | 7 | 28859 | 19 | |||
| 129081 | 15962 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 5889 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997043.42918 | 2086497.79799 | 37.7089563913869 | -122.451975038726 | (37.7089563913869, -122.451975038726) | 9 | 7 | 6 | 28861 | 5 | ||
| 139605 | 126573 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 2758 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999758.1147 | 2118475.38042 | 37.7969141507236 | -122.444889865778 | (37.7969141507236, -122.444889865778) | 13 | 9 | 1 | 57 | 17 | |||
| 140284 | 207736 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990596.20147 | 2106515.99257 | 37.7635498468715 | -122.475718165083 | (37.7635498468715, -122.475718165083) | 1 | 8 | 3 | 56 | 12 | |||
| 144331 | 224137 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 99 Lapidge St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006030.22965 | 2104977.22383 | 37.7602074517435 | -122.422227339619 | (37.7602074517435, -122.422227339619) | 2 | 4 | 5 | 28859 | 19 | |||
| 145171 | 207738 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1609 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990722.06667 | 2106516.90671 | 37.7635596530906 | -122.475282908482 | (37.7635596530906, -122.475282908482) | 1 | 8 | 3 | 56 | 12 | |||
| 147252 | 40074 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 103 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41299 | 6014104.8225 | 2094099.62476 | 37.7307919981522 | -122.39353962378 | (37.7307919981522, -122.39353962378) | 10 | 3 | 8 | 58 | 1 |
| 149381 | 191711 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 470 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011178.42006 | 2106119.36333 | 37.7636325530173 | -122.404502484523 | (37.7636325530173, -122.404502484523) | 8 | 3 | 8 | 28856 | 29 | |||
| 153242 | 65772 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1901X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38348 | 6003765.63442 | 2118986.28057 | 37.7985448455377 | -122.431059387196 | (37.7985448455377, -122.431059387196) | 13 | 9 | 1 | 57 | 17 | |
| 153851 | 9746 | Permitted Site 7 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 710X McAllister St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/21/1998 12:00:00 AM | 6 | 4x4 | 6005653.6676 | 2112008.06895 | 37.7794912200693 | -122.424029686189 | (37.7794912200693, -122.424029686189) | 7 | 9 | 11 | 28852 | 41 | ||
| 160251 | 126574 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 325 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001777.37566 | 2121822.59363 | 37.8062197470954 | -122.438142658051 | (37.8062197470954, -122.438142658051) | 13 | 9 | 1 | 57 | 17 | |||
| 166904 | 207741 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1725 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992695.99732 | 2095356.37798 | 37.733029919687 | -122.467644065248 | (37.733029919687, -122.467644065248) | 9 | 8 | 4 | 59 | 40 | |||
| 167481 | 14779 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 1019 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1998 12:00:00 AM | 6 | 3X3 | 6004177.56294 | 2111802.19305 | 37.7788424867556 | -122.429121476626 | (37.7788424867556, -122.429121476626) | 7 | 9 | 11 | 29490 | 41 | ||
| 169288 | 207746 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 88 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993770.47564 | 2093250.09241 | 37.7273085569352 | -122.463776514596 | (37.7273085569352, -122.463776514596) | 9 | 8 | 4 | 59 | 40 | |||
| 169542 | 176291 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 569 Sweeny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008017.07815 | 2094281.03184 | 37.7309499622734 | -122.414598821474 | (37.7309499622734, -122.414598821474) | 9 | 3 | 7 | 309 | 28 | |||
| 174103 | 9747 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 710X McAllister St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 05/24/2011 12:00:00 AM | 3 | 4x4 | 6005653.6676 | 2112008.06895 | 37.7794912200693 | -122.424029686189 | (37.7794912200693, -122.424029686189) | 7 | 9 | 11 | 28852 | 41 | ||
| 178231 | 26454 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 401X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/1997 12:00:00 AM | 12 | 3X3 | 6017703.04155 | 2096755.51752 | 37.7382838301428 | -122.381284484 | (37.7382838301428, -122.381284484) | 10 | 3 | 8 | 58 | 1 | ||
| 178735 | 176295 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 362 Holyoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009696.67443 | 2092614.3405 | 37.7264678005258 | -122.408674618464 | (37.7264678005258, -122.408674618464) | 10 | 3 | 7 | 309 | 28 | |||
| 182450 | 207743 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994170.0412 | 2090383.26637 | 37.7194599620872 | -122.462187404444 | (37.7194599620872, -122.462187404444) | 9 | 8 | 6 | 28861 | 24 | |||
| 185129 | 37636 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 610 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 4 | Permit Number 40054 | 5989742.22577 | 2111176.88063 | 37.7762978251029 | -122.479012706068 | (37.7762978251029, -122.479012706068) | 11 | 6 | 2 | 55 | 26 | |
| 191370 | 207744 | DPW Maintained 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 | 76 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994170.32313 | 2090420.91672 | 37.7195633571528 | -122.462189159007 | (37.7195633571528, -122.462189159007) | 9 | 8 | 6 | 28861 | 24 |
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) );