trees
142,615 rows where qLegalStatus_id = 1 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56242 | 12380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/17/2013 12:00:00 AM | 3 | 3x3 | 6004345.46385 | 2113763.00934 | 37.7842359045501 | -122.428680455521 | (37.7842359045501, -122.428680455521) | 13 | 9 | 11 | 29490 | 41 | |||
| 130779 | 14676 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
| 18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
| 98915 | 199651 | DPW Maintained 1 | :: 45 | 0 | 37 | : | Tree | Private 2 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.379309965799 | (37.7414476037323, -122.379309965799) | 10 | 3 | 8 | 58 | 1 | |||
| 108167 | 204800 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 0 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991281.57381 | 2102416.71556 | 37.7523340257173 | -122.473048745206 | (37.7523340257173, -122.473048745206) | 1 | 8 | 4 | 29491 | 12 | |||
| 3192 | 247788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 30th St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 6004361.25599 | 2098418.69842 | 37.7421049892529 | -122.427532277614 | (37.7421049892529, -122.427532277614) | 2 | 7 | 5 | 63 | 22 | |||
| 190793 | 247792 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 30th St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113215 | -122.42834067009 | (37.742063113215, -122.42834067009) | 2 | 7 | 5 | 63 | 22 | |||
| 9238 | 177934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | 1 | 8 | 4 | 64 | 14 | ||||
| 91884 | 177932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988789.67714 | 2089358.25698 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | 1 | 8 | 4 | 64 | 14 | ||||
| 92388 | 177930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | 1 | 8 | 4 | 64 | 14 | ||||
| 117932 | 177923 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988561.02848 | 2089156.81478 | 37.7157678799561 | -122.481485695422 | (37.7157678799561, -122.481485695422) | 1 | 8 | 4 | 64 | 14 | ||||
| 118117 | 177928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5988855.6313 | 2089468.65527 | 37.7166412412847 | -122.480490237638 | (37.7166412412847, -122.480490237638) | 1 | 8 | 4 | 64 | 14 | ||||
| 139082 | 177926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5988935.7978 | 2089543.35128 | 37.7168509964648 | -122.480218609114 | (37.7168509964648, -122.480218609114) | 1 | 8 | 4 | 64 | 14 | ||||
| 141505 | 177927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | 1 | 8 | 4 | 64 | 14 | ||||
| 143228 | 177933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988685.34824 | 2089320.71628 | 37.7162251402652 | -122.481067988213 | (37.7162251402652, -122.481067988213) | 1 | 8 | 4 | 64 | 14 | ||||
| 177831 | 177929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988839.75679 | 2089455.3276 | 37.7166037242653 | -122.480544132207 | (37.7166037242653, -122.480544132207) | 1 | 8 | 4 | 64 | 14 | ||||
| 192389 | 177931 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988808.76092 | 2089375.86435 | 37.7163837365992 | -122.480645454328 | (37.7163837365992, -122.480645454328) | 1 | 8 | 4 | 64 | 14 | ||||
| 56001 | 177922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990625.84661 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | 1 | 8 | 4 | 64 | 14 | |||
| 119745 | 177921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.474319162615 | (37.7161606912434, -122.474319162615) | 1 | 8 | 4 | 64 | 14 | |||
| 14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
| 75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
| 165584 | 175648 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | 1 | 8 | 4 | 64 | 14 | |||
| 172655 | 175651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008 | (37.7189698369625, -122.47492674008) | 1 | 8 | 4 | 64 | 14 | |||
| 61278 | 240133 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.7561562172456 | -122.426819912015 | (37.7561562172456, -122.426819912015) | 2 | 4 | 5 | 28862 | 22 | |||
| 123224 | 226146 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 0 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004672.1171 | 2103577.59935 | 37.7562877143308 | -122.426824733282 | (37.7562877143308, -122.426824733282) | 2 | 4 | 5 | 28862 | 22 | |||
| 150497 | 240131 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004671.77899 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | 2 | 4 | 5 | 28862 | 22 | |||
| 187007 | 240132 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.426821519118 | (37.7562000502026, -122.426821519118) | 2 | 4 | 5 | 28862 | 22 | |||
| 62478 | 178331 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Crespi Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5990248.62782 | 2090529.49404 | 37.7196348982192 | -122.47575281776 | (37.7196348982192, -122.47575281776) | 1 | 8 | 4 | 64 | 14 | ||||
| 106360 | 177925 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5989826.52584 | 2090074.03315 | 37.7183598349297 | -122.477178590321 | (37.7183598349297, -122.477178590321) | 1 | 8 | 4 | 64 | 14 | ||||
| 110440 | 176058 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.477083556286 | (37.7184611570226, -122.477083556286) | 1 | 8 | 4 | 64 | 14 | ||||
| 119351 | 178330 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Crespi Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5990231.62588 | 2090527.90324 | 37.7196295445501 | -122.47581147062 | (37.7196295445501, -122.47581147062) | 1 | 8 | 4 | 64 | 14 | ||||
| 120992 | 178329 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Crespi Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5990213.26487 | 2090523.74185 | 37.719617053851 | -122.47587463361 | (37.719617053851, -122.47587463361) | 1 | 8 | 4 | 64 | 14 | ||||
| 138439 | 177924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989730.82285 | 2090240.32639 | 37.718810881792 | -122.47752153959 | (37.718810881792, -122.47752153959) | 1 | 8 | 4 | 64 | 14 | ||||
| 144789 | 176378 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989827.05129 | 2090325.18948 | 37.7190494782331 | -122.477195118066 | (37.7190494782331, -122.477195118066) | 1 | 8 | 4 | 64 | 14 | ||||
| 155051 | 176377 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989839.20092 | 2090334.45543 | 37.7190756251255 | -122.477153798712 | (37.7190756251255, -122.477153798712) | 1 | 8 | 4 | 64 | 14 | ||||
| 163165 | 177945 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5990273.00331 | 2089979.48461 | 37.7181261218096 | -122.475628420827 | (37.7181261218096, -122.475628420827) | 1 | 8 | 4 | 64 | 14 | ||||
| 8634 | 176044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5990534.22824 | 2089263.30634 | 37.7161748133009 | -122.474673246391 | (37.7161748133009, -122.474673246391) | 1 | 8 | 4 | 64 | 14 | ||||
| 15792 | 176369 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.474816769171 | (37.7159609464097, -122.474816769171) | 1 | 8 | 4 | 64 | 14 | ||||
| 30077 | 176367 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989068.70923 | 2090618.6052 | 37.7198110969962 | -122.479837842465 | (37.7198110969962, -122.479837842465) | 1 | 8 | 4 | 64 | 14 | ||||
| 39739 | 176040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989182.35151 | 2090508.47222 | 37.7195153009692 | -122.479436972335 | (37.7195153009692, -122.479436972335) | 1 | 8 | 4 | 64 | 14 | ||||
| 51096 | 176365 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988916.46599 | 2090663.1949 | 37.719924683163 | -122.48036734977 | (37.719924683163, -122.48036734977) | 1 | 8 | 4 | 64 | 14 | ||||
| 59167 | 178308 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 5990210.12045 | 2089417.27348 | 37.7165787833656 | -122.475804743705 | (37.7165787833656, -122.475804743705) | 1 | 8 | 4 | 64 | 14 | ||||
| 66870 | 177914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989849.36693 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | 1 | 8 | 4 | 64 | 14 | ||||
| 88918 | 176045 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | 1 | 8 | 4 | 64 | 14 | ||||
| 101312 | 176046 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5990073.98867 | 2089647.08481 | 37.7172018948419 | -122.47629205486 | (37.7172018948419, -122.47629205486) | 1 | 8 | 4 | 64 | 14 | ||||
| 113662 | 176042 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989234.3289 | 2090278.89103 | 37.7188879474116 | -122.479240521736 | (37.7188879474116, -122.479240521736) | 1 | 8 | 4 | 64 | 14 | ||||
| 125774 | 176368 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5990356.63176 | 2089404.5642 | 37.7165523801656 | -122.475297405564 | (37.7165523801656, -122.475297405564) | 1 | 8 | 4 | 64 | 14 | ||||
| 127050 | 176362 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5988643.66331 | 2091104.18942 | 37.7211196861052 | -122.481342600695 | (37.7211196861052, -122.481342600695) | 1 | 8 | 4 | 64 | 14 | ||||
| 149031 | 177298 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988403.4281 | 2091243.72009 | 37.721488831717 | -122.482183231171 | (37.721488831717, -122.482183231171) | 1 | 8 | 4 | 64 | 14 | ||||
| 163419 | 176043 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989267.95492 | 2090414.23117 | 37.7192615104927 | -122.479134185915 | (37.7192615104927, -122.479134185915) | 1 | 8 | 4 | 64 | 14 | ||||
| 168538 | 176364 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988874.21496 | 2090711.48965 | 37.7200548330315 | -122.480516928613 | (37.7200548330315, -122.480516928613) | 1 | 8 | 4 | 64 | 14 | ||||
| 175663 | 176363 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5988462.77344 | 2091307.96071 | 37.7216686718604 | -122.481982796584 | (37.7216686718604, -122.481982796584) | 1 | 8 | 4 | 64 | 14 | ||||
| 188092 | 176366 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989001.16217 | 2090698.46083 | 37.7200264360421 | -122.480077167338 | (37.7200264360421, -122.480077167338) | 1 | 8 | 4 | 64 | 14 | ||||
| 58808 | 177947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | 1 | 8 | 4 | 64 | 14 | ||||
| 104030 | 177946 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989610.43005 | 2090657.90132 | 37.7199504514394 | -122.477968195982 | (37.7199504514394, -122.477968195982) | 1 | 8 | 4 | 64 | 14 | ||||
| 139166 | 176348 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.477982952958 | (37.7196430676648, -122.477982952958) | 1 | 8 | 4 | 64 | 14 | ||||
| 164370 | 177948 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989566.53985 | 2090511.453 | 37.7195457933774 | -122.478109206096 | (37.7195457933774, -122.478109206096) | 1 | 8 | 4 | 64 | 14 | ||||
| 173597 | 177949 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989559.04866 | 2090448.78739 | 37.7193732944219 | -122.478130520911 | (37.7193732944219, -122.478130520911) | 1 | 8 | 4 | 64 | 14 | ||||
| 8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
| 28195 | 177938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989480.91989 | 2089050.18574 | 37.7155285469807 | -122.478298370392 | (37.7155285469807, -122.478298370392) | 1 | 8 | 4 | 64 | 14 | ||||
| 87980 | 177937 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.478271538203 | (37.7153620069155, -122.478271538203) | 1 | 8 | 4 | 64 | 14 | ||||
| 110390 | 177935 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989493.36658 | 2088932.77712 | 37.7152068945538 | -122.478246769977 | (37.7152068945538, -122.478246769977) | 1 | 8 | 4 | 64 | 14 | ||||
| 137788 | 177936 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989491.06081 | 2088964.93712 | 37.7152950640932 | -122.478257089699 | (37.7152950640932, -122.478257089699) | 1 | 8 | 4 | 64 | 14 | ||||
| 176017 | 104722 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Garces Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 770294 | 5989426.46547 | 2089157.77848 | 37.7158208086468 | -122.478494450472 | (37.7158208086468, -122.478494450472) | 1 | 8 | 4 | 64 | 14 | |||
| 180676 | 177940 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989427.62768 | 2089128.02152 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | 1 | 8 | 4 | 64 | 14 | ||||
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 16855 | 178604 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988124.07873 | 2089803.353 | 37.7175176953569 | -122.4830433365 | (37.7175176953569, -122.4830433365) | 1 | 8 | 4 | 64 | 14 | ||||
| 19661 | 175653 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | 1 | 8 | 4 | 64 | 14 | ||||
| 21654 | 177726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989405.70354 | 2089245.56508 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | 1 | 8 | 4 | 64 | 14 | ||||
| 21900 | 176048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | 1 | 8 | 4 | 64 | 14 | ||||
| 24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
| 28994 | 178321 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5989145.21541 | 2089457.74529 | 37.716628110272 | -122.479488503489 | (37.716628110272, -122.479488503489) | 1 | 8 | 4 | 64 | 14 | ||||
| 30187 | 178322 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 5989407.26888 | 2089196.13882 | 37.7159250221006 | -122.478563605643 | (37.7159250221006, -122.478563605643) | 1 | 8 | 4 | 64 | 14 | ||||
| 36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
| 36842 | 181277 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988402.74919 | 2089827.84919 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | 1 | 8 | 4 | 64 | 14 | ||||
| 37254 | 176052 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989234.20998 | 2089407.11974 | 37.7164942740645 | -122.47917719598 | (37.7164942740645, -122.47917719598) | 1 | 8 | 4 | 64 | 14 | ||||
| 50796 | 176161 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990361.86615 | 2090050.7376 | 37.7183269161272 | -122.475326462647 | (37.7183269161272, -122.475326462647) | 1 | 8 | 4 | 64 | 14 | ||||
| 51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
| 54735 | 176050 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989206.75613 | 2089405.10082 | 37.7164871361381 | -122.47927194137 | (37.7164871361381, -122.47927194137) | 1 | 8 | 4 | 64 | 14 | ||||
| 55188 | 175656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990014.12726 | 2089314.59531 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | 1 | 8 | 4 | 64 | 14 | ||||
| 58195 | 176054 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989245.31981 | 2089315.24778 | 37.7162426617475 | -122.479132078791 | (37.7162426617475, -122.479132078791) | 1 | 8 | 4 | 64 | 14 | ||||
| 63516 | 178176 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | 1 | 8 | 4 | 64 | 14 | ||||
| 68279 | 175655 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989994.06268 | 2089291.62254 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | 1 | 8 | 4 | 64 | 14 | ||||
| 68726 | 176047 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5988958.7133 | 2089588.42281 | 37.7169760831658 | -122.480142699133 | (37.7169760831658, -122.480142699133) | 1 | 8 | 4 | 64 | 14 | ||||
| 69616 | 178117 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988789.57342 | 2089765.12974 | 37.7174514468002 | -122.480740256365 | (37.7174514468002, -122.480740256365) | 1 | 8 | 4 | 64 | 14 | ||||
| 69769 | 178320 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5988848.05481 | 2089780.78106 | 37.7174978203386 | -122.480539260585 | (37.7174978203386, -122.480539260585) | 1 | 8 | 4 | 64 | 14 | ||||
| 71490 | 181275 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988424.04089 | 2089826.43294 | 37.7175985174299 | -122.482008206935 | (37.7175985174299, -122.482008206935) | 1 | 8 | 4 | 64 | 14 | ||||
| 78916 | 177224 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989267.30759 | 2089305.68388 | 37.7162176785877 | -122.479055380104 | (37.7162176785877, -122.479055380104) | 1 | 8 | 4 | 64 | 14 | ||||
| 86816 | 178324 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990257.38166 | 2089553.17282 | 37.7169546693979 | -122.475651304982 | (37.7169546693979, -122.475651304982) | 1 | 8 | 4 | 64 | 14 | ||||
| 87156 | 177223 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989192.47222 | 2089346.91127 | 37.7163265325079 | -122.47931705855 | (37.7163265325079, -122.47931705855) | 1 | 8 | 4 | 64 | 14 | ||||
| 89898 | 175769 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989661.94364 | 2089233.64885 | 37.7160427982152 | -122.477686080452 | (37.7160427982152, -122.477686080452) | 1 | 8 | 4 | 64 | 14 | ||||
| 92455 | 181276 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988413.87941 | 2089827.13064 | 37.7175998421416 | -122.482043381217 | (37.7175998421416, -122.482043381217) | 1 | 8 | 4 | 64 | 14 | ||||
| 93553 | 178171 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988123.04078 | 2089845.83927 | 37.7176342915553 | -122.483050036443 | (37.7176342915553, -122.483050036443) | 1 | 8 | 4 | 64 | 14 | ||||
| 95623 | 178173 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988347.73388 | 2089792.82325 | 37.717501795356 | -122.482269501364 | (37.717501795356, -122.482269501364) | 1 | 8 | 4 | 64 | 14 | ||||
| 101122 | 175771 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989791.93538 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | 1 | 8 | 4 | 64 | 14 | ||||
| 104889 | 178326 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5990372.21154 | 2089922.4902 | 37.7179753801352 | -122.475281345478 | (37.7179753801352, -122.475281345478) | 1 | 8 | 4 | 64 | 14 | ||||
| 106648 | 176051 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989218.52603 | 2089406.15184 | 37.7164907055632 | -122.479231336085 | (37.7164907055632, -122.479231336085) | 1 | 8 | 4 | 64 | 14 | ||||
| 109920 | 177220 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989003.16824 | 2089530.29069 | 37.7168190498446 | -122.479984789888 | (37.7168190498446, -122.479984789888) | 1 | 8 | 4 | 64 | 14 | ||||
| 113811 | 175774 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | 1 | 8 | 4 | 64 | 14 | ||||
| 114440 | 178607 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.475437730361 | (37.7180635775375, -122.475437730361) | 1 | 8 | 4 | 64 | 14 |
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) );