Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1582 | 1582 | 45051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43936 | 5988218.295 | 2100043.5647 | 37.7456401553342 | -122.483467967859 | (37.7456401553342, -122.483467967859) | |
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 10437 | 10437 | 115185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | ||||
| 10742 | 10742 | 115189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999437.68927 | 2089235.07738 | 37.716609193035396 | -122.443896694081 | (37.7166091930354, -122.443896694081) | ||||
| 11166 | 11166 | 112236 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/2015 08:45:00 AM | 3 | 5999186.55259 | 2088995.9330400003 | 37.7159382286299 | -122.444747565144 | (37.7159382286299, -122.444747565144) | |||
| 11251 | 11251 | 115187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999459.81391 | 2089256.7158599999 | 37.716669869389 | -122.443821774256 | (37.716669869389, -122.443821774256) | ||||
| 11513 | 11513 | 112244 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:23:00 AM | 3 | 5999075.356319999 | 2088897.5178 | 37.7156616565467 | -122.445124838863 | (37.7156616565467, -122.445124838863) | |||
| 12254 | 12254 | 112240 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:38:00 AM | 3 | 5999143.09775 | 2088953.6674799998 | 37.7158196970968 | -122.444894728405 | (37.7158196970968, -122.444894728405) | |||
| 12735 | 12735 | 115192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999381.87795 | 2089181.7631299999 | 37.7164596204897 | -122.44408577653499 | (37.7164596204897, -122.444085776535) | ||||
| 12942 | 12942 | 112238 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 08:30:00 AM | 3 | 5999164.96486 | 2088975.3114099998 | 37.715880374360204 | -122.444820700722 | (37.7158803743602, -122.444820700722) | |||
| 13110 | 13110 | 112242 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:31:00 AM | 3 | 5999099.9806 | 2088915.2496599997 | 37.7157117496696 | -122.445041000443 | (37.7157117496696, -122.445041000443) | |||
| 16849 | 16849 | 22416 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6013664.2375 | 2091773.8949 | 37.724381524856206 | -122.39489998248001 | (37.7243815248562, -122.39489998248) | ||||
| 17550 | 17550 | 1369 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 34 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1997 12:00:00 AM | 3 | 5999059.98844 | 2100047.12811 | 37.746274991794294 | -122.445979419622 | (37.7462749917943, -122.445979419622) | |||
| 18003 | 18003 | 26207 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1997 12:00:00 AM | 6 | 6005594.7559 | 2098614.98254 | 37.742713632417605 | -122.42328116790199 | (37.7427136324176, -122.423281167902) | |||
| 19020 | 19020 | 25 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1995 12:00:00 AM | 0 | 6003903.525084401 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | |||
| 19614 | 19614 | 96252 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 23097 | 23097 | 24665 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4850 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 5991933.61016 | 2112783.76885 | 37.7808369148225 | -122.471549293385 | (37.7808369148225, -122.471549293385) | ||||
| 23348 | 23348 | 12189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1463 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6016268.9903 | 2095509.3837 | 37.7347829272824 | -122.38615592449699 | (37.7347829272824, -122.386155924497) | ||||
| 36706 | 36706 | 112246 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5999047.56745 | 2088876.5109400002 | 37.715602390323 | -122.44521938006399 | (37.715602390323, -122.445219380064) | ||||
| 42483 | 42483 | 97165 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 262 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6010119.55903 | 2111062.91718 | 37.777147179847105 | -122.408513509413 | (37.7771471798471, -122.408513509413) | ||||
| 78172 | 78172 | 442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988814.32729 | 2110443.9038299997 | 37.7742313463884 | -122.482168813724 | (37.7742313463884, -122.482168813724) | ||||
| 79734 | 79734 | 87582 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3438X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 5990574.05576 | 2092494.61094 | 37.725049482144 | -122.47477129702 | (37.725049482144, -122.47477129702) | |||
| 81195 | 81195 | 115191 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 83870 | 83870 | 107512 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1528X ALEMANY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6001955.0 | 2093277.9 | 37.727853146555 | -122.435484669091 | (37.727853146555, -122.435484669091) | |||||
| 83974 | 83974 | 96248 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Ocean Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 85262 | 85262 | 115190 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 86069 | 86069 | 115193 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 86411 | 86411 | 115186 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 86803 | 86803 | 96247 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 87978 | 87978 | 102959 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1299X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 90389 | 90389 | 464 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5988827.211759999 | 2110098.29514 | 37.7732831501538 | -122.48209892030701 | (37.7732831501538, -122.482098920307) | ||||
| 92748 | 92748 | 112239 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:41:00 AM | 3 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||
| 95066 | 95066 | 112245 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||||
| 101575 | 101575 | 112247 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||||
| 104100 | 104100 | 59809 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996255.87005341 | 2091897.48526237 | 37.723737527503 | -122.455086864771 | (37.723737527503, -122.455086864771) | |||
| 104474 | 104474 | 97692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.0484200001 | 37.732628603868704 | -122.425877544976 | (37.7326286038687, -122.425877544976) | ||||
| 107333 | 107333 | 41353 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 42003 | 6005497.49834422 | 2106351.86830907 | 37.763951837444296 | -122.424167571577 | (37.7639518374443, -122.424167571577) | |||
| 108864 | 108864 | 102970 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1299X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 110037 | 110037 | 112243 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:27:00 AM | 3 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||
| 114045 | 114045 | 96250 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 114714 | 114714 | 87590 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 4 | 5990484.73648 | 2091103.44002 | 37.721224497411704 | -122.474978557179 | (37.7212244974117, -122.474978557179) | |||
| 115055 | 115055 | 24664 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4850 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/1996 12:00:00 AM | 6 | 5991951.48109 | 2112844.05547 | 37.781003479214604 | -122.47149186391701 | (37.7810034792146, -122.471491863917) | |||
| 117724 | 117724 | 17034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1160X Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2014 01:41:00 PM | 3 | 6001440.1294862 | 2109757.6168908 | 37.7730732545672 | -122.438444795938 | (37.7730732545672, -122.438444795938) | |||
| 117769 | 117769 | 115188 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 5 | : 4 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 118012 | 118012 | 96249 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 118468 | 118468 | 112237 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 08:35:00 AM | 3 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||
| 120774 | 120774 | 452 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740x 23rd Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.98791 | 2110205.31094 | 37.773576798380205 | -122.482117913396 | (37.7735767983802, -122.482117913396) | ||||
| 122409 | 122409 | 96253 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 125222 | 125222 | 24674 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4249 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/1996 12:00:00 AM | 3 | 5993792.82485 | 2112723.92119 | 37.7807799742006 | -122.465113065959 | (37.7807799742006, -122.465113065959) | |||
| 140437 | 140437 | 96251 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 141449 | 141449 | 11981 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
| 143039 | 143039 | 115184 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 144552 | 144552 | 112241 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:34:00 AM | 3 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||
| 156626 | 156626 | 97167 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 262 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6010129.00149 | 2111054.10104 | 37.7771235015924 | -122.40848022278 | (37.7771235015924, -122.40848022278) | ||||
| 174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
| 23157 | 23157 | 16087 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 0 | 6000249.694130001 | 2094706.57543 | 37.731678958116 | -122.441482409212 | (37.731678958116, -122.441482409212) | |||
| 104777 | 104777 | 3759 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1062 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012453.5755993 | 2103020.9691678 | 37.755196225865895 | -122.39987450779499 | (37.7551962258659, -122.399874507795) | |||
| 19259 | 19259 | 1364 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999126.95834 | 2100012.88601 | 37.746184795201 | -122.445745384538 | (37.746184795201, -122.445745384538) | |||
| 82881 | 82881 | 104834 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1202X Arguello Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/27/2014 12:00:00 AM | 1 | 1x4 | 5995869.9 | 2107172.9 | 37.7656578771265 | -122.45752575958599 | (37.7656578771265, -122.457525759586) | ||
| 12177 | 12177 | 287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3355 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 6 | 2 | 5990530.52606 | 2093814.1828 | 37.7286701727855 | -122.475018054542 | (37.7286701727855, -122.475018054542) | ||
| 22038 | 22038 | 354 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1995 12:00:00 AM | 24 | 2 | 5990504.49839 | 2091477.17058 | 37.722251813860204 | -122.474937513077 | (37.7222518138602, -122.474937513077) | ||
| 79259 | 79259 | 329 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3454X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 79963 | 79963 | 368 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:12:00 PM | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 80402 | 80402 | 389 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 83114 | 83114 | 366 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
| 84381 | 84381 | 343 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 85567 | 85567 | 384 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 86727 | 86727 | 387 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 94449 | 94449 | 351 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 96255 | 96255 | 338 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 2 | 5990537.683837099 | 2091850.0721832002 | 37.723277631918 | -122.474850005229 | (37.723277631918, -122.474850005229) | |||
| 97846 | 97846 | 238 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3007 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990525.395690001 | 2095120.4577099998 | 37.7322565763444 | -122.47513111186001 | (37.7322565763444, -122.47513111186) | ||
| 98859 | 98859 | 346 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:09:00 PM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 98926 | 98926 | 357 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 104889 | 104889 | 352 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 108637 | 108637 | 360 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 110799 | 110799 | 342 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 110873 | 110873 | 367 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1994 12:00:00 AM | 12 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 113903 | 113903 | 355 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.7429471 | 2091103.3809490001 | 37.7212246253597 | -122.47496124712299 | (37.7212246253597, -122.474961247123) | ||
| 114841 | 114841 | 388 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 115580 | 115580 | 347 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 25 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 119861 | 119861 | 345 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 120248 | 120248 | 383 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 123472 | 123472 | 27533 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 125863 | 125863 | 385 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 127778 | 127778 | 341 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2013 12:00:00 AM | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 10556 | 10556 | 26324 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1923 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 3 | 2X2 | 6000151.26449 | 2092808.65787 | 37.7264621078328 | -122.44168654361401 | (37.7264621078328, -122.441686543614) | ||
| 17440 | 17440 | 4242 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4024 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6003700.62714 | 2100425.74142 | 37.7475784763835 | -122.42995965841101 | (37.7475784763835, -122.429959658411) | |||
| 86785 | 86785 | 8935 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4630 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/28/2001 12:00:00 AM | 3 | 2X2 | 5992645.55478 | 2112808.55137 | 37.7809461229512 | -122.469088155637 | (37.7809461229512, -122.469088155637) | ||
| 104242 | 104242 | 24786 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5982848.853180001 | 2112367.91788 | 37.779165345195295 | -122.502946585831 | (37.7791653451953, -122.502946585831) | |||
| 110981 | 110981 | 24649 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 334 Winfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6006577.8350722 | 2097905.0215139 | 37.7408196712937 | -122.41983158857599 | (37.7408196712937, -122.419831588576) | |||
| 126668 | 126668 | 344 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 2X2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 128385 | 128385 | 9995 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 GUERRERO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 12:59:00 PM | 3 | 2X2 | 6005457.0 | 2108414.0 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | ||
| 142325 | 142325 | 24788 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5982848.853180001 | 2112367.91788 | 37.779165345195295 | -122.502946585831 | (37.7791653451953, -122.502946585831) | |||
| 1531 | 1531 | 5189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 509 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001637.7109 | 2110249.8513 | 37.7744360439082 | -122.43779659970501 | (37.7744360439082, -122.437796599705) | |||
| 23304 | 23304 | 24655 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 333 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 2X3 | 6006602.01583 | 2097861.4273599996 | 37.7407013336984 | -122.419744887942 | (37.7407013336984, -122.419744887942) | |||
| 87324 | 87324 | 5216 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 911 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 2X3 | 6001435.51822 | 2111590.83947 | 37.778106560678296 | -122.43859212487601 | (37.7781065606783, -122.438592124876) | |||
| 94462 | 94462 | 9254 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6500X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 2X3 | 5986710.23998 | 2112596.1628099997 | 37.7800182322354 | -122.48960543507401 | (37.7800182322354, -122.489605435074) | ||
| 114680 | 114680 | 9251 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6500X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 3 | 2X3 | 5986757.88302 | 2112599.10461 | 37.7800290909757 | -122.489440834967 | (37.7800290909757, -122.489440834967) | ||
| 12677 | 12677 | 26323 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1925 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 2x2 | 6000135.6278 | 2092787.21241 | 37.7264023325969 | -122.441739060413 | (37.7264023325969, -122.441739060413) | ||
| 20315 | 20315 | 9992 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 67 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/02/2014 12:00:00 AM | 3 | 2x2 | 6005450.489519999 | 2108526.98568 | 37.7699215363694 | -122.42448488798901 | (37.7699215363694, -122.424484887989) |
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");