trees
194,517 rows sorted by qCaretaker_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174979 | 233404 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2997 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Cleary Bros. Landscape 22 | 5 | Width 3ft | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
| 50117 | 12913 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | 7 | 9 | 9 | 28852 | 36 | |||
| 58683 | 12911 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | 60 | 3X3 | 6007775.55734 | 2112148.54769 | 37.779996510859 | -122.416699101796 | (37.779996510859, -122.416699101796) | 7 | 9 | 9 | 28852 | 36 | |||
| 135817 | 105173 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | Arts Commission | 13 | 4x4 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | |
| 148146 | 12910 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | 60 | 3X3 | 6007779.43261 | 2112129.0051 | 37.7799430695601 | -122.416684310636 | (37.7799430695601, -122.416684310636) | 7 | 9 | 9 | 28852 | 36 | |||
| 149009 | 12909 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | 50 | 3X3 | 6007780.30496 | 2112111.95724 | 37.779896309296 | -122.41668008474 | (37.779896309296, -122.41668008474) | 7 | 9 | 9 | 28852 | 36 | |||
| 182938 | 12912 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | 50 | 3X3 | 6007764.05578 | 2112272.85999 | 37.7803371956541 | -122.41674770026 | (37.7803371956541, -122.41674770026) | 7 | 9 | 9 | 28852 | 36 | |||
| 33085 | 14533 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 49983 | 110536 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 4 | Sidewalk: Curb side : Cutout | Tree | City College 20 | Private | 05/29/2015 02:12:00 PM | 3 | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |
| 57841 | 14536 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 94799 | 14535 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 116926 | 14539 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 137455 | 14534 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 144726 | 14532 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 154708 | 110535 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout | Tree | City College 20 | Private | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |
| 161727 | 14538 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 166912 | 14537 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 70 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 167050 | 14531 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
| 15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
| 24698 | 8097 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.4292179278 | (37.7780693729621, -122.4292179278) | 7 | 9 | 11 | 28852 | 41 | ||
| 29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
| 48629 | 105164 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 15 | 5x5 | 6014842.39521 | 2095664.68421 | 37.735130289038 | -122.391099047201 | (37.735130289038, -122.391099047201) | 10 | 3 | 8 | 58 | 1 | |||
| 52126 | 22281 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
| 57045 | 105169 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 3 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 4x4 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
| 60470 | 8094 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | 7 | 9 | 11 | 28852 | 41 | |||
| 75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
| 84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
| 87319 | 22283 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 4755X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 88357 | 8090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | 7 | 9 | 11 | 28852 | 41 | ||
| 89603 | 26011 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1618X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/02/1998 12:00:00 AM | 6 | 3X3 | 6014975.06835 | 2095558.90554 | 37.7348472038217 | -122.390632955135 | (37.7348472038217, -122.390632955135) | 10 | 3 | 8 | 58 | 1 | ||
| 91890 | 22277 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 93143 | 22280 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 101451 | 105175 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.7352873542424 | -122.390027366589 | (37.7352873542424, -122.390027366589) | 10 | 3 | 8 | 58 | 1 | |||
| 103033 | 105163 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1600X OAKDALE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 17 | 4x4 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | ||
| 122917 | 22284 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 4755X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3x3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 130535 | 105165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1600X OAKDALE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 16 | 3x3 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
| 133384 | 105167 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 1 | Front Yard : Cutout | Tree | Arts Commission 19 | 8 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
| 142553 | 8096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 7 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004110.3708 | 2111520.4613 | 37.7780651171853 | -122.429333825297 | (37.7780651171853, -122.429333825297) | 7 | 9 | 11 | 28852 | 41 | ||
| 146144 | 105171 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 4755X 03RD ST | 5 | Front Yard : Yard | Tree | Arts Commission 19 | 14 | 4x4 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
| 149337 | 8095 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.77807126806 | -122.429267592872 | (37.77807126806, -122.429267592872) | 7 | 9 | 11 | 28852 | 41 | ||
| 149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
| 151905 | 22278 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
| 164164 | 105170 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 4755X 03RD ST | 4 | Front Yard : Cutout | Tree | Arts Commission 19 | 2 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
| 168475 | 8092 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | 7 | 9 | 11 | 28852 | 41 | ||
| 170027 | 22282 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 4 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
| 174039 | 22279 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
| 179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
| 185160 | 8091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.428620825565 | (37.7781664691559, -122.428620825565) | 7 | 9 | 11 | 28852 | 41 | ||
| 191133 | 26012 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1618X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/02/1998 12:00:00 AM | 3 | 3X3 | 6015044.019 | 2095518.8416 | 37.7347410214535 | -122.390391768412 | (37.7347410214535, -122.390391768412) | 10 | 3 | 8 | 58 | 1 | ||
| 11205 | 17641 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 19804 | 29809 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 19975 | 29822 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 24613 | 6699 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 24791 | 29820 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 25279 | 6695 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 26979 | 29831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 29038 | 86623 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010870.62173 | 2109748.7492 | 37.7735808121462 | -122.405822739627 | (37.7735808121462, -122.405822739627) | 14 | 2 | 9 | 28853 | 34 | ||
| 31612 | 29821 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 35348 | 17631 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | ||
| 35988 | 17646 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 38193 | 6703 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 38581 | 29817 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 41584 | 29827 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 41932 | 29823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 43501 | 17638 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 48269 | 29808 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 54027 | 86813 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 54518 | 200335 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 7 | : | Tree | Purchasing Dept 18 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | 10 | 3 | 8 | 58 | 1 | |||
| 55826 | 86803 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 12 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 55872 | 86805 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 56423 | 29810 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 57188 | 28729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 60255 | 29807 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 68696 | 86625 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010895.2675 | 2109773.10415 | 37.7736490634866 | -122.405739201611 | (37.7736490634866, -122.405739201611) | 14 | 2 | 9 | 28853 | 34 | ||
| 71834 | 17642 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 72377 | 17649 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 72416 | 29816 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 74365 | 17636 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 75159 | 86806 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 75374 | 29812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 78700 | 86807 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 78949 | 29814 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 79754 | 86812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/26/2012 02:00:00 PM | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 81099 | 6689 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 81581 | 17650 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 84528 | 17645 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 89345 | 17639 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 94190 | 6693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 103418 | 17640 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 600X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 105906 | 29804 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 108380 | 17634 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 110210 | 86626 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010925.67942 | 2109801.58517 | 37.7737289664413 | -122.405636007996 | (37.7737289664413, -122.405636007996) | 14 | 2 | 9 | 28853 | 34 | ||
| 110822 | 17654 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 111628 | 29815 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 113550 | 29819 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 116439 | 17643 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 122158 | 17651 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 123510 | 29813 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 124098 | 29825 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 126907 | 6688 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 |
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) );