Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22745 | 22745 | 24432 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005673.10821 | 2114299.89066 | 37.785785096156296 | -122.424125464932 | (37.7857850961563, -122.424125464932) | ||
| 23057 | 23057 | 22656 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | 13 | 5x6 | 6004159.3035 | 2112511.1004 | 37.7807879370459 | -122.429235205882 | (37.7807879370459, -122.429235205882) | ||
| 23266 | 23266 | 25941 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 7 | 3x3 | 6012690.56665 | 2097267.49994 | 37.739411640236 | -122.39865118591601 | (37.739411640236, -122.398651185916) | ||
| 23300 | 23300 | 25966 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 2x3 | 6012182.59825 | 2097568.59521 | 37.7402100700509 | -122.40042867166599 | (37.7402100700509, -122.400428671666) | ||
| 23330 | 23330 | 25192 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 10 | 3X3 | 5999863.3058400005 | 2104356.47488 | 37.7581532490819 | -122.44351115562 | (37.7581532490819, -122.44351115562) | ||
| 23453 | 23453 | 44513 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 150 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 12 | Permit Number 43807 | 6005815.01817 | 2093004.2329099998 | 37.72732019055479 | -122.422121046963 | (37.7273201905548, -122.422121046963) | |
| 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) | |||
| 24742 | 24742 | 54473 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.352419999 | 2095372.33986 | 37.73418801985999 | -122.39975324750799 | (37.73418801986, -122.399753247508) | ||
| 25066 | 25066 | 45114 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1432 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43977 | 5988656.3497 | 2100380.3456 | 37.7465903529409 | -122.481977924939 | (37.7465903529409, -122.481977924939) | |
| 25208 | 25208 | 66447 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.1903099995 | 2119198.2009799997 | 37.7994303674837 | -122.41244205838001 | (37.7994303674837, -122.41244205838) | |
| 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) | |||
| 26194 | 26194 | 31939 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1370 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35354 | 5981544.9955 | 2105760.2879 | 37.7609459982399 | -122.50696680963199 | (37.7609459982399, -122.506966809632) | |
| 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) | |||
| 27152 | 27152 | 72787 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 6000842.138719999 | 2087917.52073 | 37.7130714894434 | -122.43894785796199 | (37.7130714894434, -122.438947857962) | ||
| 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) | |||
| 29014 | 29014 | 43250 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 266 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43038 | 6009538.8668599995 | 2093129.97083 | 37.7278747727781 | -122.40925652566601 | (37.7278747727781, -122.409256525666) | |
| 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) | ||||
| 29551 | 29551 | 71175 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 10 | 5988319.432 | 2099688.0916 | 37.744670006074706 | -122.48309220548799 | (37.7446700060747, -122.483092205488) | ||
| 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) | |||
| 30056 | 30056 | 68330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3 | Permit Number 32145 | 5991076.10581 | 2110608.88252 | 37.774815627769705 | -122.474357034376 | (37.7748156277697, -122.474357034376) | |
| 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) | |||
| 30502 | 30502 | 30752 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | |
| 30527 | 30527 | 33381 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.871562201 | 2093773.0831922002 | 37.72867362771839 | -122.46806524141199 | (37.7286736277184, -122.468065241412) | |||
| 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) | ||||
| 30612 | 30612 | 74162 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5988352.2909 | 2099691.0788 | 37.7446801201935 | -122.48297880610501 | (37.7446801201935, -122.482978806105) | ||
| 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) | |||
| 30741 | 30741 | 95375 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2062 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2011 12:00:00 AM | 11 | 3x3 | Permit Number 767247 | 6003151.187940001 | 2118254.14775 | 37.7964997620133 | -122.43313322381701 | (37.7964997620133, -122.433133223817) | |
| 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) | |||
| 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) | ||
| 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) | ||||
| 32479 | 32479 | 46784 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 20 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 12 | Permit Number 44875 | 6002869.92629 | 2093520.6249 | 37.728571535144404 | -122.432339079298 | (37.7285715351444, -122.432339079298) | |
| 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) | |||
| 32765 | 32765 | 70201 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | ||
| 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) | |||
| 33375 | 33375 | 40695 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 239 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41675 | 6004959.82025 | 2094081.1149900001 | 37.7302287977163 | -122.425154059106 | (37.7302287977163, -122.425154059106) | |
| 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) |
| 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) | |||
| 34713 | 34713 | 33176 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3245 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 3.5x6 | Permit Number 37389 | 5985863.4598 | 2098187.5285 | 37.74040663959 | -122.491473929368 | (37.74040663959, -122.491473929368) |
| 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) |
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");