Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
618 | 618 | 20377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
815 | 815 | 8534 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.2830000003 | 37.78337929999999 | -122.43891571692801 | (37.7833793, -122.438915716928) | ||
869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
886 | 886 | 19568 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
1561 | 1561 | 8580 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000778.3855 | 2113430.8926 | 37.783121473536795 | -122.44099741813 | (37.7831214735368, -122.44099741813) | ||
1776 | 1776 | 8585 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000465.007 | 2113386.3901 | 37.78298142730029 | -122.442078382069 | (37.7829814273003, -122.442078382069) | ||
1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
1875 | 1875 | 251783 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 610 Clipper St | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | Width 2ft | 6001275.75039 | 2100902.7174 | 37.7487505133321 | -122.438378885672 | (37.7487505133321, -122.438378885672) | ||||
1898 | 1898 | 20392 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
2144 | 2144 | 252907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Point Lobos Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10x10 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.50318049806101 | (37.7794859217892, -122.503180498061) | ||||
2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
2531 | 2531 | 8603 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 5999987.1554 | 2113318.7057 | 37.782768340075606 | -122.443726682203 | (37.7827683400756, -122.443726682203) | |||
3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
3981 | 3981 | 18927 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2691 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001960.28459 | 2115686.06098 | 37.7893808348161 | -122.437070045665 | (37.7893808348161, -122.437070045665) | |||
4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
4098 | 4098 | 8400 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003921.0381 | 2113941.5724 | 37.7847021645415 | -122.430161561145 | (37.7847021645415, -122.430161561145) | |||
4214 | 4214 | 8397 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.42976141314301 | (37.7847401317276, -122.429761413143) | |||
4399 | 4399 | 8467 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002321.2505 | 2113708.7369 | 37.783972118374 | -122.435679623339 | (37.783972118374, -122.435679623339) | |||
4512 | 4512 | 8466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002359.1538 | 2113715.5053 | 37.7839928555225 | -122.435548976348 | (37.7839928555225, -122.435548976348) | |||
5083 | 5083 | 253786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
5088 | 5088 | 206891 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | Width 3ft | 5991393.559640001 | 2103864.47578 | 37.756315678748706 | -122.472767037095 | (37.7563156787487, -122.472767037095) | |||
5089 | 5089 | 253778 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
5095 | 5095 | 253779 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5100 | 5100 | 253781 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5107 | 5107 | 253780 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5557 | 5557 | 20407 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
5633 | 5633 | 8583 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000590.222999999 | 2113406.0186 | 37.7830424571155 | -122.441646596602 | (37.7830424571155, -122.441646596602) | |||
5855 | 5855 | 19776 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
5866 | 5866 | 14435 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3X3 | 5998902.8519 | 2113071.3194 | 37.7820271773983 | -122.447460087026 | (37.7820271773983, -122.447460087026) | |||
5929 | 5929 | 8470 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002187.2355 | 2113695.2 | 37.7839273365059 | -122.43614229642701 | (37.7839273365059, -122.436142296427) | |||
6006 | 6006 | 20312 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
6023 | 6023 | 19905 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6096 | 6096 | 8399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003960.687000001 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | |||
6115 | 6115 | 20296 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6147 | 6147 | 19906 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
6357 | 6357 | 20291 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
6360 | 6360 | 20424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6399 | 6399 | 20412 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6463 | 6463 | 8468 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002285.3778 | 2113701.9684 | 37.7839514961521 | -122.435803245129 | (37.7839514961521, -122.435803245129) | |||
6510 | 6510 | 8398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.784725324941604 | -122.429898258777 | (37.7847253249416, -122.429898258777) | |||
6517 | 6517 | 19907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6533 | 6533 | 19565 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
6721 | 6721 | 8476 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001756.762999999 | 2113633.6072 | 37.783733752237 | -122.437627157513 | (37.783733752237, -122.437627157513) | |||
6783 | 6783 | 14432 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998887.9614 | 2113022.2482 | 37.781891589698894 | -122.44750806785801 | (37.7818915896989, -122.447508067858) | |||
6794 | 6794 | 8396 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | ||
6834 | 6834 | 19955 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2ST | ||||||||
6839 | 6839 | 8584 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000533.0297 | 2113398.5733 | 37.7830187554699 | -122.441843926918 | (37.7830187554699, -122.441843926918) | |||
6952 | 6952 | 19935 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
7006 | 7006 | 20417 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
7140 | 7140 | 8579 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000836.5941 | 2113437.661 | 37.7831433729932 | -122.440796526182 | (37.7831433729932, -122.440796526182) | |||
7230 | 7230 | 8401 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003886.7265 | 2113933.9476 | 37.7846792853457 | -122.43027972368401 | (37.7846792853457, -122.430279723684) | |||
7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
7548 | 7548 | 20317 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
7732 | 7732 | 19948 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
7773 | 7773 | 8602 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000066.0077 | 2113328.1816 | 37.7827988555755 | -122.44345456827601 | (37.7827988555755, -122.443454568276) | |||
7886 | 7886 | 19945 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
7938 | 7938 | 19700 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
8196 | 8196 | 20297 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
8406 | 8406 | 20373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
8584 | 8584 | 2988 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2266X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003528.90719 | 2115622.95537 | 37.7892965998021 | -122.431638286196 | (37.7892965998021, -122.431638286196) | |||
8647 | 8647 | 8473 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001933.4192 | 2113657.2968 | 37.7838088404542 | -122.437017691332 | (37.7838088404542, -122.437017691332) | |||
8713 | 8713 | 8650 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5998245.1291 | 2113130.374 | 37.7821517178635 | -122.449739754186 | (37.7821517178635, -122.449739754186) | |||
8739 | 8739 | 20365 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
8750 | 8750 | 20413 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
8879 | 8879 | 8531 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6001578.5839 | 2113601.7956 | 37.783636273313604 | -122.43824130906401 | (37.7836362733136, -122.438241309064) | |||
8903 | 8903 | 19566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
8960 | 8960 | 8622 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999315.0497 | 2113216.8408 | 37.782450288182 | -122.44604454634701 | (37.782450288182, -122.446044546347) | |||
9072 | 9072 | 19804 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY22 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20 | ||||||||
9473 | 9473 | 20455 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 495X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
9584 | 9584 | 20422 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
10571 | 10571 | 19570 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
10618 | 10618 | 2271 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5990752.82343 | 2088228.49759 | 37.71334614597279 | -122.47384223413499 | (37.7133461459728, -122.473842234135) | |||
10674 | 10674 | 19936 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
10701 | 10701 | 20452 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 495X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
10705 | 10705 | 19569 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
10816 | 10816 | 19910 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
10904 | 10904 | 19431 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.48490645815501 | (37.7343051218756, -122.484906458155) | ||
10938 | 10938 | 2269 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990714.96133 | 2088247.7727 | 37.7133968776506 | -122.473974502829 | (37.7133968776506, -122.473974502829) | |||
10949 | 10949 | 19933 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
11028 | 11028 | 2270 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990735.60667 | 2088236.9442599998 | 37.7133683412468 | -122.473902356505 | (37.7133683412468, -122.473902356505) | |||
11220 | 11220 | 19950 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
11591 | 11591 | 20428 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 40 | ||||||||
11826 | 11826 | 20419 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");