trees

222 rows where qCaretaker_id = 2 and qLegalStatus_id = 8 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 222 ✖
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)
99978 234895 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 3255x 24th St 6 Side Yard : Cutout Tree Private 2     40 Width 10ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
96626 91109 Property Tree 8 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
109556 91108 Property Tree 8 Tree(s) :: 17 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
142995 108574 Property Tree 8 Tree(s) :: 17 1891 15th St 1 Back Yard : Yard Tree Private 2       7x8   6004884.86016 2107160.44126 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
171323 253471 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 17 Valletta Ct 1 Side Yard : Yard Tree Private 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
173335 117644 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1111X SANSOME ST 1 Back Yard : Yard Tree Private 2       3x30   6011937 2119613 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034) 3 1 10 308 23
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
364 255980 Property Tree 8 Tree(s) :: 17 541 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000551 2110847 37.7760138103106 -122.441598590487 (37.7760138103106, -122.441598590487) 15 5 11 29492 16
628 256542 Property Tree 8 Pinus radiata :: Monterey Pine 15 133 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
2059 264900 Property Tree 8 Pinus radiata :: Monterey Pine 15 35X Parkridge Dr 1 Median : Yard Tree Private 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
4239 258982 Property Tree 8 Pinus radiata :: Monterey Pine 15 239 Panorama Dr 1 Back Yard : Yard Tree Private 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
5288 260453 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 4 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
5987 262213 Property Tree 8 Olea europaea :: Olive Tree 9 66 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997837 2104660 37.7588708842054 -122.450540844653 (37.7588708842054, -122.450540844653) 15 5 11 28862 12
6335 262305 Property Tree 8 Casuarina cunninghamiana :: Horsetail pine 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
6943 262154 Property Tree 8 Pinus radiata :: Monterey Pine 15 519 22nd Ave 1 Back Yard : Yard Tree Private 2       3x3   5989039 2111772 37.7778909946523 -122.481488924787 (37.7778909946523, -122.481488924787) 11 6 2 55 26
7863 260451 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 2 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8587 260455 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 6 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
9029 258675 Property Tree 8 Myoporum laetum :: Myoporum 62 60 Laidley St 1 Back Yard : Yard Tree Private 2       3x3   6003232 2097949 37.7407513687421 -122.431403364879 (37.7407513687421, -122.431403364879) 2 7 5 63 7
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
12648 260457 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 8 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
13403 261178 Property Tree 8 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
13614 258670 Property Tree 8 Pinus radiata :: Monterey Pine 15 152 Kensington Way   Front Yard : Yard Tree Private 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
13832 259913 Property Tree 8 Pinus radiata :: Monterey Pine 15 23 Cresta Vista Dr 1 Back Yard : Yard Tree Private 2       3x3   5995254 2096176 37.7354277647167 -122.45885975654 (37.7354277647167, -122.45885975654) 9 7 4 59 40
16690 260450 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 1 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
19362 260454 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 5 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19609 260452 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 3 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
20664 121198 Property Tree 8 Cordyline australis :: Dracena Palm 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 40
22075 187658 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 600X Clarendon Ave 1 Front Yard : Yard Tree Private 2       3x3   5995637 2102382 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932) 1 5 4 63 12
22174 33799 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 10 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
27877 33781 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x misson st 12 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757) 12 2 9 28855 6
28785 122558 Property Tree 8 Pinus radiata :: Monterey Pine 15 1760 Diamond St 1 Back Yard : Yard Tree Private 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
28928 116154 Property Tree 8 Pinus Spp :: Pine Spp 100 324 POPE ST 1 Back Yard : Yard Tree Private 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
31871 33776 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
35596 254587 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1270 24th Ave 1 Back Yard : Cutout Tree Private 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
40432 110929 Property Tree 8 Pinus radiata :: Monterey Pine 15 445 BEACON ST   Back Yard : Yard Tree Private 2       3x3   6002243 2098437 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675) 2 7 5 63 7
43580 33793 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
48396 109097 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
51917 256537 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Cutout Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
54368 33775 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
60302 187670 Property Tree 8 Pinus radiata :: Monterey Pine 15 230 Victoria St 1 Back Yard : Yard Tree Private 2       3x3   5993274 2088748 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001) 9 8 6 64 24
62239 33794 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 13 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
66427 248974 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 716 Goettingen St 1 Back Yard : Yard Tree Private 2       3x3   6010713 2091306 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237) 10 3 7 309 28
67079 251294 Property Tree 8 :: 45 7126 Geary Blvd 1 Back Yard : Cutout Tree Private 2       3x3   5984860 2112552 37.7797887789018 -122.496002892522 (37.7797887789018, -122.496002892522) 11 6 2 55 26
71205 33789 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
71797 256101 Property Tree 8 Populus spp :: Poplar Spp 262 1255 Oak St 1 Back Yard : Cutout Tree Private 2       3x3   6001013 2109627 37.7726903083913 -122.439912920243 (37.7726903083913, -122.439912920243) 15 5 11 29492 9
84644 118371 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 4808 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999981 2101110 37.7492459313263 -122.442870994168 (37.7492459313263, -122.442870994168) 2 4 5 28862 22
87602 253142 Property Tree 8 Juniperus silicicola :: Southern red cedar 429 735 29th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
89545 256543 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
90477 109091 Property Tree 8 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 4235 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
91079 33787 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
92957 257936 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 2 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
96282 117254 Property Tree 8 Pinus radiata :: Monterey Pine 15 2067 33RD AVE 1 Back Yard : Yard Tree Private 2       3x3   5985987 2101171 37.7486056682842 -122.491266304796 (37.7486056682842, -122.491266304796) 1 8 3 29491 35
97665 121104 Property Tree 8 Pinus radiata :: Monterey Pine 15 477 Myra Way 1 Back Yard : Yard Tree Private 2       3x3   5997298 2097021 37.7378652095891 -122.45185385939 (37.7378652095891, -122.45185385939) 9 7 4 59 40
101829 257926 Property Tree 8 Pinus radiata :: Monterey Pine 15 8 Hill Point Ave 1 Back Yard : Yard Tree Private 2       3x3   5996384 2106804 37.7646744896132 -122.455720942569 (37.7646744896132, -122.455720942569) 15 5 11 29492 12
101831 120995 Property Tree 8 Private shrub :: Private Shrub 284 231 Delano Ave 1 Front Yard : Yard Landscaping Private 2       3x3   6000066 2092260 37.7249507611268 -122.44194193564 (37.7249507611268, -122.44194193564) 9 7 6 28861 25
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
106981 109092 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
108384 122480 Property Tree 8 Pinus radiata :: Monterey Pine 15 596X Buckingham Way 1 Side Yard : Cutout Tree Private 2       3x3   5990152 2094375 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616) 1 8 4 64 14
121285 104318 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 22 Beaver St 1 Front Yard : Yard Tree Private 2       3x3   6002763 2106816 37.765071454108 -122.433658549479 (37.765071454108, -122.433658549479) 15 5 5 28862 3
122758 121144 Property Tree 8 Pinus radiata :: Monterey Pine 15 400 Franconia St 1 Back Yard : Yard Tree Private 2     15 3x3   6010016 2098808 37.7434921454983 -122.408007311669 (37.7434921454983, -122.408007311669) 2 7 7 28859 2
124062 102101 Property Tree 8 Cordyline australis :: Dracena Palm 64 331 Vernon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.7184923011832 -122.468164197766 (37.7184923011832, -122.468164197766) 9 8 6 64 24
124235 122518 Property Tree 8 Pinus radiata :: Monterey Pine 15 772X Panorama Dr 1 Back Yard : Cutout Tree Private 2       3x3   5996713 2102901 37.7539767153501 -122.45430108189 (37.7539767153501, -122.45430108189) 1 5 4 63 38
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
131293 254124 Property Tree 8 Pinus radiata :: Monterey Pine 15 365 Edgehill Way 1 Back Yard : Cutout Tree Private 2       3x3   5994964 2098864 37.7427916745102 -122.460057057879 (37.7427916745102, -122.460057057879) 1 8 4 59 40
131954 110939 Property Tree 8 Pinus radiata :: Monterey Pine 15 38 SAINT CHARLES AVE 1 Back Yard : Cutout Tree Private 2     30 3x3   5992046 2088201 37.7133454608488 -122.46937060641 (37.7133454608488, -122.46937060641) 9 8 6 64 24
134313 255008 Property Tree 8 Pittosporum undulatum :: Victorian Box 36 1 Villa Ter 1 Back Yard : Yard Tree Private 2       3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
140802 33786 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
145213 256660 Property Tree 8 Private shrub :: Private Shrub 284 40X Miguel St 1 Back Yard : Yard Landscaping Private 2       3x3   6003624 2097154 37.7385906898162 -122.429991281012 (37.7385906898162, -122.429991281012) 2 7 5 63 7
148738 252848 Property Tree 8 Pinus halepensis :: Allepo Pine 330 99 Reposa Way 1 Back Yard : Yard Tree Private 2       3x3   5998022 2098104 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965) 9 7 4 59 40
159644 120526 Property Tree 8 Pinus radiata :: Monterey Pine 15 1439 47th Ave 1 Back Yard : Yard Tree Private 2     20 3x3   5981489 2105275 37.7596102388302 -122.50712446854 (37.7596102388302, -122.50712446854) 1 8 3 56 35
161514 253207 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 89 Woodhaven Ct 1 Back Yard : Cutout Tree Private 2       3x3   5996069 2103645 37.7559825991437 -122.456581972884 (37.7559825991437, -122.456581972884) 1 5 4 63 12
163103 33791 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
163643 253143 Property Tree 8 Juniperus silicicola :: Southern red cedar 429 735 29th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
166769 102079 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 76 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936) 2 7 7 28859 2
167692 33790 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
173830 98139 Property Tree 8 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 556 Laidley St   Back Yard : Yard Tree Private 2       3x3   6003085 2096041 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062) 2 7 5 63 7
176576 257935 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
178160 173600 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 500 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996184 2102497 37.7528370823128 -122.456101271869 (37.7528370823128, -122.456101271869) 1 5 4 63 12
183366 251343 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 934 Brannan St 1 Back Yard : Yard Tree Private 2       3x3   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
183601 256482 Property Tree 8 Pinus radiata :: Monterey Pine 15 168 Moultrie St 1 Back Yard : Cutout Tree Private 2       3x3   6007766 2098288 37.7419381097545 -122.415750458671 (37.7419381097545, -122.415750458671) 2 7 7 28859 2
185435 33788 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
185468 120977 Property Tree 8 Pinus radiata :: Monterey Pine 15 794x Gates St 1 Sidewalk: Curb side : Yard Tree Private 2     3030 3x3   6008103 2095407 37.7340464539486 -122.414381414226 (37.7340464539486, -122.414381414226) 2 7 7 28859 2
189109 120533 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 951 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   6010745 2108673 37.7706200263658 -122.406181480785 (37.7706200263658, -122.406181480785) 14 2 9 28853 34
194103 109076 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
39981 256672 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 Kenwood Way 11 Back Yard : Yard Tree Private 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
28314 256608 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 2 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
80950 255115 Property Tree 8 Lophostemon confertus :: Brisbane Box 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
87678 254111 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 1 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89692 122453 Property Tree 8 Pinus radiata :: Monterey Pine 15 217 San Marcos Ave 1 Back Yard : Yard Tree Private 2       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209) 1 8 4 29491 40
104559 254162 Property Tree 8 Pinus radiata :: Monterey Pine 15 301X Chester Ave 1 Back Yard : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34

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