336 rows where Police Districts = 7 and qLegalStatus_id = 6

View and edit SQL

Police Districts

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)
42469 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
42733 121190 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
42851 113727 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 4 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
42888 113973 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 11 Hiliritas Ave 1 Front Yard : Yard Tree Private 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
42938 112725 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
45212 254126 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1291 Bosworth St 1 Front Yard : Yard Tree Private 2       3x3   6000129 2096323 37.7361104052088 -122.44201565285 (37.7361104052088, -122.44201565285) 2 7 5 63 7
47041 177110 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 17 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998978.57855 2091518.53644 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081) 9 7 6 28861 25
47483 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 1 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
47565 116834 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1750 Geneva Ave 2 Front Yard : Yard Tree Private 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
48619 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 78 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
48955 255537 Significant Tree 6 Melaleuca linariifolia :: Flaxleaf Paperbark 103 93X Monterey Blvd 1 Side Yard : Cutout Tree Private 2       10x10   6001470 2094575 37.7313871286154 -122.437254157834 (37.7313871286154, -122.437254157834) 9 7 4 63 40
49109 104146 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1710-1738 Diamond St 1 Front Yard : Yard Tree Private 2     40     6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
49633 177105 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 12 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998924.5969 2091518.78116 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179) 9 7 6 28861 25
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
50525 173933 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 190 Beacon St 1 Front Yard : Yard Tree Private 2           6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
51024 105872 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 595X San Jose Ave 6 Front Yard : Yard Tree Private 2           6006124.47156 2100100.14306 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777) 2 7 7 28859 2
51717 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
52276 104869 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 4 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
52280 121184 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
52672 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44R Amber Dr 2 Back Yard : Yard Tree Private 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
54862 251605 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 48R Amber Dr 2 Back Yard : Yard Tree Private 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
55458 255165 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 371 Prospect Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 781717 6006352.58239 2097791.19314 37.7404944317648 -122.420602351048 (37.7404944317648, -122.420602351048) 2 7 7 28859 2
56399 254401 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779678 5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
57339 177108 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 15 Sidewalk: Property side : Yard Tree MTA 3     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369564 (37.7228504376851, -122.44574369564) 9 7 6 28861 25
57354 121187 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
57424 101476 Significant Tree 6 :: 45 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
59436 117588 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 261 Ripley St 1 Front Yard : Yard Tree Private 2   06/27/2016 12:00:00 AM 3   Permit Number 778127 6009622.3 2099176 37.7444805424074 -122.409394598776 (37.7444805424074, -122.409394598776) 2 7 7 28859 2
59778 112374 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1247 Bosworth St 1 Front Yard : Yard Tree Private 2       20x20 Permit Number 775819 6000424.11007 2096055.79143 37.7353935258967 -122.440976176652 (37.7353935258967, -122.440976176652) 9 7 4 63 40
61015 113741 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1580 Valencia St 1 Front Yard : Yard Tree Private 2     18     6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
61064 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Valletta Ct 1 Side Yard : Cutout Tree Private 2       6x10 Permit Number 780575 5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
61399 113734 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 11 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
61885 105866 Significant Tree 6 Maytenus boaria :: Mayten 58 3555 Cesar Chavez St 1 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
62334 87240 Significant Tree 6 Tree(s) :: 17 233 Arbor St 2 Sidewalk: Curb side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
63157 116234 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 450 PERALTA AVE 1 Front Yard : Yard Tree Private 2       3x3   6009750 2099218 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129) 2 7 7 28859 2
63382 177743 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 Ocean Ave 4 Sidewalk: Property side : Yard Tree MTA 3     37     5998700.41574 2091522.98281 37.7228491714484 -122.446609585371 (37.7228491714484, -122.446609585371) 9 7 6 28861 25
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
63551 121177 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
64560 87191 Significant Tree 6 Tree(s) :: 17 640 Miramar Ave 1 Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50212 5995439 2093622 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987) 9 7 4 28861 40
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
67180 121191 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67675 110738 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
67746 121188 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67938 113739 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 16 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
68299 99852 Significant Tree 6 Juniperus chinensis :: Juniper 113 86 Nordhoff St 1 Front Yard : Yard Tree Private 2           6000395 2095652 37.7342831509698 -122.441047861045 (37.7342831509698, -122.441047861045) 9 7 5 63 40
69512 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 500 Raymond Ave 1 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM 30 3x3   6008233.87951 2088473.93147 37.7150170728648 -122.413438766187 (37.7150170728648, -122.413438766187) 9 7 8 309 18
71176 87239 Significant Tree 6 Tree(s) :: 17 233 Arbor St 1 Sidewalk: Property side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
71228 253470 Significant Tree 6 Juniperus chinensis :: Juniper 113 3 Valletta Ct 2 Side Yard : Cutout Tree Private 2       6x10   5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
71809 96274 Significant Tree 6 Olea europaea :: Olive Tree 9 55@ Alemany Trumbull St 2 Back Yard : Yard Tree Private 2     2     6004001.3006 2094332.00643 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086) 9 7 6 28861 5
73380 105869 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
73655 253718 Significant Tree 6 Acer buergeranum :: Trident Maple 110 227 Madison St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3 Permit Number 780760 6005690 2092595 37.7261894743752 -122.422524168298 (37.7261894743752, -122.422524168298) 9 7 7 309 5
74590 115445 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 1 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
75419 105862 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 3 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
76185 105867 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
77182 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 60R Amber Dr 2 Back Yard : Yard Tree Private 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
77320 116457 Significant Tree 6 Tree(s) :: 17 412 Nevada St 1 Front Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3   Permit Number 777591 6008890.4 2096365.2 37.736721665261 -122.41172680033 (37.736721665261, -122.41172680033) 10 7 7 28859 2
78343 101466 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 301 Hazelwood Ave 1 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
78510 256521 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 2783X Diamond St 3 Side Yard : Yard Tree Private 2       10x10 Permit Number 782107 6002654 2095945 37.7352160714264 -122.433258709098 (37.7352160714264, -122.433258709098) 2 7 5 63 7
80243 255324 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 852 Chenery St 2 Front Yard : Yard Tree Private 2       3X3   6001755.94767 2095865.71194 37.7349473777015 -122.436357925586 (37.7349473777015, -122.436357925586) 2 7 5 63 7
80257 122411 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
84220 104654 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 352-354 Coleridge St 1 Front Yard : Yard Tree Private 2         Permit Number 768244 6006091.8 2098091.1 37.7413032079582 -122.421525330669 (37.7413032079582, -122.421525330669) 2 7 7 28859 2
84450 104867 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 2 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
86304 113736 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 13 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
86813 104872 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1753 Noe St 1 Hanging basket : Yard Tree Private 2   11/22/2013 12:00:00 AM     Permit Number 770054 6003434.1 2098036.1 37.7410019772539 -122.430710793678 (37.7410019772539, -122.430710793678) 2 7 5 63 7
87807 113732 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 9 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
87873 121174 Significant Tree 6 Tree(s) :: 17 950 Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
88321 121186 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
88853 121193 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
89812 107834 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
90315 112398 Significant Tree 6 Myoporum laetum :: Myoporum 62 246 CRESCENT AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6006552 2095759 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192) 2 7 7 28859 2
92509 87216 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 500 Cortland Ave 2 Back Yard : Yard Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709) 2 7 7 28859 2
92548 122410 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
92659 85428 Significant Tree 6 Tree(s) :: 17 43 Ora Way 1 Front Yard : Cutout Tree Private 2   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.7416050219872 -122.437232403771 (37.7416050219872, -122.437232403771) 2 7 5 63 7
93840 116835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1750 Geneva Ave 3 Front Yard : Yard Tree Private 2           6004521.4 2087037.7 37.710864341935 -122.42616849364 (37.710864341935, -122.42616849364) 9 7 6 309 5
94002 113187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3340 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008444 2099179 37.7444226899799 -122.413469145285 (37.7444226899799, -122.413469145285) 2 7 7 28859 2
95045 121170 Significant Tree 6 Tree(s) :: 17 900x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
95104 120593 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree MTA 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
95118 257896 Significant Tree 6 Myoporum laetum :: Myoporum 62 266 Moreland St 1 Front Yard : Yard Tree Private 2       3x3   6001949 2097289 37.7388663647576 -122.435792277212 (37.7388663647576, -122.435792277212) 2 7 5 63 7
98838 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
98904 113735 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 12 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
98953 114193 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 1 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
100356 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 4 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
100702 109040 Significant Tree 6 Juniperus chinensis :: Juniper 113 654 Precita Ave   Front Yard : Yard Tree Private 2     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152) 2 7 7 28859 2
100865 96279 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 55@ Alemany Trumbull St 7 Back Yard : Yard Tree Private 2           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208) 9 7 6 28861 5
102716 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 3 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
102801 122418 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 15 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
103941 57910 Significant Tree 6 Tree(s) :: 17 446 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1977 12:00:00 AM     Permit Number 16868 6003019.35193275 2099229.53580249 37.7442553690473 -122.432230049776 (37.7442553690473, -122.432230049776) 2 7 5 63 22
104067 255325 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 42 Lippard Ave 1 Front Yard : Yard Tree Private 2       Width 0ft Permit Number 781812 6002006.02273 2095939.48888 37.7351641583954 -122.435498605394 (37.7351641583954, -122.435498605394) 2 7 5 63 7
104414 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
104704 256850 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 100 Brentwood Ave 1 Front Yard : Yard Tree Private 2       6x6   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
105980 113733 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 10 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
106382 116072 Significant Tree 6 Juniperus chinensis :: Juniper 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);