trees
6,344 rows where qSpecies_id = 19 sorted by Zip Codes
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 | ||||||||||||||
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 | |||
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 | |
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 | |||
7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | 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 | |
8704 | 79435 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004044.7014 | 2110862.9754 | 37.7762561050616 | -122.429514097991 | (37.7762561050616, -122.429514097991) | 7 | 9 | 11 | 28852 | 10 | |||
10995 | 108012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 419X Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773433 | 6005343.63147 | 2111122.79579 | 37.7770429674219 | -122.425039228843 | (37.7770429674219, -122.425039228843) | 7 | 9 | 11 | 28852 | 10 | ||
13879 | 79434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004043.3643 | 2110877.3492 | 37.7762954962714 | -122.42951974871 | (37.7762954962714, -122.42951974871) | 7 | 9 | 11 | 28852 | 10 | |||
14584 | 43091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 146 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 2 | Permit Number 42926 | 6008599.48377 | 2113045.82808 | 37.7825065339989 | -122.413912252043 | (37.7825065339989, -122.413912252043) | 7 | 10 | 9 | 28852 | 36 | |
15897 | 72062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009233.34768 | 2115143.00173 | 37.7883004477513 | -122.411867591225 | (37.7883004477513, -122.411867591225) | 5 | 1 | 10 | 28852 | 21 | |||
17359 | 27339 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 640 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6004290.4577 | 2110500.9764 | 37.7752760561488 | -122.428638148774 | (37.7752760561488, -122.428638148774) | 7 | 9 | 11 | 28852 | 10 | |||
19735 | 138895 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004478.4652 | 2110688.3143 | 37.7758010783635 | -122.428001140268 | (37.7758010783635, -122.428001140268) | 7 | 9 | 11 | 28852 | 10 | |||
21842 | 229455 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004159.49688 | 2110026.75581 | 37.7739665502488 | -122.429057353316 | (37.7739665502488, -122.429057353316) | 7 | 9 | 11 | 28852 | 10 | |||
23907 | 244938 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005146 | 2109905 | 37.7736880308812 | -122.425636203263 | (37.7736880308812, -122.425636203263) | 7 | 9 | 11 | 28852 | 10 | |||
26289 | 59673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 531 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 3 | 3x3 | Permit Number 33280 | 6005241.131 | 2111282.5171 | 37.7774757325522 | -122.425405179356 | (37.7774757325522, -122.425405179356) | 7 | 9 | 11 | 28852 | 10 |
28232 | 229454 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004156.64154 | 2110049.10452 | 37.7740277527049 | -122.429068824191 | (37.7740277527049, -122.429068824191) | 7 | 9 | 11 | 28852 | 10 | |||
29055 | 130880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 520 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008418.95624 | 2114318.79252 | 37.7859916470346 | -122.414626911798 | (37.7859916470346, -122.414626911798) | 5 | 10 | 9 | 28852 | 36 | |||
31237 | 66691 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 29919 | 6008314.85711082 | 2113143.31425185 | 37.7827582184104 | -122.414903841616 | (37.7827582184104, -122.414903841616) | 7 | 10 | 9 | 28852 | 36 | ||
34600 | 229462 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004249.62718 | 2109371.87761 | 37.7721735161219 | -122.428698884463 | (37.7721735161219, -122.428698884463) | 7 | 9 | 11 | 28852 | 10 | |||
37183 | 30572 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 128 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | Permit Number 34549 | 6004633.56138 | 2108812.47866 | 37.7706592637331 | -122.427330967069 | (37.7706592637331, -122.427330967069) | 7 | 9 | 11 | 28852 | 10 | |
37643 | 229463 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004653.93302 | 2108815.36124 | 37.7706683307031 | -122.42726070662 | (37.7706683307031, -122.42726070662) | 7 | 9 | 11 | 28852 | 10 | |||
40750 | 30740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004184.33514 | 2109844.20882 | 37.7734667268354 | -122.428958416203 | (37.7734667268354, -122.428958416203) | 7 | 9 | 11 | 28852 | 10 |
41382 | 43096 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 11 | Permit Number 42929 | 6008431.72865 | 2114242.98901 | 37.7857842265139 | -122.414577356482 | (37.7857842265139, -122.414577356482) | 5 | 10 | 9 | 28852 | 36 | ||
41422 | 27340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 646 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004269.3633 | 2110497.2933 | 37.7752647494287 | -122.428710856528 | (37.7752647494287, -122.428710856528) | 7 | 9 | 11 | 28852 | 10 | ||
41886 | 245845 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 409 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005037.5396 | 2110358.12 | 37.7749260590097 | -122.426043647828 | (37.7749260590097, -122.426043647828) | 7 | 9 | 11 | 28852 | 10 | |||
43638 | 138894 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 637 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004319.9228 | 2110643.6144 | 37.7756693726077 | -122.428546391734 | (37.7756693726077, -122.428546391734) | 7 | 9 | 11 | 28852 | 10 | |||
44833 | 108017 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773431 | 6005280.91604 | 2110975.82036 | 37.7766358658731 | -122.425245720162 | (37.7766358658731, -122.425245720162) | 7 | 9 | 11 | 28852 | 10 | ||
46770 | 26489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005009.61064 | 2110928.03079 | 37.7764893165108 | -122.426180842363 | (37.7764893165108, -122.426180842363) | 7 | 9 | 11 | 28852 | 10 | |||
53025 | 138890 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 671 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004199.0488 | 2110623.1897 | 37.7756064502856 | -122.428963068284 | (37.7756064502856, -122.428963068284) | 7 | 9 | 11 | 28852 | 10 | |||
53754 | 138889 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 675 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004181.9725 | 2110622.1852 | 37.7756027255883 | -122.429022067745 | (37.7756027255883, -122.429022067745) | 7 | 9 | 11 | 28852 | 10 | |||
53800 | 47003 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 500 BUCHANAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 3x3 | Permit Number 45002 | 6004637 | 2110246 | 37.7745955592359 | -122.427421211008 | (37.7745955592359, -122.427421211008) | 7 | 9 | 11 | 28852 | 10 | |
53866 | 138886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 679 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004135.0961 | 2110617.1628 | 37.7755862817677 | -122.42918386646 | (37.7755862817677, -122.42918386646) | 7 | 9 | 11 | 28852 | 10 | |||
56285 | 27341 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 646 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004251.9521 | 2110495.2843 | 37.7752582477922 | -122.4287709426 | (37.7752582477922, -122.4287709426) | 7 | 9 | 11 | 28852 | 10 | ||
58098 | 112642 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 299X STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x12 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
58856 | 48537 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45863 | 6009227.23187 | 2115180.17966 | 37.7884021862584 | -122.411891379208 | (37.7884021862584, -122.411891379208) | 5 | 1 | 10 | 28852 | 21 |
61742 | 47686 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2005 12:00:00 AM | Permit Number 45484 | 6008443.03029356 | 2114183.63493373 | 37.7856218895054 | -122.414534054301 | (37.7856218895054, -122.414534054301) | 7 | 10 | 9 | 28852 | 36 | ||
62147 | 43008 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 249 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42874 | 6005373.76074263 | 2109905.4842595 | 37.7737022276545 | -122.424848377268 | (37.7737022276545, -122.424848377268) | 7 | 9 | 11 | 28852 | 10 | ||
62308 | 43097 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 590 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 12 | Permit Number 42929 | 6008475.50961 | 2114204.8503 | 37.7856819663971 | -122.414423186598 | (37.7856819663971, -122.414423186598) | 5 | 10 | 9 | 28852 | 36 | ||
66163 | 27342 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 658 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004212.4421 | 2110492.9405 | 37.7752495760457 | -122.428907449576 | (37.7752495760457, -122.428907449576) | 7 | 9 | 11 | 28852 | 10 | ||
68760 | 249389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6008887.16461 | 2113222.80178 | 37.7830086137915 | -122.412929514295 | (37.7830086137915, -122.412929514295) | 7 | 10 | 9 | 28852 | 36 | |||
74247 | 229458 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004168.10543 | 2109961.77225 | 37.7737886085898 | -122.429022940773 | (37.7737886085898, -122.429022940773) | 7 | 9 | 11 | 28852 | 10 | |||
75330 | 12259 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 611 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2006 12:00:00 AM | 3 | 3X3 | 6004921 | 2111005 | 37.7766956463335 | -122.426492853872 | (37.7766956463335, -122.426492853872) | 7 | 9 | 11 | 28852 | 10 | ||
75495 | 244953 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 249 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | Width 0ft | 6005363.7954 | 2109900.246 | 37.7736872817906 | -122.424882476223 | (37.7736872817906, -122.424882476223) | 7 | 9 | 11 | 28852 | 10 | ||
76587 | 138893 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 667 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004245.5903 | 2110630.2212 | 37.7756283913438 | -122.428802571238 | (37.7756283913438, -122.428802571238) | 7 | 9 | 11 | 28852 | 10 | |||
79902 | 138899 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004097.0928 | 2110636.0807 | 37.7756360742458 | -122.429316678431 | (37.7756360742458, -122.429316678431) | 7 | 9 | 11 | 28852 | 10 | |||
80651 | 107436 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 453 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771208 | 6005234 | 2110769 | 37.7760653369929 | -122.425393294989 | (37.7760653369929, -122.425393294989) | 7 | 9 | 11 | 28852 | 10 | |
80661 | 138885 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 683 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004111.9928 | 2110615.1538 | 37.7755794576513 | -122.429263643108 | (37.7755794576513, -122.429263643108) | 7 | 9 | 11 | 28852 | 10 | |||
82880 | 130879 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 520 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008421.50008 | 2114300.51531 | 37.7859416051581 | -122.41461681691 | (37.7859416051581, -122.41461681691) | 5 | 10 | 9 | 28852 | 36 | |||
82921 | 27338 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 638 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004363.19839 | 2110524.63458 | 37.7753451321029 | -122.428388208625 | (37.7753451321029, -122.428388208625) | 7 | 9 | 11 | 28852 | 10 | ||
86443 | 76019 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 5 | 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 | |
86513 | 138892 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 667 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004232.1971 | 2110629.2167 | 37.7756248751901 | -122.428848829978 | (37.7756248751901, -122.428848829978) | 7 | 9 | 11 | 28852 | 10 | |||
86580 | 138877 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 652 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004236.2151 | 2110494.6147 | 37.7752555185473 | -122.42882533273 | (37.7752555185473, -122.42882533273) | 7 | 9 | 11 | 28852 | 10 | |||
86700 | 142219 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 424 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005332.7943 | 2110806.7929 | 37.7761746883201 | -122.425054228576 | (37.7761746883201, -122.425054228576) | 7 | 9 | 11 | 28852 | 10 | |||
95895 | 44083 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 300X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2000 12:00:00 AM | Permit Number 43603 | 6005119 | 2109916 | 37.7737167085248 | -122.425730383611 | (37.7737167085248, -122.425730383611) | 7 | 9 | 11 | 28852 | 10 | |||
97737 | 30738 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004189.67673 | 2109821.80854 | 37.773405523492 | -122.428938341537 | (37.773405523492, -122.428938341537) | 7 | 9 | 11 | 28852 | 10 |
100574 | 50670 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 416 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47250 | 6005369.543 | 2110812.8671 | 37.7761934424034 | -122.424927537012 | (37.7761934424034, -122.424927537012) | 7 | 9 | 11 | 28852 | 10 | ||
101537 | 142267 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 620 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004556.115 | 2110646.6883 | 37.7756911762863 | -122.427729563325 | (37.7756911762863, -122.427729563325) | 7 | 9 | 11 | 28852 | 10 | |||
103369 | 16930 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 526 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1998 12:00:00 AM | 3 | 3X3 | 6004250.61796 | 2110151.92209 | 37.7743153837942 | -122.428751074797 | (37.7743153837942, -122.428751074797) | 7 | 9 | 11 | 28852 | 10 | ||
103703 | 138848 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 620 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004992.1925 | 2111048.0552 | 37.7768178896877 | -122.426249643914 | (37.7768178896877, -122.426249643914) | 7 | 9 | 11 | 28852 | 10 | |||
104995 | 138857 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004944.4801 | 2111025.8632 | 37.7767542588956 | -122.426413115073 | (37.7767542588956, -122.426413115073) | 7 | 9 | 11 | 28852 | 10 | |||
106661 | 52122 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48308 | 6004664.86592498 | 2108818.09173323 | 37.7706764462616 | -122.427223084055 | (37.7706764462616, -122.427223084055) | 7 | 9 | 11 | 28852 | 10 | ||
110026 | 29121 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008434.8728 | 2114228.13336 | 37.7857436131333 | -122.414565426956 | (37.7857436131333, -122.414565426956) | 5 | 10 | 9 | 28852 | 36 | ||
110260 | 142220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 424 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005324.3344 | 2110806.39 | 37.7761731041645 | -122.425083465013 | (37.7761731041645, -122.425083465013) | 7 | 9 | 11 | 28852 | 10 | |||
111261 | 44084 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 300X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2000 12:00:00 AM | Permit Number 43603 | 6005119 | 2109916 | 37.7737167085248 | -122.425730383611 | (37.7737167085248, -122.425730383611) | 7 | 9 | 11 | 28852 | 10 |
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) );