trees
151 rows where qSpecies_id = 185
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1408 | 260469 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
1722 | 19403 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 400X Sloat Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
2306 | 19600 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3171 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 299x Avalon Ave | 4 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
3184 | 260470 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 5 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
3831 | 250590 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | 5998102.22715 | 2111312.63197 | 37.7771524948281 | -122.450103070195 | (37.7771524948281, -122.450103070195) | 15 | 6 | 2 | 29492 | 16 | ||||
6314 | 118537 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 7915 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5982434.92947 | 2112334.2727 | 37.7790486288769 | -122.504376000287 | (37.7790486288769, -122.504376000287) | 11 | 6 | 2 | 55 | 26 | |||
6365 | 8477 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1900 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
7389 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
7574 | 19982 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY46 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
8174 | 173901 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4201x Lincoln Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x5 | ||||||||||||||
10129 | 19601 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10810 | 118536 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 7915 Geary Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5982451.53892 | 2112333.71263 | 37.7790480679712 | -122.504318500947 | (37.7790480679712, -122.504318500947) | 11 | 6 | 2 | 55 | 26 | |||
12026 | 19912 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY35 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
12627 | 256874 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
13528 | 19913 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY35 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
13643 | 19597 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
13805 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
14465 | 19599 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
14746 | 19595 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
15252 | 19827 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY25 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
15289 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
15354 | 19596 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
15443 | 19911 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY35 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
15835 | 47273 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | Permit Number 45219 | 6002244.66037 | 2088892.069 | 37.7158270832423 | -122.43416990474 | (37.7158270832423, -122.43416990474) | 9 | 7 | 6 | 28861 | 5 | |
16043 | 260472 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 7 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
18482 | 260468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 3 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
19621 | 19983 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY46 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
20151 | 110833 | Undocumented 4 | Cupressocyparis leylandii :: Leyland Cypress 185 | 533 PARNASSUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 5995513 | 2106277 | 37.7631774598891 | -122.458695326495 | (37.7631774598891, -122.458695326495) | 15 | 5 | 4 | 63 | 12 | ||
20778 | 30069 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
21013 | 250587 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5997646.23108 | 2111248.80698 | 37.776951143824 | -122.451675891826 | (37.776951143824, -122.451675891826) | 15 | 6 | 2 | 29492 | 16 | |||
21350 | 223684 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1101 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 14 | 6004763.09066 | 2096356.87709 | 37.7364664154027 | -122.425996119524 | (37.7364664154027, -122.425996119524) | 2 | 7 | 5 | 28859 | 2 | ||||
24110 | 19402 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 400X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
25221 | 19488 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100X Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 20M | 5984311.7495235 | 2095837.0474516 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | 1 | 8 | 3 | 64 | 35 | |||
25534 | 250574 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 5997258.88405 | 2111163.19525 | 37.7766938855506 | -122.453009655693 | (37.7766938855506, -122.453009655693) | 15 | 6 | 2 | 29492 | 16 | ||||
26781 | 120631 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
29747 | 250591 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 7ft | 5998359.83298 | 2111349.05645 | 37.7772672447332 | -122.449214558912 | (37.7772672447332, -122.449214558912) | 15 | 6 | 2 | 29492 | 16 | |||
30611 | 8604 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2400 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000257.3380802 | 2113384.6945808 | 37.7829649350443 | -122.442796706973 | (37.7829649350443, -122.442796706973) | 15 | 5 | 1 | 29490 | 13 | |||
32126 | 250588 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 5997756.4661 | 2111264.08964 | 37.7769994185268 | -122.451295659394 | (37.7769994185268, -122.451295659394) | 15 | 6 | 2 | 29492 | 16 | ||||
33954 | 8655 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 18 | M6 | 5998424.6782121 | 2113209.2212936 | 37.7823784827906 | -122.449124279941 | (37.7823784827906, -122.449124279941) | 15 | 6 | 1 | 54 | 31 | |||
34517 | 223685 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 76 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6003566.98749 | 2095725.27273 | 37.7346645013566 | -122.430086509581 | (37.7346645013566, -122.430086509581) | 2 | 7 | 5 | 63 | 7 | ||||
34622 | 19483 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1900X Sloat Blvd | 10 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5984946.1404685 | 2095883.2432037 | 37.734026040705 | -122.494475789917 | (37.734026040705, -122.494475789917) | 1 | 8 | 3 | 29491 | 35 | |||
35439 | 190961 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 151 Wisconsin St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6012606.72224 | 2106809.23912 | 37.7656065163403 | -122.399610842559 | (37.7656065163403, -122.399610842559) | 14 | 3 | 8 | 28856 | 20 | ||||
35760 | 118972 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4400 Cabrillo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5981914.76561 | 2110344.52005 | 37.7735547445483 | -122.50602785926 | (37.7735547445483, -122.50602785926) | 11 | 6 | 2 | 55 | 26 | |||
37662 | 8350 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 16 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
37715 | 250190 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 10ft | 5997282.93833 | 2110956.00474 | 37.7761263728801 | -122.45291148657 | (37.7761263728801, -122.45291148657) | 15 | 6 | 2 | 29492 | 16 | |||
38914 | 117889 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 526 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5982568.68483 | 2112177.26147 | 37.7786253881038 | -122.503901661967 | (37.7786253881038, -122.503901661967) | 11 | 6 | 2 | 55 | 26 | |||
39269 | 19395 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 200X Sloat Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5990818.4331684 | 2096048.8602469 | 37.7348227139519 | -122.474185743261 | (37.7348227139519, -122.474185743261) | 1 | 8 | 4 | 29491 | 40 | |||
39418 | 250579 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5997478.12296 | 2111225.14885 | 37.7768765558548 | -122.452255718936 | (37.7768765558548, -122.452255718936) | 15 | 6 | 2 | 29492 | 16 | |||
39836 | 2285 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 19 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
40066 | 250189 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 5997288.42031 | 2110933.51421 | 37.7760649338881 | -122.45289089929 | (37.7760649338881, -122.45289089929) | 15 | 6 | 2 | 29492 | 16 | |||
41433 | 19449 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5986974.9102614 | 2095954.0242956 | 37.7343389133904 | -122.48746699486 | (37.7343389133904, -122.48746699486) | 1 | 8 | 3 | 64 | 35 | |||
41580 | 190964 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Jack Balestreri Way | 36 | Front Yard : Yard | Tree | Private 2 | 16 | 6012433.13326 | 2104783.13919 | 37.7600336181869 | -122.400068950945 | (37.7600336181869, -122.400068950945) | 10 | 3 | 8 | 28856 | 29 | ||||
41871 | 19437 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5987408.7322245 | 2095946.646093 | 37.7343439457369 | -122.485966609595 | (37.7343439457369, -122.485966609595) | 1 | 8 | 3 | 64 | 35 | |||
42070 | 30068 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
43342 | 120633 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
44145 | 250581 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5997509.51988 | 2111229.44513 | 37.7768901508918 | -122.452147418077 | (37.7768901508918, -122.452147418077) | 15 | 6 | 2 | 29492 | 16 | ||||
44420 | 256875 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
44665 | 187544 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400 Somerset St | 4 | Side Yard : Yard | Tree | Private 2 | 16 | 6011380.55027 | 2088229.60878 | 37.71452238996 | -122.402545300722 | (37.71452238996, -122.402545300722) | 9 | 7 | 8 | 309 | 39 | ||||
48108 | 64515 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 720 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25396 | 6000553.55593738 | 2111421.0223091 | 37.7775900754915 | -122.441630952305 | (37.7775900754915, -122.441630952305) | 15 | 5 | 11 | 29490 | 41 |
49824 | 250612 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 7ft | 5998863.03763 | 2111421.57011 | 37.7774951176523 | -122.447479040039 | (37.7774951176523, -122.447479040039) | 15 | 6 | 2 | 29492 | 16 | |||
51838 | 186505 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400 Lower Great Hwy | 5 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | 1 | 8 | 3 | 56 | 35 | |||
52424 | 176095 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 271 Leland Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009495.21066 | 2087687.13777 | 37.7129274396128 | -122.409023568 | (37.7129274396128, -122.409023568) | 9 | 7 | 8 | 309 | 39 | |||
54360 | 250577 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 8ft | 5997444.6396 | 2111219.72454 | 37.7768597439099 | -122.452371155927 | (37.7768597439099, -122.452371155927) | 15 | 6 | 2 | 29492 | 16 | |||
58198 | 8538 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651 | (37.7837972495813, -122.43786449651) | 15 | 5 | 11 | 29490 | 13 | |||
58528 | 19484 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 20M | 5984311.7495235 | 2095837.0474516 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | 1 | 8 | 3 | 64 | 35 | |||
59450 | 2280 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 40 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
60066 | 8337 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
61863 | 190963 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Jack Balestreri Way | 35 | Front Yard : Yard | Tree | Private 2 | 28 | 6012430.01623 | 2104809.07988 | 37.7601046718029 | -122.400081553118 | (37.7601046718029, -122.400081553118) | 10 | 3 | 8 | 28856 | 29 | ||||
62413 | 223687 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6003595.32282 | 2095749.76231 | 37.7347333489588 | -122.429990291123 | (37.7347333489588, -122.429990291123) | 2 | 7 | 5 | 63 | 7 | ||||
63816 | 8345 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
65239 | 249599 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 7ft | 5998912.4282 | 2111428.40333 | 37.7775167022821 | -122.447308674267 | (37.7775167022821, -122.447308674267) | 15 | 6 | 2 | 29492 | 16 | |||
65742 | 176092 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Italy Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6002233.31845 | 2088899.94109 | 37.715848054527 | -122.434209670065 | (37.715848054527, -122.434209670065) | 9 | 7 | 6 | 28861 | 5 | |||
66218 | 223690 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 3287 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006386.04454 | 2103750.12413 | 37.7568581848634 | -122.420909618783 | (37.7568581848634, -122.420909618783) | 2 | 4 | 7 | 28859 | 19 | |||
70206 | 250569 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 5997276.19674 | 2111033.33857 | 37.7763383251004 | -122.452940390794 | (37.7763383251004, -122.452940390794) | 15 | 6 | 2 | 29492 | 16 | ||||
71202 | 250578 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 5997460.21338 | 2111222.95498 | 37.7768695060652 | -122.452317514945 | (37.7768695060652, -122.452317514945) | 15 | 6 | 2 | 29492 | 16 | |||
73363 | 8346 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
74907 | 30067 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
76163 | 19396 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 200X Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5990818.4331684 | 2096048.8602469 | 37.7348227139519 | -122.474185743261 | (37.7348227139519, -122.474185743261) | 1 | 8 | 4 | 29491 | 40 | |||
76832 | 223689 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 278 Upper Ter | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | Width 4ft | 5999412.71789 | 2106090.89076 | 37.7628898173431 | -122.445194172985 | (37.7628898173431, -122.445194172985) | 15 | 5 | 5 | 29492 | 9 | |||
76894 | 256873 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
77635 | 250567 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 5997282.79592 | 2110980.7211 | 37.7761942294073 | -122.452913763658 | (37.7761942294073, -122.452913763658) | 15 | 6 | 2 | 29492 | 16 | ||||
78510 | 256521 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 3 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
81963 | 8336 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
86023 | 19397 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 300X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990549.2944822 | 2096013.3169503 | 37.7347095261344 | -122.475113645462 | (37.7347095261344, -122.475113645462) | 1 | 8 | 4 | 64 | 40 | |||
86244 | 250580 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 5997493.10232 | 2111228.13721 | 37.7768856192175 | -122.452204116724 | (37.7768856192175, -122.452204116724) | 15 | 6 | 2 | 29492 | 16 | |||
86290 | 8335 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
90989 | 8343 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
93179 | 223686 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6003580.53373 | 2095739.50976 | 37.734704360212 | -122.430040690922 | (37.734704360212, -122.430040690922) | 2 | 7 | 5 | 63 | 7 | ||||
93897 | 250589 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5997875.41929 | 2111281.04875 | 37.7770527941865 | -122.450885388659 | (37.7770527941865, -122.450885388659) | 15 | 6 | 2 | 29492 | 16 | ||||
94259 | 250575 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5997256.45682 | 2111186.28266 | 37.7767571384568 | -122.453019719107 | (37.7767571384568, -122.453019719107) | 15 | 6 | 2 | 29492 | 16 | ||||
97351 | 2279 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 13 | Median : Cutout | Tree | DPW 1 | 40 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
97731 | 251241 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2305 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998495 | 2111363 | 37.777313260379 | -122.448747979297 | (37.777313260379, -122.448747979297) | 15 | 6 | 2 | 29492 | 16 | |||||
99268 | 250571 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5997270.54496 | 2111084.7365 | 37.7764791265377 | -122.452963652673 | (37.7764791265377, -122.452963652673) | 15 | 6 | 2 | 29492 | 16 | ||||
99384 | 176093 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Italy Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 6002215.73545 | 2088910.66953 | 37.7158765144653 | -122.434271211548 | (37.7158765144653, -122.434271211548) | 9 | 7 | 6 | 28861 | 5 | |||
100952 | 87567 | Permitted Site 7 | Cupressocyparis leylandii :: Leyland Cypress 185 | 10 Corwin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50392 | 6000837 | 2103986 | 37.7571914971866 | -122.440117143339 | (37.7571914971866, -122.440117143339) | 2 | 4 | 5 | 28862 | 38 | |||
103239 | 250573 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5997263.27261 | 2111141.17003 | 37.7766336615401 | -122.45299288421 | (37.7766336615401, -122.45299288421) | 15 | 6 | 2 | 29492 | 16 | ||||
105835 | 8403 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.7850570827926 | -122.428012143853 | (37.7850570827926, -122.428012143853) | 13 | 9 | 11 | 28858 | 13 | |||
109299 | 250595 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | 5998510.66659 | 2111373.95167 | 37.7773442266945 | -122.448694572711 | (37.7773442266945, -122.448694572711) | 15 | 6 | 2 | 29492 | 16 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );