trees
6,344 rows where qSpecies_id = 19 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
719 | 80747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | ||
1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
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 | |||
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 | |||
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 | |||
1509 | 78622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008370.1442 | 2114331.41346 | 37.7860235585803 | -122.414796682248 | (37.7860235585803, -122.414796682248) | 13 | 10 | 9 | 28858 | 36 | |||
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 | |||
1624 | 70261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3828 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5996527.35216 | 2114976.82048 | 37.7871231398678 | -122.455815970326 | (37.7871231398678, -122.455815970326) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
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 | |||
2253 | 71688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1930 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5998564.1414 | 2110396.2631 | 37.774662803409 | -122.448439160727 | (37.774662803409, -122.448439160727) | 15 | 5 | 11 | 29492 | 16 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
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 | |||
3961 | 79969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
4127 | 74230 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.7974876128867 | -122.405491940883 | (37.7974876128867, -122.405491940883) | 3 | 1 | 10 | 308 | 23 | ||
4219 | 71431 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
4423 | 78598 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008370.91308 | 2114317.13439 | 37.785984394913 | -122.414793011197 | (37.785984394913, -122.414793011197) | 13 | 10 | 9 | 28858 | 36 | |||
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 | ||
4650 | 229335 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2125 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009610.4756 | 2104742.50445 | 37.7597642613296 | -122.409828339817 | (37.7597642613296, -122.409828339817) | 2 | 4 | 8 | 28859 | 19 | |||
4718 | 181925 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2351 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986069.5587 | 2099239.0051 | 37.7433057547251 | -122.490838681113 | (37.7433057547251, -122.490838681113) | 1 | 8 | 3 | 29491 | 35 | |||
4855 | 76107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009843.66078 | 2110720.8424 | 37.7761924676323 | -122.409443785198 | (37.7761924676323, -122.409443785198) | 8 | 2 | 9 | 28853 | 34 | |||
4860 | 168126 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999733.55538 | 2116947.29263 | 37.7927170246219 | -122.444864946464 | (37.7927170246219, -122.444864946464) | 13 | 6 | 1 | 29490 | 27 | |||
4882 | 193004 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013457.05978 | 2097724.05261 | 37.7407079131502 | -122.396032957252 | (37.7407079131502, -122.396032957252) | 10 | 3 | 8 | 58 | 1 | |||
4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | |||
5002 | 138596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1997 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001444.315 | 2115232.308 | 37.788105604547 | -122.438822708512 | (37.788105604547, -122.438822708512) | 13 | 6 | 1 | 29490 | 27 | |||
5051 | 192939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | 8 | 2 | 9 | 28853 | 19 | |||
5192 | 4661 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:46:00 PM | 3 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.410431363819 | (37.8005811155969, -122.410431363819) | 3 | 1 | 10 | 308 | 23 | ||
5270 | 80931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001747.57084 | 2087049.21095 | 37.710738776642 | -122.435756299834 | (37.710738776642, -122.435756299834) | 9 | 7 | 6 | 28861 | 5 | |||
5299 | 262438 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 2 | 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 |
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) );