trees

39,840 rows where qLegalStatus_id = 7 sorted by PlantDate

✎ 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)
5638 89169 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5768 87061 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52     unknown : Yard Tree Private 2       3x3 Permit Number 50003                    
5822 16933 Permitted Site 7 Ficus nitida :: Laurel Fig 53 530 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2     24 3X3   6004214.00427 2110149.16937 37.7743057532085 -122.428877532014 (37.7743057532085, -122.428877532014) 7 9 11 28852 10
5844 99991 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
5875 99834 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1399X FUNSTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 44828 5992090 2106254 37.7629169745179 -122.470532554608 (37.7629169745179, -122.470532554608) 1 8 11 56 12
5910 24288 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 340 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6001280.10777 2086581.35963 37.7094275956588 -122.437338476184 (37.7094275956588, -122.437338476184) 9 7 6 28861 5
5929 56671 Permitted Site 7 Tree(s) :: 17 4019 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003016.37543683 2102387.64310455 37.7529266215546 -122.432465865209 (37.7529266215546, -122.432465865209) 2 4 5 28862 22
5931 7196 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 949 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003418.39077 2111568.89089 37.7781588927529 -122.431731089816 (37.7781588927529, -122.431731089816) 15 9 11 29492 41
5937 105211 Permitted Site 7 Tree(s) :: 17 223 Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 11471 6001117 2104982 37.7599422071638 -122.439220183407 (37.7599422071638, -122.439220183407) 2 4 5 28862 3
6026 128070 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6009396.36006 2121851.96105 37.8067307436876 -122.41177783889 (37.8067307436876, -122.41177783889) 3 1 10 308 23
6261 128069 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009374.1078 2121849.01591 37.8067214087259 -122.411854639205 (37.8067214087259, -122.411854639205) 3 1 10 308 23
6276 11636 Permitted Site 7 Fraxinus spp :: Ash Spp 121 499X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
6355 100391 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 226 Paris St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x7   6002817 2092256 37.7250961583897 -122.432431760897 (37.7250961583897, -122.432431760897) 9 7 6 28861 5
6363 12160 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1400X La Salle Ave 41 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6016105.23501 2095780.81201 37.7355191499757 -122.386741010111 (37.7355191499757, -122.386741010111) 10 3 8 58 1
6368 142137 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 3059 GEARY BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5997680.98 2113001.7737 37.7817663225775 -122.451682166477 (37.7817663225775, -122.451682166477) 15 6 2 54 16
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
6536 48473 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
6688 119707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree Private 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
6799 34917 Permitted Site 7 Tree(s) :: 17   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
7166 48480 Permitted Site 7 Tree(s) :: 17   1 Median : Cutout Tree Private 2         Permit Number 45832                    
7255 14729 Permitted Site 7 Maytenus boaria :: Mayten 58 880 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
7295 100582 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
7326 98693 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1400X Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 48713 6009268 2109041 37.7715477423488 -122.411316462549 (37.7715477423488, -122.411316462549) 8 2 9 28853 34
7358 108758 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1449 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5999638.3 2109087.9 37.7711317264146 -122.444629385712 (37.7711317264146, -122.444629385712) 15 5 11 29492 9
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7377 14771 Permitted Site 7 Schinus terebinthifolius :: Brazilian Pepper 93 1000X McAllister St 6 Sidewalk: Curb side : Cutout Tree Office of Mayor 9     18 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
7488 21658 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1745 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004251.7833336 2114607.9002324 37.7865504610901 -122.42906481766 (37.7865504610901, -122.42906481766) 13 9 11 29490 13
7513 45378 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
7530 27369 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 251 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006819.3487219 2111354.6736121 37.7777628978385 -122.419950711926 (37.7777628978385, -122.419950711926) 7 9 11 28852 10
7539 100598 Permitted Site 7 Tree(s) :: 17 401x Clementina St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
7549 34002 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
7552 97352 Permitted Site 7 Tree(s) :: 17   2 Unaccepted Street : Yard Tree Private 2                              
7581 9343 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 209 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     20 2X2   6000760.2622834 2098514.0876657 37.742162570261 -122.439990187576 (37.742162570261, -122.439990187576) 2 7 5 63 7
7597 9777 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 897X Gough St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6005678.151576 2112736.5747486 37.7814929008439 -122.42399680549 (37.7814929008439, -122.42399680549) 7 9 11 28852 41
7609 34915 Permitted Site 7 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
7626 30278 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 128                    
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
7632 48474 Permitted Site 7 Tree(s) :: 17   10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
7660 34914 Permitted Site 7 Tree(s) :: 17   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
7679 48477 Permitted Site 7 Tree(s) :: 17   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
7684 245413 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2726 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6010382.82 2102257.4918 37.7529842245941 -122.406982014782 (37.7529842245941, -122.406982014782) 10 4 7 28859 19
7892 9616 Permitted Site 7 Maytenus boaria :: Mayten 58 1050X Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002926.42189 2111948.31281 37.7791727913684 -122.433460108411 (37.7791727913684, -122.433460108411) 15 9 11 29490 41
7927 17200 Permitted Site 7 Olea europaea :: Olive Tree 9 200X Olive St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006498.35844 2113758.48472 37.7843450883742 -122.421231867498 (37.7843450883742, -122.421231867498) 7 9 11 28858 41
8003 21791 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.415385378175 (37.8057800612465, -122.415385378175) 5 1 10 308 23
8157 8138 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 919 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003262.67464 2111347.69223 37.7775427083406 -122.432253966617 (37.7775427083406, -122.432253966617) 15 9 11 29492 10
8181 192121 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     27 Width 4ft   6010922.27002 2113199.63335 37.783059024392 -122.405887217429 (37.783059024392, -122.405887217429) 12 2 9 28853 34
8241 56665 Permitted Site 7 Tree(s) :: 17 4549 Callan Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2                              
8260 56735 Permitted Site 7 Tree(s) :: 17 4601 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2           6015154.58866017 2096112.48595754 37.7363771809952 -122.390050945039 (37.7363771809952, -122.390050945039) 10 3 8 58 1
8352 84946 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
8379 114770 Permitted Site 7 Schinus terebinthifolius :: Brazilian Pepper 93 110 Frederick St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999469.36873216 2107750.31436605 37.7674494126495 -122.445117544708 (37.7674494126495, -122.445117544708) 15 5 11 29492 9
8495 1737 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 19 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
8552 94478 Permitted Site 7 Maytenus boaria :: Mayten 58 102 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2           5997316 2110188 37.7740195259569 -122.452741674918 (37.7740195259569, -122.452741674918) 15 5 11 29492 16
8604 48746 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8631 128082 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009683.35171 2121893.27188 37.8068602685411 -122.41078756392 (37.8068602685411, -122.41078756392) 3 1 10 308 23
8661 34920 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
8676 34246 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38056                    
8689 48479 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
8752 7916 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1225 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6005951.06937 2114267.1292 37.7857108313539 -122.423161466763 (37.7857108313539, -122.423161466763) 13 9 1 28858 41
8781 94862 Permitted Site 7 Pinus radiata :: Monterey Pine 15   2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
8986 8479 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1900X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3X3   6002632.5922648 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971) 13 9 11 29490 13
9108 116642 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 4 Sidewalk: Property side : Cutout Tree Private 2     1 3x3   6015144.15756 2112956.70855 37.7826272167081 -122.391264104249 (37.7826272167081, -122.391264104249) 6 2 9 28856 6
9119 18646 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 55 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X4   6017250.7089795 2096167.8793556 37.7366453120483 -122.382807560554 (37.7366453120483, -122.382807560554) 10 3 8 58 1
9162 48469 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
9217 48476 Permitted Site 7 Tree(s) :: 17   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
9258 109525 Permitted Site 7 Tree(s) :: 17 1550 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2           5991168.8 2098442.9 37.7414164276204 -122.473148952772 (37.7414164276204, -122.473148952772) 1 8 4 29491 40
9364 27216 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 440 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6004188.32264 2093464.07452 37.7284909288141 -122.427777281084 (37.7284909288141, -122.427777281084) 9 7 6 28861 5
9384 111852 Permitted Site 7 Tree(s) :: 17 187 States St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000958.85547421 2106373.84069392 37.7637548596233 -122.439866921627 (37.7637548596233, -122.439866921627) 15 5 5 28862 3
9479 48487 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
9492 104107 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 10 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
9573 108831 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 774658 6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
9602 98360 Permitted Site 7 Pinus radiata :: Monterey Pine 15 807 Francisco St 1 Sidewalk: Curb side : Yard Tree Private 2         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572) 5 1 1 28858 32
9737 34922 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
9839 48748 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
9900 88762 Permitted Site 7 Tree(s) :: 17 3972 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51683 6003154 2105365 37.7611095365426 -122.432202545498 (37.7611095365426, -122.432202545498) 15 4 5 28862 3
9916 91389 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 165 Kenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52087 5994308.9 2093484 37.7279818222938 -122.461932151311 (37.7279818222938, -122.461932151311) 9 8 4 59 40
9971 15508 Permitted Site 7 Washingtonia robusta :: Mexican Fan Palm 72 2737 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6007147.25057 2102426.20721 37.7532658900598 -122.418183219838 (37.7532658900598, -122.418183219838) 2 4 7 28859 19
10044 98961 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 302x Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
10108 94859 Permitted Site 7 Pinus radiata :: Monterey Pine 15   1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
10144 97101 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1096@Jones Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
10173 48744 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10185 97351 Permitted Site 7 Tree(s) :: 17   1 Unaccepted Street : Yard Tree Private 2                              
10223 7769 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 1 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
10230 255677 Permitted Site 7 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 1031 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009454.82413 2103169.76522 37.755437150131 -122.4102556204 (37.755437150131, -122.4102556204) 2 4 7 28859 19
10274 39974 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 0 Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
10346 41480 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2390 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 42055 6007082.30805796 2120481.73008774 37.8028383512958 -122.41968879786 (37.8028383512958, -122.41968879786) 5 1 1 28858 32
10422 56667 Permitted Site 7 Tree(s) :: 17 495 Callan Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2                              
10439 56506 Permitted Site 7 Tree(s) :: 17 556 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000140.95591591 2095509.77922044 37.733878172831 -122.441915966113 (37.733878172831, -122.441915966113) 9 7 5 63 40
10611 49383 Permitted Site 7 Tree(s) :: 17 522Walbridge Carter St 21 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46344 6005268.88409545 2086363.71271864 37.7090559366076 -122.423537125807 (37.7090559366076, -122.423537125807) 9 7 8 309 5
10658 97853 Permitted Site 7 Sequoia sempervirens :: Coast Redwood 155 895 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978) 10 3 8 28856 29
10683 111476 Permitted Site 7 Tree(s) :: 17 2x TRAINOR ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6008026 2108277 37.7693802414943 -122.415558521529 (37.7693802414943, -122.415558521529) 8 4 7 28853 19
10731 16564 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2265X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999663.62849 2089384.1717 37.7170314576056 -122.443126439495 (37.7170314576056, -122.443126439495) 9 7 6 28861 25
10783 26837 Permitted Site 7 Leptospermum scoparium :: New Zealand Tea Tree 157 1100X Duncan St 5 Sidewalk: Curb side : Cutout Tree Private 2     20 2x2                      
10796 56567 Permitted Site 7 Tree(s) :: 17 309 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5992136.3013072 2094883.62123857 37.7316995160329 -122.469544661545 (37.7316995160329, -122.469544661545) 9 8 4 59 40
10820 27018 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1525 Silver Ave 3 Sidewalk: Curb side : Cutout Tree Health Dept 13     12 3X3   6010513.2597857 2094754.7801651 37.7323906999135 -122.4060024251 (37.7323906999135, -122.4060024251) 10 3 7 309 28
10870 27147 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1745 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6011162.37541 2095219.41257 37.7337027663166 -122.403790951032 (37.7337027663166, -122.403790951032) 10 3 8 58 1
10886 192122 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6010961.41826 2113239.46389 37.7831705790105 -122.405754586311 (37.7831705790105, -122.405754586311) 12 2 9 28853 34
10989 254569 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1400x Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6004613 2113717 37.7841247118733 -122.427751595484 (37.7841247118733, -122.427751595484) 13 9 11 28858 41
11093 95037 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3224 Pierce St 8 Sidewalk: Property side : Cutout Tree Dept of Real Estate 7     10 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17

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