6,344 rows where qSpecies_id = 19 sorted by Zip Codes

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);