trees
6,344 rows where qSpecies_id = 19
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 3978 | 109312 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774768 | 6008187.9 | 2099833.5 | 37.7462054183774 | -122.414400990572 | (37.7462054183774, -122.414400990572) | 2 | 7 | 7 | 28859 | 2 |
| 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 | |
| 4030 | 65762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3002 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 13 | Permit Number 28725 | 6003868.45772 | 2119096.10509 | 37.7988522212082 | -122.43071142781 | (37.7988522212082, -122.43071142781) | 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 | ||||||||||||||
| 4068 | 38625 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1396 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40563 | 6016053.9414 | 2093366.9092 | 37.7288882156246 | -122.386750071292 | (37.7288882156246, -122.386750071292) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 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 | |
| 4390 | 61550 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 933 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 8 | Permit Number 21508 | 6012798.10137 | 2103191.73514 | 37.7556843132942 | -122.398695011666 | (37.7556843132942, -122.398695011666) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 4505 | 59850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 4 | Permit Number 19305 | 6016629.87582 | 2093981.66592 | 37.7306080858771 | -122.384801815251 | (37.7306080858771, -122.384801815251) | 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 | |||
| 4550 | 60389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19969 | 6015669.4777 | 2094699.9194 | 37.7325271015793 | -122.388172191813 | (37.7325271015793, -122.388172191813) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 4673 | 60356 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.7302945678233 | -122.384613110545 | (37.7302945678233, -122.384613110545) | 10 | 3 | 8 | 58 | 1 | ||
| 4708 | 65963 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2658 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 9 | Permit Number 28985 | 5989288.4886 | 2097252.0638 | 37.7380376514495 | -122.479563236125 | (37.7380376514495, -122.479563236125) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |||
| 4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | 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 | |
| 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 | |||
| 4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
| 4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
| 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 | ||
| 5221 | 46411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52278 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 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 | ||
| 5301 | 230460 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 295 Precita Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008273.9062 | 2100232.70469 | 37.7473063765964 | -122.414131828735 | (37.7473063765964, -122.414131828735) | 2 | 7 | 7 | 28859 | 2 | |||
| 5325 | 230238 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003399.42304 | 2108502.79044 | 37.7697390612459 | -122.431577753704 | (37.7697390612459, -122.431577753704) | 15 | 9 | 5 | 29492 | 10 | |||
| 5418 | 70426 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6006596.62742 | 2117360.41575 | 37.7942406389433 | -122.42114773947 | (37.7942406389433, -122.42114773947) | 13 | 9 | 10 | 28858 | 32 | ||
| 5437 | 44085 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 363 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 7 | Permit Number 45154 | 5986819.42477 | 2113508.89753 | 37.7825307151502 | -122.489294848866 | (37.7825307151502, -122.489294848866) | 11 | 6 | 2 | 55 | 26 | |
| 5462 | 230622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1191 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6003231.87176 | 2101368.34583 | 37.7501400891166 | -122.431647872075 | (37.7501400891166, -122.431647872075) | 2 | 4 | 5 | 28862 | 22 | |||
| 5470 | 137605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1241 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002263.8485 | 2112857.1338 | 37.7816305713373 | -122.435817261163 | (37.7816305713373, -122.435817261163) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | |||
| 5556 | 208569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1226 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990812.99154 | 2107022.03649 | 37.7649518737544 | -122.475005306654 | (37.7649518737544, -122.475005306654) | 11 | 8 | 11 | 56 | 12 | |||
| 5706 | 230617 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 Jersey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003140.93999 | 2101524.62009 | 37.7505640268286 | -122.431973477016 | (37.7505640268286, -122.431973477016) | 2 | 4 | 5 | 28862 | 22 | |||
| 5791 | 171860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.7230581082272 | -122.410683014136 | (37.7230581082272, -122.410683014136) | 9 | 3 | 7 | 309 | 28 | |||
| 5807 | 2413 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2773 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2013 12:00:00 AM | 3 | 5x5 | 6009870 | 2101176 | 37.7499859781013 | -122.408679163531 | (37.7499859781013, -122.408679163531) | 2 | 4 | 7 | 28859 | 19 | ||
| 5873 | 168127 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999736.35511 | 2116932.30675 | 37.7926760371256 | -122.444854181598 | (37.7926760371256, -122.444854181598) | 13 | 6 | 1 | 29490 | 27 | |||
| 5892 | 261243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 840 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||||
| 5932 | 70322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997855.1178 | 2109822.7379 | 37.7730474875653 | -122.45085044117 | (37.7730474875653, -122.45085044117) | 15 | 5 | 11 | 29492 | 16 | |||
| 5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
| 6063 | 69315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1518 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 7 | Permit Number 33394 | 5986230.6468 | 2104875.9024 | 37.7587925526495 | -122.490696346344 | (37.7587925526495, -122.490696346344) | 1 | 8 | 3 | 56 | 35 | |
| 6083 | 60590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481 | 2111039 | 37.7765370051793 | -122.441854521628 | (37.7765370051793, -122.441854521628) | 15 | 5 | 11 | 29492 | 16 |
| 6085 | 82927 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6010031.8585 | 2110690.2274 | 37.7761189490017 | -122.40879059487 | (37.7761189490017, -122.40879059487) | 8 | 2 | 9 | 28853 | 34 | ||
| 6103 | 192898 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6012445.53716 | 2112672.64368 | 37.7816971054735 | -122.400580271289 | (37.7816971054735, -122.400580271289) | 6 | 2 | 9 | 28856 | 34 | |||
| 6116 | 38816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 211 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 4 | Permit Number 40652 | 5994893.15717 | 2114075.07126 | 37.7845532569028 | -122.461404489499 | (37.7845532569028, -122.461404489499) | 11 | 6 | 2 | 54 | 11 | |
| 6126 | 142586 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2310 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008494.0857 | 2120777.934 | 37.803731078252 | -122.414824283354 | (37.803731078252, -122.414824283354) | 5 | 1 | 10 | 308 | 23 | |||
| 6152 | 68969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3343 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32959 | 5999787.27845 | 2120075.09917 | 37.8013082157737 | -122.44490400674 | (37.8013082157737, -122.44490400674) | 13 | 9 | 1 | 57 | 17 | |
| 6195 | 208636 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 469 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993711.10983 | 2101824.71737 | 37.7508489131681 | -122.464604102194 | (37.7508489131681, -122.464604102194) | 1 | 8 | 4 | 29491 | 40 | |||
| 6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
| 6248 | 21612 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | 13 | 9 | 11 | 28858 | 27 | |||
| 6252 | 70020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5999648.4798 | 2110952.3759 | 37.7762516842269 | -122.444728210696 | (37.7762516842269, -122.444728210696) | 15 | 5 | 11 | 29492 | 16 | |||
| 6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 6389 | 138549 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2130 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002048.753 | 2114005.8939 | 37.7847725542056 | -122.436643640876 | (37.7847725542056, -122.436643640876) | 13 | 6 | 11 | 29490 | 13 | |||
| 6397 | 200027 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1572 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015191.8647 | 2094356.6865 | 37.7315581787012 | -122.389799462726 | (37.7315581787012, -122.389799462726) | 10 | 3 | 8 | 58 | 1 | |||
| 6474 | 230184 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1911 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004756.02326 | 2107181.25678 | 37.7661872463737 | -122.426791183172 | (37.7661872463737, -122.426791183172) | 8 | 4 | 5 | 28862 | 3 | |||
| 6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
| 6538 | 230207 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 26 Temple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999930.02308 | 2105801.10604 | 37.7621236543094 | -122.443384183955 | (37.7621236543094, -122.443384183955) | 15 | 5 | 5 | 28862 | 3 | |||
| 6574 | 65759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3016 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 13 | Permit Number 28722 | 6003857.62455 | 2119183.89761 | 37.7990926630433 | -122.430755182511 | (37.7990926630433, -122.430755182511) | 13 | 9 | 1 | 57 | 17 | |
| 6588 | 46352 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 13 | Permit Number 44595 | 6000732.4975 | 2116220.35681 | 37.7907780071577 | -122.441356390798 | (37.7907780071577, -122.441356390798) | 13 | 6 | 1 | 29490 | 27 | ||
| 6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
| 6719 | 72384 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010697.2489 | 2118956.7107 | 37.7988539907437 | -122.407071630807 | (37.7988539907437, -122.407071630807) | 3 | 1 | 10 | 308 | 23 | |||
| 6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
| 6736 | 53162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1123@ HAWES Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 1 | Permit Number 49083 | 6014891.3438 | 2089966.2272 | 37.71948618255 | -122.390531758785 | (37.71948618255, -122.390531758785) | 10 | 3 | 8 | 58 | 1 | |
| 6949 | 230168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 279 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003584.36382 | 2106666.87413 | 37.764708561268 | -122.430807012236 | (37.764708561268, -122.430807012236) | 8 | 4 | 5 | 28862 | 3 | |||
| 6970 | 230089 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 160 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007184.87556 | 2098217.41585 | 37.741711615892 | -122.417754802436 | (37.741711615892, -122.417754802436) | 2 | 7 | 7 | 28859 | 2 | |||
| 7062 | 60350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.7287441803863 | -122.381867009636 | (37.7287441803863, -122.381867009636) | 10 | 3 | 8 | 58 | 1 | |
| 7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
| 7123 | 99440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 3 | 3x10 | Permit Number 768748 | 6014145.42414 | 2089521.2651 | 37.7182229956809 | -122.393079032245 | (37.7182229956809, -122.393079032245) | 10 | 3 | 8 | 58 | 1 | |
| 7133 | 229642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007320.40243 | 2098793.80149 | 37.7433018681988 | -122.417327030917 | (37.7433018681988, -122.417327030917) | 2 | 7 | 7 | 28859 | 2 | |||
| 7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 7201 | 5637 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6005132.21095 | 2100956.30175 | 37.7491162433305 | -122.425047067669 | (37.7491162433305, -122.425047067669) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 7277 | 71773 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007676.74747 | 2115431.38608 | 37.7890048300542 | -122.417273630072 | (37.7890048300542, -122.417273630072) | 13 | 1 | 10 | 28858 | 21 | |||
| 7297 | 130697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2311 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999746.50713 | 2116862.80854 | 37.7924857927226 | -122.444814057435 | (37.7924857927226, -122.444814057435) | 13 | 6 | 1 | 29490 | 27 | |||
| 7324 | 46621 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1566 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 4 | 3x3 | Permit Number 44746 | 6015540.17012 | 2096891.35899 | 37.738537185353 | -122.388772173723 | (37.738537185353, -122.388772173723) | 10 | 3 | 8 | 58 | 1 |
| 7326 | 98693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009268 | 2109041 | 37.7715477423488 | -122.411316462549 | (37.7715477423488, -122.411316462549) | 8 | 2 | 9 | 28853 | 34 | ||
| 7409 | 79285 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994906.63121 | 2110258.22071 | 37.7740739800962 | -122.46108112387 | (37.7740739800962, -122.46108112387) | 11 | 6 | 2 | 54 | 11 | |||
| 7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
| 7452 | 60592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 613 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 10 | Permit Number 20211 | 6000545.2975 | 2111100.6046 | 37.7767098193279 | -122.44163652073 | (37.7767098193279, -122.44163652073) | 15 | 5 | 11 | 29492 | 16 | |
| 7498 | 138017 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1798 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005043.9346 | 2115067.7403 | 37.7878578757703 | -122.426356919881 | (37.7878578757703, -122.426356919881) | 13 | 9 | 11 | 28858 | 27 | |||
| 7550 | 71272 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2477 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6000730.11 | 2114120.4408 | 37.785012045879 | -122.441213921365 | (37.785012045879, -122.441213921365) | 15 | 6 | 11 | 29490 | 13 | |||
| 7592 | 229319 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3423 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006759.7758 | 2104940.35562 | 37.7601473437483 | -122.419701563095 | (37.7601473437483, -122.419701563095) | 2 | 4 | 7 | 28859 | 19 | |||
| 7596 | 137880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2148 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003654.0545 | 2115274.6949 | 37.7883474575543 | -122.431180423335 | (37.7883474575543, -122.431180423335) | 13 | 9 | 1 | 29490 | 27 |
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) );