trees

458 rows where Supervisor Districts = 4 and qLegalStatus_id = 6 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor 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)
63 264975 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 1 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
68 264976 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 2 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
2183 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard Tree Private 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
2352 101748 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700X Panorama Dr 1 Back Yard : Yard Tree Private 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
2657 260570 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 4 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
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
4000 79751 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 15 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
4737 261021 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 2 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
6044 259265 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6370 261832 Significant Tree 6 Ilex spp :: Holly Species 81 16 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995265 2100184 37.7464333732005 -122.459111852123 (37.7464333732005, -122.459111852123) 1 8 4 59 40
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
6915 116579 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
7288 264692 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1500 Plymouth Ave 1 Side Yard : Yard Tree Private 2       10x10   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
7373 96567 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
7631 256540 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8965 261020 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
9478 260514 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3025 22nd Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5989750.29916 2095052.76589 37.7320257582668 -122.477805820702 (37.7320257582668, -122.477805820702) 1 8 4 64 35
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10088 253978 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       3x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
11182 261019 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3450X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784867 5990575 2092822 37.725948465298 -122.47479191789 (37.725948465298, -122.47479191789) 9 8 4 64 14
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
12033 259149 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 150 Lenox Way 1 Front Yard : Yard Tree Private 2       5x5   5993309.4847 2098463.34097 37.7415962663129 -122.465748753199 (37.7415962663129, -122.465748753199) 1 8 4 59 40
12152 255704 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 201X Hernandez Ave 1 Side Yard : Yard Tree Private 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
13082 96572 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13663 258677 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 607 Congo St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   6000094 2095817 37.7347190533418 -122.442100351643 (37.7347190533418, -122.442100351643) 9 7 4 63 40
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
14356 264786 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 451 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995368 2094795 37.7316424274687 -122.458365690275 (37.7316424274687, -122.458365690275) 9 7 4 59 40
14911 264785 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1738 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       10x10   5991929 2103547 37.7554749546691 -122.470892190435 (37.7554749546691, -122.470892190435) 1 8 4 56 12
15055 259264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
15224 264691 Significant Tree 6 Leucodendron argenteum :: Silver Tree 46 1560 Plymouth Ave 1 Front Yard : Yard Tree Private 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
15254 260460 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1798X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
15671 104278 Significant Tree 6 Acacia spp :: Acacia Spp 105 2 Allston Way 1 Back Yard : Yard Tree Private 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
16652 258405 Significant Tree 6 Myoporum laetum :: Myoporum 62 15 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
17333 259266 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
17429 103965 Significant Tree 6 Tree(s) :: 17 141 Marview Way 1 Front Yard : Yard Tree Private 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18957 259263 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
18983 262256 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 4210 Ocean Ave 9 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
19246 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 3 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
19616 262407 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Font Blvd 1 Sidewalk: Property side : Yard Tree Private 2       6x5   5990018 2089729 37.7174235665943 -122.476491559856 (37.7174235665943, -122.476491559856) 1 8 4 64 14
19844 254259 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
20150 256573 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 145 Castenada Ave 1 Front Yard : Cutout Tree Private 2       3x3   5994569 2100949 37.74849383418 -122.461573977381 (37.74849383418, -122.461573977381) 1 8 4 29491 40
20972 254094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 320 Magellan Ave 1 Front Yard : Yard Tree Private 2       10x10 Permit Number 781012 5994209 2099943 37.7457108840866 -122.462745872627 (37.7457108840866, -122.462745872627) 1 8 4 29491 40
21096 253953 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 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
22688 120924 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
22895 256572 Significant Tree 6 Ilex aquifolium :: European Holly 390 175 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994536 2100823 37.748145970457 -122.461678955671 (37.748145970457, -122.461678955671) 1 8 4 29491 40
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
27831 98834 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
28198 106364 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 155 BORICA ST 1 Front Yard : Yard Tree Private 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
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
30556 104909 Significant Tree 6 Pinus radiata :: Monterey Pine 15 533 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
34088 256489 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2198X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 8 4 59 40
34696 253950 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 431 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
36915 117645 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2901 21ST AVE 1 Back Yard : Yard Tree Private 2       3x3   5989904 2095901 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio 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
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
39767 254934 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
41336 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
42536 97945 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2         Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
43517 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout Tree Private 2   08/01/2008 12:00:00 AM     Permit Number 51562 5991996 2092560 37.7253113201117 -122.469860593138 (37.7253113201117, -122.469860593138) 9 8 4 59 40
44052 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree Private 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44683 114406 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
45348 93222 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 2 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
47402 120930 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 13 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
47809 116010 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
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
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
51080 120925 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 8 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
51266 255290 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3353 19th Ave 1 Side Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40

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