Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
2091 | 2091 | 12295 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.778735341492705 | -122.426792396306 | (37.7787353414927, -122.426792396306) | |||
2255 | 2255 | 191499 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016833.73477 | 2094673.4854599999 | 37.732518958184706 | -122.38414519683998 | (37.7325189581847, -122.38414519684) | |||
2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
3052 | 3052 | 17713 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1230 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002323.545 | 2112760.8562 | 37.7813696081859 | -122.435603850031 | (37.7813696081859, -122.435603850031) | |||
3383 | 3383 | 17357 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.794931112339796 | -122.42484601254 | (37.7949311123398, -122.42484601254) | |||
4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
5679 | 5679 | 17669 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1015X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002374.7226 | 2112093.816 | 37.779540990434604 | -122.435379071124 | (37.7795409904346, -122.435379071124) | ||
7554 | 7554 | 12324 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.780351202823205 | -122.427115646852 | (37.7803512028232, -122.427115646852) | |||
7670 | 7670 | 7966 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005614.52229 | 2116667.02972 | 37.7922813615542 | -122.424496592638 | (37.7922813615542, -122.424496592638) | |||
7730 | 7730 | 7960 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | |||
8498 | 8498 | 18823 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005861.74139 | 2116275.81208 | 37.7912211336846 | -122.423613381076 | (37.7912211336846, -122.423613381076) | |||
11054 | 11054 | 1139 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | |||
11106 | 11106 | 25304 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.44296946786501 | (37.7231817335313, -122.442969467865) | |||
11537 | 11537 | 25293 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175036998 | (37.7235513818789, -122.43985175037) | |||
12673 | 12673 | 25310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000354.040159999 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | |||
13006 | 13006 | 25299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123001 | (37.7234515931109, -122.44068314123) | |||
14180 | 14180 | 12213 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | |||
14416 | 14416 | 12182 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.734530219899895 | -122.38599530928002 | (37.7345302198999, -122.38599530928) | |||
14762 | 14762 | 12188 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.734726794786404 | -122.386106718848 | (37.7347267947864, -122.386106718848) | |||
14865 | 14865 | 12184 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.734332915157296 | -122.385929490724 | (37.7343329151573, -122.385929490724) | |||
15422 | 15422 | 12186 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138001 | (37.7346703842439, -122.38607488138) | |||
16102 | 16102 | 12179 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973632995 | -122.385668291381 | (37.733710973633, -122.385668291381) | |||
16320 | 16320 | 12187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | |||
16421 | 16421 | 12185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.734276365571105 | -122.385906337047 | (37.7342763655711, -122.385906337047) | |||
17086 | 17086 | 15318 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | |||
17896 | 17896 | 10143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005657.84848 | 2103570.5399700003 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | |||
18155 | 18155 | 1705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017900.557664401 | 2093604.0676713001 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | |||
18911 | 18911 | 12302 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.42758319096399 | (37.7790930089412, -122.427583190964) | |||
19071 | 19071 | 10185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005788.9112599995 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | |||
19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
20101 | 20101 | 10202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.42269187452601 | (37.7512674207747, -122.422691874526) | |||
20535 | 20535 | 10072 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | |||
20855 | 20855 | 17135 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2033 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997261.7134 | 2109120.9259 | 37.771086505654104 | -122.45285242516701 | (37.7710865056541, -122.452852425167) | |||
22091 | 22091 | 10162 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005758.27618 | 2103002.2349099996 | 37.7547692495131 | -122.42302752222099 | (37.7547692495131, -122.423027522221) | |||
47442 | 47442 | 11955 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | |||
78058 | 78058 | 20276 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
78963 | 78963 | 12206 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
80698 | 80698 | 12309 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004806.2528800005 | 2112097.03189 | 37.7796876103034 | -122.426967593325 | (37.7796876103034, -122.426967593325) | |||
84373 | 84373 | 12120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
85014 | 85014 | 20210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1349 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276002 | 37.781665193424104 | -122.43415110441099 | (37.7816651934241, -122.434151104411) | |||
85072 | 85072 | 1696 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017739.602575701 | 2093657.002741 | 37.72977793847971 | -122.380942720777 | (37.7297779384797, -122.380942720777) | |||
89649 | 89649 | 27488 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
90722 | 90722 | 12296 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 853 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004840.61204 | 2111776.51991 | 37.778809506036204 | -122.426825897852 | (37.7788095060362, -122.426825897852) | |||
91159 | 91159 | 20202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002746.658969999 | 2112743.01466 | 37.781344642713 | -122.434138807658 | (37.781344642713, -122.434138807658) | |||
94799 | 94799 | 7993 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.42491511428301 | (37.7950822509185, -122.424915114283) | |||
96817 | 96817 | 7985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.42486745909201 | (37.7939007015449, -122.424867459092) | |||
96962 | 96962 | 12285 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
97647 | 97647 | 27658 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
102821 | 102821 | 7209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
103981 | 103981 | 17345 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 175X Otis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
105257 | 105257 | 26194 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 772904 | 6002390.549968 | 2104882.2284699 | 37.7597406467411 | -122.43480846230499 | (37.7597406467411, -122.434808462305) | ||
106256 | 106256 | 14757 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 955X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004579.18989 | 2111878.0493 | 37.7790734963365 | -122.42773749615101 | (37.7790734963365, -122.427737496151) | |||
108812 | 108812 | 7212 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
111795 | 111795 | 25294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000635.349880001 | 2091747.8935900002 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | |||
111824 | 111824 | 12298 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 869 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.398019999 | 2111828.5317 | 37.778951909736 | -122.42685455914801 | (37.778951909736, -122.426854559148) | |||
112287 | 112287 | 12177 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
113484 | 113484 | 27487 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
114668 | 114668 | 14799 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003745.74789 | 2111758.98852 | 37.778699404291395 | -122.43061221122801 | (37.7786994042914, -122.430612211228) | |||
114969 | 114969 | 12284 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
116991 | 116991 | 20209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1349 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276002 | 37.781665193424104 | -122.43415110441099 | (37.7816651934241, -122.434151104411) | |||
121009 | 121009 | 2694 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | |||
121121 | 121121 | 12180 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1403X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
123069 | 123069 | 1691 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017695.7876646 | 2093605.1145141998 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | |||
124076 | 124076 | 15427 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2109 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006990.7827 | 2106030.4142400003 | 37.7631534012249 | -122.418979933746 | (37.7631534012249, -122.418979933746) | |||
124572 | 124572 | 14760 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 967 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004525.5867099995 | 2111875.68505 | 37.7790639723642 | -122.427922762836 | (37.7790639723642, -122.427922762836) | |||
124800 | 124800 | 12209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
129260 | 129260 | 12204 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
129338 | 129338 | 12165 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
138297 | 138297 | 20203 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002746.658969999 | 2112743.01466 | 37.781344642713 | -122.434138807658 | (37.781344642713, -122.434138807658) | |||
138359 | 138359 | 12321 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004765.45239 | 2112324.5518400003 | 37.780310016849704 | -122.427124950246 | (37.7803100168497, -122.427124950246) | |||
138769 | 138769 | 7210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
141287 | 141287 | 1702 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | |||
141998 | 141998 | 12327 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004464.0 | 2112418.0 | 37.780549550881204 | -122.428174475606 | (37.7805495508812, -122.428174475606) | |||
142461 | 142461 | 4606 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010770.745019999 | 2118660.6682599997 | 37.7980452429337 | -122.40679643371 | (37.7980452429337, -122.40679643371) | |||
143686 | 143686 | 12294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 841X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.42680427007099 | (37.7787020480516, -122.426804270071) | |||
144967 | 144967 | 14791 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
145506 | 145506 | 12205 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
145902 | 145902 | 15426 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) |
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");