trees
1,746 rows where qSpecies_id = 10 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13127 | 32202 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.02214 | 2100018.34894 | 37.7467730300449 | -122.410713678287 | (37.7467730300449, -122.410713678287) | 2 | 7 | 7 | 28859 | 2 | |
| 13175 | 30752 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | 10 | 3 | 8 | 58 | 1 |
| 13400 | 81931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009287.21527 | 2113626.45246 | 37.7841393898643 | -122.411574026434 | (37.7841393898643, -122.411574026434) | 14 | 10 | 9 | 28852 | 36 | |||
| 13482 | 72809 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.7109046790814 | -122.446180954109 | (37.7109046790814, -122.446180954109) | 9 | 7 | 6 | 28861 | 5 | ||
| 13627 | 78732 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 53 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998972.2526 | 2087962.75673 | 37.7130891296288 | -122.44541403745 | (37.7130891296288, -122.44541403745) | 9 | 7 | 6 | 28861 | 25 | |||
| 13719 | 264662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1070 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014517.40872 | 2089968.05117 | 37.7194704392608 | -122.391824453064 | (37.7194704392608, -122.391824453064) | 10 | 3 | 8 | 58 | 1 | |||
| 13817 | 78590 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008293.184 | 2113486.29357 | 37.7836987391503 | -122.415003105409 | (37.7836987391503, -122.415003105409) | 7 | 10 | 9 | 28858 | 36 | |||
| 14095 | 262078 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001148 | 2087377 | 37.7116047371551 | -122.437852010648 | (37.7116047371551, -122.437852010648) | 9 | 7 | 6 | 28861 | 5 | ||||
| 14252 | 76445 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998808.02641 | 2086988.08444 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | 9 | 7 | 6 | 28861 | 5 | ||
| 14298 | 18879 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2315 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1998 12:00:00 AM | 3 | 3X3 | 6003607.44812 | 2115913.14135 | 37.790097828305 | -122.431387267427 | (37.790097828305, -122.431387267427) | 13 | 9 | 1 | 29490 | 27 | ||
| 14517 | 81930 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009272.01277 | 2113623.31708 | 37.7841299280977 | -122.411626400234 | (37.7841299280977, -122.411626400234) | 14 | 10 | 9 | 28852 | 36 | |||
| 14828 | 82804 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 46 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000854.60594 | 2092857.18319 | 37.7266353963958 | -122.4392586043 | (37.7266353963958, -122.4392586043) | 9 | 7 | 6 | 28861 | 25 | |||
| 14990 | 260236 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 15074 | 61794 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2112 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 11 | Permit Number 21817 | 6012105.79225 | 2102838.47853 | 37.7546757515047 | -122.401064430306 | (37.7546757515047, -122.401064430306) | 10 | 3 | 8 | 28856 | 29 | |
| 15383 | 260234 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 15406 | 255194 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 15475 | 148112 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 509 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4x5 | 6010229.36415 | 2091734.22439 | 37.7240810061078 | -122.406771124199 | (37.7240810061078, -122.406771124199) | 10 | 3 | 7 | 309 | 28 | |||
| 15829 | 182637 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1634 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988859.5989 | 2102431.4519 | 37.7522339655322 | -122.481425305484 | (37.7522339655322, -122.481425305484) | 1 | 8 | 3 | 56 | 35 | |||
| 16035 | 184914 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983535.9639 | 2102008.3107 | 37.7507611695923 | -122.499803702352 | (37.7507611695923, -122.499803702352) | 1 | 8 | 3 | 29491 | 35 | |||
| 16036 | 247980 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 501 Peralta Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 6009795.98268 | 2099453.55621 | 37.7452523808083 | -122.408813614968 | (37.7452523808083, -122.408813614968) | 2 | 7 | 7 | 28859 | 2 | ||||
| 16295 | 69167 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1357 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33204 | 5982738.1126 | 2105902.9753 | 37.7614079699737 | -122.502850971641 | (37.7614079699737, -122.502850971641) | 1 | 8 | 3 | 56 | 35 | |
| 16397 | 200789 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1614 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015325 | 2096036 | 37.7361766159661 | -122.389456416811 | (37.7361766159661, -122.389456416811) | 10 | 3 | 8 | 58 | 1 | |||
| 16476 | 260228 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 16479 | 193722 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1500 Owen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013875.94265 | 2107923.76341 | 37.7687374206141 | -122.395298938712 | (37.7687374206141, -122.395298938712) | 14 | 3 | 9 | 310 | 20 | |||
| 16501 | 255192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 16512 | 72518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999282.60736 | 2089782.01796 | 37.718102119793 | -122.444472018286 | (37.718102119793, -122.444472018286) | 9 | 7 | 6 | 28861 | 25 | |||
| 16625 | 259862 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300x Brussels St | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 16807 | 255193 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 16910 | 85922 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1750 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988150.1283 | 2103379.9075 | 37.7547968937654 | -122.483948277297 | (37.7547968937654, -122.483948277297) | 1 | 8 | 3 | 56 | 35 | ||
| 17100 | 156687 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 699x Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007926.21888 | 2103995.6336 | 37.7576189924373 | -122.415600489977 | (37.7576189924373, -122.415600489977) | 2 | 4 | 7 | 28859 | 19 | |||
| 17408 | 72787 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000842.13872 | 2087917.52073 | 37.7130714894434 | -122.438947857962 | (37.7130714894434, -122.438947857962) | 9 | 7 | 6 | 28861 | 5 | |||
| 17795 | 144230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 696 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:47:00 PM | 0 | Width 4ft | 5982610.26029 | 2111073.90375 | 37.7755983350405 | -122.503676106264 | (37.7755983350405, -122.503676106264) | 11 | 6 | 2 | 55 | 26 | ||
| 17891 | 201310 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 9 Lydia Ave | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012935.48709 | 2092735.05755 | 37.7269801335046 | -122.397486565679 | (37.7269801335046, -122.397486565679) | 10 | 3 | 8 | 58 | 1 | |||
| 18135 | 193744 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 106 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016631.20601 | 2095628.77258 | 37.7351307863641 | -122.384911922862 | (37.7351307863641, -122.384911922862) | 10 | 3 | 8 | 58 | 1 | |||
| 18315 | 261539 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 723 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5981936 | 2110809 | 37.7748313206063 | -122.505988851899 | (37.7748313206063, -122.505988851899) | 11 | 6 | 2 | 55 | 26 | ||
| 18390 | 78903 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2078 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989460.8159 | 2101226.1598 | 37.7489594901873 | -122.479258062134 | (37.7489594901873, -122.479258062134) | 1 | 8 | 3 | 29491 | 35 | |||
| 18477 | 260227 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 18586 | 1979 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.3743209 | 2094812.8777717 | 37.7329560922326 | -122.380750713036 | (37.7329560922326, -122.380750713036) | 10 | 3 | 8 | 58 | 1 | ||
| 18688 | 70201 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | 1 | 8 | 3 | 56 | 35 | |||
| 18691 | 78242 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 767 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001367.70534 | 2092560.86013 | 37.725850945661 | -122.437463630336 | (37.725850945661, -122.437463630336) | 9 | 7 | 6 | 28861 | 25 | |||
| 18708 | 74162 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988352.2909 | 2099691.0788 | 37.7446801201935 | -122.482978806105 | (37.7446801201935, -122.482978806105) | 1 | 8 | 3 | 29491 | 35 | |||
| 18912 | 85921 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1758 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988172 | 2103340 | 37.7546885917873 | -122.483869713816 | (37.7546885917873, -122.483869713816) | 1 | 8 | 3 | 56 | 35 | ||
| 19341 | 260229 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 19462 | 41404 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | 9 | 7 | 8 | 309 | 39 | |
| 19508 | 262456 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 784 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001253 | 2092432 | 37.7254906030662 | -122.437850932396 | (37.7254906030662, -122.437850932396) | 9 | 7 | 6 | 28861 | 25 | ||
| 19612 | 260233 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 19627 | 217751 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 441 West Portal Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 5991805.88488 | 2096457.39841 | 37.7360016106807 | -122.470801561553 | (37.7360016106807, -122.470801561553) | 1 | 8 | 4 | 59 | 40 | |||
| 19954 | 86412 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1837X 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988124.549971 | 2102801.454812 | 37.7532071291716 | -122.483994317971 | (37.7532071291716, -122.483994317971) | 1 | 8 | 3 | 56 | 35 | ||
| 19988 | 85916 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1838 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988170.1375 | 2102775.399 | 37.7531382408152 | -122.483834758682 | (37.7531382408152, -122.483834758682) | 1 | 8 | 3 | 56 | 35 | ||
| 20103 | 210188 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 511 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998607.30137 | 2094965.41627 | 37.7322959685703 | -122.447179088249 | (37.7322959685703, -122.447179088249) | 9 | 7 | 4 | 59 | 40 | |||
| 20188 | 25908 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1744 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1997 12:00:00 AM | 6 | 3X3 | 6014300.07795 | 2096067.04044 | 37.7362049671689 | -122.393002190722 | (37.7362049671689, -122.393002190722) | 10 | 3 | 8 | 58 | 1 | ||
| 20495 | 210102 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1375 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991112.23533 | 2106068.30241 | 37.7623505127853 | -122.47390072154 | (37.7623505127853, -122.47390072154) | 1 | 8 | 11 | 56 | 12 | |||
| 20585 | 185794 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1636 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989817.1639 | 2101782.2212 | 37.7505069782885 | -122.478066471132 | (37.7505069782885, -122.478066471132) | 1 | 8 | 3 | 29491 | 35 | |||
| 20726 | 193574 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Illinois St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016138.78787 | 2103882.6002 | 37.7577668436722 | -122.387189940687 | (37.7577668436722, -122.387189940687) | 10 | 3 | 8 | 28856 | 29 | |||
| 20888 | 141868 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1224 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004136.2776 | 2112564.142 | 37.7809322725586 | -122.429318647091 | (37.7809322725586, -122.429318647091) | 7 | 9 | 11 | 29490 | 41 | |||
| 21035 | 56920 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1215 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 6 | Permit Number 775369 | 5987049.1527 | 2106973.4458 | 37.764599608453 | -122.488019735539 | (37.764599608453, -122.488019735539) | 1 | 8 | 3 | 56 | 35 | ||
| 21054 | 202253 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013211.00283 | 2093308.76677 | 37.7285707590106 | -122.396574305077 | (37.7285707590106, -122.396574305077) | 10 | 3 | 8 | 58 | 1 | |||
| 21638 | 177578 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 242 Hale St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6009395.15494 | 2094572.30852 | 37.731827072866 | -122.409855114442 | (37.731827072866, -122.409855114442) | 10 | 3 | 7 | 309 | 28 | |||
| 21736 | 202247 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013203.9034 | 2093250.17887 | 37.7284094934863 | -122.396594743075 | (37.7284094934863, -122.396594743075) | 10 | 3 | 8 | 58 | 1 | |||
| 22050 | 57958 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 332 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 13 | Permit Number 16918 | 5999508.52729 | 2086501.12484 | 37.7091064162873 | -122.443455572131 | (37.7091064162873, -122.443455572131) | 9 | 7 | 6 | 28861 | 5 | ||
| 22060 | 201295 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 77 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012646.29133 | 2092949.94041 | 37.7275540511672 | -122.39850138854 | (37.7275540511672, -122.39850138854) | 10 | 3 | 8 | 58 | 1 | |||
| 22247 | 193723 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 Owen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013916.41487 | 2107877.23111 | 37.7686119040458 | -122.395155687479 | (37.7686119040458, -122.395155687479) | 14 | 3 | 9 | 310 | 20 | |||
| 22260 | 24175 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 95X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 6 | 4x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
| 22303 | 201289 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 72 Lydia Ave | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012662.53869 | 2092985.79759 | 37.7276534127642 | -122.398447735869 | (37.7276534127642, -122.398447735869) | 10 | 3 | 8 | 58 | 1 | |||
| 22564 | 191757 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Owen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014146.70674 | 2107631.58061 | 37.76795020627 | -122.394341918847 | (37.76795020627, -122.394341918847) | 14 | 3 | 9 | 310 | 20 | |
| 22677 | 447 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 700x 23rd Ave | 7 | Median : Cutout | Tree | DPW 1 | 05/19/2015 10:02:00 AM | 3 | 8-HOA | 5988844.1797663 | 2110365.2900002 | 37.7740172309193 | -122.482059789586 | (37.7740172309193, -122.482059789586) | 11 | 6 | 2 | 55 | 26 | ||
| 22701 | 191771 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1700 Owen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014456.78592 | 2107294.74285 | 37.7670425555978 | -122.393245808049 | (37.7670425555978, -122.393245808049) | 14 | 3 | 9 | 310 | 20 | |
| 22703 | 232038 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 10 | : | Tree | Private 2 | 9 | Width 3ft | 6002409.33491 | 2108672.13814 | 37.7701478804393 | -122.435014548882 | (37.7701478804393, -122.435014548882) | 15 | 5 | 5 | 29492 | 9 | |||
| 22715 | 97320 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1044 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774147 | 5989913.4382 | 2099069.7096 | 37.7430647189098 | -122.477535314334 | (37.7430647189098, -122.477535314334) | 1 | 8 | 3 | 29491 | 35 | |
| 22801 | 193603 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2001 25th St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6012529.65643 | 2101837.23343 | 37.7519501860606 | -122.399528292892 | (37.7519501860606, -122.399528292892) | 10 | 3 | 8 | 28856 | 29 | |||
| 22947 | 177552 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1252 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008179.27118 | 2087123.9525 | 37.7113072443981 | -122.413532095133 | (37.7113072443981, -122.413532095133) | 9 | 7 | 8 | 309 | 39 | |||
| 23285 | 232074 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 322 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004379.21392 | 2100174.01438 | 37.7469256989599 | -122.427595213956 | (37.7469256989599, -122.427595213956) | 2 | 7 | 5 | 63 | 22 | |||
| 23634 | 193662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1748 Oakdale Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014283.43423 | 2096079.37448 | 37.7362379093615 | -122.39306059808 | (37.7362379093615, -122.39306059808) | 10 | 3 | 8 | 58 | 1 | |||
| 23662 | 24438 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
| 23733 | 232110 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 986 Burnett Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5999352.49281 | 2100464.86727 | 37.7474387010349 | -122.444998003853 | (37.7474387010349, -122.444998003853) | 2 | 5 | 5 | 63 | 38 | |||
| 23758 | 193643 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2000 Oakdale Ave | 7 | : | Tree | Private 2 | 14 | Width 3ft | 6012803.91355 | 2097182.00336 | 37.7391831989548 | -122.398253282685 | (37.7391831989548, -122.398253282685) | 10 | 3 | 8 | 58 | 1 | |||
| 24052 | 210106 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1481 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991786.0303 | 2105349.66275 | 37.7604163228817 | -122.471517969583 | (37.7604163228817, -122.471517969583) | 1 | 8 | 4 | 56 | 12 | |||
| 24142 | 25980 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1951 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 18 | 3x3 | 6013173.42584 | 2096838.91364 | 37.738261722099 | -122.396951618345 | (37.738261722099, -122.396951618345) | 10 | 3 | 8 | 58 | 1 | ||
| 24544 | 86286 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988350.35796 | 2106445.496749 | 37.763225825829 | -122.483480563078 | (37.763225825829, -122.483480563078) | 1 | 8 | 3 | 56 | 35 | ||
| 24788 | 210199 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 124 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999216.76029 | 2093513.04693 | 37.728342906802 | -122.444967687707 | (37.728342906802, -122.444967687707) | 9 | 7 | 4 | 28861 | 40 | |||
| 25026 | 202218 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013169.31452 | 2092974.31986 | 37.7276501158438 | -122.396694988704 | (37.7276501158438, -122.396694988704) | 10 | 3 | 8 | 58 | 1 | |||
| 25413 | 24111 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 180X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/1997 12:00:00 AM | 6 | 3X3 | 6016348.1117358 | 2095906.4833443 | 37.7358776620103 | -122.38591004253 | (37.7358776620103, -122.38591004253) | 10 | 3 | 8 | 58 | 1 | ||
| 25598 | 27634 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 245X Industrial St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010692.9519893 | 2096884.4242044 | 37.7382482984797 | -122.405531120584 | (37.7382482984797, -122.405531120584) | 10 | 3 | 8 | 58 | 1 | |||
| 25741 | 85910 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2230 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988256.502181 | 2100122.915005 | 37.7458602539478 | -122.483341670527 | (37.7458602539478, -122.483341670527) | 1 | 8 | 3 | 29491 | 35 | ||
| 26101 | 193706 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Owen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013673.45389 | 2108376.61913 | 37.7699695979404 | -122.396031076772 | (37.7699695979404, -122.396031076772) | 14 | 3 | 9 | 310 | 20 | |||
| 26234 | 232066 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2601 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010356.46242 | 2104551.43452 | 37.7592814045264 | -122.407234857828 | (37.7592814045264, -122.407234857828) | 10 | 4 | 7 | 28859 | 19 | |||
| 26495 | 42983 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 26714 | 184921 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983531.9028 | 2102160.6005 | 37.7511790768162 | -122.499829000947 | (37.7511790768162, -122.499829000947) | 1 | 8 | 3 | 29491 | 35 | |||
| 26770 | 182061 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1385 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988327.9412 | 2105916.982 | 37.7617733637233 | -122.483519345701 | (37.7617733637233, -122.483519345701) | 1 | 8 | 3 | 56 | 35 | |||
| 26956 | 131226 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1461 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008843.49268 | 2117944.40743 | 37.7959705442472 | -122.413414626583 | (37.7959705442472, -122.413414626583) | 5 | 1 | 10 | 308 | 21 | |||
| 27067 | 182293 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2471 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5987174.7926 | 2105038.9232 | 37.7592952697891 | -122.487443071965 | (37.7592952697891, -122.487443071965) | 1 | 8 | 3 | 56 | 35 | |||
| 27255 | 86314 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1563 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988370.7453 | 2104668.8777 | 37.7583488993654 | -122.483279812102 | (37.7583488993654, -122.483279812102) | 1 | 8 | 3 | 56 | 35 | ||
| 27731 | 232114 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 621 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008529.17733 | 2095946.17312 | 37.7355508380971 | -122.412946090592 | (37.7355508380971, -122.412946090592) | 10 | 7 | 7 | 28859 | 2 | |||
| 27857 | 131211 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2003 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003387.69253 | 2118236.54987 | 37.7964648557237 | -122.432313609585 | (37.7964648557237, -122.432313609585) | 13 | 9 | 1 | 57 | 17 | |||
| 27999 | 232144 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 91 Clover Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6000466.92396 | 2104962.588 | 37.7598518930567 | -122.44146708205 | (37.7598518930567, -122.44146708205) | 2 | 4 | 5 | 28862 | 3 | |||
| 28107 | 254206 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778893 | 5998078.03119 | 2093679.45345 | 37.7287347632495 | -122.448916289727 | (37.7287347632495, -122.448916289727) | 9 | 7 | 4 | 28861 | 40 |
| 28180 | 202242 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013197.35794 | 2093205.03586 | 37.7282851757099 | -122.396614207973 | (37.7282851757099, -122.396614207973) | 10 | 3 | 8 | 58 | 1 | |||
| 28237 | 201279 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 30 Lydia Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012855.91167 | 2092842.97051 | 37.7272720093701 | -122.397769224371 | (37.7272720093701, -122.397769224371) | 10 | 3 | 8 | 58 | 1 | |||
| 28340 | 25975 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2065 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2015 12:54:00 PM | 3 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | 10 | 3 | 8 | 58 | 1 | ||
| 28571 | 191760 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Owen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014227.64463 | 2107550.44075 | 37.7677319129348 | -122.394056280688 | (37.7677319129348, -122.394056280688) | 14 | 3 | 9 | 310 | 20 |
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) );