Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124720 | 124720 | 13115 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1626 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 60 | 3x3 | 6004582.24244 | 2119837.84859 | 37.80092927108829 | -122.428294391798 | (37.8009292710883, -122.428294391798) | ||
| 16762 | 16762 | 25545 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1997 12:00:00 AM | 35 | 3X3 | 6010962.7216300005 | 2096974.8083 | 37.73851155467371 | -122.40460474641701 | (37.7385115546737, -122.404604746417) | ||
| 127738 | 127738 | 27634 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 72535 | 72535 | 131232 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1403 The Embarcadero | 27 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 10ft | 6009815.0933300005 | 2122512.40886 | 37.8085676494355 | -122.410375388423 | (37.8085676494355, -122.410375388423) | |||
| 41324 | 41324 | 232137 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 369 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6003939.39037 | 2103322.72212 | 37.7555464256549 | -122.42934058040001 | (37.7555464256549, -122.4293405804) | |||
| 138293 | 138293 | 102019 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 50 | 3028 Market St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 4x14 | 6000376.7 | 2105451.5 | 37.7611891846044 | -122.44181421161001 | (37.7611891846044, -122.44181421161) | |||
| 30667 | 30667 | 193640 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 7 | : 4 | Tree 1 | Private 1 | 28 | Width 6ft | 6012998.43724 | 2097039.27853 | 37.7388021399962 | -122.397570695448 | (37.7388021399962, -122.397570695448) | |||
| 130039 | 130039 | 232143 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4500 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001046.64941 | 2104664.30606 | 37.7590658936826 | -122.43944071792801 | (37.7590658936826, -122.439440717928) | |||
| 122085 | 122085 | 25971 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 26 | 8x6 | 6012498.75973 | 2097344.83298 | 37.739613292243796 | -122.399319801459 | (37.7396132922438, -122.399319801459) | ||
| 160341 | 160341 | 42607 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 25 | Permit Number 42674 | 6006086.4179 | 2118663.17416 | 37.7977889095761 | -122.42300576222999 | (37.7977889095761, -122.42300576223) | ||
| 66391 | 66391 | 232113 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008027.37409 | 2096368.3193700002 | 37.7366817787289 | -122.414710885994 | (37.7366817787289, -122.414710885994) | |||
| 81280 | 81280 | 25935 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 24 | 3x3 | 6013056.68658 | 2097014.0389 | 37.7387360805466 | -122.397367525612 | (37.7387360805466, -122.397367525612) | ||
| 98023 | 98023 | 25554 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 99279 | 99279 | 25552 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 108095 | 108095 | 25553 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 116504 | 116504 | 25543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 121314 | 121314 | 25551 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 127270 | 127270 | 25544 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 169924 | 169924 | 42606 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 24 | Permit Number 42674 | 6006095.7199099995 | 2118663.62857 | 37.797790682161605 | -122.42297360696301 | (37.7977906821616, -122.422973606963) | |
| 159362 | 159362 | 232136 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 220 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003683.73706 | 2101597.86103 | 37.7507958864336 | -122.43010166677 | (37.7507958864336, -122.43010166677) | |||
| 182781 | 182781 | 232125 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 221 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006181.07888 | 2101867.41037 | 37.751677132113706 | -122.421484762237 | (37.7516771321137, -122.421484762237) | |||
| 165724 | 165724 | 232123 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 115 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007153.85946 | 2100096.11498 | 37.74686835730729 | -122.417995196642 | (37.7468683573073, -122.417995196642) | |||
| 184705 | 184705 | 233237 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4110 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6001733.83213 | 2103535.46825 | 37.7560054620974 | -122.43698330244601 | (37.7560054620974, -122.436983302446) | |||
| 184772 | 184772 | 193619 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1920 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 22 | Width 2ft | 6013689.18996 | 2098250.53118 | 37.742166425539104 | -122.395267204339 | (37.7421664255391, -122.395267204339) | |||
| 188797 | 188797 | 232091 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 685 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007330.3803199995 | 2103369.40953 | 37.75586601412179 | -122.41761676372101 | (37.7558660141218, -122.417616763721) | |||
| 160308 | 160308 | 233250 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 648 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002605.08046 | 2108877.80309 | 37.7707236983666 | -122.434352173914 | (37.7707236983666, -122.434352173914) | |||
| 178880 | 178880 | 117826 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 639 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5983481.30251 | 2111445.18055 | 37.776668928038504 | -122.500690467806 | (37.7766689280385, -122.500690467806) | |||
| 14184 | 14184 | 25546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 20 | 2X3 | 6010986.1155199995 | 2096981.2518200001 | 37.7385305546342 | -122.40452431464199 | (37.7385305546342, -122.404524314642) | ||
| 30854 | 30854 | 96684 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985882.68379 | 2113417.37347 | 37.7822246913621 | -122.492528778473 | (37.7822246913621, -122.492528778473) | ||
| 32057 | 32057 | 232049 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1901 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6009554.9243 | 2105709.1951200003 | 37.762415460925205 | -122.41008871242701 | (37.7624154609252, -122.410088712427) | |||
| 155230 | 155230 | 57965 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 20 | Permit Number 16925 | 5998963.22576 | 2086714.9374 | 37.7096623843901 | -122.445355572527 | (37.7096623843901, -122.445355572527) | ||
| 178350 | 178350 | 193608 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2070 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 2ft | 6012834.87099 | 2098853.0421599997 | 37.7437732433365 | -122.39826345580299 | (37.7437732433365, -122.398263455803) | |||
| 186807 | 186807 | 96685 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985883.85851 | 2113362.06041 | 37.782072886304704 | -122.492520639753 | (37.7820728863047, -122.492520639753) | ||
| 175439 | 175439 | 35357 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 853 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 19 | Permit Number 38819 | 6011893.15946 | 2104410.58195 | 37.758980537228105 | -122.401910282252 | (37.7589805372281, -122.401910282252) | |
| 6555 | 6555 | 22647 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1990 12:00:00 AM | 18 | 3X3 | 6003892.2472 | 2112477.7184 | 37.780681156415895 | -122.430156700947 | (37.7806811564159, -122.430156700947) | ||
| 7858 | 7858 | 22652 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1992 12:00:00 AM | 18 | 3X3 | 6004004.2161 | 2112490.9321 | 37.7807237790226 | -122.429770289505 | (37.7807237790226, -122.429770289505) | ||
| 8253 | 8253 | 22651 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1990 12:00:00 AM | 18 | 3X3 | 6003985.4387 | 2112488.1502 | 37.7807150772953 | -122.4298350511 | (37.7807150772953, -122.4298350511) | ||
| 8410 | 8410 | 22654 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6004084.8894 | 2112499.2776 | 37.7807512616309 | -122.42949179698 | (37.7807512616309, -122.42949179698) | |||
| 8432 | 8432 | 22657 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x6 | 6004182.2536 | 2112515.9686 | 37.780802603117706 | -122.42915615755899 | (37.7808026031177, -122.429156157559) | |||
| 8672 | 8672 | 22653 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004029.2526 | 2112495.8003 | 37.7807385635944 | -122.429684023491 | (37.7807385635944, -122.429684023491) | |||
| 12523 | 12523 | 66532 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3722 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 18 | 3x3 | Permit Number 29707 | 5984457.3026 | 2098196.9463 | 37.7403502256776 | -122.496336488295 | (37.7403502256776, -122.496336488295) | |
| 13905 | 13905 | 25980 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1951 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 18 | 3x3 | 6013173.42584 | 2096838.9136400002 | 37.738261722099 | -122.396951618345 | (37.738261722099, -122.396951618345) | ||
| 56549 | 56549 | 232106 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 376 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003833.58419 | 2096631.88415 | 37.737168945997794 | -122.429229419698 | (37.7371689459978, -122.429229419698) | |||
| 64110 | 64110 | 193551 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1164 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009847.38155 | 2108765.9462599996 | 37.770824986312704 | -122.409292927523 | (37.7708249863127, -122.409292927523) | |||
| 74892 | 74892 | 193552 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1164 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009839.28647 | 2108760.54539 | 37.770809703234704 | -122.409320547503 | (37.7708097032347, -122.409320547503) | |||
| 79793 | 79793 | 25945 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2076 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 18 | 3x3 | 6012602.39779 | 2097471.73155 | 37.7399675045813 | -122.39897036769301 | (37.7399675045813, -122.398970367693) | ||
| 111557 | 111557 | 27633 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 132713 | 132713 | 193645 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2088 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012555.125990001 | 2097369.19721 | 37.739683332629106 | -122.39912661970101 | (37.7396833326291, -122.399126619701) | |||
| 135361 | 135361 | 193663 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 180 Wisconsin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012524.06501 | 2107118.2212400003 | 37.7664503043564 | -122.399918436813 | (37.7664503043564, -122.399918436813) | |||
| 137380 | 137380 | 250012 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6005639.67048 | 2114203.54458 | 37.785518665693004 | -122.424234295496 | (37.785518665693, -122.424234295496) | |||
| 137661 | 137661 | 193609 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2070 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 2ft | 6012828.25614 | 2098863.87145 | 37.7438026098029 | -122.398287088186 | (37.7438026098029, -122.398287088186) | |||
| 157231 | 157231 | 193756 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 618 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6016336.61649 | 2097223.03863 | 37.7394920207503 | -122.386041534315 | (37.7394920207503, -122.386041534315) | |||
| 171318 | 171318 | 193665 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 180 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012523.80707 | 2107157.0082400003 | 37.7665567904001 | -122.399922052977 | (37.7665567904001, -122.399922052977) | |||
| 26909 | 26909 | 193581 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016627.824130001 | 2102624.40575 | 37.754339175729704 | -122.38541095757 | (37.7543391757297, -122.38541095757) | ||||
| 34092 | 34092 | 193607 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6012652.93364 | 2101843.19483 | 37.7519734254466 | -122.39910239827101 | (37.7519734254466, -122.399102398271) | |||
| 44023 | 44023 | 232064 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 764 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 6ft | 6010114.571769999 | 2104714.08807 | 37.759714473963705 | -122.408082907717 | (37.7597144739637, -122.408082907717) | |||
| 65943 | 65943 | 66074 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 391 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 17 | Permit Number 29117 | 6013527.73484 | 2105290.93775 | 37.761488891222 | -122.396318814866 | (37.761488891222, -122.396318814866) | |
| 66811 | 66811 | 193656 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Quint St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6012385.611280001 | 2095252.0487900001 | 37.7338606387586 | -122.39956412819599 | (37.7338606387586, -122.399564128196) | |||
| 160871 | 160871 | 232072 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 264 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004173.62803 | 2099577.2924099998 | 37.745275607592895 | -122.42826359009399 | (37.7452756075929, -122.428263590094) | |||
| 161082 | 161082 | 193591 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6016298.28126 | 2102605.60806 | 37.754269323574796 | -122.38654930051901 | (37.7542693235748, -122.386549300519) | |||
| 16636 | 16636 | 25943 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012631.62363 | 2097312.6354799997 | 37.739532288795 | -122.398858153188 | (37.739532288795, -122.398858153188) | ||
| 44911 | 44911 | 67700 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 16 | Permit Number 31310 | 5987428.34051 | 2113876.38168 | 37.7835752474242 | -122.4872152912 | (37.7835752474242, -122.4872152912) | ||
| 47228 | 47228 | 193644 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2076 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6012612.91692 | 2097326.29896 | 37.739568763475205 | -122.398923792012 | (37.7395687634752, -122.398923792012) | |||
| 52738 | 52738 | 233243 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 124 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001675.343669999 | 2108090.60737 | 37.768509437087395 | -122.43751176207701 | (37.7685094370874, -122.437511762077) | |||
| 58622 | 58622 | 233251 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 210 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004243.47514 | 2108758.37955 | 37.7704886515521 | -122.428676423893 | (37.7704886515521, -122.428676423893) | |||
| 61071 | 61071 | 193597 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1740 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012177.211069999 | 2106575.98015 | 37.7649420882242 | -122.401080044314 | (37.7649420882242, -122.401080044314) | |||
| 61944 | 61944 | 210185 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 567 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5998324.414919999 | 2094970.2920799998 | 37.7322931887605 | -122.448157438212 | (37.7322931887605, -122.448157438212) | |||
| 74642 | 74642 | 119410 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.78180786995821 | -122.49250029292101 | (37.7818078699582, -122.492500292921) | |||
| 91105 | 91105 | 25970 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 2x3 | 6012475.65333 | 2097362.28804 | 37.7396599323249 | -122.399400919032 | (37.7396599323249, -122.399400919032) | ||
| 114371 | 114371 | 25947 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2088 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012602.39779 | 2097471.73155 | 37.7399675045813 | -122.39897036769301 | (37.7399675045813, -122.398970367693) | ||
| 129822 | 129822 | 193646 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2088 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6012530.49142 | 2097385.7061 | 37.7397272896935 | -122.399212954624 | (37.7397272896935, -122.399212954624) | |||
| 141085 | 141085 | 25977 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | ||
| 157298 | 157298 | 232055 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1901 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6009549.12714 | 2105835.03313 | 37.762760658487004 | -122.410117647215 | (37.762760658487, -122.410117647215) | |||
| 163351 | 163351 | 78279 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.43752492633101 | (37.7257404495571, -122.437524926331) | ||
| 164836 | 164836 | 210186 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 563 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5998356.76458 | 2094969.04279 | 37.732291607777 | -122.44804550859699 | (37.732291607777, -122.448045508597) | |||
| 164911 | 164911 | 193743 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6016637.85786 | 2095631.9190900002 | 37.735139793969495 | -122.384889143935 | (37.7351397939695, -122.384889143935) | |||
| 182382 | 182382 | 193647 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2047 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6012619.151219999 | 2097251.20104 | 37.7393629077777 | -122.398896967025 | (37.7393629077777, -122.398896967025) | |||
| 11590 | 11590 | 15745 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4570 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1995 12:00:00 AM | 15 | 3X3 | 6002141.222999999 | 2092193.7491 | 37.7248868880905 | -122.434763397745 | (37.7248868880905, -122.434763397745) | ||
| 16646 | 16646 | 27538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.38711827459998 | (37.7549212799101, -122.3871182746) | ||
| 26628 | 26628 | 210184 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 571 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998301.09081 | 2094970.00997 | 37.7322910807629 | -122.448238054342 | (37.7322910807629, -122.448238054342) | |||
| 47095 | 47095 | 250014 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6005647.6336900005 | 2114206.58605 | 37.7855274664505 | -122.424206961487 | (37.7855274664505, -122.424206961487) | |||
| 57321 | 57321 | 232124 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 334 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007777.01976 | 2105954.9327599998 | 37.7629903885117 | -122.416255249491 | (37.7629903885117, -122.416255249491) | |||
| 61999 | 61999 | 200783 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1614 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6015318.2755 | 2096010.195 | 37.736105387845 | -122.389477864784 | (37.736105387845, -122.389477864784) | |||
| 65625 | 65625 | 78240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348306999 | (37.7255059765042, -122.43764348307) | ||
| 74867 | 74867 | 193580 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6016656.51597 | 2102626.40234 | 37.754346245297704 | -122.385311872064 | (37.7543462452977, -122.385311872064) | ||||
| 76877 | 76877 | 193600 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6012450.86154 | 2101834.3619999997 | 37.7519379094129 | -122.399800577033 | (37.7519379094129, -122.399800577033) | |||
| 96480 | 96480 | 27535 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
| 102773 | 102773 | 27540 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/24/2004 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
| 137348 | 137348 | 177572 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 17 Paulding St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000254.94105 | 2093181.2203900001 | 37.7274909853165 | -122.44135486014099 | (37.7274909853165, -122.441354860141) | |||
| 152095 | 152095 | 233242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 124 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001672.4759599995 | 2108104.26162 | 37.7685467652396 | -122.437522659154 | (37.7685467652396, -122.437522659154) | |||
| 161380 | 161380 | 232079 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 508 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007441.401269999 | 2096392.4655 | 37.7367151381826 | -122.416738563139 | (37.7367151381826, -122.416738563139) | |||
| 13693 | 13693 | 25934 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 14 | 3x3 | 6013105.1413900005 | 2096960.5409 | 37.7385918838981 | -122.39719624022499 | (37.7385918838981, -122.397196240225) | ||
| 15065 | 15065 | 25926 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 14 | 3x3 | 6013312.92964 | 2096802.5667400002 | 37.7381696854804 | -122.396466732646 | (37.7381696854804, -122.396466732646) | ||
| 29125 | 29125 | 232051 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1901 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6009550.86588 | 2105758.7582099997 | 37.7625513224022 | -122.410106248314 | (37.7625513224022, -122.410106248314) | |||
| 33552 | 33552 | 43314 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 143 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 14 | 6x9 | Permit Number 43077 | 6003948.96614 | 2092962.71195 | 37.7271007559741 | -122.428569025964 | (37.7271007559741, -122.428569025964) |
| 37688 | 37688 | 72518 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1996 12:00:00 AM | 14 | 5999282.60736 | 2089782.0179599999 | 37.718102119793 | -122.44447201828599 | (37.718102119793, -122.444472018286) | ||
| 41115 | 41115 | 232122 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 310 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006779.43206 | 2096281.2177400002 | 37.736372421849 | -122.419019394955 | (37.736372421849, -122.419019394955) | |||
| 41639 | 41639 | 232138 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 580 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003623.80973 | 2104905.2272099997 | 37.7598737366978 | -122.430544868859 | (37.7598737366978, -122.430544868859) | |||
| 46022 | 46022 | 232076 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 286 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6006797.887730001 | 2095759.0542799998 | 37.7349397154871 | -122.41891856296199 | (37.7349397154871, -122.418918562962) | |||
| 48983 | 48983 | 66073 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 654 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 14 | 8x8 | Permit Number 29116 | 6014375.99765 | 2104093.9898900003 | 37.7582494972364 | -122.39330123865801 | (37.7582494972364, -122.393301238658) |
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");