trees
6,344 rows where qSpecies_id = 19 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );