trees

222 rows where qCaretaker_id = 2 and qLegalStatus_id = 8 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 222 ✖
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)
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
227 102275 Property Tree 8 Tree(s) :: 17 267 Topaz Way   Back Yard : Yard Landscaping Private 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
1694 100166 Property Tree 8 Salix spp :: Willow 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree Private 2         Permit Number 769026                    
13614 258670 Property Tree 8 Pinus radiata :: Monterey Pine 15 152 Kensington Way   Front Yard : Yard Tree Private 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
15601 99374 Property Tree 8 Pinus radiata :: Monterey Pine 15 21 Panorama Dr   Back Yard : Yard Tree Private 2     24     5998009 2100230 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288) 1 5 4 63 38
19898 98265 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 755 O'Farrell St   Back Yard : Yard Tree Private 2         Backyard tree; not significant 6007700 2113968.3 37.7849888609023 -122.417089467607 (37.7849888609023, -122.417089467607) 7 10 9 28858 36
24750 94468 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
26011 100148 Property Tree 8 Tree(s) :: 17 209 Vicksburg St   Back Yard : Yard Tree Private 2           6004141 2102142 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
27177 101951 Property Tree 8 Tree(s) :: 17 21 Lyell St   unknown : Yard Tree Private 2           6003106 2094969 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
30200 98503 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 208 Glenview Dr   Back Yard : Yard Tree Private 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
33684 97290 Property Tree 8 Pinus radiata :: Monterey Pine 15 55 Hiliritas Ave   Front Yard : Yard Tree Private 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
33827 99268 Property Tree 8 Tree(s) :: 17 292 Whitney St   Front Yard : Cutout Tree Private 2           6004280 2096681 37.7373290690714 -122.427689454915 (37.7373290690714, -122.427689454915) 2 7 5 63 7
34602 97033 Property Tree 8 Afrocarpus gracilior :: Fern Pine 89 61 Vicksburg St   Back Yard : Yard Tree Private 2         Possible significant tree; Nellie RoW; rear yard 6004120 2102703 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406) 2 4 5 28862 22
39203 97052 Property Tree 8 Pyrus spp :: Pear Tree 281 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
40432 110929 Property Tree 8 Pinus radiata :: Monterey Pine 15 445 BEACON ST   Back Yard : Yard Tree Private 2       3x3   6002243 2098437 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675) 2 7 5 63 7
42557 101977 Property Tree 8 Cedrus deodara :: Deodar Cedar 109 601 Grand View Ave   Front Yard : Yard Tree Private 2           6000076.2 2101609.9 37.7506239629918 -122.442577679409 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
51341 97051 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
53937 94690 Property Tree 8 Brachychiton populneus :: Bottle Tree 348 749 Congo St   Front Yard : Yard Tree Private 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
54211 98502 Property Tree 8 Tree(s) :: 17 244 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
58309 100046 Property Tree 8 Tree(s) :: 17 562 28th St   Front Yard : Yard Tree Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
71699 94469 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
75016 98140 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 315 San Marcos Ave   Front Yard : Yard Tree Private 2           5992920.8 2100212.1 37.7463754865467 -122.467219803339 (37.7463754865467, -122.467219803339) 1 8 4 29491 40
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
92154 97177 Property Tree 8 Tree(s) :: 17 257 Roosevelt Way   Back Yard : Yard Tree Private 2         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.7658190148973 -122.440304070451 (37.7658190148973, -122.440304070451) 15 5 5 28862 3
94159 97024 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
98201 106968 Property Tree 8 :: 45 351 26th Ave   Back Yard : Yard Tree Private 2           5987720.26121 2113604.44601 37.7828456076198 -122.486185401226 (37.7828456076198, -122.486185401226) 11 6 2 55 26
99841 98436 Property Tree 8 Tree(s) :: 17 238 Glenview Dr   Back Yard : Yard Tree Private 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
104809 94487 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
105239 110843 Property Tree 8 Pseudotsuga menziesii :: Douglas Fir 285 2037 TURK BLVD   Front Yard : Yard Tree Private 2     15     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
105934 99256 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1466 York St   Back Yard : Yard Tree Private 2           6010099 2100741 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429) 2 4 7 28859 19
113165 113482 Property Tree 8 Pinus radiata :: Monterey Pine 15 2839 Pierce St   Back Yard : Yard Tree Private 2           6001345 2118077 37.7959107386074 -122.439370308548 (37.7959107386074, -122.439370308548) 13 9 1 57 17
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
120627 100045 Property Tree 8 Acacia decurrens :: Acacia: Silver Wattle 111 556 28th St   Front Yard : Yard Tree Private 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
122314 97023 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
124823 98405 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 84 Richland Ave   Sidewalk: Curb side : Cutout Tree Private 2   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072) 2 7 5 28859 2
127263 98715 Property Tree 8 Pinus radiata :: Monterey Pine 15 26 Vernon St   Back Yard : Yard Tree Private 2           5992459 2088068 37.713004133171 -122.467933479353 (37.713004133171, -122.467933479353) 9 8 6 64 24
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
137033 114410 Property Tree 8 Pinus radiata :: Monterey Pine 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree Private 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
137283 109242 Property Tree 8 Private shrub :: Private Shrub 284 2479 DIAMOND ST   Sidewalk: Curb side : Yard Landscaping Private 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
141124 100244 Property Tree 8 Persea americana :: Avocado 34 71 Sanchez St   Back Yard : Yard Tree Private 2         Interior courtyard 6003507 2107903 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878) 7 9 5 28862 3
141783 110320 Property Tree 8 :: 45 9 Imperial Aly   Back Yard : Yard Landscaping Private 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
149268 106458 Property Tree 8 Tree(s) :: 17 71 HANCOCK ST   Back Yard : Yard Tree Private 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
150502 97162 Property Tree 8 Malus :: Crab Apple 82 478 10th Ave   Back Yard : Yard Tree Private 2         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686) 11 6 2 54 11
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
157400 97685 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 84 Coventry Ct   Back Yard : Yard Tree Private 2           5997084 2096485 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132) 9 7 4 59 40
162706 94228 Property Tree 8 Acer palmatum :: Japanese Maple 216 1097 Church St   Front Yard : Yard Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
163139 112668 Property Tree 8 Pinus radiata :: Monterey Pine 15 129 Henry St   Back Yard : Yard Tree Private 2           6002668 2107340.8 37.7665070360696 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
167578 100472 Property Tree 8 Pinus radiata :: Monterey Pine 15 70 Stanford Heights Ave   Back Yard : Yard Tree Private 2           5997872.4 2096006.9 37.735113616296 -122.449794826729 (37.735113616296, -122.449794826729) 9 7 4 59 40
170932 102752 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 2452 Green St   Back Yard : Yard Tree Private 2           6001313 2117994 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164) 13 9 1 57 17
173830 98139 Property Tree 8 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 556 Laidley St   Back Yard : Yard Tree Private 2       3x3   6003085 2096041 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062) 2 7 5 63 7
176195 102381 Property Tree 8 Pinus radiata :: Monterey Pine 15 258 Molimo Dr   Back Yard : Yard Tree Private 2           5997615 2096604 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905) 9 7 4 59 40
179317 103673 Property Tree 8 :: 45 64 Henry St   Back Yard : Yard Tree Private 2           6003097 2107420 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662) 15 5 5 28862 3
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
364 255980 Property Tree 8 Tree(s) :: 17 541 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000551 2110847 37.7760138103106 -122.441598590487 (37.7760138103106, -122.441598590487) 15 5 11 29492 16
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
628 256542 Property Tree 8 Pinus radiata :: Monterey Pine 15 133 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
2059 264900 Property Tree 8 Pinus radiata :: Monterey Pine 15 35X Parkridge Dr 1 Median : Yard Tree Private 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
4239 258982 Property Tree 8 Pinus radiata :: Monterey Pine 15 239 Panorama Dr 1 Back Yard : Yard Tree Private 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
5987 262213 Property Tree 8 Olea europaea :: Olive Tree 9 66 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997837 2104660 37.7588708842054 -122.450540844653 (37.7588708842054, -122.450540844653) 15 5 11 28862 12
6335 262305 Property Tree 8 Casuarina cunninghamiana :: Horsetail pine 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
6943 262154 Property Tree 8 Pinus radiata :: Monterey Pine 15 519 22nd Ave 1 Back Yard : Yard Tree Private 2       3x3   5989039 2111772 37.7778909946523 -122.481488924787 (37.7778909946523, -122.481488924787) 11 6 2 55 26
7179 260247 Property Tree 8 Magnolia spp :: Magnolia 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
9029 258675 Property Tree 8 Myoporum laetum :: Myoporum 62 60 Laidley St 1 Back Yard : Yard Tree Private 2       3x3   6003232 2097949 37.7407513687421 -122.431403364879 (37.7407513687421, -122.431403364879) 2 7 5 63 7
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
10450 114373 Property Tree 8 Liquidambar styraciflua :: American Sweet Gum 37 805 GONZALEZ DR 1 Front Yard : Yard Tree Private 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
11932 252833 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 1 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
13832 259913 Property Tree 8 Pinus radiata :: Monterey Pine 15 23 Cresta Vista Dr 1 Back Yard : Yard Tree Private 2       3x3   5995254 2096176 37.7354277647167 -122.45885975654 (37.7354277647167, -122.45885975654) 9 7 4 59 40
16690 260450 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 1 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
20664 121198 Property Tree 8 Cordyline australis :: Dracena Palm 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 40
22075 187658 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 600X Clarendon Ave 1 Front Yard : Yard Tree Private 2       3x3   5995637 2102382 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932) 1 5 4 63 12
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
23775 108576 Property Tree 8 :: 45 2479 Diamond St 1 Front Yard : Yard Landscaping Private 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
27030 106971 Property Tree 8 Pinus radiata :: Monterey Pine 15 3479X San Bruno Ave 1 Front Yard : Yard Tree Private 2     30     6011510.60551 2091910.03431 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294) 10 3 7 309 28
28785 122558 Property Tree 8 Pinus radiata :: Monterey Pine 15 1760 Diamond St 1 Back Yard : Yard Tree Private 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
28928 116154 Property Tree 8 Pinus Spp :: Pine Spp 100 324 POPE ST 1 Back Yard : Yard Tree Private 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
30075 100070 Property Tree 8 Tree(s) :: 17 331 Serrano Dr 1 Front Yard : Yard Tree Private 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
30353 105684 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 1 Front Yard : Pot Tree Private 2     10     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
30542 98548 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 132 Hamerton Ave 1 Front Yard : Yard Tree Private 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
31871 33776 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
32266 108871 Property Tree 8 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard Tree Private 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
35596 254587 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1270 24th Ave 1 Back Yard : Cutout Tree Private 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
43876 114817 Property Tree 8 Pinus radiata :: Monterey Pine 15 100 RACCOON DR 1 Back Yard : Cutout Tree Private 2           5998725 2104028 37.757186355085 -122.447424250084 (37.757186355085, -122.447424250084) 15 5 5 63 3
44517 251117 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 2024 Castro St 1 Back Yard : Yard Tree Private 2           6002622 2099601 37.7452527853239 -122.433630548541 (37.7452527853239, -122.433630548541) 2 7 5 63 22
44661 102745 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 222 Moncada Way 1 Front Yard : Yard Tree Private 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
46823 103516 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Back Yard : Yard Tree Private 2           6008298 2118971 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445) 5 1 10 308 32
48396 109097 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
51917 256537 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Cutout Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
56024 105231 Property Tree 8 Pinus Spp :: Pine Spp 100 460X ROOSEVELT WAY 1 Front Yard : Yard Tree Private 2     9     6000051 2106345 37.7636239504047 -122.443004833609 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
57437 108624 Property Tree 8 Juniperus chinensis :: Juniper 113 101 GENEBERN WAY 1 Front Yard : Yard Tree Private 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
57789 121199 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 72 Fountain St 1 Back Yard : Yard Tree Private 2           6000322 2101283 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556) 2 4 5 28862 22

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