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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1852 | 1852 | 178671 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 624 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6002757.8843 | 2087321.68 | 37.7115442544376 | -122.432283877092 | (37.7115442544376, -122.432283877092) | |||
| 1995 | 1995 | 193739 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 4ft | 6016922.219330001 | 2094905.4243400001 | 37.7331607080971 | -122.383855425397 | (37.7331607080971, -122.383855425397) | |||
| 7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
| 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) | |||
| 12374 | 12374 | 15776 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4804 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 773279 | 6001272.7685 | 2090814.9657 | 37.721051717250795 | -122.43766683913601 | (37.7210517172508, -122.437666839136) | ||
| 14012 | 14012 | 106954 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 29 Lydia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012839.09683 | 2092807.12473 | 37.727172647775 | -122.397824840259 | (37.727172647775, -122.397824840259) | |||
| 14512 | 14512 | 24130 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016633.73992 | 2095504.76195 | 37.734790418140605 | -122.384894525455 | (37.7347904181406, -122.384894525455) | |||
| 16675 | 16675 | 16465 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018666.35636 | 2097096.27558 | 37.7392726167438 | -122.37797742504 | (37.7392726167438, -122.37797742504) | |||
| 16833 | 16833 | 16463 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018612.88561 | 2097134.8000900003 | 37.7393754506279 | -122.378164978648 | (37.7393754506279, -122.378164978648) | |||
| 17069 | 17069 | 232077 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6006071.88671 | 2096082.4988799999 | 37.7357869155289 | -122.42145157094299 | (37.7357869155289, -122.421451570943) | ||||
| 20729 | 20729 | 25193 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999854.12011 | 2104362.71552 | 37.758169860475995 | -122.443543372027 | (37.758169860476, -122.443543372027) | |||
| 22095 | 22095 | 16101 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 300 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000029.1931 | 2094706.63805 | 37.731666565451896 | -122.442244727636 | (37.7316665654519, -122.442244727636) | |||
| 22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
| 22679 | 22679 | 9226 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 6332 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987316.8892 | 2112613.5319 | 37.7801013217352 | -122.487508066232 | (37.7801013217352, -122.487508066232) | |||
| 23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
| 23613 | 23613 | 177549 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008302.63413 | 2087080.3017900002 | 37.7111943147388 | -122.41310263557502 | (37.7111943147388, -122.413102635575) | |||
| 23756 | 23756 | 232044 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1312 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007145.81115 | 2107846.77823 | 37.7681494393824 | -122.418572549693 | (37.7681494393824, -122.418572549693) | |||
| 23830 | 23830 | 177533 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 475 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009855.34609 | 2092245.89508 | 37.725465012383 | -122.408100121635 | (37.725465012383, -122.408100121635) | |||
| 24091 | 24091 | 193642 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012823.32202 | 2097168.087 | 37.739146068631705 | -122.398185200408 | (37.7391460686317, -122.398185200408) | |||
| 24208 | 24208 | 177560 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998919.67884 | 2087945.88417 | 37.7130398000187 | -122.445594536777 | (37.7130398000187, -122.445594536777) | |||
| 24241 | 24241 | 193574 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Illinois St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016138.78787 | 2103882.6002 | 37.7577668436722 | -122.38718994068701 | (37.7577668436722, -122.387189940687) | |||
| 24302 | 24302 | 232117 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006376.96981 | 2097041.1204900001 | 37.7384362742185 | -122.420464800608 | (37.7384362742185, -122.420464800608) | |||
| 24403 | 24403 | 232085 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 119 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006812.50904 | 2096877.7534400001 | 37.7380122393768 | -122.41894733046401 | (37.7380122393768, -122.418947330464) | |||
| 25259 | 25259 | 210133 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 136 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998117.85696 | 2093994.9890700001 | 37.7296034271496 | -122.448801328523 | (37.7296034271496, -122.448801328523) | |||
| 25883 | 25883 | 233254 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 25 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004291.56909 | 2098141.11691 | 37.741338872095604 | -122.42775345958201 | (37.7413388720956, -122.427753459582) | |||
| 26047 | 26047 | 232121 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006748.24321 | 2096971.86371 | 37.738267026292206 | -122.419176203435 | (37.7382670262922, -122.419176203435) | |||
| 26099 | 26099 | 202241 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013196.57345 | 2093194.11858 | 37.728255155426 | -122.396616155019 | (37.728255155426, -122.396616155019) | |||
| 26295 | 26295 | 201309 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 11 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012928.97985 | 2092740.84393 | 37.7269956593979 | -122.397509466884 | (37.7269956593979, -122.397509466884) | |||
| 26615 | 26615 | 201282 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 46 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012790.052209999 | 2092889.91673 | 37.727397246266605 | -122.398000193676 | (37.7273972462666, -122.398000193676) | |||
| 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) | |||
| 26699 | 26699 | 177553 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008169.89589 | 2087127.62977 | 37.7113168149851 | -122.413564758528 | (37.7113168149851, -122.413564758528) | |||
| 26729 | 26729 | 193753 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 119 Lindsay Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016558.9112599995 | 2095642.3661200001 | 37.7351641125365 | -122.38516282111901 | (37.7351641125365, -122.385162821119) | |||
| 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) | ||||
| 27092 | 27092 | 210148 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 351 Judson Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997785.60202 | 2093518.5538 | 37.7282762427524 | -122.44991563981701 | (37.7282762427524, -122.449915639817) | |||
| 27307 | 27307 | 244089 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 426 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997974.5438 | 2108985.8648 | 37.7707564848077 | -122.450376994548 | (37.7707564848077, -122.450376994548) | |||
| 27358 | 27358 | 202320 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 155 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012974.90873 | 2093002.4411400002 | 37.727716509204 | -122.397369027877 | (37.727716509204, -122.397369027877) | |||
| 27719 | 27719 | 210162 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996802.41479 | 2091448.3649900001 | 37.7225356893565 | -122.453165155657 | (37.7225356893565, -122.453165155657) | |||
| 27767 | 27767 | 210160 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 124 Marston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998602.69679 | 2093217.94824 | 37.727497569257395 | -122.44706929632099 | (37.7274975692574, -122.447069296321) | |||
| 27807 | 27807 | 122017 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1443 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991028.73556 | 2110608.20349 | 37.77481101883011 | -122.474520846677 | (37.7748110188301, -122.474520846677) | |||
| 27836 | 27836 | 201298 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012703.34992 | 2092907.69585 | 37.727441234813 | -122.398301172475 | (37.727441234813, -122.398301172475) | |||
| 28114 | 28114 | 210164 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 556 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993014.635559999 | 2090870.2943400003 | 37.7207306285937 | -122.466216557854 | (37.7207306285937, -122.466216557854) | |||
| 28231 | 28231 | 233247 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 691 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002444.44359 | 2108805.44805 | 37.7705159100121 | -122.43490264356701 | (37.7705159100121, -122.434902643567) | |||
| 28515 | 28515 | 177540 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118 Lowell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998750.27555 | 2087125.8155099999 | 37.7107784043659 | -122.446121097934 | (37.7107784043659, -122.446121097934) | |||
| 28561 | 28561 | 193638 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013067.98269 | 2096986.48087 | 37.7386610408817 | -122.3973265367 | (37.7386610408817, -122.3973265367) | |||
| 28707 | 28707 | 177564 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 791 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001913.98711 | 2089225.11823 | 37.7167227891097 | -122.435336672548 | (37.7167227891097, -122.435336672548) | |||
| 28957 | 28957 | 177550 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1232 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008203.75149 | 2087114.38987 | 37.7112823619554 | -122.41344680884899 | (37.7112823619554, -122.413446808849) | |||
| 29052 | 29052 | 232115 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006996.58261 | 2097438.2156700003 | 37.7395615077658 | -122.41835062308901 | (37.7395615077658, -122.418350623089) | |||
| 29099 | 29099 | 193627 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 225 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6010780.20523 | 2096913.54105 | 37.738333125583 | -122.405231490243 | (37.738333125583, -122.405231490243) | |||
| 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) | |||
| 29169 | 29169 | 202128 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2799 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012573.71911 | 2093089.235 | 37.7279324822924 | -122.398762044451 | (37.7279324822924, -122.398762044451) | |||
| 29222 | 29222 | 193556 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1201 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6016179.83084 | 2103134.6743900003 | 37.7557154703086 | -122.386995832797 | (37.7557154703086, -122.386995832797) | |||
| 29243 | 29243 | 201365 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 205 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6013111.57283 | 2092803.6730099998 | 37.7271783404816 | -122.39688264483401 | (37.7271783404816, -122.396882644834) | |||
| 29327 | 29327 | 193722 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Owen St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013875.94265 | 2107923.7634099997 | 37.7687374206141 | -122.395298938712 | (37.7687374206141, -122.395298938712) | |||
| 29430 | 29430 | 193630 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012153.66421 | 2097445.6121900002 | 37.7398707711245 | -122.40052007783501 | (37.7398707711245, -122.400520077835) | |||
| 29537 | 29537 | 202192 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1928 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013154.16149 | 2093432.6773299999 | 37.728907828517706 | -122.396779493476 | (37.7289078285177, -122.396779493476) | ||||
| 29584 | 29584 | 202251 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013208.3513 | 2093289.05623 | 37.728516490324395 | -122.396582090505 | (37.7285164903244, -122.396582090505) | |||
| 29745 | 29745 | 210188 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 511 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998607.30137 | 2094965.4162700002 | 37.7322959685703 | -122.447179088249 | (37.7322959685703, -122.447179088249) | |||
| 29951 | 29951 | 201313 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 300 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6012967.92533 | 2092673.3343599997 | 37.7268124603184 | -122.397370099843 | (37.7268124603184, -122.397370099843) | |||
| 30262 | 30262 | 177548 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008309.89956 | 2087076.14497 | 37.7111833088358 | -122.413077230629 | (37.7111833088358, -122.413077230629) | |||
| 30543 | 30543 | 104420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.776744114760106 | -122.504756894571 | (37.7767441147601, -122.504756894571) | ||||
| 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) | |||
| 30716 | 30716 | 193588 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6016388.406359999 | 2102608.3572299997 | 37.754281861036404 | -122.38623781404199 | (37.7542818610364, -122.386237814042) | |||
| 30800 | 30800 | 193660 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1728 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014387.04364 | 2096004.28587 | 37.736037486423605 | -122.392697123571 | (37.7360374864236, -122.392697123571) | |||
| 31026 | 31026 | 193704 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1455 Owen St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013721.19181 | 2108405.29195 | 37.770050982988 | -122.39586796044901 | (37.770050982988, -122.395867960449) | |||
| 31037 | 31037 | 193710 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Owen St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013693.6350300005 | 2108276.962 | 37.7696970844794 | -122.395954285486 | (37.7696970844794, -122.395954285486) | |||
| 31061 | 31061 | 193700 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1455 Owen St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013736.07493 | 2108320.89304 | 37.7698200703662 | -122.395810564824 | (37.7698200703662, -122.395810564824) | |||
| 31064 | 31064 | 193698 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1455 Owen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013751.344769999 | 2108267.80694 | 37.7696751572211 | -122.395754026247 | (37.7696751572211, -122.395754026247) | |||
| 31268 | 31268 | 51730 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3950 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 48012 | 5995856.51987 | 2115213.07332 | 37.787733304083 | -122.458153993141 | (37.787733304083, -122.458153993141) | |||
| 31277 | 31277 | 201299 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 61 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012712.67575 | 2092900.9099400002 | 37.727423121574205 | -122.398268456931 | (37.7274231215742, -122.398268456931) | |||
| 31449 | 31449 | 202248 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6013204.66207 | 2093259.83536 | 37.72843605046 | -122.396592796933 | (37.72843605046, -122.396592796933) | |||
| 31858 | 31858 | 210113 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 816 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5991488.40902 | 2102519.55417 | 37.7526283666271 | -122.47234097878 | (37.7526283666271, -122.47234097878) | |||
| 31902 | 31902 | 193562 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1201 Illinois St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016167.560869999 | 2103348.503 | 37.756301919113 | -122.38705317985901 | (37.756301919113, -122.387053179859) | |||
| 31950 | 31950 | 202214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013163.74677 | 2092935.74492 | 37.727543887034294 | -122.396711533513 | (37.7275438870343, -122.396711533513) | |||
| 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) | |||
| 32468 | 32468 | 193582 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6016596.341630001 | 2102622.43103 | 37.7543320117256 | -122.385519695483 | (37.7543320117256, -122.385519695483) | ||||
| 32540 | 32540 | 210191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Melrose Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 5997966.64829 | 2095534.3479400002 | 37.7338214930658 | -122.44943494048799 | (37.7338214930658, -122.449434940488) | ||||
| 32568 | 32568 | 193757 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 618 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016332.92123 | 2097214.9082299997 | 37.7394694918092 | -122.38605374441002 | (37.7394694918092, -122.38605374441) | |||
| 32573 | 32573 | 201331 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 95 Bitting Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012535.62971 | 2092785.01018 | 37.7270950209928 | -122.39887237867599 | (37.7270950209928, -122.398872378676) | |||
| 32583 | 32583 | 232120 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006744.342619999 | 2096963.28909 | 37.7382432626218 | -122.41918908171301 | (37.7382432626218, -122.419189081713) | |||
| 32748 | 32748 | 210125 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 451 Hearst Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5998401.39485 | 2094357.9622 | 37.7306162760214 | -122.447847234167 | (37.7306162760214, -122.447847234167) | |||
| 32914 | 32914 | 210110 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991591.03653 | 2105189.72808 | 37.7599659019171 | -122.47218069799999 | (37.7599659019171, -122.472180698) | |||
| 33090 | 33090 | 182294 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2461 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987213.1035 | 2105040.2293 | 37.7593010901644 | -122.487310671955 | (37.7593010901644, -122.487310671955) | |||
| 33567 | 33567 | 232098 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4430 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000426.80036 | 2101707.41736 | 37.750911701115996 | -122.441372274626 | (37.750911701116, -122.441372274626) | |||
| 33680 | 33680 | 210196 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998996.1704400005 | 2093773.42837 | 37.729045261128796 | -122.445748991746 | (37.7290452611288, -122.445748991746) | |||
| 33969 | 33969 | 232135 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4185 25th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003143.3737699995 | 2101224.11027 | 37.749739035528606 | -122.43194360511299 | (37.7497390355286, -122.431943605113) | |||
| 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) | |||
| 34330 | 34330 | 182135 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1463 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988347.2296 | 2105350.1101 | 37.7602180102839 | -122.483411077972 | (37.7602180102839, -122.483411077972) | |||
| 34697 | 34697 | 200659 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1524 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015248.4747 | 2095361.6525 | 37.7343207514686 | -122.389673913899 | (37.7343207514686, -122.389673913899) | |||
| 34726 | 34726 | 187449 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5010 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000654.7168 | 2089835.9634 | 37.718328437150504 | -122.43973310452 | (37.7183284371505, -122.43973310452) | |||
| 34925 | 34925 | 202296 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6012783.083 | 2093197.04815 | 37.7282401781334 | -122.39804582346001 | (37.7282401781334, -122.39804582346) | |||
| 34984 | 34984 | 182861 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1839 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988124.6648 | 2102778.1754 | 37.7531432168441 | -122.483992213945 | (37.7531432168441, -122.483992213945) | |||
| 35094 | 35094 | 177530 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 179 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999882.65893 | 2090264.59961 | 37.719461399191104 | -122.442432532145 | (37.7194613991911, -122.442432532145) | |||
| 35359 | 35359 | 185795 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1638 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5989786.792 | 2101779.0793 | 37.7504965885044 | -122.478171268627 | (37.7504965885044, -122.478171268627) | |||
| 35408 | 35408 | 193594 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1433 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012974.008219999 | 2106570.26127 | 37.764970802696 | -122.39832370409799 | (37.764970802696, -122.398323704098) | |||
| 35508 | 35508 | 210194 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 306 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999439.88836 | 2094142.41735 | 37.730083743362606 | -122.44424153463699 | (37.7300837433626, -122.444241534637) | |||
| 35796 | 35796 | 193720 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Owen St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013844.32278 | 2107963.90586 | 37.7688458842584 | -122.395411122836 | (37.7688458842584, -122.395411122836) | |||
| 35887 | 35887 | 177568 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3303 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011984.2913 | 2090294.781 | 37.7202266242306 | -122.400603502565 | (37.7202266242306, -122.400603502565) | |||
| 36083 | 36083 | 250018 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6005787.19276 | 2114383.50511 | 37.7860211214227 | -122.42373671138701 | (37.7860211214227, -122.423736711387) |
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");