trees

39,840 rows where qLegalStatus_id = 7 sorted by SiteOrder descending

✎ 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)
4397 44679 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
7996 45026 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
11315 48289 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13496 45859 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10442 45860 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
12840 45025 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
16497 44678 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
10915 48287 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13485 45024 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
13500 45861 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
18065 44701 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
5544 48286 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
15686 45023 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
18086 45862 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
19213 44683 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
9780 45872 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
11907 48285 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
19195 44685 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4748 45021 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
10300 48270 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10839 44710 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
13968 45864 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3563 44709 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
14612 48283 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
18690 45856 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4171 48297 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
12587 45866 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
15096 45020 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
17050 44708 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10879 44707 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
16425 45867 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
16835 45029 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
8605 48280 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
8878 45868 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
9779 44706 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
11495 45018 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
3112 44154 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 67 Saint Charles Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443) 9 8 6 64 24
3325 11719 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
5297 35195 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   9 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5954 48227 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
6154 35450 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7589 45884 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
7609 34915 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
7630 24158 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 110X Whitney Young Cir 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016346.0952597 2096044.1423309 37.736255534298 -122.385926606914 (37.736255534298, -122.385926606914) 10 3 8 58 1
9082 43481 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   9 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
10047 53124 Permitted Site 7 Tree(s) :: 17 601@ NOE ST Duboce Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2006 12:00:00 AM     Permit Number 49066 6002808.44176413 2108284.12633652 37.7691051487822 -122.433606309272 (37.7691051487822, -122.433606309272) 15 5 5 28862 3
10706 46293 Permitted Site 7 Robinia x ambigua :: Locust 196   9 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
11015 44836 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
11508 36864 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
12172 44551 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
12471 76775 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
12582 32159 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 600 Linden St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1995 12:00:00 AM     Permit Number 35508 6004513.09393523 2110705.7048246 37.77585078754 -122.42788259012 (37.77585078754, -122.42788259012) 7 9 11 28852 10
12633 39951 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 0 Ervine St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
12780 33093 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   9 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
13109 38799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   9 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13515 35181 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   9 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13773 36645 Permitted Site 7 Robinia x ambigua :: Locust 196   9 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
13834 41252 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 155 Minna St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1999 12:00:00 AM     Permit Number 41945 6012533.02981985 2114448.22388081 37.7865773148555 -122.40040234125 (37.7865773148555, -122.40040234125) 12 2 9 28855 6
14631 36650 Permitted Site 7 Tree(s) :: 17   9 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                    
15447 128076 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 7 Width 4ft   6009546.7837 2121872.26218 37.8067949229139 -122.411258701628 (37.8067949229139, -122.411258701628) 3 1 10 308 23
17054 45804 Permitted Site 7 Tree(s) :: 17 880 Clipper Ter 9 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2001 12:00:00 AM     Permit Number 44433 5999675.79411068 2100284.35240189 37.7469614974882 -122.443867085897 (37.7469614974882, -122.443867085897) 2 4 5 63 22
17468 6907 Permitted Site 7 Persea americana :: Avocado 34 333 Fell St 9 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005876.17496 2110669.29389 37.7758278290987 -122.423164749384 (37.7758278290987, -122.423164749384) 7 9 11 28852 10
17797 42821 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 801 Bay St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.2276607 2121167.35462349 37.8047131790945 -122.420211856319 (37.8047131790945, -122.420211856319) 5 1 1 28858 32
17913 35078 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1541 12th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1998 12:00:00 AM     Permit Number 38627 5992419.71878294 2104964.13539049 37.7593944056925 -122.46929829243 (37.7593944056925, -122.46929829243) 1 8 4 56 12
18185 11652 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 699X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
18253 35690 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   9 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
18426 48475 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
19116 41459 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2238 Geary Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2000 12:00:00 AM     Permit Number 42045 6001025.06662099 2113514.63784374 37.7833654634469 -122.440150010843 (37.7833654634469, -122.440150010843) 15 5 11 29490 13
19722 28629 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1299 Ocean Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 3 3X3   5996025.31382 2091881.53932 37.7236805140054 -122.455882701682 (37.7236805140054, -122.455882701682) 9 8 4 28861 24
20237 42318 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 301 Edna St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42532 5998734.92164885 2093801.38025355 37.7291070907004 -122.446654155848 (37.7291070907004, -122.446654155848) 9 7 4 28861 40
20829 93919 Permitted Site 7 Tree(s) :: 17 280 Portola Dr 9 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2010 12:00:00 AM   3x3 Permit Number 53386 5999488 2100471 37.7474632730192 -122.444529871348 (37.7474632730192, -122.444529871348) 2 5 5 63 38
21540 33778 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 77 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757) 12 2 9 28855 6
21625 14774 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1000X McAllister St 9 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   05/13/1992 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
21933 40234 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 3750 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM     Permit Number 41412 6005244.44626478 2096435.85175558 37.7367104548817 -122.42433748337 (37.7367104548817, -122.42433748337) 2 7 5 28859 2
22525 25795 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 800X The Embarcadero 9 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.67701 37.8017810445969 -122.399988868692 (37.8017810445969, -122.399988868692) 3 1 10 28860 6
23001 39528 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1500 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40969 6012854.83375701 2106613.68395322 37.7650833924806 -122.398738948997 (37.7650833924806, -122.398738948997) 14 3 8 28856 20
23053 48044 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3350 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574) 2 7 7 28859 2
23319 6827 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
23390 22618 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1001 Turk St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3x5   6005224.1346872 2112659.8569034 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881) 7 9 11 28852 41
24611 217610 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1201 Ocean Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2003 12:00:00 AM 3 Width 0ft   5996168.7329 2091856.7846 37.7236207736962 -122.455385141266 (37.7236207736962, -122.455385141266) 9 8 4 28861 24
24627 39288 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2030 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/1998 12:00:00 AM 10 3x3 Permit Number 40887 6008691.77200643 2106524.44270682 37.7646055260983 -122.413131696747 (37.7646055260983, -122.413131696747) 8 4 7 28859 19
27214 108859 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6015632.2 2115560.3 37.7898031599115 -122.389757582477 (37.7898031599115, -122.389757582477) 6 2 9 28855 6
27502 92600 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2201 Baker St 9 Sidewalk: Property side : Cutout Tree Private 2   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814 2116396 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455) 13 6 1 29490 27
27607 91318 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 450 Rhode Island St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2009 12:00:00 AM   3x3 Permit Number 52049 6011745 2106547 37.7648383947947 -122.40257292402 (37.7648383947947, -122.40257292402) 8 3 8 28853 20
27832 15155 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
27992 49579 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 400REVISED Alemany Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171) 2 7 7 28859 2
29299 32677 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 899 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37098 6011223.96618851 2112626.31921579 37.7815017061756 -122.404803090396 (37.7815017061756, -122.404803090396) 6 2 9 28853 34
29442 42763 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 415 Buchanan St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
29961 26692 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1295X Pierce St 9 Sidewalk: Curb side : Cutout Tree Private 2     2 4X4   6002282.65453 2112732.23804 37.7812887073654 -122.435743262788 (37.7812887073654, -122.435743262788) 15 5 11 29490 41
30150 9556 Permitted Site 7 Pittosporum spp :: Pittosporum spp 170 1195X Golden Gate Ave 9 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   01/19/2016 07:58:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
31285 377 Permitted Site 7 Sequoia sempervirens :: Coast Redwood 155 3711X 19th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2008 12:00:00 AM 12 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189) 1 8 4 64 14
31775 3202 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 3700X California St 9 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   5996548.27505 2114783.92692 37.786594706495 -122.455729633586 (37.786594706495, -122.455729633586) 11 6 1 54 31

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