341 rows where qLegalStatus_id = 8 sorted by Zip Codes descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes ▲ Neighborhoods (old)
5288 260453 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 4 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
7863 260451 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 2 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8587 260455 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 6 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
12648 260457 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 8 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
19362 260454 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 5 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19609 260452 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 3 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
53415 254271 Property Tree 8 Pinus radiata :: Monterey Pine 15 1201X Junipero Serra Blvd 1 Side Yard : Yard Tree PUC 8       10x10   5991180 2089593 37.717117469349 -122.472465193375 (37.717117469349, -122.472465193375) 9 8 6 64 24
60302 187670 Property Tree 8 Pinus radiata :: Monterey Pine 15 230 Victoria St 1 Back Yard : Yard Tree Private 2       3x3   5993274 2088748 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001) 9 8 6 64 24
75714 114950 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 2 unknown : Yard Tree DPW 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
80950 255115 Property Tree 8 Lophostemon confertus :: Brisbane Box 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
104559 254162 Property Tree 8 Pinus radiata :: Monterey Pine 15 301X Chester Ave 1 Back Yard : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
108384 122480 Property Tree 8 Pinus radiata :: Monterey Pine 15 596X Buckingham Way 1 Side Yard : Cutout Tree Private 2       3x3   5990152 2094375 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616) 1 8 4 64 14
124062 102101 Property Tree 8 Cordyline australis :: Dracena Palm 64 331 Vernon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.7184923011832 -122.468164197766 (37.7184923011832, -122.468164197766) 9 8 6 64 24
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
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
131954 110939 Property Tree 8 Pinus radiata :: Monterey Pine 15 38 SAINT CHARLES AVE 1 Back Yard : Cutout Tree Private 2     30 3x3   5992046 2088201 37.7133454608488 -122.46937060641 (37.7133454608488, -122.46937060641) 9 8 6 64 24
133884 114949 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 1 unknown : Yard Tree DPW 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
153614 255116 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 301X Chester Ave 3 Sidewalk: Property side : Cutout Tree DPW 1       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
177799 103504 Property Tree 8 Pinus radiata :: Monterey Pine 15 148 Huntington Dr 1 Back Yard : Yard Tree Private 2           5984515 2095210 37.7321522522788 -122.49591670505 (37.7321522522788, -122.49591670505) 1 8 4 64 35
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
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
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
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
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
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
10460 258772 Property Tree 8 Cupressus spp :: Cypress species 337 20 Crestline Dr 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   5999139 2101332 37.7498074496931 -122.445798597569 (37.7498074496931, -122.445798597569) 2 5 5 63 38
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
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
28314 256608 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 2 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
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
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
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
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
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
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
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
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
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
68497 99961 Property Tree 8 Callistemon citrinus :: Lemon Bottlebrush 67 537 Valley St 1 Front Yard : Yard Tree Private 2   07/25/2012 12:00:00 AM     Permit Number 768880 6002459 2099152 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356) 2 7 5 63 22
87678 254111 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 1 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89545 256543 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
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
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
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
106981 109092 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
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
124235 122518 Property Tree 8 Pinus radiata :: Monterey Pine 15 772X Panorama Dr 1 Back Yard : Cutout Tree Private 2       3x3   5996713 2102901 37.7539767153501 -122.45430108189 (37.7539767153501, -122.45430108189) 1 5 4 63 38
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
145213 256660 Property Tree 8 Private shrub :: Private Shrub 284 40X Miguel St 1 Back Yard : Yard Landscaping Private 2       3x3   6003624 2097154 37.7385906898162 -122.429991281012 (37.7385906898162, -122.429991281012) 2 7 5 63 7
161514 253207 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 89 Woodhaven Ct 1 Back Yard : Cutout Tree Private 2       3x3   5996069 2103645 37.7559825991437 -122.456581972884 (37.7559825991437, -122.456581972884) 1 5 4 63 12
171323 253471 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 17 Valletta Ct 1 Side Yard : Yard Tree Private 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
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
178160 173600 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 500 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996184 2102497 37.7528370823128 -122.456101271869 (37.7528370823128, -122.456101271869) 1 5 4 63 12
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
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
1189 261265 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 5 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
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
13075 261490 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
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
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
39981 256672 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 Kenwood Way 11 Back Yard : Yard Tree Private 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
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
92957 257936 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 2 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
97665 121104 Property Tree 8 Pinus radiata :: Monterey Pine 15 477 Myra Way 1 Back Yard : Yard Tree Private 2       3x3   5997298 2097021 37.7378652095891 -122.45185385939 (37.7378652095891, -122.45185385939) 9 7 4 59 40
105992 258053 Property Tree 8 Pinus radiata :: Monterey Pine 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
107546 112377 Property Tree 8 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 3 Sidewalk: Curb side : Cutout Tree MTA 3     36     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
129920 106227 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 38 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997884 2095808.5 37.7345695210024 -122.44974042874 (37.7345695210024, -122.44974042874) 9 7 4 59 40
131293 254124 Property Tree 8 Pinus radiata :: Monterey Pine 15 365 Edgehill Way 1 Back Yard : Cutout Tree Private 2       3x3   5994964 2098864 37.7427916745102 -122.460057057879 (37.7427916745102, -122.460057057879) 1 8 4 59 40
139843 108680 Property Tree 8 Juniperus chinensis :: Juniper 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree Private 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
148738 252848 Property Tree 8 Pinus halepensis :: Allepo Pine 330 99 Reposa Way 1 Back Yard : Yard Tree Private 2       3x3   5998022 2098104 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965) 9 7 4 59 40
150726 106275 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 42 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
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
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
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
176576 257935 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
192549 98880 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 101 Lansdale Ave 1 Front Yard : Yard Tree Private 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
5745 193934 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 Width 3ft   6016623.26344 2095403.70542 37.7345123576517 -122.384923708478 (37.7345123576517, -122.384923708478) 10 3 8 58 1
7677 258687 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 9 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12066 258686 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 8 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
15996 258691 Property Tree 8 Pinus radiata :: Monterey Pine 15 100x Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1

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