trees
8,298 rows where qLegalStatus_id = 4 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
323 | 106136 | Undocumented 4 | Tree(s) :: 17 | 200X RIDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996801 | 2094865 | 37.7319168756422 | -122.453416604011 | (37.7319168756422, -122.453416604011) | 9 | 7 | 4 | 59 | 40 | ||||
392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
434 | 102445 | Undocumented 4 | Tree(s) :: 17 | 900 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001563.3 | 2088855.6 | 37.7156882523244 | -122.436522388875 | (37.7156882523244, -122.436522388875) | 9 | 7 | 6 | 28861 | 5 | |||
506 | 264804 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
1111 | 99485 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
1152 | 259051 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 25 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000711 | 2094308 | 37.7306108324003 | -122.439859019702 | (37.7306108324003, -122.439859019702) | 9 | 7 | 4 | 63 | 40 | ||||
1523 | 260685 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
1769 | 251583 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 75 Rice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1995 12:00:00 AM | 3x3 | 5995352 | 2086409 | 37.7086155444167 | -122.457814401925 | (37.7086155444167, -122.457814401925) | 9 | 7 | 6 | 28861 | 25 | |||
1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
2023 | 264805 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
2670 | 262494 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 41 Miraloma Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994945 | 2097531 | 37.7391304944698 | -122.4600262078 | (37.7391304944698, -122.4600262078) | 9 | 7 | 4 | 59 | 40 | ||||
2991 | 99574 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
3310 | 175373 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991419.90979 | 2088711.03664 | 37.714709696259 | -122.47157171488 | (37.714709696259, -122.47157171488) | 9 | 8 | 6 | 64 | 24 | |||
3347 | 121153 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 50X Trumbull St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778630 | 6003754 | 2094198 | 37.7304815449788 | -122.429331070998 | (37.7304815449788, -122.429331070998) | 9 | 7 | 6 | 28861 | 5 | |||
3697 | 114907 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 248 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994525 | 2088748 | 37.7149903414399 | -122.460842000428 | (37.7149903414399, -122.460842000428) | 9 | 8 | 6 | 28861 | 24 | |||
3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
5017 | 262484 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 2 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
5267 | 121644 | Undocumented 4 | Tree(s) :: 17 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 2x4 | Permit Number 779268 | 5997955 | 2098188 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | 9 | 7 | 4 | 59 | 40 | |
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
6533 | 258833 | Undocumented 4 | Potential Site :: Potential Site 48 | 1199X Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996025 | 2091881 | 37.7236790151497 | -122.455883747529 | (37.7236790151497, -122.455883747529) | 9 | 8 | 4 | 28861 | 24 | ||||
7079 | 120113 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 266 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999649 | 2094406 | 37.7308194078275 | -122.443537538611 | (37.7308194078275, -122.443537538611) | 9 | 7 | 4 | 63 | 40 | ||||
7275 | 261458 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
7333 | 262326 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 10 Roemer Way | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998623 | 2086576 | 37.7092614661016 | -122.446521459005 | (37.7092614661016, -122.446521459005) | 9 | 7 | 6 | 28861 | 5 | |||||
7565 | 121637 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 298x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000311 | 2091736 | 37.7235259352509 | -122.441057424661 | (37.7235259352509, -122.441057424661) | 9 | 7 | 6 | 28861 | 25 | ||||
7598 | 114708 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | 6000185 | 2095264 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | 9 | 7 | 5 | 63 | 40 | ||||
8149 | 99454 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |||
8237 | 260684 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
8318 | 98543 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
8351 | 261505 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 50 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5991584 | 2091622 | 37.7227119804791 | -122.471216515117 | (37.7227119804791, -122.471216515117) | 9 | 8 | 4 | 59 | 40 | ||||
8380 | 118286 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 199X JULES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 3x3 | 5994418 | 2091201 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | 9 | 8 | 6 | 28861 | 24 | |||
8489 | 260833 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 30 Paloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992351 | 2093917 | 37.7290578205122 | -122.468732100912 | (37.7290578205122, -122.468732100912) | 9 | 8 | 4 | 59 | 40 | ||||
8669 | 262474 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
8859 | 118364 | Undocumented 4 | Magnolia x soulangiana :: Saucer Magnolia 147 | 226 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5991730 | 2090049 | 37.7184013526744 | -122.470597317131 | (37.7184013526744, -122.470597317131) | 9 | 8 | 6 | 64 | 24 | |||
8887 | 261586 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 20 Aptos Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5993103 | 2094790 | 37.7314982775013 | -122.466195816439 | (37.7314982775013, -122.466195816439) | 9 | 8 | 4 | 59 | 40 | |||||
9144 | 254818 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
9195 | 106155 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 174 STILLINGS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 3x3 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | 9 | 7 | 4 | 63 | 40 | |||
9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
9763 | 111086 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | 9 | 7 | 4 | 59 | 40 | |||||
10048 | 258883 | Undocumented 4 | Potential Site :: Potential Site 48 | 1198X Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996138 | 2091849 | 37.7235976355668 | -122.455490816534 | (37.7235976355668, -122.455490816534) | 9 | 8 | 4 | 28861 | 24 | ||||
10239 | 117493 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 156 DORADO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994380 | 2093088 | 37.7268985955584 | -122.461657658843 | (37.7268985955584, -122.461657658843) | 9 | 8 | 4 | 28861 | 40 | ||||
10330 | 260835 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Paloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992413 | 2094015 | 37.7293304857774 | -122.468524891335 | (37.7293304857774, -122.468524891335) | 9 | 8 | 4 | 59 | 40 | ||||
10523 | 262206 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000738 | 2088975 | 37.7159691653279 | -122.439383549479 | (37.7159691653279, -122.439383549479) | 9 | 7 | 6 | 28861 | 5 | ||||
11113 | 107054 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6003385 | 2094496 | 37.7312788881427 | -122.43062801307 | (37.7312788881427, -122.43062801307) | 9 | 7 | 5 | 28861 | 25 | |||
11463 | 260828 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 165 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | ||||
11763 | 108805 | Undocumented 4 | :: 45 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
11769 | 111367 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 20 MELROSE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5999966 | 2095537 | 37.7339429435496 | -122.442522793498 | (37.7339429435496, -122.442522793498) | 9 | 7 | 4 | 63 | 40 | |||
11776 | 108812 | Undocumented 4 | :: 45 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
12051 | 106705 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5996224 | 2090880 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | 9 | 8 | 6 | 28861 | 24 | ||||
12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
12393 | 261459 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
12482 | 177894 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.7153972189891 | -122.406185898468 | (37.7153972189891, -122.406185898468) | 9 | 7 | 8 | 309 | 39 | |||
12759 | 113115 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
12772 | 111858 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
13253 | 260510 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 177 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990921 | 2091320 | 37.7218443909369 | -122.473486322075 | (37.7218443909369, -122.473486322075) | 9 | 8 | 4 | 64 | 40 | ||||
13310 | 263635 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5998173 | 2095582 | 37.733964136305 | -122.448724954929 | (37.733964136305, -122.448724954929) | 9 | 7 | 4 | 59 | 40 | ||||
13349 | 261323 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 278 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993017 | 2089051 | 37.7157354224316 | -122.466076249864 | (37.7157354224316, -122.466076249864) | 9 | 8 | 6 | 64 | 24 | ||||
13774 | 260686 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 120 Moncada Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992223 | 2093041 | 37.7266451461328 | -122.469110873957 | (37.7266451461328, -122.469110873957) | 9 | 8 | 4 | 59 | 40 | ||||
13816 | 99468 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 6 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
13923 | 105374 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 127 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | 5993372.2 | 2093864.2 | 37.7289717869451 | -122.465197927613 | (37.7289717869451, -122.465197927613) | 9 | 8 | 4 | 59 | 40 | |||
14302 | 175030 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010584.6901 | 2086918.22746 | 37.710877138233 | -122.405203838782 | (37.710877138233, -122.405203838782) | 9 | 7 | 8 | 309 | 39 | |||
14324 | 100848 | Undocumented 4 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
14513 | 262471 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 660 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993411 | 2091542 | 37.7225978304542 | -122.464895215983 | (37.7225978304542, -122.464895215983) | 9 | 8 | 4 | 59 | 40 | ||||
14522 | 258882 | Undocumented 4 | Potential Site :: Potential Site 48 | 1199X Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996025 | 2091881 | 37.7236790151497 | -122.455883747529 | (37.7236790151497, -122.455883747529) | 9 | 8 | 4 | 28861 | 24 | ||||
14604 | 108382 | Undocumented 4 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | 9 | 7 | 8 | 309 | 39 | ||||
15387 | 254816 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2687 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5997223 | 2088538 | 37.7145686012354 | -122.451501477097 | (37.7145686012354, -122.451501477097) | 9 | 8 | 6 | 28861 | 24 | ||
15525 | 261460 | Undocumented 4 | Tree(s) :: 17 | 701X Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
15549 | 264810 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 56 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994250 | 2093087 | 37.7268883657721 | -122.462106990145 | (37.7268883657721, -122.462106990145) | 9 | 8 | 4 | 28861 | 40 | ||||
15900 | 108806 | Undocumented 4 | :: 45 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
16017 | 254863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
16020 | 96530 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16477 | 224849 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 779889 | 6003244.13534 | 2095137.54828 | 37.7330324530887 | -122.431160782146 | (37.7330324530887, -122.431160782146) | 9 | 7 | 5 | 28861 | 25 | ||
16522 | 262483 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 1 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
16732 | 262211 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999946 | 2089791 | 37.7181646124566 | -122.4421796072 | (37.7181646124566, -122.4421796072) | 9 | 7 | 6 | 28861 | 25 | ||||
16788 | 106928 | Undocumented 4 | Tree(s) :: 17 | 132 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 772627 | 5999153.18191 | 2093532.26995 | 37.7283920599051 | -122.445188861704 | (37.7283920599051, -122.445188861704) | 9 | 7 | 4 | 28861 | 40 | |||
16798 | 260834 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 30 Paloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992351 | 2093917 | 37.7290578205122 | -122.468732100912 | (37.7290578205122, -122.468732100912) | 9 | 8 | 4 | 59 | 40 | ||||
17023 | 254832 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
17569 | 98514 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||||
17824 | 254830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
17997 | 122419 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
18034 | 255666 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 275 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993722 | 2089019 | 37.7156882061667 | -122.463637144214 | (37.7156882061667, -122.463637144214) | 9 | 8 | 6 | 64 | 24 | ||||
18858 | 261506 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 50 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5991584 | 2091622 | 37.7227119804791 | -122.471216515117 | (37.7227119804791, -122.471216515117) | 9 | 8 | 4 | 59 | 40 | ||||
19196 | 258834 | Undocumented 4 | Potential Site :: Potential Site 48 | 1198X Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996138 | 2091849 | 37.7235976355668 | -122.455490816534 | (37.7235976355668, -122.455490816534) | 9 | 8 | 4 | 28861 | 24 | ||||
19220 | 122819 | Undocumented 4 | :: 45 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003309 | 2094407 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | 9 | 7 | 5 | 28861 | 25 | ||||
19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 |
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) );