trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190141 | 100043 | Significant Tree 6 | Tree(s) :: 17 | 50 Bronte St | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2012 12:00:00 AM | Permit Number 769001 | 6009337 | 2097155 | 37.7389153282678 | -122.410238449764 | (37.7389153282678, -122.410238449764) | 10 | 7 | 7 | 28859 | 2 | |||
3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
189375 | 100473 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
139989 | 100474 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
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 | |||||
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
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 | ||
126350 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : | Tree | Private 2 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261909 | (37.740765720819, -122.41052261909) | 10 | 7 | 7 | 28859 | 2 | |||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
182728 | 102583 | Significant Tree 6 | Tree(s) :: 17 | 22 Gennessee St | 1 | Front Yard : Yard | Tree | Private 2 | 02/27/2013 12:00:00 AM | Permit Number 769949 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | 9 | 7 | 4 | 28861 | 40 | |||
177640 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 30X Zircon Pl | 1 | Back Yard : Yard | Tree | Private 2 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.434652757436 | (37.7430068656447, -122.434652757436) | 2 | 7 | 5 | 63 | 7 | |||||
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 | ||||
168357 | 104148 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
116917 | 104149 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
142943 | 104150 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 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 | ||||
108320 | 104865 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 80 Stoneman St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770375 | 6007947.7 | 2099422 | 37.7450620347132 | -122.415202450973 | (37.7450620347132, -122.415202450973) | 2 | 7 | 7 | 28859 | 2 | ||||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 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 | ||||
123534 | 104868 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 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 | ||||
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 | |||
154007 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 101 LUNDYS LN | 1 | Front Yard : Cutout | Tree | Private 2 | 18 | 6006875 | 2098969 | 37.7437578546964 | -122.418879543436 | (37.7437578546964, -122.418879543436) | 2 | 7 | 7 | 28859 | 2 | ||||
30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
34790 | 105768 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 98X GOLD MINE DR | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6001350 | 2099153 | 37.7439504273559 | -122.437996817375 | (37.7439504273559, -122.437996817375) | 2 | 7 | 5 | 63 | 22 | ||||
124470 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
159232 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
182948 | 105860 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
22846 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
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 | |||||
23771 | 105863 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
35675 | 105864 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
126862 | 105865 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
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 | |||||
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 | |||||
186539 | 105868 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
145596 | 105870 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
178545 | 105871 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
151159 | 107322 | Significant Tree 6 | Tree(s) :: 17 | 68 ROSENKRANZ ST | 1 | Front Yard : Yard | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773942 | 6009212 | 2098349 | 37.7421867844178 | -122.410754944355 | (37.7421867844178, -122.410754944355) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||||
170160 | 107835 | 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 | ||||
178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
108135 | 108305 | Significant Tree 6 | Tree(s) :: 17 | 360 GAMBIER ST | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | Permit Number 774454 | 6006059.9 | 2092154.5 | 37.725000818071 | -122.421214176486 | (37.725000818071, -122.421214176486) | 9 | 7 | 7 | 309 | 5 | ||
149707 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 MIGUEL ST | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6003334.2 | 2097391.9 | 37.7392274919289 | -122.431010244874 | (37.7392274919289, -122.431010244874) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||||
35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
184053 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X STILLINGS AVE | 1 | Back Yard : Yard | Tree | Private 2 | 60 | 6000417 | 2095694 | 37.7343997262189 | -122.44097481224 | (37.7343997262189, -122.44097481224) | 9 | 7 | 5 | 63 | 40 | ||||
139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
3842 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 268 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | 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 | ||||
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 | ||||
124026 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 6 | 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 | ||||
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 | |||
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 | |||||
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 | |||
32139 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
119037 | 112769 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
133887 | 112770 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
137248 | 112771 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
165386 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
136074 | 112773 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
140130 | 112774 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
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 | ||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
110541 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
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 | ||||
155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | |||
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 | |||||
110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
117937 | 113726 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 3 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
185504 | 113729 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 6 | 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 | |||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
192790 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 8 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||
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 | |||||
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 | |||||
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 | |||||
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 |
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) );