trees
6,344 rows where qSpecies_id = 19 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
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 | ||||||||||||||
1398 | 20032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3ST | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
3531 | 39973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3892 | 39976 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8292 | 261770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:05:00 AM | 3 | 4x4 | ||||||||||||
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10686 | 34901 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
11435 | 36622 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
11817 | 33081 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
11841 | 34905 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
12228 | 34902 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13886 | 34906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
14106 | 36623 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14123 | 36635 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15275 | 36627 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15484 | 36610 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15890 | 256718 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 927 Brazil Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782649 | |||||||||||
17350 | 34904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
18716 | 261769 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:00:00 AM | 3 | 4x4 | ||||||||||||
19128 | 36616 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
3633 | 46628 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1426 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 0 | Permit Number 44749 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |||
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 | |||
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 | |
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 | |
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 | |
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 |
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 | |||
8087 | 188688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816544 | -122.382223941884 | (37.739646816544, -122.382223941884) | 10 | 3 | 8 | 58 | 1 | ||
8140 | 26662 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.7388160650952 | -122.382981244792 | (37.7388160650952, -122.382981244792) | 10 | 3 | 8 | 58 | 1 | ||
8929 | 29875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
9417 | 203065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:10:00 PM | 3 | Width 3ft | 6017458.84969 | 2097245.24162 | 37.7396150308979 | -122.382162846439 | (37.7396150308979, -122.382162846439) | 10 | 3 | 8 | 58 | 1 | ||
9477 | 193012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013566.4311 | 2097855.47673 | 37.7410748608127 | -122.395663996006 | (37.7410748608127, -122.395663996006) | 10 | 3 | 8 | 58 | 1 | |||
9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
10130 | 193311 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1433 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016240.13881 | 2097427.00946 | 37.7400467432612 | -122.386389332697 | (37.7400467432612, -122.386389332697) | 10 | 3 | 8 | 58 | 1 | |||
10210 | 46620 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1566 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 4 | 3x3 | Permit Number 44746 | 6015560.90449 | 2096875.62072 | 37.7384951204397 | -122.388699385265 | (37.7384951204397, -122.388699385265) | 10 | 3 | 8 | 58 | 1 |
10334 | 193296 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018120.52005 | 2093146.99774 | 37.728398581107 | -122.379590415761 | (37.728398581107, -122.379590415761) | 10 | 3 | 8 | 58 | 1 | |||
10462 | 85563 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.04426 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | 10 | 3 | 8 | 58 | 1 | ||
10827 | 193103 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1360 Fairfax Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.7399452071057 | -122.384567672275 | (37.7399452071057, -122.384567672275) | 10 | 3 | 8 | 58 | 1 | |||
10970 | 60364 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19942 | 6015971.722 | 2094398.676 | 37.7317166892309 | -122.387106247473 | (37.7317166892309, -122.387106247473) | 10 | 3 | 8 | 58 | 1 | |
11058 | 188442 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6017408.67942 | 2097282.36848 | 37.7397142027529 | -122.382338897719 | (37.7397142027529, -122.382338897719) | 10 | 3 | 8 | 58 | 1 | ||
11507 | 71409 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1510 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015375.9848 | 2094913.1689 | 37.7330963758454 | -122.389201760959 | (37.7330963758454, -122.389201760959) | 10 | 3 | 8 | 58 | 1 | |||
11625 | 28733 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2011 12:00:00 AM | 3 | 3x3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
12214 | 17410 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1818 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1996 12:00:00 AM | 6 | 3x3 | 6013752.07113 | 2096127.41343 | 37.7363402827738 | -122.394901116419 | (37.7363402827738, -122.394901116419) | 10 | 3 | 8 | 58 | 1 | ||
12547 | 60392 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1474 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 3 | Permit Number 19972 | 6015573.2956 | 2094772.4682 | 37.7327209763825 | -122.388509781451 | (37.7327209763825, -122.388509781451) | 10 | 3 | 8 | 58 | 1 | |
12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
13928 | 193037 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 5 | : | Tree | Private 2 | 6 | Width 4ft | 6013937.10901 | 2099755.21268 | 37.7463117498036 | -122.394515309055 | (37.7463117498036, -122.394515309055) | 10 | 3 | 8 | 58 | 1 | |||
14135 | 193309 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2017 12:00:00 AM | 3 | Width 4ft | 6016323.77034 | 2097360.91546 | 37.7398698915759 | -122.38609556018 | (37.7398698915759, -122.38609556018) | 10 | 3 | 8 | 58 | 1 | ||
14782 | 193113 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1918 Palou Ave | 1 | : | Tree | Private 2 | 18 | Width 6ft | 6013201.37448 | 2096537.6402 | 37.7374360437463 | -122.396833869195 | (37.7374360437463, -122.396833869195) | 10 | 3 | 8 | 58 | 1 | |||
15265 | 60385 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1418 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19965 | 6015851.3994 | 2094564.1651 | 37.7321644254987 | -122.38753377178 | (37.7321644254987, -122.38753377178) | 10 | 3 | 8 | 58 | 1 | |
15790 | 193310 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Galvez Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016258.92909 | 2097409.86162 | 37.740000698884 | -122.386323167782 | (37.740000698884, -122.386323167782) | 10 | 3 | 8 | 58 | 1 | |||
15831 | 59843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 3 | Permit Number 19298 | 6016839.42379 | 2093825.06532 | 37.730189678993 | -122.384066468412 | (37.730189678993, -122.384066468412) | 10 | 3 | 8 | 58 | 1 | |
15957 | 4906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | 10 | 3 | 8 | 58 | 1 | ||
17007 | 82838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1415 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016205.4223 | 2093876.0516 | 37.7302946051933 | -122.386261868118 | (37.7302946051933, -122.386261868118) | 10 | 3 | 8 | 58 | 1 | |||
17955 | 60377 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19957 | 6016692.94797 | 2093937.42445 | 37.7304900957418 | -122.384580682763 | (37.7304900957418, -122.384580682763) | 10 | 3 | 8 | 58 | 1 | |
18043 | 60382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 2 | Permit Number 19962 | 6016050.49586 | 2094420.00347 | 37.7317796120287 | -122.38683539465 | (37.7317796120287, -122.38683539465) | 10 | 3 | 8 | 58 | 1 | |
18666 | 17439 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1921 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1996 12:00:00 AM | 20 | 3x3 | 6013086.99078 | 2096553.03142 | 37.73747193747 | -122.397230428865 | (37.73747193747, -122.397230428865) | 10 | 3 | 8 | 58 | 1 | ||
19103 | 193292 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017364.44288 | 2093716.31678 | 37.7299200892409 | -122.382243827706 | (37.7299200892409, -122.382243827706) | 10 | 3 | 8 | 58 | 1 | |||
19497 | 193116 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1771 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014627.24242 | 2096799.70603 | 37.7382348845319 | -122.391922256922 | (37.7382348845319, -122.391922256922) | 10 | 3 | 8 | 58 | 1 | |||
19797 | 200218 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015220.8524 | 2090180.0119 | 37.7200914677866 | -122.389407680138 | (37.7200914677866, -122.389407680138) | 10 | 3 | 8 | 58 | 1 | |||
19804 | 29809 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
19975 | 29822 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
20162 | 110037 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1899x Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x105 | 6013815.03805 | 2098100.36713 | 37.7417611046854 | -122.39482154348 | (37.7417611046854, -122.39482154348) | 10 | 3 | 8 | 58 | 1 | |||
20198 | 99442 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 990X Jamestown Ave | 4 | 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 | |
20366 | 1853 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2445 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1991 12:00:00 AM | 6 | 3X3 | 6011002.0813 | 2086868.54548 | 37.7107640475959 | -122.403757736125 | (37.7107640475959, -122.403757736125) | 10 | 3 | 8 | 309 | 1 | ||
20671 | 193295 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017437.79116 | 2093660.55631 | 37.7297710328838 | -122.38198637428 | (37.7297710328838, -122.38198637428) | 10 | 3 | 8 | 58 | 1 | |||
20913 | 28719 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1636 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6014663.94428 | 2095448.06679 | 37.7345255974839 | -122.391700880702 | (37.7345255974839, -122.391700880702) | 10 | 3 | 8 | 58 | 1 | ||
21079 | 200127 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1561 Wallace Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015055.9884 | 2092639.1195 | 37.7268345484304 | -122.390149270389 | (37.7268345484304, -122.390149270389) | 10 | 3 | 8 | 58 | 1 | |||
21437 | 29859 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014017.477 | 2099779.02044 | 37.7463815884414 | -122.394239070574 | (37.7463815884414, -122.394239070574) | 10 | 3 | 8 | 58 | 1 | ||
21758 | 103918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
22735 | 193066 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 25 | : | Tree | Private 2 | 4 | Width 4ft | 6015154.4129 | 2098847.09569 | 37.7438858474558 | -122.390242547283 | (37.7438858474558, -122.390242547283) | 10 | 3 | 8 | 58 | 1 |
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) );