Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
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) | ||||
10548 | 10548 | 15906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | ||
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) | ||||
10802 | 10802 | 112326 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:24:00 PM | 3 | 3x3 | 5998237.3346 | 2088425.37851 | 37.7143174021005 | -122.447987437577 | (37.7143174021005, -122.447987437577) | ||
10887 | 10887 | 15908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.210469999 | 2087081.2429799999 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | ||
10898 | 10898 | 112312 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:44:00 PM | 3 | 3x3 | 5998649.95946 | 2088647.23333 | 37.7149501426196 | -122.446577201695 | (37.7149501426196, -122.446577201695) | ||
10954 | 10954 | 15902 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.7453700001 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | ||
10960 | 10960 | 112316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 09:14:00 AM | 3 | 3x3 | 5998526.38122 | 2088580.63045 | 37.714760206699204 | -122.446999548499 | (37.7147602066992, -122.446999548499) | ||
10967 | 10967 | 112330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 01:58:00 PM | 3 | 3x3 | 5998125.15209 | 2088363.53994 | 37.7141411943457 | -122.448370732221 | (37.7141411943457, -122.448370732221) | ||
11003 | 11003 | 30034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001399.41366 | 2091990.2767900003 | 37.7242860560331 | -122.437313179168 | (37.7242860560331, -122.437313179168) | ||
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) | |||
11224 | 11224 | 112322 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:56:00 PM | 3 | 3x3 | 5998335.48775 | 2088476.67454 | 37.7144638594022 | -122.447651873544 | (37.7144638594022, -122.447651873544) | ||
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) | ||||
11252 | 11252 | 112315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:16:00 PM | 3 | 3x3 | 5998550.09979 | 2088594.3048900003 | 37.7147991086711 | -122.446918551062 | (37.7147991086711, -122.446918551062) | ||
11265 | 11265 | 112313 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:23:00 PM | 3 | 3x3 | 5998619.49642 | 2088631.19842 | 37.714904374305604 | -122.446681341371 | (37.7149043743056, -122.446681341371) | ||
11509 | 11509 | 15905 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/13/1994 12:00:00 AM | 12 | TR20 | 5998282.5187800005 | 2087066.12192 | 37.71058777596279 | -122.44773347081998 | (37.7105877759628, -122.44773347082) | ||
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) | |||
11515 | 11515 | 112327 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:20:00 PM | 3 | 3x3 | 5998214.4608 | 2088412.1030400002 | 37.7142796431617 | -122.448065542797 | (37.7142796431617, -122.448065542797) | ||
11532 | 11532 | 15904 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | TR20 | 5998273.75241 | 2087065.5939900002 | 37.7105858253457 | -122.44776373121 | (37.7105858253457, -122.44776373121) | ||
11633 | 11633 | 30033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001409.17078 | 2092014.85305 | 37.7243540915456 | -122.43728120918199 | (37.7243540915456, -122.437281209182) | ||
11893 | 11893 | 112323 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:50:00 PM | 3 | 3x3 | 5998308.396509999 | 2088461.81998 | 37.714421523820796 | -122.447744442568 | (37.7144215238208, -122.447744442568) | ||
11901 | 11901 | 30035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001391.73475 | 2091959.7367599998 | 37.7242017634957 | -122.437337538205 | (37.7242017634957, -122.437337538205) | ||
11999 | 11999 | 112324 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:32:00 PM | 3 | 3x3 | 5998283.0477 | 2088450.2631 | 37.7143883424342 | -122.447831226251 | (37.7143883424342, -122.447831226251) | ||
12086 | 12086 | 30036 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001380.52526 | 2091907.5611599998 | 37.7240578638665 | -122.437372553325 | (37.7240578638665, -122.437372553325) | ||
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) | |||
12438 | 12438 | 112308 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 02:04:00 PM | 3 | 3x3 | 5998782.969959999 | 2088720.9540000001 | 37.715160159502396 | -122.44612276258002 | (37.7151601595024, -122.44612276258) | ||
12558 | 12558 | 112328 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:14:00 PM | 3 | 3x3 | 5998191.630340001 | 2088400.91043 | 37.714247605705296 | -122.448143648024 | (37.7142476057053, -122.448143648024) | ||
12577 | 12577 | 15907 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998292.86326 | 2087073.3238400002 | 37.7106081420281 | -122.447698236291 | (37.7106081420281, -122.447698236291) | ||
12661 | 12661 | 112310 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:58:00 PM | 3 | 3x3 | 5998739.5143099995 | 2088696.4519999998 | 37.7150904008744 | -122.446271201979 | (37.7150904008744, -122.446271201979) | ||
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) | ||||
12770 | 12770 | 112309 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 02:01:00 PM | 3 | 3x3 | 5998760.629790001 | 2088707.7894700002 | 37.715122736896205 | -122.44619903316001 | (37.7151227368962, -122.44619903316) | ||
12816 | 12816 | 112331 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 01:54:00 PM | 3 | 3x3 | 5998098.06062 | 2088348.6855900001 | 37.71409885876079 | -122.44846330124399 | (37.7140988587608, -122.448463301244) | ||
12834 | 12834 | 112320 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 03:02:00 PM | 3 | 3x3 | 5998366.80541 | 2088493.52458 | 37.7145119155785 | -122.447544839824 | (37.7145119155785, -122.447544839824) | ||
12844 | 12844 | 30032 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/08/2007 12:00:00 AM | 3 | 3X3 | 6001428.828369999 | 2092060.2753299999 | 37.724479928297896 | -122.43721650653099 | (37.7244799282979, -122.437216506531) | ||
12917 | 12917 | 112325 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:28:00 PM | 3 | 3x3 | 5998267.37148 | 2088441.00492 | 37.7143620255669 | -122.447884743106 | (37.7143620255669, -122.447884743106) | ||
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) | |||
13000 | 13000 | 112314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:18:00 PM | 3 | 3x3 | 5998572.09352 | 2088605.5152 | 37.7148311461116 | -122.44684333807699 | (37.7148311461116, -122.446843338077) | ||
13036 | 13036 | 112329 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:10:00 PM | 3 | 3x3 | 5998165.78515 | 2088385.61312 | 37.7142041252815 | -122.448231877823 | (37.7142041252815, -122.448231877823) | ||
13071 | 13071 | 112311 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 01:54:00 PM | 3 | 3x3 | 5998675.77838 | 2088661.28113 | 37.7149901894291 | -122.44648897100201 | (37.7149901894291, -122.446488971002) | ||
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) | |||
13125 | 13125 | 112321 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:59:00 PM | 3 | 3x3 | 5998349.45615 | 2088484.30117 | 37.7144855986971 | -122.447604142043 | (37.7144855986971, -122.447604142043) | ||
23474 | 23474 | 180020 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001294.8535400005 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | |||
23615 | 23615 | 180300 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001840.8677900005 | 2092960.9802599999 | 37.7269764741671 | -122.43585655983 | (37.7269764741671, -122.43585655983) | |||
23923 | 23923 | 180093 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999825.21966 | 2089601.0341900003 | 37.717636125294206 | -122.44258345996799 | (37.7176361252942, -122.442583459968) | |||
25341 | 25341 | 180280 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.730056572136704 | -122.432867327564 | (37.7300565721367, -122.432867327564) | |||
25355 | 25355 | 180096 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999764.69095 | 2089543.44622 | 37.717474551281704 | -122.44278854676399 | (37.7174745512817, -122.442788546764) | |||
27205 | 27205 | 180297 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001879.66047 | 2093045.2388099998 | 37.7272100325946 | -122.43572848019699 | (37.7272100325946, -122.435728480197) | |||
28906 | 28906 | 180049 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000848.655230001 | 2090751.2328 | 37.7208525973406 | -122.439128305154 | (37.7208525973406, -122.439128305154) | |||
29276 | 29276 | 180062 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000649.61116 | 2090402.60873 | 37.7198840266041 | -122.439791356397 | (37.7198840266041, -122.439791356397) | |||
30468 | 30468 | 180034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001097.83369 | 2091228.63345 | 37.7221776071819 | -122.43830115639601 | (37.7221776071819, -122.438301156396) | |||
31090 | 31090 | 180050 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000834.87553 | 2090725.84202 | 37.7207820959038 | -122.43917411838801 | (37.7207820959038, -122.439174118388) | |||
31509 | 31509 | 180054 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000783.664419999 | 2090626.8381700001 | 37.7205073395271 | -122.43934404620501 | (37.7205073395271, -122.439344046205) | |||
31681 | 31681 | 180089 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999997.23135 | 2089763.94995 | 37.7180932587717 | -122.442000582366 | (37.7180932587717, -122.442000582366) | |||
32210 | 32210 | 180306 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001696.41333 | 2092647.43732 | 37.7261073495475 | -122.436333505406 | (37.7261073495475, -122.436333505406) | |||
33314 | 33314 | 180058 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000718.4568 | 2090503.6472599998 | 37.7201653741024 | -122.43956062093599 | (37.7201653741024, -122.439560620936) | |||
33418 | 33418 | 180274 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002921.14547 | 2094140.96014 | 37.7302777397151 | -122.432206295294 | (37.7302777397151, -122.432206295294) | |||
33919 | 33919 | 180071 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000421.866669999 | 2090169.28245 | 37.719230399348795 | -122.440561861357 | (37.7192303993488, -122.440561861357) | |||
34228 | 34228 | 218724 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995542.9319 | 2099985.30545 | 37.7459037813392 | -122.458136423557 | (37.7459037813392, -122.458136423557) | |||
34599 | 34599 | 180281 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002702.132669999 | 2094050.3830099998 | 37.7300166152669 | -122.43295698278799 | (37.7300166152669, -122.432956982788) | |||
34779 | 34779 | 180046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000892.57758 | 2090835.74953 | 37.72108716032729 | -122.438982533116 | (37.7210871603273, -122.438982533116) | |||
34829 | 34829 | 180308 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001657.6308 | 2092560.9693 | 37.7258677242939 | -122.43646138808201 | (37.7258677242939, -122.436461388082) | |||
36534 | 36534 | 180276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002837.82705 | 2094112.9620299998 | 37.7301961388438 | -122.432492339061 | (37.7301961388438, -122.432492339061) | |||
36582 | 36582 | 180286 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1416x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002358.56722 | 2093739.38526 | 37.729143192803896 | -122.434122505942 | (37.7291431928039, -122.434122505942) | |||
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) | ||||
36746 | 36746 | 180279 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002763.71136 | 2094082.1093 | 37.7301072210706 | -122.43274636337699 | (37.7301072210706, -122.432746363377) | |||
38485 | 38485 | 180041 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6000958.05426 | 2090960.37345 | 37.7214330746668 | -122.438765125611 | (37.7214330746668, -122.438765125611) | |||
41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
41522 | 41522 | 180104 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999356.341630001 | 2089157.3690099998 | 37.7163911829698 | -122.444172290429 | (37.7163911829698, -122.444172290429) | |||
42007 | 42007 | 180098 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999719.616830001 | 2089501.32474 | 37.7173563255146 | -122.44294132361 | (37.7173563255146, -122.44294132361) | |||
42505 | 42505 | 180295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6001915.65954 | 2093123.81591 | 37.7274278322296 | -122.435609650978 | (37.7274278322296, -122.435609650978) | |||
42878 | 42878 | 180299 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001853.52362 | 2092985.7243400002 | 37.7270451347108 | -122.43581457857599 | (37.7270451347108, -122.435814578576) | |||
42890 | 42890 | 180042 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000946.28599 | 2090939.0206400002 | 37.72137377516479 | -122.438804275824 | (37.7213737751648, -122.438804275824) | |||
43112 | 43112 | 180044 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000922.20318 | 2090893.2066400002 | 37.721246610132106 | -122.438884241716 | (37.7212466101321, -122.438884241716) | |||
43357 | 43357 | 180061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000666.70399 | 2090425.0511 | 37.7199466212073 | -122.43973388071001 | (37.7199466212073, -122.43973388071) | |||
43625 | 43625 | 180079 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000270.676519999 | 2090025.31664 | 37.71882649133779 | -122.44107414397699 | (37.7188264913378, -122.441074143977) | |||
44736 | 44736 | 218728 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5995477.81623 | 2099995.17452 | 37.745927137623895 | -122.458362297293 | (37.7459271376239, -122.458362297293) | |||
45442 | 45442 | 180019 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001306.24608 | 2091632.60198 | 37.7232986651911 | -122.437609642494 | (37.7232986651911, -122.437609642494) | |||
45965 | 45965 | 180296 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6001890.92675 | 2093072.4710799998 | 37.7272854461671 | -122.435691480293 | (37.7272854461671, -122.435691480293) | |||
46429 | 46429 | 180266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003123.6487300005 | 2094209.53901 | 37.7304775213983 | -122.431511108549 | (37.7304775213983, -122.431511108549) | |||
46615 | 46615 | 180033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001110.15786 | 2091253.57403 | 37.722246789330896 | -122.43826034064699 | (37.7222467893309, -122.438260340647) | |||
46925 | 46925 | 180031 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001136.72316 | 2091302.93534 | 37.7223838352188 | -122.438172045228 | (37.7223838352188, -122.438172045228) | |||
47023 | 47023 | 180106 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999293.95899 | 2089098.2812 | 37.7162253821619 | -122.44438367066499 | (37.7162253821619, -122.444383670665) | |||
47880 | 47880 | 180029 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001164.3216699995 | 2091355.63442 | 37.722530104558295 | -122.438080416893 | (37.7225301045583, -122.438080416893) | |||
48488 | 48488 | 180305 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001711.8087 | 2092678.4747900001 | 37.7261934461482 | -122.436282504856 | (37.7261934461482, -122.436282504856) | |||
49739 | 49739 | 180292 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002054.37525 | 2093322.2219599998 | 37.7279804881067 | -122.435144295884 | (37.7279804881067, -122.435144295884) | |||
49881 | 49881 | 180069 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000467.5949099995 | 2090212.96823 | 37.719352954453605 | -122.440406927962 | (37.7193529544536, -122.440406927962) | |||
50821 | 50821 | 180285 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1370x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002464.77938 | 2093869.18417 | 37.7295056186676 | -122.433764595578 | (37.7295056186676, -122.433764595578) | |||
51011 | 51011 | 180077 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000313.69602 | 2090066.17904 | 37.718941140487104 | -122.44092837286199 | (37.7189411404871, -122.440928372862) | |||
51190 | 51190 | 180313 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001593.9198900005 | 2092419.10174 | 37.725474567678496 | -122.43667148142099 | (37.7254745676785, -122.436671481421) | |||
51994 | 51994 | 180057 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000730.46127 | 2090524.7556599998 | 37.7202240162157 | -122.439520637988 | (37.7202240162157, -122.439520637988) | |||
52126 | 52126 | 180030 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001150.53734 | 2091330.00448 | 37.72245894660539 | -122.438126231036 | (37.7224589466054, -122.438126231036) | |||
55159 | 55159 | 180314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001581.90285 | 2092391.7220299998 | 37.7253987062729 | -122.436711064184 | (37.7253987062729, -122.436711064184) | |||
55694 | 55694 | 180075 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000353.03268 | 2090103.7584400002 | 37.7190465653394 | -122.44079509604401 | (37.7190465653394, -122.440795096044) | |||
56333 | 56333 | 180293 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002035.95053 | 2093297.18768 | 37.727910703393896 | -122.435206200706 | (37.7279107033939, -122.435206200706) | |||
56779 | 56779 | 180014 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5998072.24977 | 2088335.05478 | 37.7140599558874 | -122.44855153193599 | (37.7140599558874, -122.448551531936) | |||
57669 | 57669 | 180056 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000745.033480001 | 2090553.4894299998 | 37.7203037419912 | -122.439472325501 | (37.7203037419912, -122.439472325501) | |||
58109 | 58109 | 180284 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1370x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002484.53778 | 2093889.06697 | 37.7295613334859 | -122.433697709378 | (37.7295613334859, -122.433697709378) | |||
58312 | 58312 | 180267 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003103.77149 | 2094203.80062 | 37.730460638447205 | -122.43157941747299 | (37.7304606384472, -122.431579417473) | |||
58747 | 58747 | 180269 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003058.36483 | 2094187.72674 | 37.730413929437105 | -122.431735247507 | (37.7304139294371, -122.431735247507) |
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");