trees
1,977 rows where qSpecies_id = 41 sorted by Latitude
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 | |||||||||||||
73406 | 176134 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 John Muir Dr | 2 | : | Tree | Private 2 | 16 | Width 0ft | 5987222.73644 | 2086464.92996 | 37.7082987351809 | -122.485913919409 | (37.7082987351809, -122.485913919409) | 1 | 8 | 4 | 64 | 14 | |||
179383 | 176133 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 John Muir Dr | 1 | : | Tree | Private 2 | 10 | Width 0ft | 5987205.94604 | 2086467.25904 | 37.7083041517833 | -122.485972119031 | (37.7083041517833, -122.485972119031) | 1 | 8 | 4 | 64 | 14 | |||
114998 | 176136 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 John Muir Dr | 4 | : | Tree | Private 2 | 11 | Width 0ft | 5987247.74108 | 2086476.2363 | 37.7083312366754 | -122.485828330936 | (37.7083312366754, -122.485828330936) | 1 | 8 | 4 | 64 | 14 | |||
104096 | 176135 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 John Muir Dr | 3 | : | Tree | Private 2 | 13 | Width 0ft | 5987227.51653 | 2086480.11804 | 37.7083407164149 | -122.485898513129 | (37.7083407164149, -122.485898513129) | 1 | 8 | 4 | 64 | 14 |
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) );