trees
6,344 rows where qSpecies_id = 19 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
5545 | 130743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2505 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6000699.35516 | 2116964.23908 | 37.7928186255236 | -122.441524465083 | (37.7928186255236, -122.441524465083) | 13 | 6 | 1 | 29490 | 27 | |||
7224 | 230106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Montezuma St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007653.59945 | 2099775.01516 | 37.7460148026546 | -122.416244399181 | (37.7460148026546, -122.416244399181) | 2 | 7 | 7 | 28859 | 2 | |||
9477 | 193012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013566.4311 | 2097855.47673 | 37.7410748608127 | -122.395663996006 | (37.7410748608127, -122.395663996006) | 10 | 3 | 8 | 58 | 1 | |||
10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
10345 | 177314 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002705.04854 | 2090582.53455 | 37.7204948470285 | -122.432699277554 | (37.7204948470285, -122.432699277554) | 9 | 7 | 6 | 28861 | 5 | |||
12684 | 124078 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 701 Funston Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991927.57036 | 2110249.98447 | 37.7738794837524 | -122.471385513439 | (37.7738794837524, -122.471385513439) | 11 | 6 | 2 | 54 | 11 | ||||
13367 | 132936 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6003117.4123 | 2117569.74013 | 37.794618639305 | -122.433201167605 | (37.794618639305, -122.433201167605) | 13 | 9 | 1 | 29490 | 27 | |||
13914 | 130707 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2878 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999875.30316 | 2117112.77625 | 37.7931794874933 | -122.444386392923 | (37.7931794874933, -122.444386392923) | 13 | 9 | 1 | 57 | 27 | |||
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
14523 | 130701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2897 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999786.03622 | 2117022.81208 | 37.7929273760386 | -122.444688791774 | (37.7929273760386, -122.444688791774) | 13 | 9 | 1 | 29490 | 27 | |||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
17570 | 130747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6000754.11446 | 2117108.3848 | 37.7932175315164 | -122.441345343526 | (37.7932175315164, -122.441345343526) | 13 | 6 | 1 | 29490 | 27 | |||
19820 | 130770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2780 Vallejo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6000266.86927 | 2117513.67047 | 37.7943025707535 | -122.44306035785 | (37.7943025707535, -122.44306035785) | 13 | 9 | 1 | 57 | 27 | |||
21000 | 177315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002661.25858 | 2090511.24379 | 37.7202966148776 | -122.432845554988 | (37.7202966148776, -122.432845554988) | 9 | 7 | 6 | 28861 | 5 | |||
21413 | 130451 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000640.0525 | 2117925.65091 | 37.7954550312843 | -122.441798686384 | (37.7954550312843, -122.441798686384) | 13 | 9 | 1 | 57 | 17 | |||
21758 | 103918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
22251 | 249605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998732.40134 | 2111478.39717 | 37.7776436838383 | -122.447935044877 | (37.7776436838383, -122.447935044877) | 15 | 6 | 2 | 54 | 16 | |||
23638 | 130929 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1050 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6006268.36625 | 2120777.17306 | 37.8036036786362 | -122.422526464039 | (37.8036036786362, -122.422526464039) | 5 | 9 | 1 | 28858 | 32 | |||
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
25384 | 130843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2140 Pacific Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003869.85005 | 2117317.48489 | 37.7939686659649 | -122.43057962765 | (37.7939686659649, -122.43057962765) | 13 | 9 | 1 | 29490 | 27 | |||
25744 | 130450 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000641.55271 | 2117919.6901 | 37.7954387499501 | -122.441793067403 | (37.7954387499501, -122.441793067403) | 13 | 9 | 1 | 57 | 17 | |||
27686 | 208660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 451 Hearst Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5998589.90723 | 2094352.40559 | 37.7306117919987 | -122.447195121356 | (37.7306117919987, -122.447195121356) | 9 | 7 | 4 | 28861 | 40 | |||
28492 | 208698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992075.90201 | 2088383.47737 | 37.713848227595 | -122.469280529167 | (37.713848227595, -122.469280529167) | 9 | 8 | 6 | 64 | 24 | |||
28556 | 130702 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2897 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5999808.18764 | 2117027.13994 | 37.7929405232326 | -122.444612458193 | (37.7929405232326, -122.444612458193) | 13 | 9 | 1 | 29490 | 27 | |||
28738 | 130752 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2692 Broadway | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000784.08782 | 2117161.81389 | 37.7933659412357 | -122.441245469319 | (37.7933659412357, -122.441245469319) | 13 | 9 | 1 | 29490 | 27 | |||
29457 | 130693 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2332 Baker St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999784.20316 | 2116989.05162 | 37.7928345741144 | -122.444692706526 | (37.7928345741144, -122.444692706526) | 13 | 6 | 1 | 29490 | 27 | |||
32428 | 130757 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2692 Broadway | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000846.06388 | 2117169.90123 | 37.7933916771221 | -122.441031608748 | (37.7933916771221, -122.441031608748) | 13 | 9 | 1 | 29490 | 27 | |||
34197 | 208827 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 494 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 5998253.80109 | 2095287.46641 | 37.7331600372071 | -122.448424398367 | (37.7331600372071, -122.448424398367) | 9 | 7 | 4 | 59 | 40 | ||||
34244 | 208692 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992715.18147 | 2091115.28005 | 37.7213860176206 | -122.467269473301 | (37.7213860176206, -122.467269473301) | 9 | 8 | 6 | 64 | 24 | |||
34507 | 130744 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6000756.03377 | 2117079.91374 | 37.7931394667743 | -122.441336658784 | (37.7931394667743, -122.441336658784) | 13 | 6 | 1 | 29490 | 27 | |||
34705 | 130755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2692 Broadway | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000824.66047 | 2117166.59628 | 37.7933813834962 | -122.441105428686 | (37.7933813834962, -122.441105428686) | 13 | 9 | 1 | 29490 | 27 | |||
35236 | 130703 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2897 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5999825.46856 | 2117028.47056 | 37.792945162835 | -122.444552761197 | (37.792945162835, -122.444552761197) | 13 | 9 | 1 | 29490 | 27 | |||
35268 | 130847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2619 Octavia St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6004415.06873 | 2118278.49005 | 37.7966382126449 | -122.428761657123 | (37.7966382126449, -122.428761657123) | 13 | 9 | 1 | 57 | 17 | |||
37028 | 130696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2332 Baker St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5999779.55905 | 2117010.55379 | 37.7928933483891 | -122.444710321537 | (37.7928933483891, -122.444710321537) | 13 | 6 | 1 | 29490 | 27 | |||
37234 | 250755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2930 Lake St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5986296.61932 | 2114541.51737 | 37.7853354602953 | -122.491179523725 | (37.7853354602953, -122.491179523725) | 11 | 6 | 1 | 55 | 33 | |||
39879 | 177340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1705 San Jose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001501.14438 | 2094151.47949 | 37.7302260089086 | -122.437116174588 | (37.7302260089086, -122.437116174588) | 9 | 7 | 6 | 28861 | 25 | |||
42314 | 177337 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 Morningside Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5985552.21468 | 2094749.49981 | 37.730948533249 | -122.492296977222 | (37.730948533249, -122.492296977222) | 1 | 8 | 4 | 64 | 35 | |||
42443 | 177310 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 8 Seminole Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5999325.72656 | 2089990.15999 | 37.7186760905062 | -122.444337923973 | (37.7186760905062, -122.444337923973) | 9 | 7 | 6 | 28861 | 25 | |||
45169 | 130675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3000 Jackson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999776.06377 | 2116420.42071 | 37.7912727988584 | -122.444679979296 | (37.7912727988584, -122.444679979296) | 13 | 6 | 1 | 29490 | 27 | |||
45640 | 201340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012714.10336 | 2092626.08619 | 37.7266685912663 | -122.398244248089 | (37.7266685912663, -122.398244248089) | 10 | 3 | 8 | 58 | 1 | ||||
47588 | 192980 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 706 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012085.32121 | 2105070.03534 | 37.7608019728409 | -122.401292034298 | (37.7608019728409, -122.401292034298) | 10 | 3 | 8 | 28856 | 29 | ||||
48347 | 130453 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000637.63214 | 2117939.44774 | 37.7954927758367 | -122.441808051905 | (37.7954927758367, -122.441808051905) | 13 | 9 | 1 | 57 | 17 | |||
48558 | 208664 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 462 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998358.74509 | 2094413.2873 | 37.7307657478333 | -122.447998662027 | (37.7307657478333, -122.447998662027) | 9 | 7 | 4 | 59 | 40 | ||||
48682 | 130713 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2880 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999861.09704 | 2117109.69163 | 37.7931702073929 | -122.44443532504 | (37.7931702073929, -122.44443532504) | 13 | 9 | 1 | 57 | 27 | |||
49270 | 130749 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6000751.3477 | 2117126.2512 | 37.7932664303608 | -122.441356199238 | (37.7932664303608, -122.441356199238) | 13 | 6 | 1 | 29490 | 27 | |||
51054 | 130751 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2692 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6000773.36667 | 2117159.22444 | 37.7933582205658 | -122.441282379285 | (37.7933582205658, -122.441282379285) | 13 | 9 | 1 | 29490 | 27 | |||
51345 | 122814 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1648x York St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/29/2016 12:00:00 AM | 3 | 3x3 | 6010545 | 2100072 | 37.7469924183851 | -122.406267191996 | (37.7469924183851, -122.406267191996) | 2 | 7 | 7 | 28859 | 2 | ||
52171 | 130592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3299 Baker St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999274.24312 | 2120194.36104 | 37.8016063841789 | -122.446687914526 | (37.8016063841789, -122.446687914526) | 13 | 9 | 1 | 57 | 17 | |||
52268 | 208807 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 465 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995478.87513 | 2095402.03061 | 37.7333155569589 | -122.458026289878 | (37.7333155569589, -122.458026289878) | 9 | 7 | 4 | 59 | 40 | |||
52931 | 208687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 395 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991938.37587 | 2091181.64136 | 37.7215233557961 | -122.469959478655 | (37.7215233557961, -122.469959478655) | 9 | 8 | 6 | 64 | 24 | |||
53846 | 130586 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4 Charlton Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 4ft | 6003663.86314 | 2118487.91826 | 37.7971707039232 | -122.431375953045 | (37.7971707039232, -122.431375953045) | 13 | 9 | 1 | 57 | 17 | |||
54393 | 208675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 170 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998945.61582 | 2093811.25675 | 37.7291462424042 | -122.445926481947 | (37.7291462424042, -122.445926481947) | 9 | 7 | 4 | 28861 | 40 | ||||
54610 | 193006 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013524.80106 | 2097799.85374 | 37.7409198159039 | -122.395804042044 | (37.7409198159039, -122.395804042044) | 10 | 3 | 8 | 58 | 1 | |||
55428 | 192998 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013640.58193 | 2097957.11926 | 37.74135807441 | -122.395414726402 | (37.74135807441, -122.395414726402) | 10 | 3 | 8 | 58 | 1 | |||
57620 | 130689 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2332 Baker St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999793.00019 | 2116922.39838 | 37.7926520638797 | -122.444657475568 | (37.7926520638797, -122.444657475568) | 13 | 6 | 1 | 29490 | 27 | |||
60202 | 208828 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5998172.90509 | 2095504.48065 | 37.7337512811885 | -122.448719701551 | (37.7337512811885, -122.448719701551) | 9 | 7 | 4 | 59 | 40 | |||
63147 | 208832 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 442 Circular Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999778.07128 | 2093728.8817 | 37.7289675587946 | -122.443042710459 | (37.7289675587946, -122.443042710459) | 9 | 7 | 4 | 63 | 40 | ||||
63766 | 130844 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2140 Pacific Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003853.59975 | 2117314.84912 | 37.7939605082153 | -122.430635667118 | (37.7939605082153, -122.430635667118) | 13 | 9 | 1 | 29490 | 27 | |||
63937 | 230205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 106 Saturn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000016.25171 | 2105983.08898 | 37.7626282513032 | -122.443099023316 | (37.7626282513032, -122.443099023316) | 15 | 5 | 5 | 28862 | 3 | |||
65568 | 130939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1059 Vallejo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6008473.87293 | 2118598.50668 | 37.7977457789976 | -122.414739899931 | (37.7977457789976, -122.414739899931) | 5 | 1 | 10 | 308 | 21 | |||
65933 | 193003 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013679.75792 | 2098005.28913 | 37.7414925176543 | -122.395282642077 | (37.7414925176543, -122.395282642077) | 10 | 3 | 8 | 58 | 1 | |||
67649 | 130745 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000755.97288 | 2117092.09991 | 37.7931729233386 | -122.441337744262 | (37.7931729233386, -122.441337744262) | 13 | 6 | 1 | 29490 | 27 | |||
68046 | 130714 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2880 Broadway | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999842.66795 | 2117107.53981 | 37.7931632475384 | -122.444498935903 | (37.7931632475384, -122.444498935903) | 13 | 9 | 1 | 57 | 27 | |||
68609 | 192999 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013665.72254 | 2097988.38117 | 37.7414453113422 | -122.395329987788 | (37.7414453113422, -122.395329987788) | 10 | 3 | 8 | 58 | 1 | |||
68715 | 193011 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013575.88043 | 2097868.72965 | 37.7411117761863 | -122.395632251741 | (37.7411117761863, -122.395632251741) | 10 | 3 | 8 | 58 | 1 | |||
69179 | 130748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000753.05451 | 2117117.77983 | 37.7932432674277 | -122.441349685447 | (37.7932432674277, -122.441349685447) | 13 | 6 | 1 | 29490 | 27 | |||
69892 | 130746 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000755.18115 | 2117099.3021 | 37.7931926535653 | -122.441341000707 | (37.7931926535653, -122.441341000707) | 13 | 6 | 1 | 29490 | 27 | |||
73093 | 208831 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 155 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999047.28286 | 2093764.30963 | 37.7290231413879 | -122.445571637337 | (37.7290231413879, -122.445571637337) | 9 | 7 | 4 | 28861 | 40 | ||||
73116 | 177313 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6002728.18448 | 2090617.99941 | 37.7205935377418 | -122.432621836053 | (37.7205935377418, -122.432621836053) | 9 | 7 | 6 | 28861 | 5 | |||
74593 | 130754 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2692 Broadway | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6000812.4038 | 2117165.60067 | 37.7933779516739 | -122.441147766074 | (37.7933779516739, -122.441147766074) | 13 | 9 | 1 | 29490 | 27 | |||
74596 | 208810 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 210 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5996333.27865 | 2096192.61314 | 37.7355353589738 | -122.455129507936 | (37.7355353589738, -122.455129507936) | 9 | 7 | 4 | 59 | 40 | |||
75465 | 100192 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 62 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x6 | 6000448 | 2095531 | 37.7339539318334 | -122.440855946438 | (37.7339539318334, -122.440855946438) | 9 | 7 | 5 | 63 | 40 | ||||
76529 | 177343 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1705 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6001559.05455 | 2094165.73323 | 37.7302684380183 | -122.436916991836 | (37.7302684380183, -122.436916991836) | 9 | 7 | 6 | 28861 | 25 | |||
76603 | 130572 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3100 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999066.12179 | 2119437.50271 | 37.7995163642449 | -122.447353599888 | (37.7995163642449, -122.447353599888) | 13 | 9 | 1 | 57 | 17 | |||
77171 | 130452 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000638.04444 | 2117933.23994 | 37.7954757543447 | -122.441806179526 | (37.7954757543447, -122.441806179526) | 13 | 9 | 1 | 57 | 17 | |||
77579 | 130687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2332 Baker St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999796.25439 | 2116902.05149 | 37.7925963823766 | -122.444644752851 | (37.7925963823766, -122.444644752851) | 13 | 6 | 1 | 29490 | 27 | |||
77656 | 122815 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1648x York St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/29/2016 12:00:00 AM | 3 | 3x3 | 6010545 | 2100072 | 37.7469924183851 | -122.406267191996 | (37.7469924183851, -122.406267191996) | 2 | 7 | 7 | 28859 | 2 | ||
77963 | 201342 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bitting Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6012732.15495 | 2092620.25423 | 37.7266535833942 | -122.398181434938 | (37.7266535833942, -122.398181434938) | 10 | 3 | 8 | 58 | 1 | ||||
78590 | 130456 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000631.42489 | 2117979.46855 | 37.7956023087551 | -122.441832403743 | (37.7956023087551, -122.441832403743) | 13 | 9 | 1 | 57 | 17 | |||
78901 | 130674 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3000 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999790.09601 | 2116421.81228 | 37.7912774204711 | -122.444631528338 | (37.7912774204711, -122.444631528338) | 13 | 6 | 1 | 29490 | 27 | |||
81215 | 177358 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 25 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6005142.85219 | 2093319.57992 | 37.7281481289271 | -122.424467146157 | (37.7281481289271, -122.424467146157) | 9 | 7 | 6 | 28861 | 5 | ||||
81386 | 130673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2201 Baker St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999792.86572 | 2116462.14587 | 37.7913883239543 | -122.44462484546 | (37.7913883239543, -122.44462484546) | 13 | 6 | 1 | 29490 | 27 | |||
82163 | 130715 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2880 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999827.63697 | 2117105.59874 | 37.7931570602113 | -122.444550804278 | (37.7931570602113, -122.444550804278) | 13 | 9 | 1 | 57 | 27 | |||
82862 | 119125 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5981604.24423 | 2111607.23903 | 37.7770035165843 | -122.507195675426 | (37.7770035165843, -122.507195675426) | 11 | 6 | 2 | 55 | 26 | |||
83881 | 130676 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3000 Jackson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999769.49778 | 2116418.15307 | 37.7912661978305 | -122.44470253431 | (37.7912661978305, -122.44470253431) | 13 | 6 | 1 | 29490 | 27 | |||
85451 | 130777 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2646 Pierce St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6001675.65352 | 2117448.49941 | 37.7942038512832 | -122.438181140948 | (37.7942038512832, -122.438181140948) | 13 | 9 | 1 | 57 | 27 | |||
88713 | 130768 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2750 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000658.4228 | 2117791.69742 | 37.7950882769533 | -122.441725504023 | (37.7950882769533, -122.441725504023) | 13 | 9 | 1 | 57 | 27 | |||
89392 | 130750 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2560 Divisadero St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000749.66032 | 2117135.65891 | 37.7932921653448 | -122.441362713021 | (37.7932921653448, -122.441362713021) | 13 | 6 | 1 | 29490 | 27 | |||
90415 | 124230 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 Paramount Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 5996657.38111 | 2111061.58218 | 37.7763803929944 | -122.455083075411 | (37.7763803929944, -122.455083075411) | 11 | 6 | 2 | 54 | 16 | |||
90622 | 130740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2505 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6000693.67656 | 2117008.09774 | 37.7929387264039 | -122.441547262008 | (37.7929387264039, -122.441547262008) | 13 | 6 | 1 | 29490 | 27 | |||
90696 | 130494 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3636 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999178.80483 | 2121342.50895 | 37.8047534357904 | -122.447100848119 | (37.8047534357904, -122.447100848119) | 13 | 9 | 1 | 57 | 17 | |||
91013 | 130457 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000629.31438 | 2117995.14587 | 37.7956452342896 | -122.441840832198 | (37.7956452342896, -122.441840832198) | 13 | 9 | 1 | 57 | 17 | |||
91432 | 193000 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013704.26945 | 2098039.76999 | 37.7415885580679 | -122.395200303744 | (37.7415885580679, -122.395200303744) | 10 | 3 | 8 | 58 | 1 | |||
94235 | 130525 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 Cherry St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5996138.91299 | 2115724.53557 | 37.7891538638973 | -122.45721398625 | (37.7891538638973, -122.45721398625) | 11 | 6 | 1 | 54 | 31 | |||
94560 | 208808 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 471 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995363.92535 | 2095839.64393 | 37.7345105311352 | -122.458455366341 | (37.7345105311352, -122.458455366341) | 9 | 7 | 4 | 59 | 40 | |||
95316 | 230277 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 541 30th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6003113.15131 | 2098299.51429 | 37.7417070635275 | -122.431839319727 | (37.7417070635275, -122.431839319727) | 2 | 7 | 5 | 63 | 7 | |||
95416 | 229931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4458 24th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6000237.91008 | 2101704.07957 | 37.7508917739405 | -122.442025233688 | (37.7508917739405, -122.442025233688) | 2 | 4 | 5 | 28862 | 22 | ||||
96214 | 208691 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992715.41868 | 2091126.56279 | 37.7214170109678 | -122.467269473306 | (37.7214170109678, -122.467269473306) | 9 | 8 | 6 | 64 | 24 | |||
96226 | 103029 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.7185909063027 | -122.463407787149 | (37.7185909063027, -122.463407787149) | 9 | 8 | 6 | 64 | 24 |
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) );