trees

6,344 rows where qSpecies_id = 19 sorted by Fire Prevention Districts

✎ View and edit SQL

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                    
70 264978 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1439 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2020 12:00:00 AM 3 3x3 Permit Number 787884 5989892.86343 2105570.52868 37.7609130564186 -122.47808163393 (37.7609130564186, -122.47808163393) 1 8 3 56 35
2006 50719 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2279 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/2004 12:00:00 AM 5   Permit Number 47272 5988534.5082 2099828.4885 37.7450680122132 -122.482358807669 (37.7450680122132, -122.482358807669) 1 8 3 29491 35
2828 81279 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2294 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52532 5986721.5097 2099657.5798 37.7444931137009 -122.488615192328 (37.7444931137009, -122.488615192328) 1 8 3 29491 35
3029 181658 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1285 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5987371.0004 2106539.9848 37.7634282140159 -122.486874731079 (37.7634282140159, -122.486874731079) 1 8 3 56 35
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
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
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
8615 81216 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1490 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5989947.3486 2105228.4272 37.7599768999261 -122.477868186468 (37.7599768999261, -122.477868186468) 1 8 3 56 35
9373 71806 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2567 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5988291.4423 2097857.1501 37.7396410933419 -122.483054814949 (37.7396410933419, -122.483054814949) 1 8 3 29491 35
11199 73361 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 23 Huntington Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5984617.03994 2094708.01424 37.730779908566 -122.495526924733 (37.730779908566, -122.495526924733) 1 8 4 64 35
12494 261750 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 127 Edgehill Way 2 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
13657 73537 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 23 Huntington Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5984627.56608 2094712.464 37.7307927427943 -122.495490862808 (37.7307927427943, -122.495490862808) 1 8 4 64 35
14619 20886 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1892X Sunset Blvd 36 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
14786 69030 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1451 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1994 12:00:00 AM 2   Permit Number 33036 5984623.8069 2105296.0559 37.7598521830846 -122.496284456968 (37.7598521830846, -122.496284456968) 1 8 3 56 35
15119 55242 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 176 Escolta Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1972 12:00:00 AM 2   Permit Number 11162 5986318.2122 2097305.7128 37.7380119721821 -122.489836759019 (37.7380119721821, -122.489836759019) 1 8 3 29491 35
15248 181652 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1273 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5987059.7825 2106621.4802 37.7636338282412 -122.487957107499 (37.7636338282412, -122.487957107499) 1 8 3 56 35
15299 96710 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 2900 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2012 12:00:00 AM     Permit Number 767523 5987054 2098280 37.7407300421735 -122.487364354837 (37.7407300421735, -122.487364354837) 1 8 3 29491 35
15571 208760 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 280 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993247.31483 2099712.66892 37.7450230186124 -122.46605447665 (37.7450230186124, -122.46605447665) 1 8 4 29491 40
15576 261749 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 127 Edgehill Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
15685 65904 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1334 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/31/1990 12:00:00 AM     Permit Number 28912 5993661.3773817 2106405.83948229 37.7634246223214 -122.465108777096 (37.7634246223214, -122.465108777096) 1 8 11 56 12
16230 46377 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2247 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 2   Permit Number 44614 5982946.355 2099827.607 37.7447389446862 -122.501681271429 (37.7447389446862, -122.501681271429) 1 8 3 29491 35
18803 181711 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3403 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985126.2438 2107009.2181 37.7645854668325 -122.494673101587 (37.7645854668325, -122.494673101587) 1 8 3 56 35
19629 208762 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 35 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   5994672.03489 2099765.24391 37.7452494678991 -122.461131895315 (37.7452494678991, -122.461131895315) 1 8 4 59 40
20643 208583 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1445 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5992706.97104 2105607.29281 37.761176942478 -122.46835163294 (37.761176942478, -122.46835163294) 1 8 4 56 12
21030 208773 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 275 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5994654.95951 2100272.97227 37.7466425798092 -122.461227736077 (37.7466425798092, -122.461227736077) 1 8 4 29491 40
22480 183789 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1938 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5986790.2146 2099636.6696 37.7444397088205 -122.488376091529 (37.7444397088205, -122.488376091529) 1 8 3 29491 35
24629 208637 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 50 San Marcos Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993888.92612 2100134.77757 37.7462190170898 -122.463866550195 (37.7462190170898, -122.463866550195) 1 8 4 29491 40
24685 69316 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1522 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1994 12:00:00 AM 7   Permit Number 33395 5986232.9661 2104850.9692 37.7587242284295 -122.490686490749 (37.7587242284295, -122.490686490749) 1 8 3 56 35
24855 208606 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2031 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993157.03204 2101649.9677 37.750337137758 -122.466507438167 (37.750337137758, -122.466507438167) 1 8 4 29491 12
28018 208708 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 204 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993575.04046 2104633.76822 37.7585539977942 -122.465278659389 (37.7585539977942, -122.465278659389) 1 8 4 56 12
28517 94060 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1401X 08th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
30653 59273 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1273 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/30/1980 12:00:00 AM 12   Permit Number 18609 5987366.8666 2106612.0315 37.7636257934084 -122.486894319548 (37.7636257934084, -122.486894319548) 1 8 3 56 35
31015 208568 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1819 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993416.14051 2103094.09078 37.7543172772349 -122.465716339657 (37.7543172772349, -122.465716339657) 1 8 4 56 12
31076 69469 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1569 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM     Permit Number 33585 5991106.49879759 2104699.95810887 37.7585930707153 -122.473820732038 (37.7585930707153, -122.473820732038) 1 8 4 56 12
31470 181928 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2430 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986137.4123 2098684.1625 37.7417862692125 -122.49056325187 (37.7417862692125, -122.49056325187) 1 8 3 29491 35
32330 208746 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 544 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5991202.16511 2097060.41227 37.7376224012427 -122.472932801005 (37.7376224012427, -122.472932801005) 1 8 4 29491 40
32401 46894 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1445 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/11/2006 12:00:00 AM     Permit Number 44949 5992707.32410369 2105628.35090548 37.7612347828689 -122.468351943903 (37.7612347828689, -122.468351943903) 1 8 4 56 12
32464 208618 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 135 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5994515.08547 2099410.26338 37.7442657471571 -122.461648863411 (37.7442657471571, -122.461648863411) 1 8 4 59 40
34476 208591 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1640 09th Ave 2 Front Yard : Yard Tree Private 2     2 Width 6ft   5993421.74589 2104308.25926 37.7576513932025 -122.465785166563 (37.7576513932025, -122.465785166563) 1 8 4 56 12
34679 183790 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1948 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5986770.5847 2099634.5359 37.7444327048931 -122.488443809987 (37.7444327048931, -122.488443809987) 1 8 3 29491 35
34749 208763 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 35 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5994659.14299 2099779.22757 37.7452871216202 -122.461177486446 (37.7452871216202, -122.461177486446) 1 8 4 59 40
35429 183642 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1490 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982814.3712 2105004.9294 37.7589466720393 -122.502520759166 (37.7589466720393, -122.502520759166) 1 8 3 56 35
35690 208564 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1354 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992117.52814 2106220.86982 37.7628275995343 -122.470434932245 (37.7628275995343, -122.470434932245) 1 8 11 56 12
35986 208580 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1334 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993658.18126 2106404.34895 37.7634203454089 -122.465119723094 (37.7634203454089, -122.465119723094) 1 8 11 56 12
35998 81185 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2433 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2008 12:00:00 AM 2 3x3 Permit Number 50344 5986665.7177 2104339.6943 37.757345677061 -122.489152268707 (37.757345677061, -122.489152268707) 1 8 3 56 35
37601 181655 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1285 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987062.1447 2106555.339 37.7634523605553 -122.487944077449 (37.7634523605553, -122.487944077449) 1 8 3 56 35
37912 110359 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1850 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989944 2106611 37.763772878654 -122.477980844758 (37.763772878654, -122.477980844758) 1 8 3 56 35
38040 208575 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 501 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5994133.40491 2106633.33156 37.764076463789 -122.463492709215 (37.764076463789, -122.463492709215) 1 5 11 56 12
38455 208703 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1336 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994279.39858 2106403.642 37.7634542066563 -122.462971097941 (37.7634542066563, -122.462971097941) 1 5 11 56 12
39263 181611 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1255 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987363.9139 2106709.4716 37.7638931649343 -122.486911688048 (37.7638931649343, -122.486911688048) 1 8 3 56 35
39420 253554 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1855 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.488266922919 (37.7526951056681, -122.488266922919) 1 8 3 56 35
39545 101317 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 273 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
39916 218206 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 95 Taraval St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993445.69352 2099168.64824 37.7435407182253 -122.465329014242 (37.7435407182253, -122.465329014242) 1 8 4 59 40
41513 208587 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1470 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994003.72332 2105501.49161 37.7609612535865 -122.463859075953 (37.7609612535865, -122.463859075953) 1 5 11 56 12
41787 208589 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1590 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993720.33861 2104658.61064 37.7586305867373 -122.464777960952 (37.7586305867373, -122.464777960952) 1 8 4 56 12
41877 114072 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
42014 181750 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1226 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5987404.6616 2106891.3599 37.7643949557383 -122.486784113218 (37.7643949557383, -122.486784113218) 1 8 3 56 35
42314 177337 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 151 Morningside Dr 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   5985552.21468 2094749.49981 37.730948533249 -122.492296977222 (37.730948533249, -122.492296977222) 1 8 4 64 35
43232 183982 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1675 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5985912.7623 2103834.8263 37.7559154701897 -122.49171908385 (37.7559154701897, -122.49171908385) 1 8 3 56 35
43451 208610 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2654 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991456.65153 2097359.35552 37.7384579532575 -122.472074711998 (37.7384579532575, -122.472074711998) 1 8 4 29491 40
43542 208796 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 430 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993899.72941 2101734.49217 37.7506120497216 -122.463945294833 (37.7506120497216, -122.463945294833) 1 8 4 29491 40
44338 218303 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 26 Ardenwood Way 1 : Tree Private 2     10 Width 3ft   5991253.24799 2096255.67247 37.7354157473276 -122.472697526668 (37.7354157473276, -122.472697526668) 1 8 4 29491 40

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