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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1265 | 1265 | 108488 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009599.94268 | 2111020.96873 | 37.777002885413104 | -122.410308071481 | (37.7770028854131, -122.410308071481) | |
| 1276 | 1276 | 229197 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3186 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 4x4 | 6008575.05448 | 2100617.97477 | 37.7483811527748 | -122.41311771451599 | (37.7483811527748, -122.413117714516) | |||
| 1278 | 1278 | 231178 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3298 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007881.72523 | 2100615.5936 | 37.7483356677609 | -122.41551506969101 | (37.7483356677609, -122.415515069691) | ||
| 1280 | 1280 | 231193 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007038.27508 | 2100609.92371 | 37.7482726540762 | -122.41843130396799 | (37.7482726540762, -122.418431303968) | ||
| 1281 | 1281 | 231175 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 4x4 | 6008989.553669999 | 2100618.8922900003 | 37.7484069327314 | -122.41168444520599 | (37.7484069327314, -122.411684445206) | ||
| 1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
| 1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
| 1287 | 1287 | 245764 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Width 3ft | Permit Number 779702 | 6004001.6074 | 2097411.86925 | 37.739320118017 | -122.428704072653 | (37.739320118017, -122.428704072653) | ||
| 1291 | 1291 | 234571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2892 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x4 | 6010196.53099 | 2100680.54575 | 37.7486438528311 | -122.407515070373 | (37.7486438528311, -122.407515070373) | ||
| 1296 | 1296 | 231177 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6008330.40398 | 2100615.02413 | 37.7483593136265 | -122.41396350442 | (37.7483593136265, -122.41396350442) | |||
| 1304 | 1304 | 231176 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008965.15097 | 2100617.87341 | 37.7484027661782 | -122.411768757547 | (37.7484027661782, -122.411768757547) | |||
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 1308 | 1308 | 231174 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3092 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6009165.99895 | 2100621.73745 | 37.7484246412851 | -122.411074499805 | (37.7484246412851, -122.411074499805) | |||
| 1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
| 1313 | 1313 | 231170 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2934 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009921.15441 | 2100625.625 | 37.7484776347434 | -122.408463450455 | (37.7484776347434, -122.408463450455) | |||
| 1315 | 1315 | 231172 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2968 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009727.404 | 2100624.8141099997 | 37.7484645559129 | -122.409133381503 | (37.7484645559129, -122.409133381503) | ||
| 1318 | 1318 | 100805 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002563.2899400005 | 2116751.5140400003 | 37.79234055221529 | -122.43505995207899 | (37.7923405522153, -122.435059952079) | |||
| 1321 | 1321 | 131728 | Undocumented 2 | Tree(s) :: 17 | 2951 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779933 | 6003422.05081 | 2118487.47605 | 37.7971557823578 | -122.432212651716 | (37.7971557823578, -122.432212651716) | |
| 1325 | 1325 | 141834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | |||
| 1327 | 1327 | 132224 | Undocumented 2 | Tree(s) :: 17 | 3720 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779917 | 5997037.00688 | 2115048.93067 | 37.7873503715741 | -122.454057896478 | (37.7873503715741, -122.454057896478) | |
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
| 1342 | 1342 | 187633 | Undocumented 2 | Tree(s) :: 17 | 148 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |
| 1344 | 1344 | 141858 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1110 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004615.4703 | 2112626.4811 | 37.781130557433706 | -122.427665325896 | (37.7811305574337, -122.427665325896) | |||
| 1359 | 1359 | 196907 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 351 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011780.0 | 2112595.0 | 37.7814467742932 | -122.40287726647301 | (37.7814467742932, -122.402877266473) | |||
| 1360 | 1360 | 125405 | Undocumented 2 | Tree(s) :: 17 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779167 | 6001716.65019 | 2117116.43684 | 37.7932944253528 | -122.438015491236 | (37.7932944253528, -122.438015491236) | |
| 1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1365 | 1365 | 251509 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 1368 | 1368 | 141257 | Undocumented 2 | Rhaphiolepis indica :: India Hawthorn 144 | 51 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996492.2734 | 2114210.7856 | 37.7850177994523 | -122.455881936455 | (37.7850177994523, -122.455881936455) | |||
| 1369 | 1369 | 121635 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560.0 | 2111978.0 | 37.778660711296794 | -122.46932365779699 | (37.7786607112968, -122.469323657797) | ||
| 1370 | 1370 | 141258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 COMMONWEALTH AVE | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996495.6576 | 2114088.9538 | 37.7846834760254 | -122.455861417999 | (37.7846834760254, -122.455861417999) | |||
| 1372 | 1372 | 251508 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1375 | 1375 | 251506 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1381 | 1381 | 189623 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009091.0 | 2109329.0 | 37.7723285943803 | -122.411949073152 | (37.7723285943803, -122.411949073152) | |||
| 1387 | 1387 | 250572 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Permit Number 779711 | 5997267.39343 | 2111112.94332 | 37.7765563945078 | -122.45297659119 | (37.7765563945078, -122.45297659119) | ||
| 1398 | 1398 | 251517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Bonview St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6007188.0 | 2098162.0 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | ||||
| 1399 | 1399 | 116632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2332 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 17 | 3x3 | Permit Number 779740 | 5991403.36215 | 2112037.8136299998 | 37.7787580362874 | -122.473329239514 | (37.7787580362874, -122.473329239514) | |
| 1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
| 1412 | 1412 | 120316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779745 | 5988743.0107 | 2113100.3508099997 | 37.7815210589505 | -122.482610207249 | (37.7815210589505, -122.482610207249) | |
| 1427 | 1427 | 196746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1201x 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012720.73761 | 2107120.44123 | 37.7664673626982 | -122.399238333493 | (37.7664673626982, -122.399238333493) | |||
| 1429 | 1429 | 102682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001423.65551 | 2115717.83054 | 37.7894375487454 | -122.438928994703 | (37.7894375487454, -122.438928994703) | |||
| 1437 | 1437 | 111252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3129x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5983208.5024 | 2097401.5189 | 37.7380929647396 | -122.500595473335 | (37.7380929647396, -122.500595473335) | |||
| 1438 | 1438 | 251533 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002292.0 | 2112799.0 | 37.7814725496882 | -122.43571571002899 | (37.7814725496882, -122.435715710029) | ||||
| 1439 | 1439 | 185582 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2227 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982934.0602 | 2099947.7625 | 37.74506813637971 | -122.501732671769 | (37.7450681363797, -122.501732671769) | |||
| 1442 | 1442 | 111247 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3101x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4 | 5983327.0508 | 2097406.6113 | 37.738113905777794 | -122.500185975345 | (37.7381139057778, -122.500185975345) | |||
| 1444 | 1444 | 187918 | Undocumented 2 | Betula pendula :: European White Birch 146 | 48 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013111.47563 | 2115056.38033 | 37.7882794108076 | -122.398443735705 | (37.7882794108076, -122.398443735705) | |||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 1458 | 1458 | 246242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
| 1467 | 1467 | 246243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
| 1472 | 1472 | 244877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1349 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000105.0 | 2109153.0 | 37.7713370947812 | -122.443019734512 | (37.7713370947812, -122.443019734512) | |||
| 1475 | 1475 | 187957 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014291.0 | 2114089.0 | 37.78568884516871 | -122.39429498812099 | (37.7856888451687, -122.394294988121) | |||
| 1482 | 1482 | 140438 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003482.3387 | 2112124.8891 | 37.779689150174704 | -122.43154957445299 | (37.7796891501747, -122.431549574453) | |||
| 1484 | 1484 | 233542 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 660 Clipper St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001023.66433 | 2100904.7757200003 | 37.748741823193 | -122.439250743354 | (37.748741823193, -122.439250743354) | |
| 1487 | 1487 | 233540 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 660 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001114.06108 | 2100904.6606 | 37.748746650735505 | -122.438938144387 | (37.7487466507355, -122.438938144387) | |
| 1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 1494 | 1494 | 251576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 1498 | 1498 | 251577 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 490X Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 1502 | 1502 | 223929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 610 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001216.05485 | 2100901.84413 | 37.748744719898 | -122.43858524950599 | (37.748744719898, -122.438585249506) | |
| 1503 | 1503 | 220995 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 610 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001157.49823 | 2100904.8155400003 | 37.748749547471206 | -122.438787950406 | (37.7487495474712, -122.438787950406) | |
| 1509 | 1509 | 233541 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 660 Clipper St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001052.254930001 | 2100904.1832 | 37.748741823188205 | -122.439151834995 | (37.7487418231882, -122.439151834995) | |
| 1513 | 1513 | 251580 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | ||||
| 1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 1540 | 1540 | 251588 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990886.0 | 2105639.0 | 37.7611586563939 | -122.47465184359501 | (37.7611586563939, -122.474651843595) | ||||
| 1541 | 1541 | 196583 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010636.210390001 | 2110621.8756 | 37.7759651028325 | -122.406695151275 | (37.7759651028325, -122.406695151275) | |||
| 1543 | 1543 | 141557 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 524 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000673.0 | 2110815.0 | 37.7759328964671 | -122.44117426506 | (37.7759328964671, -122.44117426506) | |||
| 1545 | 1545 | 142037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1549 | 1549 | 142039 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1550 | 1550 | 142038 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1553 | 1553 | 207056 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | |||
| 1554 | 1554 | 196582 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010641.65206 | 2110616.23142 | 37.7759499096844 | -122.40667592917801 | (37.7759499096844, -122.406675929178) | |||
| 1556 | 1556 | 251583 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995352.0 | 2086409.0 | 37.7086155444167 | -122.45781440192499 | (37.7086155444167, -122.457814401925) | |||||
| 1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
| 1559 | 1559 | 207057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991827.84816 | 2097768.2699700003 | 37.7396022020835 | -122.47082108403099 | (37.7396022020835, -122.470821084031) | |||
| 1560 | 1560 | 210622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | Width 2ft | 5993364.80541 | 2106063.8087299997 | 37.762468389619606 | -122.46610965904699 | (37.7624683896196, -122.466109659047) | ||
| 1567 | 1567 | 251594 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1574 | 1574 | 251596 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1580 | 1580 | 239668 | Undocumented 2 | Butia capitata :: Pindo Palm 149 | 180 Dolores St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 23 | Width 4ft | 6004776.3298 | 2107329.36682 | 37.766595069134105 | -122.426731495165 | (37.7665950691341, -122.426731495165) | |||
| 1583 | 1583 | 251593 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1592 | 1592 | 251595 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1595 | 1595 | 251591 | Undocumented 2 | Leptospermum quinquenervia :: Tea Tree 151 | 1670 Owens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014197.0 | 2107586.0 | 37.7678278475322 | -122.39416476730699 | (37.7678278475322, -122.394164767307) | ||||
| 1600 | 1600 | 251625 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1605 | 1605 | 251634 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1613 | 1613 | 251616 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1618 | 1618 | 251611 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 1619 | 1619 | 251617 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1624 | 1624 | 251624 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1625 | 1625 | 251623 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1626 | 1626 | 251635 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999176.0 | 2100050.0 | 37.746289501198795 | -122.445578473632 | (37.7462895011988, -122.445578473632) | |||||
| 1627 | 1627 | 101897 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1030 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 769674 | 6008181.44725 | 2116041.89613 | 37.7907095228698 | -122.415570672075 | (37.7907095228698, -122.415570672075) | ||
| 1633 | 1633 | 251599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 740 Moraga St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992006.0 | 2103899.0 | 37.756445907456396 | -122.470651540396 | (37.7564459074564, -122.470651540396) | ||||
| 1635 | 1635 | 251542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Vista Ln | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 780127 | 5999350.0 | 2102347.0 | 37.752606437592604 | -122.445141915929 | (37.7526064375926, -122.445141915929) | ||||
| 1638 | 1638 | 251620 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1639 | 1639 | 251615 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1640 | 1640 | 251622 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) |
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");