trees
1,977 rows where qSpecies_id = 41 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
537 | 261951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
595 | 261954 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
657 | 20296 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
720 | 19950 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
795 | 19570 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
1051 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
2302 | 19935 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
2744 | 261957 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2858 | 261960 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3011 | 19948 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 25ST | |||||||||||||
3028 | 19906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3052 | 19908 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3078 | 19568 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
3098 | 20419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3191 | 19565 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
3442 | 20392 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
4154 | 261966 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 20 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
4336 | 20312 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
4465 | 20303 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
4930 | 20365 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
5295 | 19947 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 25ST | |||||||||||||
5357 | 19933 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
5438 | 20428 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 40 | |||||||||||||
5813 | 20297 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
6028 | 261967 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Portola Dr | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
6583 | 20407 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 52 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
6724 | 261948 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
7317 | 20294 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
7644 | 19569 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
7787 | 19910 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
8411 | 19699 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40ST | |||||||||||||
8535 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
8582 | 19955 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2ST | |||||||||||||
8866 | 20398 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
8937 | 19804 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY22 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20 | |||||||||||||
9183 | 261965 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 19 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
9387 | 19932 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
9705 | 261963 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 17 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
9757 | 261950 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
9922 | 261964 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 18 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10143 | 256870 | Planning Code 138.1 required 2 | Cupressus macrocarpa :: Monterey Cypress 41 | 30X Bernal Heights Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 12x6 | ||||||||||||||
10413 | 20317 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
11142 | 20455 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
11294 | 20417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
12224 | 19907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
12236 | 20366 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
12293 | 20434 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
12390 | 20412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
12448 | 261958 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12674 | 19753 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY15 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
12679 | 19813 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY24 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
12914 | 20429 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
12968 | 19943 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
13027 | 261955 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13064 | 19694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 12ST | |||||||||||||
13121 | 261953 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13143 | 19776 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
13162 | 251365 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
13223 | 19700 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40ST | |||||||||||||
13417 | 19945 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
13718 | 251364 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
14026 | 19949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
14194 | 261962 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 16 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14203 | 20280 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
14241 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
14832 | 261961 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14966 | 20413 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
15219 | 251366 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
15603 | 251321 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Monument Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
15795 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
15823 | 20424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
15891 | 261952 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15921 | 20422 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
15978 | 20430 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
16093 | 19936 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
16153 | 19978 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY45 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 30ST | |||||||||||||
16212 | 261956 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
16465 | 19951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
16556 | 20423 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
16638 | 19909 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
16749 | 20291 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
16814 | 261949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
17534 | 261947 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
17805 | 20377 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
17984 | 20373 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18123 | 19934 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
18542 | 19869 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
18620 | 261959 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 13 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
19208 | 19953 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
19293 | 20452 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
19500 | 20013 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY47 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
19615 | 19566 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
115202 | 186631 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 7 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.509330032989 | (37.7606954284135, -122.509330032989) | 1 | 8 | 3 | 56 | 35 | |||
79662 | 186630 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 6 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.509326793851 | (37.7606655657469, -122.509326793851) | 1 | 8 | 3 | 56 | 35 | |||
72016 | 186632 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | 1 | 8 | 3 | 56 | 35 | |||
96178 | 186633 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | 1 | 8 | 3 | 56 | 35 |
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) );