6,344 rows where qSpecies_id = 19 sorted by qCareAssistant

View and edit SQL

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)
33 261067 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1832 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2020 12:00:00 AM 3 4x6 Permit Number 782484 6011934 2092960 37.727541965346 -122.400964507068 (37.727541965346, -122.400964507068) 10 3 8 58 1
70 264978 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1439 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2020 12:00:00 AM 3 3x3 Permit Number 787884 5989892.86343 2105570.52868 37.7609130564186 -122.47808163393 (37.7609130564186, -122.47808163393) 1 8 3 56 35
76 34164 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2500 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM 5   Permit Number 38230 6001594.91074 2117340.13182 37.7939017096586 -122.438452751501 (37.7939017096586, -122.438452751501) 13 9 1 57 27
201 229505 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Church St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004360.58946 2103177.16015 37.7551705836636 -122.427873571204 (37.7551705836636, -122.427873571204) 2 4 5 28862 22
337 193188 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 401 Harrison St 6 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6014838.37703 2114321.79559 37.7863584598262 -122.392417493778 (37.7863584598262, -122.392417493778) 6 2 9 28855 6
355 229322 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2771 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6009868 2101202 37.7500572563342 -122.408687913648 (37.7500572563342, -122.408687913648) 2 4 7 28859 19
382 34903 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
493 193117 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1789 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6014368.11598 2096649.52963 37.737808141841 -122.39280769162 (37.737808141841, -122.39280769162) 10 3 8 58 1
500 230695 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 174 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003158.12549 2105079.13528 37.7603248546353 -122.432167861868 (37.7603248546353, -122.432167861868) 2 4 5 28862 3
510 138618 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1844 BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000524.7294 2115065.5231 37.787595296239 -122.441992330061 (37.787595296239, -122.441992330061) 13 6 1 29490 27
569 112652 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 3100X 26TH ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008747 2100981 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695) 2 4 7 28859 19
598 142905 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 577 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010143.121 2119878.0324 37.8013526887848 -122.409054146394 (37.8013526887848, -122.409054146394) 3 1 10 308 23
606 230121 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 34 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005876.28529 2103471.2527 37.7560637219709 -122.422652741428 (37.7560637219709, -122.422652741428) 2 4 5 28859 19
867 130823 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2451 Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004083.73489 2117213.2991 37.7936947127019 -122.429832130065 (37.7936947127019, -122.429832130065) 13 9 1 29490 27
879 229569 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 129 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997890.05734 2106786.37745 37.7647124175658 -122.450510642978 (37.7647124175658, -122.450510642978) 15 5 11 29492 9
924 168125 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2329 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999732.18095 2116962.81225 37.7927595589676 -122.444870818143 (37.7927595589676, -122.444870818143) 13 6 1 29490 27
1118 36625 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
1184 138898 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 640 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004115.5085 2110637.0852 37.7756398749162 -122.429253045645 (37.7756398749162, -122.429253045645) 7 9 11 28852 10
1219 122783 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 424 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006739 2101281 37.7500984250046 -122.419513794578 (37.7500984250046, -122.419513794578) 2 4 7 28859 19
1278 170724 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 540 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000352.85514 2092916.82872 37.7267706040626 -122.440997412 (37.7267706040626, -122.440997412) 9 7 6 28861 25
1296 114159 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.7953963109343 -122.434341453993 (37.7953963109343, -122.434341453993) 13 9 1 57 17
1344 230660 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3881 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003952.37271 2101858.52195 37.751526811317 -122.429191284844 (37.751526811317, -122.429191284844) 2 4 5 28862 22
1369 229980 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 542 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1982 12:00:00 AM 15 Width 3ft Permit Number 19660 6003257.39485 2095864.57819 37.735029463323 -122.431166815702 (37.735029463323, -122.431166815702) 2 7 5 63 7
1398 20032 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 100 STAIRWAY51 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3ST                      
1407 177359 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 282 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003626.27943 2092029.25547 37.724519425612 -122.429618004189 (37.724519425612, -122.429618004189) 9 7 6 28861 5
1463 229983 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 568 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1982 12:00:00 AM 15 Width 2ft Permit Number 19661 6003129.34202 2095763.1248 37.7347436380916 -122.431602298905 (37.7347436380916, -122.431602298905) 2 7 5 63 7
1464 130824 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2451 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004088.29924 2117192.3041 37.7936373242572 -122.429814838808 (37.7936373242572, -122.429814838808) 13 9 1 29490 27
1586 229909 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 807 Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001288.79481 2101656.59827 37.7508212320121 -122.438387781783 (37.7508212320121, -122.438387781783) 2 4 5 28862 22
1682 3092 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2980 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000114.43818 2115142.33295 37.7877828069853 -122.443417371621 (37.7877828069853, -122.443417371621) 13 6 1 29490 27
1749 5395 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 347 Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/08/2014 12:00:00 AM 3 6x6   6004924.31069 2106310.22613 37.7638051176279 -122.426147093211 (37.7638051176279, -122.426147093211) 8 4 5 28859 19
1761 193283 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1628 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007524.2032 2108954.2313 37.7712115401103 -122.417342217788 (37.7712115401103, -122.417342217788) 8 2 9 28853 19
1993 230761 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 240 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001081.17206 2104997.55986 37.7599828919108 -122.43934520993 (37.7599828919108, -122.43934520993) 2 4 5 28862 3
2024 190143 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1200 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 10:47:00 AM 3 Width 4ft   6017523.52148 2096815.65975 37.7384390567147 -122.381909364434 (37.7384390567147, -122.381909364434) 10 3 8 58 1
2065 849 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 109X POTRERO AVE 8 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM 36 3x3 Permit Number 777000 6010279 2107809 37.7682216042911 -122.407732456911 (37.7682216042911, -122.407732456911) 8 4 8 28853 19
2078 168123 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2329 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999728.56043 2116992.74288 37.792841533961 -122.444885497769 (37.792841533961, -122.444885497769) 13 6 1 29490 27
2140 46192 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   6 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2272 230809 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3810 20th St 8 Sidewalk: Curb side : Yard Tree Private 2     28 Width 3ft   6004611.63281 2104276.64637 37.7582037127468 -122.427083697555 (37.7582037127468, -122.427083697555) 2 4 5 28862 3
2301 230508 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3150X 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008646.92599 2100993.40112 37.7494160242499 -122.412895723159 (37.7494160242499, -122.412895723159) 2 4 7 28859 19
2329 248481 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 771 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999055.2186 2107891.4924 37.7678134046704 -122.446560186722 (37.7678134046704, -122.446560186722) 15 5 11 29492 9
2353 229453 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 500 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004612.82375 2110259.96619 37.7746325395952 -122.427505836641 (37.7746325395952, -122.427505836641) 7 9 11 28852 10
2390 143239 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 986 POLK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6006984.4971 2114185.2189 37.7855441907656 -122.41958028036 (37.7855441907656, -122.41958028036) 13 9 9 28858 36
2415 153966 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1275 Fairfax Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6017369.99484 2096847.10054 37.7385169074393 -122.382442377325 (37.7385169074393, -122.382442377325) 10 3 8 58 1
2439 152111 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 61 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x5   6006504.58335 2108147.23788 37.7689383093717 -122.420811828315 (37.7689383093717, -122.420811828315) 8 4 7 28853 19
2486 230212 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 176 States St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2015 12:00:00 AM 3 Width 3ft   6001156.11314 2106298.81983 37.7635600973444 -122.439179292201 (37.7635600973444, -122.439179292201) 15 5 5 28862 3
2488 142324 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1773 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5999334.4877 2110458.6226 37.7748780407761 -122.44577887398 (37.7748780407761, -122.44577887398) 15 5 11 29492 16
2498 230703 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 230 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003998.71516 2105716.62151 37.7621228628946 -122.42930611389 (37.7621228628946, -122.42930611389) 8 4 5 28862 3
2520 229926 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 601 Alvarado St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6002393.13839 2102647.73661 37.7536054152682 -122.434639730348 (37.7536054152682, -122.434639730348) 2 4 5 28862 22
2590 3930 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 100X Castro St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/24/2014 07:47:00 AM 3 4x4   6002189.24503 2107585.41749 37.7671515138645 -122.435698075908 (37.7671515138645, -122.435698075908) 15 5 5 28862 3
2594 177351 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 501X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2020 12:07:00 PM 3 Width 3ft Permit Number 48612 6000375.5599 2092850.31101 37.7265892548896 -122.440914152761 (37.7265892548896, -122.440914152761) 9 7 6 28861 25
2609 10168 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1025 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6005769.33975 2102766.2906 37.7541220254375 -122.422972492697 (37.7541220254375, -122.422972492697) 2 4 5 28859 19
2668 85700 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 918 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2020 12:00:00 AM 3 3x3   6010976.81813 2112473.48761 37.7810682491478 -122.405647340366 (37.7810682491478, -122.405647340366) 14 2 9 28853 34
2701 246408 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 153 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003537.9846 2107412.8853 37.7667542995576 -122.431020673856 (37.7667542995576, -122.431020673856) 7 9 5 28862 3
2786 208603 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 330 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   5996564.3769 2106988.87425 37.7651924567906 -122.455110430599 (37.7651924567906, -122.455110430599) 15 5 11 29492 12
2828 81279 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2294 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52532 5986721.5097 2099657.5798 37.7444931137009 -122.488615192328 (37.7444931137009, -122.488615192328) 1 8 3 29491 35
2840 208818 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 204 Acadia St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001433.86045 2094986.8847 37.7325160147058 -122.437408581945 (37.7325160147058, -122.437408581945) 9 7 5 63 40
2848 230823 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 4328 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6001534.87211 2105281.58352 37.7607885603698 -122.43779642627 (37.7607885603698, -122.43779642627) 15 4 5 28862 3
2933 192982 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1135 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6011684.46525 2103085.46172 37.755330400403 -122.402538867895 (37.755330400403, -122.402538867895) 10 3 8 28856 29
2938 193145 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 555 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013012.05406 2115204.53124 37.7886806595304 -122.398798121635 (37.7886806595304, -122.398798121635) 12 2 9 28855 6
2943 177371 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 49 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003790.41241 2094032.67984 37.7300296743254 -122.429193404555 (37.7300296743254, -122.429193404555) 9 7 6 28861 5
2992 187489 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 700 Velasco Ave 5 Front Yard : Yard Tree Private 2     3     6006684.44019 2086612.84014 37.7098197873211 -122.418662398253 (37.7098197873211, -122.418662398253) 9 7 8 309 39
3006 130736 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2456 Broderick St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000252.0898 2117051.94751 37.793033958294 -122.443078320911 (37.793033958294, -122.443078320911) 13 6 1 29490 27
3029 181658 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1285 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5987371.0004 2106539.9848 37.7634282140159 -122.486874731079 (37.7634282140159, -122.486874731079) 1 8 3 56 35
3063 192918 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009145.73706 2109144.68728 37.7718255855015 -122.411746706156 (37.7718255855015, -122.411746706156) 8 2 9 28853 34
3139 130835 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2707 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6003954.12542 2118159.05361 37.7962841720447 -122.430348098084 (37.7962841720447, -122.430348098084) 13 9 1 57 17
3209 130852 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2400 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6004581.36981 2117470.78611 37.7944298743033 -122.42812862796 (37.7944298743033, -122.42812862796) 13 9 1 28858 27
3248 85701 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 926 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2020 12:00:00 AM 3 3x3   6010962.65697 2112458.52521 37.781026374014 -122.405695276931 (37.781026374014, -122.405695276931) 14 2 9 28853 34
3258 130902 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 810 Mason St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009606.05045 2116280.73796 37.7914452987052 -122.410658473411 (37.7914452987052, -122.410658473411) 5 1 10 28857 21
3304 29846 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 11 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014879.93963 2099132.42343 37.7446540699209 -122.391211560464 (37.7446540699209, -122.391211560464) 10 3 8 58 1
3307 235079 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 109 Frederick St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5999446.97548 2107694.45371 37.7672947551641 -122.44519098308 (37.7672947551641, -122.44519098308) 15 5 5 29492 9
3340 192835 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 333 03rd St 5 : Tree Private 2     1 Width 2ft   6013082.87743 2113319.47205 37.7835086710412 -122.398420759824 (37.7835086710412, -122.398420759824) 6 2 9 28856 6
3365 46090 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 100 19th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2001 12:00:00 AM     Permit Number 44465 5989930.31260509 2114699.05014668 37.7859796419382 -122.478619707642 (37.7859796419382, -122.478619707642) 11 6 2 55 26
3378 230766 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 194 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000059.54509 2104891.85845 37.7596344702783 -122.442870922879 (37.7596344702783, -122.442870922879) 2 4 5 28862 3
3381 258768 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1511 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015807.577 2096620.6892 37.7378087983482 -122.38782872013 (37.7378087983482, -122.38782872013) 10 3 8 58 1
3411 138551 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2130 POST ST 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6002005.3272 2114004.2448 37.784765558283 -122.436793761521 (37.784765558283, -122.436793761521) 13 6 11 29490 13
3414 262418 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
3434 193308 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1500 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2017 12:00:00 AM 3 Width 4ft   6016349.7682 2097340.57346 37.7398154754097 -122.386004251994 (37.7398154754097, -122.386004251994) 10 3 8 58 1
3497 46195 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3514 236494 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 330 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3   6008239.85381 2097040.27643 37.7385387618647 -122.414023771603 (37.7385387618647, -122.414023771603) 2 7 7 28859 2
3524 142455 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1612 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000105.7777 2110265.4989 37.7743917798743 -122.443096955102 (37.7743917798743, -122.443096955102) 15 5 11 29492 16
3531 39973 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 0 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
3661 130497 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3536 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000731.95465 2120687.25683 37.8030429054598 -122.441678975811 (37.8030429054598, -122.441678975811) 13 9 1 57 17
3816 229732 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2749 Harrison St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   6008964.54646 2102425.01611 37.7533647423057 -122.411898531501 (37.7533647423057, -122.411898531501) 2 4 7 28859 19
3833 130643 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2596 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002472.36463 2115758.47109 37.7896087481804 -122.435303491175 (37.7896087481804, -122.435303491175) 13 9 1 29490 27
3892 39976 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 0 Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
3950 230064 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 501 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007631.21664 2095734.29453 37.7349186191825 -122.416035690789 (37.7349186191825, -122.416035690789) 2 7 7 28859 2
3965 141553 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 59 KITTREDGE TER 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5997973.788 2111391.0975 37.7773605902541 -122.450553037974 (37.7773605902541, -122.450553037974) 15 6 2 54 16
4003 193246 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 843 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011569.59394 2112947.98567 37.7824042397005 -122.40363001712 (37.7824042397005, -122.40363001712) 6 2 9 28853 34
4013 264857 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
4018 230535 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3470 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007100.85634 2104416.17044 37.7587272602842 -122.418484755192 (37.7587272602842, -122.418484755192) 2 4 7 28859 19
4024 114160 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.434397600465 (37.7953804657925, -122.434397600465) 13 9 1 57 17
4058 34900 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
4243 162646 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
4264 130484 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 148 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002643.1953 2119039.17059 37.7986264014436 -122.434947157292 (37.7986264014436, -122.434947157292) 13 9 1 57 17
4277 192886 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2 Rizal St 7 : Tree Private 2     9 Width 3ft   6012771.99776 2112717.29257 37.7818379024256 -122.399453999917 (37.7818379024256, -122.399453999917) 6 2 9 28856 34
4332 30435 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 3229 Barker St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM     Permit Number 88                    
4387 264910 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1615 Wallace Ave 1 Front Yard : Cutout Tree Private 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
4515 130841 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2140 Pacific Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6003916.87009 2117324.15419 37.7939896417495 -122.430417409747 (37.7939896417495, -122.430417409747) 13 9 1 29490 27
4555 130513 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 213 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5998527.12413 2115621.30489 37.7890072896931 -122.448943670531 (37.7890072896931, -122.448943670531) 13 6 1 54 31
4575 29055 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 400X 11th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/2005 12:00:00 AM 3 3x3   6008920.1536798 2108682.7358637 37.7705445174102 -122.412494357701 (37.7705445174102, -122.412494357701) 8 2 9 28853 19
4626 5513 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 821 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2002 12:00:00 AM 18 5X5   6005073.13796 2103547.17923 37.7562268536034 -122.425435698922 (37.7562268536034, -122.425435698922) 2 4 5 28859 19

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