trees
27,746 rows where qCaretaker_id = 1 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193851 | 4405 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.427774340913 | (37.7540702011025, -122.427774340913) | 2 | 4 | 5 | 28862 | 22 | ||
| 193847 | 7630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.413365122515 | (37.7460702755308, -122.413365122515) | 2 | 7 | 7 | 28859 | 2 | |||
| 193830 | 221480 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.77804 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | 8 | 4 | 5 | 28859 | 19 | ||
| 193816 | 226 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | 1 | 8 | 4 | 64 | 35 | |||
| 193809 | 109820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
| 193806 | 199575 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 25 | Median : Yard | Tree | DPW 1 | 27 | 6012270.74731 | 2102100.89416 | 37.7526597061983 | -122.400442161487 | (37.7526597061983, -122.400442161487) | 10 | 3 | 8 | 28856 | 29 | ||||
| 193789 | 30049 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1400X Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 193780 | 11487 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018880.35523 | 2097308.40588 | 37.7398668752499 | -122.37725221891 | (37.7398668752499, -122.37725221891) | 10 | 3 | 8 | 58 | 1 | |||
| 193779 | 4461 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1451 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004572.77209 | 2100404.42204 | 37.7475692915908 | -122.426942314243 | (37.7475692915908, -122.426942314243) | 2 | 7 | 5 | 63 | 22 | |||
| 193770 | 24003 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 307 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3x3 | 5992304.2356 | 2097084.7947 | 37.7377530904378 | -122.469124226279 | (37.7377530904378, -122.469124226279) | 1 | 8 | 4 | 59 | 40 | |||
| 193767 | 251050 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 5800x Geary Blvd | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 5988878.2157 | 2112618.8979 | 37.7802069893248 | -122.482107186669 | (37.7802069893248, -122.482107186669) | 11 | 6 | 2 | 55 | 26 | |||
| 193747 | 86057 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1559 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987436.4387 | 2104667.1333 | 37.7582896916438 | -122.486510886694 | (37.7582896916438, -122.486510886694) | 1 | 8 | 3 | 56 | 35 | ||
| 193746 | 229517 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 5 | Width 3ft | 6004438.06736 | 2101723.80119 | 37.7511843827583 | -122.427502095471 | (37.7511843827583, -122.427502095471) | 2 | 4 | 5 | 28862 | 22 | ||
| 193744 | 23969 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 98 West Portal Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5992949.0597 | 2097865.5443 | 37.7399340705835 | -122.466951520918 | (37.7399340705835, -122.466951520918) | 1 | 8 | 4 | 59 | 40 | |||
| 193733 | 86508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1304 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987730.517605 | 2106398.207322 | 37.7630598861076 | -122.485620887193 | (37.7630598861076, -122.485620887193) | 1 | 8 | 3 | 56 | 35 | ||
| 193729 | 119871 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 193725 | 8040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005219.6402 | 2111621.59299 | 37.7784055377786 | -122.425503660502 | (37.7784055377786, -122.425503660502) | 7 | 9 | 11 | 28852 | 10 | ||
| 193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 193704 | 88452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | 5 | 1 | 1 | 28858 | 17 | ||
| 193689 | 20677 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 31 | Median : Cutout | Tree | DPW 1 | 50 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | ||||
| 193677 | 19310 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 375 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6010658.6989499 | 2110585.1273498 | 37.7758654588782 | -122.406614766861 | (37.7758654588782, -122.406614766861) | 14 | 2 | 9 | 28853 | 34 | |||
| 193658 | 5460 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 595 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/2017 12:00:00 AM | 3 | 3X3 | 6005000.81386 | 2104899.04779 | 37.7599346801473 | -122.425782040418 | (37.7599346801473, -122.425782040418) | 2 | 4 | 5 | 28859 | 19 | ||
| 193657 | 19401 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 400X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
| 193653 | 124177 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
| 193638 | 1503 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 345 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995510.44866 | 2113974.84382 | 37.7843135680421 | -122.459261623975 | (37.7843135680421, -122.459261623975) | 11 | 6 | 2 | 54 | 11 | |||
| 193636 | 4520 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 37X Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005067.314179 | 2113761.703735 | 37.784273146185 | -122.42618301414 | (37.784273146185, -122.42618301414) | 13 | 9 | 11 | 28858 | 41 | |||
| 193633 | 19388 | DPW Maintained 1 | Eucalyptus lehmanni :: Bushy Yate 260 | 100X Sloat Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5991082.2835044 | 2096052.6376293 | 37.7348483670999 | -122.473273805701 | (37.7348483670999, -122.473273805701) | 1 | 8 | 4 | 29491 | 40 | |||
| 193625 | 255507 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
| 193606 | 14074 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007538.3610866 | 2110874.6036795 | 37.7764852227054 | -122.417429363009 | (37.7764852227054, -122.417429363009) | 8 | 2 | 9 | 28853 | 34 | |||
| 193604 | 20175 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002842.186 | 2112511.508 | 37.7807144047359 | -122.433791779426 | (37.7807144047359, -122.433791779426) | 15 | 9 | 11 | 29490 | 41 | ||
| 193594 | 256211 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 193586 | 6608 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400X Evans Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016747.6410828 | 2097755.6169144 | 37.7409771122017 | -122.384657465748 | (37.7409771122017, -122.384657465748) | 10 | 3 | 8 | 58 | 1 | ||
| 193583 | 86511 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1260 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/2012 12:00:00 AM | 3 | 3x3 | 5987724.7376 | 2106723.0542 | 37.7639514896809 | -122.485664720175 | (37.7639514896809, -122.485664720175) | 1 | 8 | 3 | 56 | 35 | ||
| 193582 | 13645 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 590 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6012116.841628 | 2115339.7303771 | 37.7890019643739 | -122.401904951476 | (37.7890019643739, -122.401904951476) | 4 | 2 | 10 | 28854 | 6 | |||
| 193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
| 193554 | 86441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | 1 | 8 | 3 | 29491 | 35 | ||
| 193546 | 102510 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1700X Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
| 193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 193544 | 6946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 566 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x4 | 6004669.16029 | 2110552.41632 | 37.7754387224635 | -122.427331794438 | (37.7754387224635, -122.427331794438) | 7 | 9 | 11 | 28852 | 10 | |||
| 193530 | 2294 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990137.07953 | 2088614.48643 | 37.7143702930322 | -122.475998609661 | (37.7143702930322, -122.475998609661) | 1 | 8 | 4 | 64 | 14 | |||
| 193523 | 23584 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/25/1990 12:00:00 AM | 18 | 3X3 | 6005448.93118 | 2121362.59765 | 37.8051648419518 | -122.425403847517 | (37.8051648419518, -122.425403847517) | 13 | 1 | 1 | 28858 | 17 | ||
| 193522 | 13279 | DPW Maintained 1 | Tristania conferta :: 61 | 2525 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2008 12:00:00 AM | 6 | 3X3 | 6000265.7268 | 2119165.2172 | 37.7988372159853 | -122.443182983285 | (37.7988372159853, -122.443182983285) | 13 | 9 | 1 | 57 | 17 | ||
| 193507 | 4387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001708.3008261 | 2095817.8256998 | 37.7348131857142 | -122.436519230882 | (37.7348131857142, -122.436519230882) | 2 | 7 | 5 | 63 | 7 | |||
| 193505 | 91666 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
| 193494 | 4256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4082 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003396.98562 | 2100411.62921 | 37.7475225268465 | -122.431008624962 | (37.7475225268465, -122.431008624962) | 2 | 4 | 5 | 63 | 22 | |||
| 193493 | 24949 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2546 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/25/1995 12:00:00 AM | 8 | 3x3 | 6015784.41472 | 2103697.39561 | 37.7572386805017 | -122.388402594091 | (37.7572386805017, -122.388402594091) | 10 | 3 | 8 | 28856 | 29 | ||
| 193491 | 5510 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 811 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X5 | 6005073.33558 | 2103604.24932 | 37.7563835658713 | -122.425439076749 | (37.7563835658713, -122.425439076749) | 2 | 4 | 5 | 28859 | 19 | |||
| 193489 | 1778 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 2001X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | |||
| 193487 | 13912 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1072 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/1991 12:00:00 AM | 12 | 4x4 | 6009268.88359 | 2112623.24078 | 37.7813837816878 | -122.411566544068 | (37.7813837816878, -122.411566544068) | 14 | 2 | 9 | 28852 | 36 | ||
| 193478 | 21762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | |||
| 193472 | 230151 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004293.81892 | 2105454.00937 | 37.7614184949793 | -122.42826674582 | (37.7614184949793, -122.42826674582) | 8 | 4 | 5 | 28862 | 3 | |||
| 193458 | 110773 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:06:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 193437 | 233637 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 758x San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.7427248694691 | -122.423117200821 | (37.7427248694691, -122.423117200821) | 2 | 7 | 7 | 28859 | 2 | |||
| 193433 | 178034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1378x Geneva Ave | 2 | Median : Yard | Tree | DPW 1 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | 9 | 7 | 6 | 28861 | 5 | ||||
| 193426 | 10214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | 2 | 4 | 5 | 28859 | 19 | |||
| 193415 | 91972 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1340 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993348.371695 | 2106356.020653 | 37.7632697788308 | -122.466187733171 | (37.7632697788308, -122.466187733171) | 1 | 8 | 11 | 56 | 12 | ||
| 193412 | 29177 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3201X Ortega St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984120.341494 | 2102212.6107977 | 37.7513563962435 | -122.497797988224 | (37.7513563962435, -122.497797988224) | 1 | 8 | 3 | 29491 | 35 | ||
| 193400 | 90612 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2800X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5986872.6923 | 2110514.01864 | 37.7743107369841 | -122.488890344657 | (37.7743107369841, -122.488890344657) | 11 | 6 | 2 | 55 | 26 | ||
| 193392 | 20816 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1792X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
| 193380 | 28215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 193379 | 107543 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||
| 193375 | 23979 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 103 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 5992943.4645 | 2097737.8921 | 37.7395832468442 | -122.466961588709 | (37.7395832468442, -122.466961588709) | 1 | 8 | 4 | 59 | 40 | |||
| 193372 | 85693 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 474 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013649 | 2112678 | 37.7817788567242 | -122.396417203711 | (37.7817788567242, -122.396417203711) | 6 | 2 | 9 | 28856 | 34 | ||
| 193366 | 33475 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432 | 2098629 | 37.7427993369958 | -122.420387207052 | (37.7427993369958, -122.420387207052) | 2 | 7 | 7 | 28859 | 2 | ||
| 193360 | 4815 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 36 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005920.04886 | 2097862.788 | 37.7406666288593 | -122.422102970598 | (37.7406666288593, -122.422102970598) | 2 | 7 | 7 | 28859 | 2 | |||
| 193354 | 15210 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1142 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1995 12:00:00 AM | 12 | 3X3 | 6009135.951727 | 2111577.9227488 | 37.7785061292027 | -122.411952533595 | (37.7785061292027, -122.411952533595) | 8 | 2 | 9 | 28853 | 34 | ||
| 193351 | 90346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1351X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991366.65333 | 2111298.67818 | 37.7767264470425 | -122.473402303093 | (37.7767264470425, -122.473402303093) | 11 | 6 | 2 | 54 | 26 | ||
| 193344 | 13225 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | 13 | 9 | 1 | 57 | 17 | |||
| 193331 | 20759 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
| 193317 | 8897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
| 193297 | 194313 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | 12 | 2 | 9 | 28855 | 6 | |||
| 193251 | 173722 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 928 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 17 | 3x3 | 6012423 | 2103596 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | 10 | 3 | 8 | 28856 | 29 | |||
| 193248 | 85830 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
| 193242 | 23510 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2642 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/2011 12:00:00 AM | 3 | 3x3 | 6005784.53282 | 2119453.21557 | 37.799941123039 | -122.424106583651 | (37.799941123039, -122.424106583651) | 13 | 9 | 1 | 28858 | 32 | ||
| 193236 | 14189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1859 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005466.0919 | 2108863.1381 | 37.7708454112193 | -122.424454833335 | (37.7708454112193, -122.424454833335) | 8 | 2 | 5 | 28853 | 19 | |||
| 193227 | 111275 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 700X BOSWORTH ST | 13 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 193218 | 4054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/1999 12:00:00 AM | 3 | 3X3 | 6009770.62771 | 2100537.88813 | 37.7482282977114 | -122.408977781708 | (37.7482282977114, -122.408977781708) | 2 | 4 | 7 | 28859 | 2 | ||
| 193210 | 11297 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
| 193203 | 28327 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3435 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2004 12:00:00 AM | 3 | 3x3 | 6005943.50429 | 2098256.08104 | 37.7417478459244 | -122.422049803265 | (37.7417478459244, -122.422049803265) | 2 | 7 | 7 | 28859 | 2 | ||
| 193199 | 121757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 20 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 193191 | 138110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004839.6037 | 2114746.6136 | 37.7869645899648 | -122.427040986298 | (37.7869645899648, -122.427040986298) | 13 | 9 | 11 | 28858 | 27 | |||
| 193189 | 15426 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) | 8 | 4 | 7 | 28859 | 19 | |||
| 193167 | 96143 | DPW Maintained 1 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.386411945382 | (37.738179827823, -122.386411945382) | 10 | 3 | 8 | 58 | 1 | ||||
| 193153 | 8987 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2000 12:00:00 AM | 3 | 6x6 | 5991034.7169 | 2112750.4859 | 37.7806934847588 | -122.474656542364 | (37.7806934847588, -122.474656542364) | 11 | 6 | 2 | 54 | 26 | ||
| 193151 | 20851 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1892X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 193145 | 5074 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.437054001757 | (37.73828941133, -122.437054001757) | 2 | 7 | 5 | 63 | 7 | |||
| 193134 | 194316 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 7ft | 6014969.23068 | 2116866.26037 | 37.7933522391693 | -122.392142782374 | (37.7933522391693, -122.392142782374) | 12 | 2 | 9 | 28855 | 6 | |||
| 193106 | 11097 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1930 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007278.45191 | 2119022.53652 | 37.7988428206086 | -122.418906485047 | (37.7988428206086, -122.418906485047) | 5 | 1 | 10 | 28858 | 32 | |||
| 193105 | 2055 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X Bosworth St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1992 12:00:00 AM | 12 | 3X3 | 6002096.95921 | 2095378.98206 | 37.7336302998954 | -122.435144128606 | (37.7336302998954, -122.435144128606) | 9 | 7 | 5 | 63 | 40 | ||
| 193101 | 18583 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 200 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993482.9987854 | 2088541.1278419 | 37.7143623091404 | -122.464428558674 | (37.7143623091404, -122.464428558674) | 9 | 8 | 6 | 64 | 24 | ||
| 193094 | 21415 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2692X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
| 193092 | 23606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 193085 | 1417 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X5 | 5995446.00012 | 2115789.30403 | 37.7892918808868 | -122.459616055153 | (37.7892918808868, -122.459616055153) | 11 | 6 | 1 | 54 | 11 | |||
| 193081 | 173746 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 193072 | 10119 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | 2 | 4 | 5 | 28859 | 19 | ||
| 193064 | 180043 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900x Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 6000932.74205 | 2090913.38517 | 37.7213026154097 | -122.438849257207 | (37.7213026154097, -122.438849257207) | 9 | 7 | 6 | 28861 | 25 | |||
| 193061 | 21109 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
| 193050 | 112539 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | 3 | 1 | 10 | 308 | 23 | ||
| 193042 | 7738 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 325 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2011 12:00:00 AM | 1 | 3x3 | 6006374.72821 | 2111215.69184 | 37.7773562281519 | -122.421478937302 | (37.7773562281519, -122.421478937302) | 7 | 9 | 11 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );