Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188850 | 188850 | 207816 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 236 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5997465.81636 | 2094312.11288 | 37.73043686484979 | -122.45107834899599 | (37.7304368648498, -122.451078348996) | |||
| 188762 | 188762 | 65630 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2510 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 8 | Permit Number 28538 | 6001388.347 | 2114610.3564 | 37.7863947012265 | -122.43897175770701 | (37.7863947012265, -122.438971757707) | |
| 188748 | 188748 | 207927 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1630 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991926.85515 | 2096424.2337 | 37.7359175438479 | -122.470380908151 | (37.7359175438479, -122.470380908151) | |||
| 188479 | 188479 | 207867 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1350 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5994282.22065 | 2106308.08088 | 37.7631919832571 | -122.46295440383498 | (37.7631919832571, -122.462954403835) | |||
| 188436 | 188436 | 207812 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 635 Hearst Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5997216.39115 | 2094387.61086 | 37.7306298809467 | -122.451946087746 | (37.7306298809467, -122.451946087746) | |||
| 188377 | 188377 | 137560 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1250 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002310.5713 | 2112882.3991 | 37.781702597408795 | -122.435657430814 | (37.7817025974088, -122.435657430814) | |||
| 188363 | 188363 | 227455 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 122 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001675.52241 | 2108124.5913400003 | 37.7686027588258 | -122.43751357779101 | (37.7686027588258, -122.437513577791) | |||
| 188031 | 188031 | 227333 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 245 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998975.3756099995 | 2106713.7250599996 | 37.7645749912571 | -122.446751599103 | (37.7645749912571, -122.446751599103) | |||
| 187923 | 187923 | 114432 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 700 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777170 | 5992893.39745 | 2110635.08838 | 37.774992699186 | -122.468072606609 | (37.774992699186, -122.468072606609) | ||
| 187844 | 187844 | 64559 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.774506509156204 | -122.442246634385 | (37.7745065091562, -122.442246634385) | |
| 187706 | 187706 | 55001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.777706381155205 | -122.474810664746 | (37.7777063811552, -122.474810664746) | ||
| 187520 | 187520 | 226741 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010258.15584 | 2102463.0673700003 | 37.7535417126867 | -122.407427621191 | (37.7535417126867, -122.407427621191) | |||
| 187456 | 187456 | 191461 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 26 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6014466.473259999 | 2112793.29077 | 37.782140875944 | -122.393597178563 | (37.782140875944, -122.393597178563) | |||
| 187438 | 187438 | 227401 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 569 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002632.3517 | 2103249.18042 | 37.75527041381021 | -122.433855464885 | (37.7552704138102, -122.433855464885) | |||
| 187412 | 187412 | 207389 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1726 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993749.768130001 | 2103720.2567 | 37.7560558061474 | -122.464608044838 | (37.7560558061474, -122.464608044838) | |||
| 187356 | 187356 | 207814 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 5999174.291680001 | 2094063.56835 | 37.729852086101396 | -122.44515406592899 | (37.7298520861014, -122.445154065929) | |||
| 186959 | 186959 | 66501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | |
| 186720 | 186720 | 226746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 41 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010705.09671 | 2100401.8324 | 37.7479070202997 | -122.40573681752599 | (37.7479070202997, -122.405736817526) | |||
| 186701 | 186701 | 177068 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 26 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000490.27056 | 2088504.66061 | 37.7146636177052 | -122.440206107549 | (37.7146636177052, -122.440206107549) | |||
| 186625 | 186625 | 61561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.40014150193399 | (37.754725580248, -122.400141501934) | |
| 185957 | 185957 | 207972 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 204 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996281.29923 | 2096182.49278 | 37.7355045886606 | -122.45530848830299 | (37.7355045886606, -122.455308488303) | |||
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
| 185760 | 185760 | 191462 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 44 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014434.11551 | 2112764.95464 | 37.7820612733549 | -122.393707138698 | (37.7820612733549, -122.393707138698) | |||
| 185546 | 185546 | 129643 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 926 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007928.293190001 | 2120314.2038 | 37.8024259849283 | -122.416749372103 | (37.8024259849283, -122.416749372103) | |||
| 185445 | 185445 | 226712 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010271.799319999 | 2102896.97753 | 37.754733897156 | -122.407411026915 | (37.754733897156, -122.407411026915) | |||
| 185371 | 185371 | 227352 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005581.68888 | 2097079.0360400002 | 37.738495532331704 | -122.42321719373999 | (37.7384955323317, -122.42321719374) | |||
| 185158 | 185158 | 227512 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006402.46798 | 2109528.79831 | 37.772725988548395 | -122.42126315847601 | (37.7727259885484, -122.421263158476) | |||
| 184900 | 184900 | 227457 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 38 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000239.37945 | 2106664.2294799997 | 37.7645112140449 | -122.442376209409 | (37.7645112140449, -122.442376209409) | |||
| 184817 | 184817 | 227298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | ||||
| 184650 | 184650 | 54966 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 734 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 16 | Permit Number 10844 | 5993209.18585 | 2111421.27834 | 37.777169597209 | -122.467037406046 | (37.777169597209, -122.467037406046) | ||
| 184368 | 184368 | 227204 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 475 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6007551.4691 | 2096600.33455 | 37.737292091044104 | -122.41637272882299 | (37.7372920910441, -122.416372728823) | |||
| 184181 | 184181 | 120484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5988270.499009999 | 2114625.30582 | 37.785680652510294 | -122.48435672889299 | (37.7856806525103, -122.484356728893) | |||
| 184064 | 184064 | 62716 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.431480001 | 2119179.891 | 37.799292719927294 | -122.417820789314 | (37.7992927199273, -122.417820789314) | |
| 183928 | 183928 | 141966 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004861.3228 | 2111665.6559 | 37.7785062716793 | -122.42674635400101 | (37.7785062716793, -122.426746354001) | |||
| 183847 | 183847 | 227240 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1041 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005776.90584 | 2102650.34664 | 37.753804097106205 | -122.422938087332 | (37.7538040971062, -122.422938087332) | |||
| 183799 | 183799 | 227236 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3271 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006927.020169999 | 2106115.20922 | 37.7633826377237 | -122.41920648270201 | (37.7633826377237, -122.419206482702) | |||
| 183784 | 183784 | 226662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004759.3932300005 | 2108882.7963099997 | 37.7708594546408 | -122.42690072149901 | (37.7708594546408, -122.426900721499) | |||
| 183646 | 183646 | 141038 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997552.7181 | 2113122.5903 | 37.7820907068665 | -122.452134610087 | (37.7820907068665, -122.452134610087) | |||
| 183560 | 183560 | 227186 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 260 Upper Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5999465.27543 | 2106151.00222 | 37.7630578682481 | -122.445016716945 | (37.7630578682481, -122.445016716945) | |||
| 183200 | 183200 | 227303 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.43323551541701 | (37.7437280128274, -122.433235515417) | ||||
| 183099 | 183099 | 207973 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995100.87909 | 2096206.0642799998 | 37.7355015111722 | -122.459391325848 | (37.7355015111722, -122.459391325848) | |||
| 182691 | 182691 | 246495 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 359 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004220.129819999 | 2099827.66275 | 37.7459656978564 | -122.428120633885 | (37.7459656978564, -122.428120633885) | |||
| 182678 | 182678 | 67465 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826001 | (37.7202991536555, -122.41105982826) | ||
| 182610 | 182610 | 207409 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2119 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5992555.1152 | 2101006.21366 | 37.7485348028432 | -122.46854205627199 | (37.7485348028432, -122.468542056272) | |||
| 182407 | 182407 | 191465 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014398.12583 | 2112729.40877 | 37.781961672523295 | -122.393829158687 | (37.7819616725233, -122.393829158687) | |||
| 182263 | 182263 | 120396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.48310009361099 | (37.7857281137897, -122.483100093611) | |||
| 182182 | 182182 | 129600 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2230 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005520.4 | 2117740.68195 | 37.7952240242221 | -122.424898677743 | (37.7952240242221, -122.424898677743) | |||
| 181998 | 181998 | 141820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004741.7405 | 2112502.8158 | 37.7807981447488 | -122.42721968229799 | (37.7807981447488, -122.427219682298) | |||
| 181991 | 181991 | 191439 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2205 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.751993394903295 | -122.40070234973801 | (37.7519933949033, -122.400702349738) | |||
| 181721 | 181721 | 226720 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010300.3347 | 2102457.6667400002 | 37.75352924447979 | -122.407281376151 | (37.7535292444798, -122.407281376151) | |||
| 181593 | 181593 | 143365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1735 UNION ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6004681.3503 | 2118768.1568 | 37.7979977794826 | -122.427875172085 | (37.7979977794826, -122.427875172085) | |||
| 181564 | 181564 | 207881 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1631 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992440.55655 | 2104337.16872 | 37.7576741235779 | -122.469180593809 | (37.7576741235779, -122.469180593809) | |||
| 181511 | 181511 | 207403 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.82157 | 2097093.68289 | 37.7377289565351 | -122.472027105478 | (37.7377289565351, -122.472027105478) | |||
| 181482 | 181482 | 207371 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992131.14604 | 2105828.32493 | 37.7617505624579 | -122.470359244405 | (37.7617505624579, -122.470359244405) | |||
| 181443 | 181443 | 207842 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 193 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995618.109069999 | 2091172.31825 | 37.7217097825699 | -122.457239048551 | (37.7217097825699, -122.457239048551) | |||
| 181171 | 181171 | 227362 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 790 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009074.570280001 | 2104618.83465 | 37.7593946444689 | -122.411673040887 | (37.7593946444689, -122.411673040887) | |||
| 180465 | 180465 | 191444 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | |||
| 180439 | 180439 | 207990 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 171 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999635.155619999 | 2095749.2946099997 | 37.7345069905129 | -122.443681865832 | (37.7345069905129, -122.443681865832) | |||
| 180427 | 180427 | 247286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 644 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5997022.454 | 2108829.1148 | 37.7702715542748 | -122.453658952423 | (37.7702715542748, -122.453658952423) | |||
| 180317 | 180317 | 185606 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2123 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987259.0828 | 2100808.0996 | 37.7476834885004 | -122.48684086956699 | (37.7476834885004, -122.486840869567) | |||
| 179892 | 179892 | 200621 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1421 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016453.6001 | 2095015.2073 | 37.733436233731204 | -122.38548323143999 | (37.7334362337312, -122.38548323144) | |||
| 179764 | 179764 | 129630 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2615 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006581.14365 | 2120192.71417 | 37.802016543384205 | -122.421402549791 | (37.8020165433842, -122.421402549791) | |||
| 179640 | 179640 | 57058 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2030 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18365 | 6001452.76061 | 2115511.13593 | 37.78887167462379 | -122.438813476778 | (37.7888716746238, -122.438813476778) | ||
| 179480 | 179480 | 138668 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1714 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999604.5625 | 2114731.8754 | 37.786626707802206 | -122.44515191825701 | (37.7866267078022, -122.445151918257) | |||
| 179367 | 179367 | 65899 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 166 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28906 | 5995945.57364 | 2113203.14409 | 37.782219693115394 | -122.45770039603998 | (37.7822196931154, -122.45770039604) | |
| 179330 | 179330 | 248362 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1321 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999488.4156 | 2108245.651 | 37.768810569479896 | -122.44508727896002 | (37.7688105694799, -122.44508727896) | |||
| 179289 | 179289 | 62212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.8822599999 | 37.729166984360795 | -122.437772711138 | (37.7291669843608, -122.437772711138) | |
| 179247 | 179247 | 207393 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1257 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5993281.8173 | 2106939.31773 | 37.764867519157 | -122.466460318209 | (37.764867519157, -122.466460318209) | |||
| 179036 | 179036 | 62083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 11 | Permit Number 22167 | 6013240.89819 | 2104321.43892 | 37.758810894525794 | -122.397242884449 | (37.7588108945258, -122.397242884449) | |
| 178937 | 178937 | 226691 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005210.09814 | 2107610.9819400003 | 37.767392831646106 | -122.425251206571 | (37.7673928316461, -122.425251206571) | |||
| 178930 | 178930 | 138622 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1641 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999567.3174 | 2114633.4522 | 37.786354337420505 | -122.44527369771099 | (37.7863543374205, -122.445273697711) | |||
| 178868 | 178868 | 56417 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 222 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 10 | Permit Number 12577 | 5990267.02613 | 2113888.22786 | 37.783772894624 | -122.47739550229299 | (37.783772894624, -122.477395502293) | ||
| 178595 | 178595 | 227373 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3410 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006229.031880001 | 2102615.79175 | 37.7537347189024 | -122.421372075386 | (37.7537347189024, -122.421372075386) | |||
| 178387 | 178387 | 62826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 170 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | 8 | Permit Number 23191 | 6000498.4193400005 | 2091715.9404799999 | 37.723481529728495 | -122.44040811326299 | (37.7234815297285, -122.440408113263) | |
| 178363 | 178363 | 226739 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010223.2273 | 2103077.92399 | 37.7552280170702 | -122.407591760047 | (37.7552280170702, -122.407591760047) | |||
| 178236 | 178236 | 207953 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 44 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994094.04258 | 2101846.56715 | 37.750930975380896 | -122.46328148097601 | (37.7509309753809, -122.463281480976) | |||
| 177945 | 177945 | 45683 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.41532827329901 | (37.79625955578, -122.415328273299) | ||
| 177936 | 177936 | 177040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5999261.0565599995 | 2089438.38497 | 37.7171573523208 | -122.444521826318 | (37.7171573523208, -122.444521826318) | |||
| 177872 | 177872 | 207844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995613.369530001 | 2090975.38331 | 37.721168773811 | -122.457241192529 | (37.721168773811, -122.457241192529) | |||
| 177649 | 177649 | 248459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 732 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997631.4677 | 2107944.9417 | 37.767878735979295 | -122.451488603572 | (37.7678787359793, -122.451488603572) | |||
| 177622 | 177622 | 227179 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 29 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998442.56486 | 2106249.64257 | 37.7632702863117 | -122.448561014387 | (37.7632702863117, -122.448561014387) | |||
| 177500 | 177500 | 227388 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3016 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009153.44991 | 2104528.30813 | 37.7591505037244 | -122.411393840047 | (37.7591505037244, -122.411393840047) | |||
| 177409 | 177409 | 207847 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995588.095430001 | 2090580.79577 | 37.7200838784522 | -122.457300026187 | (37.7200838784522, -122.457300026187) | |||
| 177288 | 177288 | 101277 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988481.6146 | 2106443.4757 | 37.7632279152074 | -122.48302644728001 | (37.7632279152074, -122.48302644728) | |||
| 177003 | 177003 | 207410 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5992569.29046 | 2100645.22315 | 37.7475444343476 | -122.46846677852601 | (37.7475444343476, -122.468466778526) | |||
| 176961 | 176961 | 227212 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1085 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007655.00083 | 2103359.6493 | 37.7558574759534 | -122.416493425951 | (37.7558574759534, -122.416493425951) | |||
| 176948 | 176948 | 248443 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 721 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997578.9268 | 2108015.8037 | 37.768070296065 | -122.451675447809 | (37.768070296065, -122.451675447809) | |||
| 176899 | 176899 | 227315 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4321 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001009.28999 | 2102281.6908 | 37.7525216836269 | -122.43939913507799 | (37.7525216836269, -122.439399135078) | |||
| 176637 | 176637 | 248520 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998876.5494 | 2107680.7234 | 37.767224479143 | -122.447163009367 | (37.767224479143, -122.447163009367) | |||
| 176315 | 176315 | 226679 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 136 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6005601.15773 | 2100240.7900099996 | 37.747178090991994 | -122.42337458408001 | (37.747178090992, -122.42337458408) | |||
| 176095 | 176095 | 207970 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 63 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998594.466519999 | 2095921.95645 | 37.734921667891506 | -122.44729228142201 | (37.7349216678915, -122.447292281422) | |||
| 176073 | 176073 | 207979 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6000455.91103 | 2095286.7491099997 | 37.7332837263556 | -122.440811080593 | (37.7332837263556, -122.440811080593) | |||
| 175991 | 175991 | 101635 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.753633925344296 | -122.484938226474 | (37.7536339253443, -122.484938226474) | |||
| 175876 | 175876 | 118089 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 7049 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5985075.84275 | 2112426.03783 | 37.7794555626476 | -122.49524691703199 | (37.7794555626476, -122.495246917032) | |||
| 175469 | 175469 | 227244 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000236.67461 | 2100097.15362 | 37.7464794715648 | -122.44191418271099 | (37.7464794715648, -122.441914182711) | |||
| 175312 | 175312 | 227465 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 93 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999376.95058 | 2105267.12267 | 37.760625913485 | -122.445258648971 | (37.760625913485, -122.445258648971) | |||
| 175175 | 175175 | 227405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 841 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002478.05006 | 2103327.42947 | 37.7554765096424 | -122.43439467949499 | (37.7554765096424, -122.434394679495) | |||
| 175117 | 175117 | 227359 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 165 Montcalm St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6010158.31216 | 2099748.7883900004 | 37.746083312104 | -122.40758154645 | (37.746083312104, -122.40758154645) | |||
| 174916 | 174916 | 61663 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.9849400003 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) |
| 174666 | 174666 | 68980 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.0276200003 | 37.8010556951124 | -122.44238022937901 | (37.8010556951124, -122.442380229379) |
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");