Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
| 94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
| 125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 78153 | 78153 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 83945 | 83945 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 84454 | 84454 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 85803 | 85803 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 174 STILLINGS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | |||||
| 88432 | 88432 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2398 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
| 90158 | 90158 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 91812 | 91812 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001257.0 | 2116757.0 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | ||||
| 91961 | 91961 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 93035 | 93035 | 103565 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
| 97963 | 97963 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 109308 | 109308 | 103590 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 109984 | 109984 | 116585 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2100 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011843.0 | 2103815.0 | 37.757342401329105 | -122.402041888427 | (37.7573424013291, -122.402041888427) | |||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 112529 | 112529 | 104716 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 115088 | 115088 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 3X3 | 5999593.0 | 2099199.0 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) | |||
| 116755 | 116755 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 117763 | 117763 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x8 | 5997298.0 | 2095759.0 | 37.7344000615683 | -122.45176284684601 | (37.7344000615683, -122.451762846846) | ||||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 140837 | 140837 | 105857 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 1500X Valencia St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6006259.2 | 2100711.5 | 37.7485076710609 | -122.42113253995599 | (37.7485076710609, -122.421132539956) | ||||
| 143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 6044 | 6044 | 107491 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6011446.048280001 | 2119975.7461599996 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | ||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
| 11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 15377 | 15377 | 25938 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6012867.3394 | 2097145.5573099998 | 37.739086658519895 | -122.39803142710899 | (37.7390866585199, -122.398031427109) | ||
| 15925 | 15925 | 25939 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6012857.31615 | 2097153.53613 | 37.7391080084261 | -122.39806664277201 | (37.7391080084261, -122.398066642772) | ||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 17954 | 17954 | 16098 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | ||
| 18654 | 18654 | 16099 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000036.69943 | 2094718.89433 | 37.7317006461483 | -122.442219656332 | (37.7317006461483, -122.442219656332) | |||
| 18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
| 19631 | 19631 | 16102 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000017.68556 | 2094719.9660099999 | 37.7317025050652 | -122.442285467815 | (37.7317025050652, -122.442285467815) | |||
| 21395 | 21395 | 16100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000028.57256 | 2094720.41703 | 37.7317043639536 | -122.442247861742 | (37.7317043639536, -122.442247861742) | |||
| 21593 | 21593 | 16127 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 330 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999874.93833 | 2094721.1240700001 | 37.7316975479954 | -122.442779055318 | (37.7316975479954, -122.442779055318) | |||
| 26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
| 27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
| 32407 | 32407 | 866 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 43705 | 43705 | 190817 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.40845015844101 | (37.7645813917285, -122.408450158441) | |||
| 45155 | 45155 | 190814 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 6010041.1190599995 | 2106539.02685 | 37.7647212291204 | -122.40846567444599 | (37.7647212291204, -122.408465674446) | |||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 75147 | 75147 | 129353 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6011391.406830001 | 2120329.06369 | 37.8026609588854 | -122.404766271855 | (37.8026609588854, -122.404766271855) | |||
| 86324 | 86324 | 121732 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 104252 | 104252 | 121734 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
| 112118 | 112118 | 878 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 135071 | 135071 | 190816 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 6010044.10542 | 2106509.4810599997 | 37.7646402703573 | -122.40845326111099 | (37.7646402703573, -122.408453261111) | |||
| 139863 | 139863 | 24744 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 128X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982380.471419999 | 2112632.1433099997 | 37.7798632908372 | -122.504586464809 | (37.7798632908372, -122.504586464809) | ||
| 154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
| 163136 | 163136 | 129352 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6011406.69978 | 2120255.02893 | 37.8024585322873 | -122.404708135188 | (37.8024585322873, -122.404708135188) | |||
| 175803 | 175803 | 129354 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.40477563290199 | (37.8026870410416, -122.404775632902) | |||
| 181902 | 181902 | 190815 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | |||
| 183528 | 183528 | 219372 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 400x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | |||
| 188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) | |||
| 37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
| 44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 65 | 65 | 226926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
| 8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
| 8632 | 8632 | 99720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007185.20399 | 2119756.67852 | 37.8008533386708 | -122.41928126041701 | (37.8008533386708, -122.419281260417) | |||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 12269 | 12269 | 106828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | |||
| 14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
| 23498 | 23498 | 176772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 6007351.78047 | 2093548.13266 | 37.72890017978 | -122.41684696742901 | (37.72890017978, -122.416846967429) | |||
| 23542 | 23542 | 176768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 955 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6007502.25565 | 2093569.5745700002 | 37.7289675174267 | -122.416328280725 | (37.7289675174267, -122.416328280725) | |||
| 23567 | 23567 | 137685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 720 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000552.856000001 | 2111474.7278 | 37.7777374972355 | -122.441637228704 | (37.7777374972355, -122.441637228704) | |||
| 23730 | 23730 | 219413 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999418.48835 | 2095681.2919599998 | 37.734307911173204 | -122.444426068323 | (37.7343079111732, -122.444426068323) | |||
| 23847 | 23847 | 226860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22961 | 2096323.57705 | 37.7361509008315 | -122.43965349751801 | (37.7361509008315, -122.439653497518) | |||
| 23881 | 23881 | 129298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6006767.5192599995 | 2119403.73147 | 37.799860702966 | -122.420701557924 | (37.799860702966, -122.420701557924) | |||
| 24179 | 24179 | 226965 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 26 Danvers St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5999778.9374 | 2105368.70326 | 37.7609277664162 | -122.44387566164801 | (37.7609277664162, -122.443875661648) | |||
| 24188 | 24188 | 247556 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6000035.32206 | 2108353.94379 | 37.7691391145131 | -122.443203353661 | (37.7691391145131, -122.443203353661) | |||
| 24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
| 24254 | 24254 | 219293 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 480 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5998219.47976 | 2094421.4454299998 | 37.7307801864506 | -122.448480709434 | (37.7307801864506, -122.448480709434) | |||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 24727 | 24727 | 129157 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5997198.13027 | 2114418.3589 | 37.785628226512706 | -122.45345490104499 | (37.7856282265127, -122.453454901045) | |||
| 24753 | 24753 | 129266 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 24 Priest St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6008334.4403800005 | 2117141.01825 | 37.7937360410291 | -122.41511915572399 | (37.7937360410291, -122.415119155724) |
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");