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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78535 | 78535 | 110569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
| 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) | ||||
| 97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
| 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) | |||
| 107354 | 107354 | 110571 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
| 107819 | 107819 | 114704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 524 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | |||||
| 108530 | 108530 | 110402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 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) | |||
| 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) | |||
| 115819 | 115819 | 110406 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
| 130260 | 130260 | 54791 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.711719793993204 | -122.39815894829901 | (37.7117197939932, -122.398158948299) | ||
| 131920 | 131920 | 31117 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.33216 | 2094320.7757 | 37.7305365079364 | -122.446493035949 | (37.7305365079364, -122.446493035949) | |
| 132065 | 132065 | 226896 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1243 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006432.373930001 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | |||
| 132381 | 132381 | 226897 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | |||
| 132689 | 132689 | 176620 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Desmond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010562.66148 | 2086802.426 | 37.710557939180795 | -122.405271825739 | (37.7105579391808, -122.405271825739) | |||
| 132978 | 132978 | 190823 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 184 Hooper St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 8ft | 6012465.245630001 | 2107532.99928 | 37.7675859124819 | -122.400151016782 | (37.7675859124819, -122.400151016782) | |||
| 133392 | 133392 | 68011 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 4 | Permit Number 31741 | 6007478.84194 | 2121154.66744 | 37.8047083959278 | -122.41836432607501 | (37.8047083959278, -122.418364326075) | ||
| 133611 | 133611 | 227022 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 121 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008279.64625 | 2099237.50243 | 37.7445740950309 | -122.41404158626999 | (37.7445740950309, -122.41404158627) | |||
| 134405 | 134405 | 62997 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 6 | Permit Number 776580 | 6000198.89461 | 2121071.17508 | 37.8040666559246 | -122.443551231218 | (37.8040666559246, -122.443551231218) | ||
| 134612 | 134612 | 190772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | |||
| 134676 | 134676 | 226905 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001346.10314 | 2099785.59551 | 37.7456871634399 | -122.438055596491 | (37.7456871634399, -122.438055596491) | |||
| 135527 | 135527 | 226938 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 471 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001539.72825 | 2103087.28578 | 37.754763826593496 | -122.437622481215 | (37.7547638265935, -122.437622481215) | |||
| 136530 | 136530 | 46600 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2425 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | 5 | Permit Number 44728 | 6001248.41305 | 2117934.15473 | 37.795513025858 | -122.439694270995 | (37.795513025858, -122.439694270995) | ||
| 137589 | 137589 | 101799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 616 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6x6 | 6012351.43379 | 2105077.38644 | 37.7608370005419 | -122.400372179851 | (37.7608370005419, -122.400372179851) | |||
| 137719 | 137719 | 190768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1475 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015141.73354 | 2101746.8036700003 | 37.751847135458895 | -122.39048896238998 | (37.7518471354589, -122.39048896239) | |||
| 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) | ||
| 144668 | 144668 | 110414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 146783 | 146783 | 35594 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.6753599998 | 37.752955146087295 | -122.401332479509 | (37.7529551460873, -122.401332479509) | |
| 147284 | 147284 | 176635 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012623.11061 | 2087166.05245 | 37.7116713673138 | -122.398175911295 | (37.7116713673138, -122.398175911295) | |||
| 148745 | 148745 | 61250 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1997 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.800048553351296 | -122.41764457883001 | (37.8000485533513, -122.41764457883) | |
| 149049 | 149049 | 245188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1185 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000914.1833 | 2109291.5347 | 37.7717635792199 | -122.440230675759 | (37.7717635792199, -122.440230675759) | |||
| 149982 | 149982 | 190828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016393.1041 | 2108697.45755 | 37.7710014881618 | -122.386646144905 | (37.7710014881618, -122.386646144905) | |||
| 151494 | 151494 | 110917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121001 | (37.7829898170664, -122.39259867121) | |||
| 151778 | 151778 | 245189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1175 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000936.7356 | 2109295.3643 | 37.77177537830379 | -122.440152940733 | (37.7717753783038, -122.440152940733) | |||
| 151842 | 151842 | 226892 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 533 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009849.313709999 | 2098992.71311 | 37.743989993451 | -122.408596701189 | (37.743989993451, -122.408596701189) | |||
| 155878 | 155878 | 119158 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981361.29524 | 2110027.47694 | 37.772651641953395 | -122.507918828236 | (37.7726516419534, -122.507918828236) | |||
| 157403 | 157403 | 226885 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997889.74449 | 2105168.82757 | 37.760271015821296 | -122.450395110664 | (37.7602710158213, -122.450395110664) | |||
| 157526 | 157526 | 97087 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4.5 | 5981444.7277 | 2111006.81618 | 37.7753455356701 | -122.50770291724501 | (37.7753455356701, -122.507702917245) | |||
| 157750 | 157750 | 30806 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 138 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 15 | Permit Number 34671 | 6001325.75026 | 2095385.6774799998 | 37.7336048607826 | -122.437810896383 | (37.7336048607826, -122.437810896383) | |
| 159101 | 159101 | 226886 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997890.66163 | 2105156.29016 | 37.760236643732796 | -122.450391034916 | (37.7602366437328, -122.450391034916) | |||
| 159523 | 159523 | 34521 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 306 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 11 | Permit Number 38231 | 6006308.04583 | 2092388.1729 | 37.725656419580496 | -122.42037294026301 | (37.7256564195805, -122.420372940263) | ||
| 159879 | 159879 | 176598 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 156 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000311.35306 | 2092335.41636 | 37.725171815405 | -122.441099188288 | (37.725171815405, -122.441099188288) | |||
| 163948 | 163948 | 185240 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2538 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985848.3989 | 2097948.0365 | 37.7397481784215 | -122.491508379416 | (37.7397481784215, -122.491508379416) | |||
| 164696 | 164696 | 110916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014753.14393 | 2113088.0309200003 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | |||
| 167059 | 167059 | 176607 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1186 Munich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6001048.8202 | 2087208.00194 | 37.7111350656127 | -122.438182703088 | (37.7111350656127, -122.438182703088) | |||
| 167504 | 167504 | 226901 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1322 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001336.59248 | 2099937.64594 | 37.746104117009295 | -122.438099372796 | (37.7461041170093, -122.438099372796) | |||
| 167693 | 167693 | 38364 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825001 | (37.7566067521127, -122.50598509825) | |
| 168266 | 168266 | 184451 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2150 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982967.4153 | 2100488.966 | 37.7465560908843 | -122.50165736947099 | (37.7465560908843, -122.501657369471) | |||
| 170147 | 170147 | 190829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016399.44084 | 2108687.19343 | 37.770973655936 | -122.386623509886 | (37.770973655936, -122.386623509886) | |||
| 170907 | 170907 | 129360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 555 California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6011669.484759999 | 2116684.16602 | 37.7926684882083 | -122.40354738383002 | (37.7926684882083, -122.40354738383) | |||
| 173736 | 173736 | 57800 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1977 12:00:00 AM | 9 | Permit Number 16735 | 5981352.9647 | 2110030.94394 | 37.7726606704836 | -122.50794790130199 | (37.7726606704836, -122.507947901302) | ||
| 174140 | 174140 | 49714 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | |
| 174872 | 174872 | 183003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2570 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988097.5458 | 2098263.8729 | 37.740746562571005 | -122.48375503089301 | (37.740746562571, -122.483755030893) | |||
| 175407 | 175407 | 219276 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1607 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993358.66826 | 2104530.96639 | 37.75825925039079 | -122.466019495715 | (37.7582592503908, -122.466019495715) | |||
| 178358 | 178358 | 226936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1487 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003327.22961 | 2099593.7477 | 37.7452728619629 | -122.431191467012 | (37.7452728619629, -122.431191467012) | |||
| 180106 | 180106 | 176853 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 44 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6002702.22859 | 2087060.99975 | 37.7108253274008 | -122.43245763061 | (37.7108253274008, -122.43245763061) | |||
| 180391 | 180391 | 69013 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2183 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 4 | Permit Number 33017 | 5982309.8617 | 2100270.0071 | 37.7459162464128 | -122.50391486605301 | (37.7459162464128, -122.503914866053) | |
| 181098 | 181098 | 110919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.783047040932395 | -122.39252008665001 | (37.7830470409324, -122.39252008665) | |||
| 182712 | 182712 | 183002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2590 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988041.6053 | 2098260.4304 | 37.7407338538563 | -122.48394819724399 | (37.7407338538563, -122.483948197244) | |||
| 183234 | 183234 | 43136 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1730 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42952 | 6006290.853069999 | 2092023.3911599999 | 37.7246538391803 | -122.42040649398199 | (37.7246538391803, -122.420406493982) | |
| 185007 | 185007 | 190767 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015346.46104 | 2101795.38447 | 37.751991883134295 | -122.38978437325198 | (37.7519918831343, -122.389784373252) | |||
| 185418 | 185418 | 226891 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 257 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009789.62155 | 2099611.54236 | 37.745685819851104 | -122.408846754995 | (37.7456858198511, -122.408846754995) | |||
| 185451 | 185451 | 176846 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 211 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007213.98461 | 2092669.27766 | 37.7264792821724 | -122.417261085441 | (37.7264792821724, -122.417261085441) | |||
| 186712 | 186712 | 38366 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 6 | Permit Number 40430 | 5981835.1907 | 2104176.6987 | 37.756614999407894 | -122.50584576351999 | (37.7566149994079, -122.50584576352) | ||
| 186803 | 186803 | 226887 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1266 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997536.57649 | 2105194.59271 | 37.7603215415281 | -122.451618405363 | (37.7603215415281, -122.451618405363) | |||
| 186871 | 186871 | 190764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2131 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011336.13604 | 2105543.46577 | 37.762060080324204 | -122.403916462872 | (37.7620600803242, -122.403916462872) | |||
| 188311 | 188311 | 248142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009850.53205 | 2099420.75509 | 37.7451653713952 | -122.40862267810499 | (37.7451653713952, -122.408622678105) | |||
| 26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
| 32222 | 32222 | 219278 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994659.22206 | 2100668.89439 | 37.747729927596396 | -122.46124169176001 | (37.7477299275964, -122.46124169176) | |||
| 39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) | |||
| 42674 | 42674 | 219277 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994666.162690001 | 2100675.76794 | 37.74774920006679 | -122.46121818977501 | (37.7477492000668, -122.461218189775) | |||
| 46210 | 46210 | 226966 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 17 Temple St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000015.92856 | 2105901.5883400002 | 37.7624044523192 | -122.443094287484 | (37.7624044523192, -122.443094287484) | |||
| 47837 | 47837 | 219366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992883.56621 | 2099683.9790000003 | 37.7449232514072 | -122.46731015773999 | (37.7449232514072, -122.46731015774) | |||
| 53868 | 53868 | 219242 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995302.90929 | 2090039.9744900002 | 37.718582527746705 | -122.45824668854799 | (37.7185825277467, -122.458246688548) | |||
| 53919 | 53919 | 218142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.717992043688895 | -122.449490525783 | (37.7179920436889, -122.449490525783) | |||
| 54353 | 54353 | 190762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1540 Newhall St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6014201.85219 | 2095471.1202599998 | 37.7345632359036 | -122.39330011180901 | (37.7345632359036, -122.393300111809) | |||
| 56355 | 56355 | 190820 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2301 Silver Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6012984.546630001 | 2096381.0531099997 | 37.7369940170607 | -122.397572570511 | (37.7369940170607, -122.397572570511) | |||
| 65273 | 65273 | 219243 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995302.33675 | 2090036.07608 | 37.718571790736796 | -122.45824838556601 | (37.7185717907368, -122.458248385566) | |||
| 73223 | 73223 | 118055 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 499 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5984683.022969999 | 2112541.9282299997 | 37.7797507575988 | -122.496614381059 | (37.7797507575988, -122.496614381059) | |||
| 73904 | 73904 | 219369 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994238.9129800005 | 2101823.0990400002 | 37.750874882880396 | -122.46277880671002 | (37.7508748828804, -122.46277880671) | |||
| 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) | |||
| 152524 | 152524 | 219341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 176 Margaret Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 10ft | 5996604.57651 | 2089160.1054 | 37.7162413244539 | -122.45368388192101 | (37.7162413244539, -122.453683881921) | |||
| 155247 | 155247 | 190819 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2301 Silver Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6013014.89599 | 2096394.0221900002 | 37.7370313173328 | -122.397468547752 | (37.7370313173328, -122.397468547752) | |||
| 156857 | 156857 | 176639 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994551.36715 | 2086753.98013 | 37.7095167499667 | -122.460606453835 | (37.7095167499667, -122.460606453835) | |||
| 158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
| 160189 | 160189 | 185221 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | |||
| 168701 | 168701 | 182592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2489 26th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988273.3615 | 2098387.8742 | 37.7410972704537 | -122.483156220906 | (37.7410972704537, -122.483156220906) | |||
| 169609 | 169609 | 190818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Helena St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6011192.32656 | 2096261.9333400002 | 37.7365669811865 | -122.403760731784 | (37.7365669811865, -122.403760731784) | |||
| 175801 | 175801 | 219367 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992906.92509 | 2099685.21793 | 37.74492800164 | -122.46722947778 | (37.74492800164, -122.46722947778) | |||
| 182427 | 182427 | 219370 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994548.062390001 | 2100959.98911 | 37.748522802305004 | -122.461647175376 | (37.748522802305, -122.461647175376) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");