trees
8,298 rows where qLegalStatus_id = 4 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45084 | 110421 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 39 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011494 | 2097294 | 37.7394176654516 | -122.402790273501 | (37.7394176654516, -122.402790273501) | 10 | 3 | 8 | 58 | 1 | ||||
| 45500 | 112852 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
| 46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 46286 | 111319 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 48483 | 110384 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2280 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24x18 | 6011419 | 2097963 | 37.7412504087772 | -122.403096636858 | (37.7412504087772, -122.403096636858) | 10 | 3 | 8 | 58 | 1 | ||||
| 49569 | 195005 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016499.64724 | 2096292.33943 | 37.7369455301091 | -122.385412999906 | (37.7369455301091, -122.385412999906) | 10 | 3 | 8 | 58 | 1 | |||
| 49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
| 50880 | 107396 | Undocumented 4 | Tree(s) :: 17 | 499X PHELPS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
| 51154 | 97433 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
| 51401 | 107045 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1622X MCKINNON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015259 | 2096017 | 37.7361207862805 | -122.389683281146 | (37.7361207862805, -122.389683281146) | 10 | 3 | 8 | 58 | 1 | |||
| 52334 | 108743 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 120x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 52863 | 113177 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 53916 | 93764 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 55222 | 111656 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1740 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 6014066 | 2101066 | 37.7499180589901 | -122.394161367931 | (37.7499180589901, -122.394161367931) | 10 | 3 | 8 | 58 | 1 | |||
| 55425 | 112845 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
| 55820 | 93765 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 56624 | 93755 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 59108 | 109457 | Undocumented 4 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 951 GILMAN AVE | 43 | Front Yard : Yard | Tree | Rec/Park 5 | 23 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||||
| 59753 | 104427 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1000x GILMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6015570 | 2089525 | 37.71831228448 | -122.3881550967 | (37.71831228448, -122.3881550967) | 10 | 3 | 8 | 58 | 1 | |||
| 59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 60045 | 256037 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1555 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x3 | 6015125 | 2093955 | 37.7304515202688 | -122.390002579169 | (37.7304515202688, -122.390002579169) | 10 | 3 | 8 | 58 | 1 | |||
| 60646 | 116182 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
| 60999 | 194761 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 900 Quint St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6014176.55403 | 2097659.59689 | 37.7405709356069 | -122.393540690348 | (37.7405709356069, -122.393540690348) | 10 | 3 | 8 | 58 | 1 | |||
| 61524 | 93759 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 61959 | 254462 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 56 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 63327 | 191576 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 10 | : | Tree | Private 2 | 3 | Width 4ft | 6015473.23648 | 2098286.93961 | 37.7423654535913 | -122.389101016203 | (37.7423654535913, -122.389101016203) | 10 | 3 | 8 | 58 | 1 | |||
| 63362 | 114791 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100x GILLETTE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
| 64253 | 114443 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 65570 | 255182 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Ingalls St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018024 | 2094000 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | 10 | 3 | 8 | 58 | 1 | ||||
| 66231 | 113846 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 REVERE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6014548 | 2094736 | 37.7325639703463 | -122.392051962294 | (37.7325639703463, -122.392051962294) | 10 | 3 | 8 | 58 | 1 | ||||
| 66685 | 198701 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1200 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017953.40415 | 2093964.00554 | 37.7306327066323 | -122.380224903656 | (37.7306327066323, -122.380224903656) | 10 | 3 | 8 | 58 | 1 | |||
| 67748 | 254409 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
| 69625 | 102708 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 999X PHELPS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744 | 2097272 | 37.7395381878784 | -122.391551574015 | (37.7395381878784, -122.391551574015) | 10 | 3 | 8 | 58 | 1 | |
| 70005 | 116118 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x NEWHALL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | 6013898 | 2095214 | 37.7338403506101 | -122.394332641739 | (37.7338403506101, -122.394332641739) | 10 | 3 | 8 | 58 | 1 | ||
| 70011 | 113178 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 70529 | 200821 | Undocumented 4 | Tristania conferta :: 61 | 5210 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014424.8043 | 2093925.5984 | 37.7303319313757 | -122.392421219379 | (37.7303319313757, -122.392421219379) | 10 | 3 | 8 | 58 | 1 | |||
| 71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
| 72219 | 113170 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
| 73180 | 111309 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 100x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015178 | 2088529 | 37.7155557353625 | -122.389440569451 | (37.7155557353625, -122.389440569451) | 10 | 3 | 8 | 58 | 1 | ||||
| 73281 | 111318 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 73464 | 116134 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 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 | ||
| 76045 | 110426 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 90 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011326 | 2097433 | 37.7397899480097 | -122.403380922944 | (37.7397899480097, -122.403380922944) | 10 | 3 | 8 | 58 | 1 | ||||
| 76134 | 109289 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011707.98734 | 2087352.96474 | 37.7121335759116 | -122.401351970141 | (37.7121335759116, -122.401351970141) | 10 | 3 | 8 | 309 | 1 | |||||
| 76585 | 116562 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
| 76740 | 108752 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 77597 | 200340 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 23 | : | Tree | Private 2 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.389683204014 | (37.7417134289277, -122.389683204014) | 10 | 3 | 8 | 58 | 1 | |||
| 78151 | 106555 | Undocumented 4 | Tree(s) :: 17 | 495X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012736.59297 | 2087029.1616 | 37.711301812416 | -122.397774087156 | (37.711301812416, -122.397774087156) | 10 | 3 | 8 | 309 | 1 | |||
| 79868 | 110425 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 81 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011518 | 2097294 | 37.7394190054764 | -122.402707291584 | (37.7394190054764, -122.402707291584) | 10 | 3 | 8 | 58 | 1 | ||||
| 79983 | 254630 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||||
| 80694 | 195220 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Phelps St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6015550.34718 | 2098396.81359 | 37.7426714191664 | -122.388842057332 | (37.7426714191664, -122.388842057332) | 10 | 3 | 8 | 58 | 1 | ||||
| 81971 | 80519 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 82563 | 104649 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | 10 | 3 | 8 | 309 | 1 | |||||
| 83572 | 119911 | Undocumented 4 | Tree(s) :: 17 | 67 Rebecca Ln | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6017125 | 2096711 | 37.7381296664541 | -122.383279988851 | (37.7381296664541, -122.383279988851) | 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 | ||
| 84748 | 103998 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 84868 | 108751 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 85230 | 110424 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 65 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011494 | 2097294 | 37.7394176654516 | -122.402790273501 | (37.7394176654516, -122.402790273501) | 10 | 3 | 8 | 58 | 1 | ||||
| 85278 | 101315 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 60 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011155 | 2096548 | 37.7373503742221 | -122.403909910739 | (37.7373503742221, -122.403909910739) | 10 | 3 | 8 | 58 | 1 | ||||
| 86119 | 111312 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
| 86958 | 112623 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6012539 | 2087662 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | 10 | 3 | 8 | 309 | 1 | ||||
| 87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 87310 | 97046 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X SHAFTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014988 | 2094146 | 37.7309683687499 | -122.390489552503 | (37.7309683687499, -122.390489552503) | 10 | 3 | 8 | 58 | 1 | |||
| 87340 | 113172 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 88998 | 97048 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | 10 | 3 | 8 | 58 | 1 | |||
| 89537 | 111311 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
| 89965 | 116128 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 90453 | 254461 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 55 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 90740 | 112843 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1415 EVANS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016481 | 2097724 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | 10 | 3 | 8 | 58 | 1 | |||||
| 90877 | 116171 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
| 91025 | 93754 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 91138 | 114442 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 91873 | 108742 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 92463 | 111565 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 92632 | 111660 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1740 CESAR CHAVEZ ST | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 6014066 | 2101066 | 37.7499180589901 | -122.394161367931 | (37.7499180589901, -122.394161367931) | 10 | 3 | 8 | 58 | 1 | |||
| 92814 | 103995 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 93001 | 115142 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 93467 | 116133 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 93965 | 116189 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1751 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6013485 | 2092424 | 37.7261566141218 | -122.395565112125 | (37.7261566141218, -122.395565112125) | 10 | 3 | 8 | 58 | 1 | |||
| 94518 | 191575 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6015519.38239 | 2098345.71066 | 37.7425293847338 | -122.388945558515 | (37.7425293847338, -122.388945558515) | 10 | 3 | 8 | 58 | 1 | |||
| 95331 | 111566 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 95365 | 112846 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
| 95949 | 258389 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1995 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013601 | 2099985 | 37.74692400616 | -122.395693639953 | (37.74692400616, -122.395693639953) | 10 | 3 | 8 | 58 | 1 | ||||
| 96184 | 107386 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6011510 | 2087367 | 37.712161065506 | -122.402037262127 | (37.712161065506, -122.402037262127) | 10 | 3 | 8 | 309 | 1 | |||
| 97745 | 104425 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101x WHITNEY YOUNG CIR | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6016394 | 2096049 | 37.7362715234519 | -122.385761317359 | (37.7362715234519, -122.385761317359) | 10 | 3 | 8 | 58 | 1 | |||
| 97996 | 116136 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 98985 | 116168 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
| 99078 | 108747 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 140x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 99511 | 114445 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 100133 | 116555 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
| 100672 | 116561 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
| 101697 | 255715 | Undocumented 4 | Prunus armeniaca :: Apricot 296 | 937x Meade Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
| 101852 | 116567 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
| 101910 | 103408 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 102400 | 254464 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 58 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 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) );