trees
1,377 rows where qSpecies_id = 61 sorted by Supervisor Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
13435 | 71273 | DPW Maintained 1 | Tristania conferta :: 61 | 2480 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6000737.6791 | 2114169.5665 | 37.7851473635462 | -122.441191260636 | (37.7851473635462, -122.441191260636) | 15 | 6 | 1 | 29490 | 27 | |||
16548 | 143139 | DPW Maintained 1 | Tristania conferta :: 61 | 2520 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000358 | 2119336 | 37.7993114011756 | -122.442875959315 | (37.7993114011756, -122.442875959315) | 13 | 9 | 1 | 57 | 17 | |||
17209 | 13251 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000984.849 | 2119261.9127 | 37.7991436944439 | -122.440701531677 | (37.7991436944439, -122.440701531677) | 13 | 9 | 1 | 57 | 17 | |||
24618 | 51914 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406377 | (37.8007048866604, -122.43013406377) | 13 | 9 | 1 | 57 | 17 | |
27028 | 68142 | DPW Maintained 1 | Tristania conferta :: 61 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | 15 | 6 | 1 | 29490 | 27 | |
29504 | 138720 | DPW Maintained 1 | Tristania conferta :: 61 | 2921 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:10:00 PM | 2 | Width 0ft | 5999959.1608 | 2114707.5789 | 37.7865802293131 | -122.443923351787 | (37.7865802293131, -122.443923351787) | 15 | 6 | 1 | 29490 | 31 | ||
30243 | 13145 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | 13 | 9 | 1 | 57 | 17 | ||
30290 | 13100 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852 | -122.426586143087 | (37.800932566852, -122.426586143087) | 13 | 9 | 1 | 57 | 17 | ||
31794 | 13264 | DPW Maintained 1 | Tristania conferta :: 61 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | 13 | 9 | 1 | 57 | 17 | ||
32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
36334 | 138235 | DPW Maintained 1 | Tristania conferta :: 61 | 230 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998964.7831 | 2112316.4696 | 37.7799580944916 | -122.447191491368 | (37.7799580944916, -122.447191491368) | 15 | 5 | 1 | 54 | 16 | |||
38204 | 41235 | DPW Maintained 1 | Tristania conferta :: 61 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551 | (37.7795508339841, -122.44711229551) | 15 | 5 | 1 | 54 | 16 | ||
41026 | 138710 | DPW Maintained 1 | Tristania conferta :: 61 | 2699 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000650.0889 | 2114452.8379 | 37.7859201640241 | -122.4415146292 | (37.7859201640241, -122.4415146292) | 15 | 6 | 1 | 29490 | 27 | |||
42452 | 13177 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.072 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | 13 | 9 | 1 | 57 | 17 | ||
42759 | 13242 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | 13 | 9 | 1 | 57 | 17 | |||
45358 | 18082 | DPW Maintained 1 | Tristania conferta :: 61 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.7866244385926 | -122.444742742308 | (37.7866244385926, -122.444742742308) | 15 | 6 | 1 | 29490 | 31 | ||
46016 | 143140 | DPW Maintained 1 | Tristania conferta :: 61 | 2532 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000155.1695 | 2119230.0223 | 37.7990088489402 | -122.44357020422 | (37.7990088489402, -122.44357020422) | 13 | 9 | 1 | 57 | 17 | |||
46527 | 138746 | DPW Maintained 1 | Tristania conferta :: 61 | 2516 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000515.6821 | 2114142.2729 | 37.7850597745123 | -122.441957339259 | (37.7850597745123, -122.441957339259) | 15 | 6 | 1 | 29490 | 27 | |||
46645 | 138597 | DPW Maintained 1 | Tristania conferta :: 61 | 1991 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001451.6996 | 2115181.7517 | 37.7879672100973 | -122.438793534901 | (37.7879672100973, -122.438793534901) | 13 | 6 | 1 | 29490 | 27 | |||
47298 | 143113 | DPW Maintained 1 | Tristania conferta :: 61 | 2775 VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005458.8135 | 2119882.0495 | 37.8011001957164 | -122.425264228759 | (37.8011001957164, -122.425264228759) | 13 | 9 | 1 | 57 | 17 | |||
49136 | 42633 | DPW Maintained 1 | Tristania conferta :: 61 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) | 13 | 9 | 1 | 57 | 17 |
51619 | 141090 | DPW Maintained 1 | Tristania conferta :: 61 | 196 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996268.5766 | 2112969.4544 | 37.7815965932692 | -122.456566052477 | (37.7815965932692, -122.456566052477) | 11 | 6 | 1 | 54 | 31 | |||
56076 | 13283 | DPW Maintained 1 | Tristania conferta :: 61 | 2539 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000208.0345 | 2119155.4664 | 37.7988071530908 | -122.44338191609 | (37.7988071530908, -122.44338191609) | 13 | 9 | 1 | 57 | 17 | |||
60050 | 143150 | DPW Maintained 1 | Tristania conferta :: 61 | 2218 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001729.5264 | 2119441.44 | 37.7996790084154 | -122.43813756656 | (37.7996790084154, -122.43813756656) | 13 | 9 | 1 | 57 | 17 | |||
65922 | 143235 | DPW Maintained 1 | Tristania conferta :: 61 | 1549 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004978.7622 | 2119817.1566 | 37.8008948846007 | -122.426920790121 | (37.8008948846007, -122.426920790121) | 13 | 9 | 1 | 57 | 17 | |||
67253 | 13146 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 6 | 3x3 | 6003666.0486 | 2119638.1147 | 37.800328969814 | -122.431450542751 | (37.800328969814, -122.431450542751) | 13 | 9 | 1 | 57 | 17 | ||
67481 | 138713 | DPW Maintained 1 | Tristania conferta :: 61 | 1642 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000620.5484 | 2114390.3234 | 37.7857468323482 | -122.441612343055 | (37.7857468323482, -122.441612343055) | 15 | 6 | 1 | 29490 | 27 | |||
68040 | 13160 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003384.5853 | 2119677.9886 | 37.8004224969778 | -122.43242736605 | (37.8004224969778, -122.43242736605) | 13 | 9 | 1 | 57 | 17 | |||
69058 | 89051 | DPW Maintained 1 | Tristania conferta :: 61 | 2420 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000933.3562 | 2114194.3706 | 37.7852266134024 | -122.440516060128 | (37.7852266134024, -122.440516060128) | 15 | 6 | 1 | 29490 | 27 | |
69190 | 13159 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.432349074336 | (37.8004302230496, -122.432349074336) | 13 | 9 | 1 | 57 | 17 | |||
69876 | 13270 | DPW Maintained 1 | Tristania conferta :: 61 | 2498 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2000 12:00:00 AM | 9 | 3x3 | 6000499.2901 | 2119275.2189 | 37.7991525665006 | -122.442382681808 | (37.7991525665006, -122.442382681808) | 13 | 9 | 1 | 57 | 17 | ||
72018 | 29686 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.8004092361933 | -122.432581299288 | (37.8004092361933, -122.432581299288) | 13 | 9 | 1 | 57 | 17 | |||
72289 | 141093 | DPW Maintained 1 | Tristania conferta :: 61 | 190 Jordan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5996268.2382 | 2113005.3272 | 37.7816950710308 | -122.456569818134 | (37.7816950710308, -122.456569818134) | 11 | 6 | 1 | 54 | 31 | |||
74531 | 51913 | DPW Maintained 1 | Tristania conferta :: 61 | 1734 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50189 | 6004067.1338 | 2119771.0279 | 37.8007166387692 | -122.430072116268 | (37.8007166387692, -122.430072116268) | 13 | 9 | 1 | 57 | 17 | |
75752 | 13092 | DPW Maintained 1 | Tristania conferta :: 61 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.425439586315 | (37.8010780038521, -122.425439586315) | 13 | 9 | 1 | 57 | 17 | ||
77870 | 13262 | DPW Maintained 1 | Tristania conferta :: 61 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6000711.0138 | 2119222.9095 | 37.7990210040081 | -122.441646291613 | (37.7990210040081, -122.441646291613) | 13 | 9 | 1 | 57 | 17 | |||
80655 | 137923 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003379.2097 | 2115283.9028 | 37.7883571613531 | -122.432131998946 | (37.7883571613531, -122.432131998946) | 13 | 9 | 1 | 29490 | 27 | |||
81130 | 137789 | DPW Maintained 1 | Tristania conferta :: 61 | 1711 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005260.1426 | 2115739.9282 | 37.7897157547789 | -122.425656740164 | (37.7897157547789, -122.425656740164) | 13 | 9 | 1 | 28858 | 27 | |||
82224 | 51915 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | 13 | 9 | 1 | 57 | 17 | |
83005 | 93014 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) | 13 | 9 | 1 | 57 | 17 |
83749 | 138245 | DPW Maintained 1 | Tristania conferta :: 61 | 750 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999284.3395 | 2114037.2657 | 37.7847012079666 | -122.446209824081 | (37.7847012079666, -122.446209824081) | 15 | 6 | 1 | 29490 | 31 | |||
84433 | 143133 | DPW Maintained 1 | Tristania conferta :: 61 | 2447 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000680.1362 | 2119221.2843 | 37.7990147823393 | -122.441753021456 | (37.7990147823393, -122.441753021456) | 13 | 9 | 1 | 57 | 17 | |||
84941 | 29685 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.8004125358422 | -122.43251101256 | (37.8004125358422, -122.43251101256) | 13 | 9 | 1 | 57 | 17 | |||
84965 | 138569 | DPW Maintained 1 | Tristania conferta :: 61 | 1912 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001034.7522 | 2115044.284 | 37.7875660297526 | -122.440226232429 | (37.7875660297526, -122.440226232429) | 13 | 6 | 1 | 29490 | 27 | |||
84992 | 138681 | DPW Maintained 1 | Tristania conferta :: 61 | 3050 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999237.6946 | 2114657.811 | 37.786402399412 | -122.44641585719 | (37.786402399412, -122.44641585719) | 15 | 6 | 1 | 29490 | 31 | |||
87396 | 18099 | DPW Maintained 1 | Tristania conferta :: 61 | 3019 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999451.351 | 2114633.9478 | 37.786349077981 | -122.445674946059 | (37.786349077981, -122.445674946059) | 15 | 6 | 1 | 29490 | 31 | |||
87468 | 13137 | DPW Maintained 1 | Tristania conferta :: 61 | 1769 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003915.4564 | 2119670.1702 | 37.8004311181643 | -122.430589781889 | (37.8004311181643, -122.430589781889) | 13 | 9 | 1 | 57 | 17 | ||
87509 | 89053 | DPW Maintained 1 | Tristania conferta :: 61 | 2420 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51790 | 6000877.1335 | 2114188.3074 | 37.7852067638224 | -122.440710137812 | (37.7852067638224, -122.440710137812) | 15 | 6 | 1 | 29490 | 27 | |
94108 | 141094 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | 11 | 6 | 1 | 54 | 31 | |||
95409 | 68141 | DPW Maintained 1 | Tristania conferta :: 61 | 2528 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 14 | Permit Number 31895 | 6000471.2962 | 2114132.7617 | 37.7850311298137 | -122.442110217066 | (37.7850311298137, -122.442110217066) | 15 | 6 | 1 | 29490 | 27 | |
95484 | 98999 | DPW Maintained 1 | Tristania conferta :: 61 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |
95987 | 13208 | DPW Maintained 1 | Tristania conferta :: 61 | 2199 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6001971.1512 | 2119400.3389 | 37.7995798943259 | -122.437298513288 | (37.7995798943259, -122.437298513288) | 13 | 9 | 1 | 57 | 17 | ||
97333 | 89052 | DPW Maintained 1 | Tristania conferta :: 61 | 2420 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000895.8744 | 2114188.3074 | 37.7852078310557 | -122.440645300245 | (37.7852078310557, -122.440645300245) | 15 | 6 | 1 | 29490 | 27 | |
97432 | 53100 | DPW Maintained 1 | Tristania conferta :: 61 | 560@ PINE Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | Permit Number 767803 | 5999200.433 | 2114690.2424 | 37.7864893192828 | -122.446547106561 | (37.7864893192828, -122.446547106561) | 15 | 6 | 1 | 29490 | 31 | ||
97869 | 141234 | DPW Maintained 1 | Tristania conferta :: 61 | 22 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996538.8064 | 2114429.9137 | 37.7856221373365 | -122.455736793232 | (37.7856221373365, -122.455736793232) | 11 | 6 | 1 | 54 | 31 | |||
99454 | 24422 | DPW Maintained 1 | Tristania conferta :: 61 | 1709 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 17 | 3X3 | 6005271.4523 | 2115623.5999 | 37.7893969854581 | -122.425609326978 | (37.7893969854581, -122.425609326978) | 13 | 9 | 1 | 28858 | 27 | ||
100073 | 68137 | DPW Maintained 1 | Tristania conferta :: 61 | 2786 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31889 | 6000193.313 | 2114445.5102 | 37.7858740103556 | -122.443094416733 | (37.7858740103556, -122.443094416733) | 13 | 6 | 1 | 29490 | 27 | |
100614 | 143151 | DPW Maintained 1 | Tristania conferta :: 61 | 2300 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001315.564 | 2119391.1109 | 37.7995172663928 | -122.439566414616 | (37.7995172663928, -122.439566414616) | 13 | 9 | 1 | 57 | 17 | |||
101768 | 138747 | DPW Maintained 1 | Tristania conferta :: 61 | 1614 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6000647.5573 | 2114208.4263 | 37.7852489286219 | -122.441505842685 | (37.7852489286219, -122.441505842685) | 15 | 6 | 1 | 29490 | 27 | |||
103128 | 143135 | DPW Maintained 1 | Tristania conferta :: 61 | 2684 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999523.0401 | 2119140.8402 | 37.7987279071831 | -122.445751158267 | (37.7987279071831, -122.445751158267) | 13 | 9 | 1 | 57 | 17 | |||
103148 | 13172 | DPW Maintained 1 | Tristania conferta :: 61 | 1945X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 4 | 3x3 | 6003080.8814 | 2119554.1567 | 37.8000652607778 | -122.4334694479 | (37.8000652607778, -122.4334694479) | 13 | 9 | 1 | 57 | 17 | ||
103234 | 13098 | DPW Maintained 1 | Tristania conferta :: 61 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.425995743515 | (37.8012321434749, -122.425995743515) | 13 | 9 | 1 | 57 | 17 | ||
105044 | 13231 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866 | (37.7992872786644, -122.43957165866) | 13 | 9 | 1 | 57 | 17 | |||
105826 | 13237 | DPW Maintained 1 | Tristania conferta :: 61 | 2320 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 30 | 3X3 | 6001278.1859 | 2119382.1727 | 37.7994905970471 | -122.439695114779 | (37.7994905970471, -122.439695114779) | 13 | 9 | 1 | 57 | 17 | ||
106526 | 13252 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | 13 | 9 | 1 | 57 | 17 | |||
106592 | 137790 | DPW Maintained 1 | Tristania conferta :: 61 | 1711 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005264.6664 | 2115686.9342 | 37.7895705021499 | -122.425637314961 | (37.7895705021499, -122.425637314961) | 13 | 9 | 1 | 28858 | 27 | |||
106679 | 13268 | DPW Maintained 1 | Tristania conferta :: 61 | 2467 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6000591.5664 | 2119207.4707 | 37.7989718069145 | -122.442058509671 | (37.7989718069145, -122.442058509671) | 13 | 9 | 1 | 57 | 17 | ||
107434 | 24423 | DPW Maintained 1 | Tristania conferta :: 61 | 1707 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005275.9761 | 2115602.2731 | 37.7893386830183 | -122.425592156658 | (37.7893386830183, -122.425592156658) | 13 | 9 | 1 | 28858 | 27 | ||
107579 | 114595 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
108588 | 24424 | DPW Maintained 1 | Tristania conferta :: 61 | 1705 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005279.8538 | 2115571.2522 | 37.7892537264959 | -122.42557653158 | (37.7892537264959, -122.42557653158) | 13 | 9 | 1 | 28858 | 27 | ||
109318 | 13106 | DPW Maintained 1 | Tristania conferta :: 61 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | 13 | 9 | 1 | 57 | 17 | ||
109409 | 14479 | DPW Maintained 1 | Tristania conferta :: 61 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5998992.7029 | 2112117.3083 | 37.7794128442998 | -122.44708056796 | (37.7794128442998, -122.44708056796) | 15 | 5 | 1 | 54 | 16 | |||
109869 | 138450 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002081.3526 | 2114464.1963 | 37.7860327882669 | -122.436563672241 | (37.7860327882669, -122.436563672241) | 13 | 6 | 1 | 29490 | 27 | |||
110624 | 68143 | DPW Maintained 1 | Tristania conferta :: 61 | 2540 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 14 | Permit Number 31897 | 6000418.1917 | 2114124.8356 | 37.7850063402866 | -122.442293372082 | (37.7850063402866, -122.442293372082) | 15 | 6 | 1 | 29490 | 27 | |
110940 | 138204 | DPW Maintained 1 | Tristania conferta :: 61 | 270 MASONIC AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999001.1634 | 2112067.5603 | 37.7792767325302 | -122.447047718592 | (37.7792767325302, -122.447047718592) | 15 | 5 | 1 | 54 | 16 | |||
111151 | 13156 | DPW Maintained 1 | Tristania conferta :: 61 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.8002050816246 | -122.432326975222 | (37.8002050816246, -122.432326975222) | 13 | 9 | 1 | 57 | 17 | |||
111240 | 13151 | DPW Maintained 1 | Tristania conferta :: 61 | 1850 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 6 | 3x3 | 6003502.6435 | 2119692.0618 | 37.8004678320559 | -122.432019843179 | (37.8004678320559, -122.432019843179) | 13 | 9 | 1 | 57 | 17 | ||
112356 | 18027 | DPW Maintained 1 | Tristania conferta :: 61 | 2770 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2011 12:00:00 AM | 4 | 3x3 | 6000645.3835 | 2114854.2782 | 37.7870221472222 | -122.441559726807 | (37.7870221472222, -122.441559726807) | 13 | 6 | 1 | 29490 | 27 | ||
112724 | 138451 | DPW Maintained 1 | Tristania conferta :: 61 | 2182 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002125.8695 | 2114363.4018 | 37.7857585619048 | -122.436402439491 | (37.7857585619048, -122.436402439491) | 13 | 6 | 1 | 29490 | 27 | |||
113209 | 143387 | DPW Maintained 1 | Tristania conferta :: 61 | 1680 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004355.1091 | 2119807.5248 | 37.800833155227 | -122.429078206161 | (37.800833155227, -122.429078206161) | 13 | 9 | 1 | 57 | 17 | |||
113698 | 13158 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | 13 | 9 | 1 | 57 | 17 | |||
113908 | 13129 | DPW Maintained 1 | Tristania conferta :: 61 | 1721 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6004129.6812 | 2119699.0984 | 37.8005226811605 | -122.429850542898 | (37.8005226811605, -122.429850542898) | 13 | 9 | 1 | 57 | 17 | |||
114160 | 13290 | DPW Maintained 1 | Tristania conferta :: 61 | 2665 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1997 12:00:00 AM | 6 | 3X3 | 5999641.675 | 2119108.3375 | 37.7986454362464 | -122.445338306635 | (37.7986454362464, -122.445338306635) | 13 | 9 | 1 | 57 | 17 | ||
115758 | 13163 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | 13 | 9 | 1 | 57 | 17 | |||
118696 | 13221 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 12 | 3X3 | 6001619.3007 | 2119428.9852 | 37.7996385414338 | -122.438518094144 | (37.7996385414338, -122.438518094144) | 13 | 9 | 1 | 57 | 17 | ||
121271 | 143236 | DPW Maintained 1 | Tristania conferta :: 61 | 1550 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2016 06:43:00 AM | 3 | Width 0ft | 6004943.5793 | 2119894.559 | 37.8011054222859 | -122.427048053959 | (37.8011054222859, -122.427048053959) | 13 | 9 | 1 | 57 | 17 | ||
121377 | 13176 | DPW Maintained 1 | Tristania conferta :: 61 | 1964 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6002959.4463 | 2119614.5629 | 37.8002242300692 | -122.433893979596 | (37.8002242300692, -122.433893979596) | 13 | 9 | 1 | 57 | 17 | |||
122631 | 13099 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 6 | 3X3 | 6005022.5453 | 2119823.4113 | 37.8009145339293 | -122.4267697277 | (37.8009145339293, -122.4267697277) | 13 | 9 | 1 | 57 | 17 | ||
123256 | 57326 | DPW Maintained 1 | Tristania conferta :: 61 | 750 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 14 | Permit Number 16154 | 5999289.2953 | 2113999.1058 | 37.7845967138408 | -122.446189932846 | (37.7845967138408, -122.446189932846) | 15 | 6 | 1 | 29490 | 31 | ||
124227 | 138714 | DPW Maintained 1 | Tristania conferta :: 61 | 1642 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000616.1387 | 2114405.757 | 37.7857889577881 | -122.441628707296 | (37.7857889577881, -122.441628707296) | 15 | 6 | 1 | 29490 | 27 | |||
127281 | 13244 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||
128758 | 13116 | DPW Maintained 1 | Tristania conferta :: 61 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.428353733906 | (37.8007297168722, -122.428353733906) | 13 | 9 | 1 | 57 | 17 | ||
128869 | 103963 | DPW Maintained 1 | Tristania conferta :: 61 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467 | 2114127 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | 15 | 6 | 1 | 29490 | 27 | ||
129116 | 93015 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );