trees
412 rows where qSpecies_id = 216 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10913 | 253391 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2529x Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
48789 | 249654 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2401 Lyon St | 6 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 5999239.43043 | 2117239.91203 | 37.7934922681044 | -122.446595695332 | (37.7934922681044, -122.446595695332) | 11 | 1 | 57 | 30 | ||||
6760 | 125377 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 12 Hastings Ter | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6007265.71276 | 2119272.51381 | 37.7995284781148 | -122.418968306241 | (37.7995284781148, -122.418968306241) | 5 | 1 | 1 | 28858 | 32 | ||||
8255 | 249853 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 285 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011465.28647 | 2120398.88484 | 37.8028567997706 | -122.40451552739 | (37.8028567997706, -122.40451552739) | 3 | 1 | 10 | 308 | 23 | |||
10005 | 249841 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 6011410.89749 | 2120342.69349 | 37.8026994723548 | -122.404699784063 | (37.8026994723548, -122.404699784063) | 3 | 1 | 10 | 308 | 23 | |||
11432 | 33068 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1360 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37332 | 6011466.15955 | 2120021.30065 | 37.8018200945828 | -122.40448591181 | (37.8018200945828, -122.40448591181) | 3 | 1 | 10 | 308 | 23 | ||
23469 | 125395 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2671 Leavenworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6007309.27771 | 2121901.08627 | 37.8067483254418 | -122.419004095666 | (37.8067483254418, -122.419004095666) | 5 | 1 | 1 | 28858 | 32 | |||
24138 | 125372 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1725 Taylor St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6008695.5781 | 2118930.11416 | 37.7986687451178 | -122.413996207379 | (37.7986687451178, -122.413996207379) | 5 | 1 | 10 | 308 | 21 | |||
45331 | 107372 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 305x GREENWICH ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6011370 | 2120243 | 37.8024234525216 | -122.404834287898 | (37.8024234525216, -122.404834287898) | 3 | 1 | 10 | 308 | 23 | ||||
47030 | 249838 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 305 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011296.05526 | 2120375.39097 | 37.8027828323166 | -122.405099502142 | (37.8027828323166, -122.405099502142) | 3 | 1 | 10 | 308 | 23 | |||
67840 | 97192 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 18 Bartol St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6011743 | 2118577 | 37.7978698622465 | -122.403426241675 | (37.7978698622465, -122.403426241675) | 3 | 1 | 10 | 308 | 23 | |||||
67910 | 125378 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 16 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6007605.55128 | 2119392.07825 | 37.7998759024036 | -122.41780081986 | (37.7998759024036, -122.41780081986) | 5 | 1 | 1 | 28858 | 32 | ||||
67921 | 250217 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011333.4654 | 2120069.14279 | 37.8019440409451 | -122.40494846819 | (37.8019440409451, -122.40494846819) | 3 | 1 | 10 | 308 | 23 | |||
81302 | 249839 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 305 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011296.15098 | 2120380.09271 | 37.8027957474947 | -122.405099502163 | (37.8027957474947, -122.405099502163) | 3 | 1 | 10 | 308 | 23 | |||
87191 | 249849 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 289 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011439.22895 | 2120384.4493 | 37.8028157070334 | -122.404604683485 | (37.8028157070334, -122.404604683485) | 3 | 1 | 10 | 308 | 23 | |||
88966 | 125386 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 943 Vallejo St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6008816.33616 | 2118653.07682 | 37.797914850658 | -122.413558740271 | (37.797914850658, -122.413558740271) | 3 | 1 | 10 | 308 | 21 | ||||
93662 | 125391 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 81 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6008269.4097 | 2119109.23173 | 37.799136612912 | -122.415483578111 | (37.799136612912, -122.415483578111) | 5 | 1 | 10 | 308 | 32 | |||
95667 | 33071 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1360 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37332 | 6011470.52327 | 2119999.58164 | 37.8017607033429 | -122.404469281534 | (37.8017607033429, -122.404469281534) | 3 | 1 | 10 | 308 | 23 | ||
96521 | 125380 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008921.33225 | 2118578.8099 | 37.7977168271187 | -122.41319016839 | (37.7977168271187, -122.41319016839) | 3 | 1 | 10 | 308 | 21 | ||||
97642 | 125381 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008898.87665 | 2118577.20166 | 37.7977111506028 | -122.413267757408 | (37.7977111506028, -122.413267757408) | 3 | 1 | 10 | 308 | 21 | ||||
105764 | 125393 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 60 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008405.48034 | 2119146.48416 | 37.7992465460522 | -122.415015364072 | (37.7992465460522, -122.415015364072) | 5 | 1 | 10 | 308 | 32 | ||||
107854 | 125388 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1172 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007288.73286 | 2119886.64225 | 37.8012160163785 | -122.418932229062 | (37.8012160163785, -122.418932229062) | 5 | 1 | 1 | 28858 | 32 | |||
112041 | 125368 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1027 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008663.01245 | 2118264.99762 | 37.796840670723 | -122.414061816495 | (37.796840670723, -122.414061816495) | 5 | 1 | 10 | 308 | 21 | |||
117725 | 125387 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 941 Vallejo St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | 6008922.06708 | 2118675.50985 | 37.7979823825383 | -122.413194467167 | (37.7979823825383, -122.413194467167) | 3 | 1 | 10 | 308 | 21 | ||||
126127 | 125394 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 601 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6007295.97012 | 2121904.70723 | 37.8067575183062 | -122.419050406278 | (37.8067575183062, -122.419050406278) | 5 | 1 | 1 | 28858 | 32 | |||
126683 | 125382 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008858.79836 | 2118571.71552 | 37.7976938368446 | -122.413406051567 | (37.7976938368446, -122.413406051567) | 3 | 1 | 10 | 308 | 21 | ||||
129021 | 125379 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 90 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6008158.15776 | 2119112.52341 | 37.7991393972318 | -122.415868782036 | (37.7991393972318, -122.415868782036) | 5 | 1 | 10 | 308 | 32 | ||||
131240 | 125384 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008834.76125 | 2118568.89898 | 37.7976847536936 | -122.41348902752 | (37.7976847536936, -122.41348902752) | 3 | 1 | 10 | 308 | 21 | ||||
131886 | 249842 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 6011409.7751 | 2120350.84076 | 37.8027217800346 | -122.40470424202 | (37.8027217800346, -122.40470424202) | 3 | 1 | 10 | 308 | 23 | |||
136040 | 125396 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1306x Montgomery St | 28 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011438.36253 | 2120049.61228 | 37.8018962779427 | -122.404584097094 | (37.8018962779427, -122.404584097094) | 3 | 1 | 10 | 308 | 23 | |||
137652 | 125385 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1 Florence St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6008475.36416 | 2118338.86569 | 37.7970329529656 | -122.414716355687 | (37.7970329529656, -122.414716355687) | 5 | 1 | 10 | 308 | 21 | ||||
139731 | 249843 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 6011406.1385 | 2120362.03253 | 37.8027523066439 | -122.404717614929 | (37.8027523066439, -122.404717614929) | 3 | 1 | 10 | 308 | 23 | |||
144145 | 125369 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 17 Marion Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008330.46439 | 2119444.85614 | 37.8000615854201 | -122.415296079343 | (37.8000615854201, -122.415296079343) | 5 | 1 | 10 | 308 | 32 | ||||
147056 | 125361 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 5 Kimball Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007994.32097 | 2116413.82948 | 37.7917202403447 | -122.416244474729 | (37.7917202403447, -122.416244474729) | 5 | 1 | 10 | 28858 | 21 | |||
149068 | 249958 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 283 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011531.90819 | 2120075.94359 | 37.8019738048974 | -122.404262237813 | (37.8019738048974, -122.404262237813) | 3 | 1 | 10 | 308 | 23 | |||
149085 | 125392 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 14 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008540.3901 | 2119172.36551 | 37.7993251899554 | -122.414550360622 | (37.7993251899554, -122.414550360622) | 5 | 1 | 10 | 308 | 32 | ||||
150350 | 125371 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008342.7298 | 2119381.51745 | 37.799888362508 | -122.415249150039 | (37.799888362508, -122.415249150039) | 5 | 1 | 10 | 308 | 32 | ||||
156820 | 249995 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 41 Darrell Pl | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011498.48414 | 2120303.07103 | 37.8025955736741 | -122.404393897677 | (37.8025955736741, -122.404393897677) | 3 | 1 | 10 | 308 | 23 | |||
161680 | 125390 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1048 Union St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007884.3838 | 2119276.01103 | 37.7995728983285 | -122.416827724637 | (37.7995728983285, -122.416827724637) | 5 | 1 | 1 | 308 | 32 | |||
167088 | 125383 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008843.29101 | 2118569.75825 | 37.7976875919697 | -122.413459572924 | (37.7976875919697, -122.413459572924) | 3 | 1 | 10 | 308 | 21 | ||||
172860 | 125370 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Marion Pl | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.36598 | 2119390.6131 | 37.7999132602469 | -122.41525451361 | (37.7999132602469, -122.41525451361) | 5 | 1 | 10 | 308 | 32 | ||||
185264 | 250216 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011344.36464 | 2120071.55622 | 37.8019512768773 | -122.404910921503 | (37.8019512768773, -122.404910921503) | 3 | 1 | 10 | 308 | 23 | |||
188416 | 249968 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 213 Filbert St | 3 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | 3 | 1 | 10 | 308 | 23 | |||
192581 | 125389 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1182 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6007220.46315 | 2119868.37371 | 37.8011620111718 | -122.419167176043 | (37.8011620111718, -122.419167176043) | 5 | 1 | 1 | 28858 | 32 | ||||
32124 | 120500 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013077.52006 | 2115450.9456 | 37.7893609031295 | -122.398588915951 | (37.7893609031295, -122.398588915951) | 12 | 2 | 9 | 28855 | 6 | |
42310 | 120499 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013067.81097 | 2115461.47291 | 37.7893892677417 | -122.398623247559 | (37.7893892677417, -122.398623247559) | 12 | 2 | 9 | 28855 | 6 | |
51986 | 120502 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013100.31596 | 2115425.92976 | 37.7892934854631 | -122.398508288148 | (37.7892934854631, -122.398508288148) | 12 | 2 | 9 | 28855 | 6 | |
63903 | 220401 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006279.41971 | 2109112.41341 | 37.7715757574385 | -122.421659217195 | (37.7715757574385, -122.421659217195) | 8 | 2 | 9 | 28853 | 19 | |||
69550 | 187839 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012618.54939 | 2115295.68448 | 37.7889090117828 | -122.400166003066 | (37.7889090117828, -122.400166003066) | 12 | 2 | 9 | 28855 | 6 | |||
77266 | 187844 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012639.88234 | 2115272.52164 | 37.7888466015242 | -122.400090566143 | (37.7888466015242, -122.400090566143) | 12 | 2 | 9 | 28855 | 6 | |||
107733 | 221664 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 65 McCoppin St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6006280.59621 | 2109108.90891 | 37.7715662012613 | -122.421654898657 | (37.7715662012613, -122.421654898657) | 8 | 2 | 9 | 28853 | 19 | |||
114524 | 120501 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013088.10367 | 2115439.05309 | 37.7893288387076 | -122.398551462773 | (37.7893288387076, -122.398551462773) | 12 | 2 | 9 | 28855 | 6 | |
158447 | 187841 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012627.24493 | 2115287.70514 | 37.7888875872319 | -122.400135356873 | (37.7888875872319, -122.400135356873) | 12 | 2 | 9 | 28855 | 6 | |||
164905 | 120498 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013051.90851 | 2115477.96446 | 37.7894336636916 | -122.398679426422 | (37.7894336636916, -122.398679426422) | 12 | 2 | 9 | 28855 | 6 | |
184222 | 187843 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012635.2526 | 2115279.40045 | 37.7888652309851 | -122.400107067789 | (37.7888652309851, -122.400107067789) | 12 | 2 | 9 | 28855 | 6 | |||
190025 | 187842 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012630.56089 | 2115283.22761 | 37.788875477874 | -122.40012356945 | (37.788875477874, -122.40012356945) | 12 | 2 | 9 | 28855 | 6 | |||
192953 | 187840 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012623.23421 | 2115291.51814 | 37.7888978332071 | -122.4001495014 | (37.7888978332071, -122.4001495014) | 12 | 2 | 9 | 28855 | 6 | |||
7126 | 187852 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013926.08485 | 2107407.78513 | 37.7673234471545 | -122.395089353509 | (37.7673234471545, -122.395089353509) | 14 | 3 | 9 | 310 | 20 | |||
8727 | 187834 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1751 22nd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012872.98936 | 2103757.51384 | 37.7572419903395 | -122.398475721873 | (37.7572419903395, -122.398475721873) | 10 | 3 | 8 | 28856 | 29 | |||
11045 | 187828 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1989 18th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011906.05073 | 2105571.23226 | 37.7621681446677 | -122.401947288436 | (37.7621681446677, -122.401947288436) | 10 | 3 | 8 | 28856 | 29 | |||
13424 | 83116 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 625 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52391 | 6012731.81298 | 2104419.00109 | 37.7590504235551 | -122.399010395827 | (37.7590504235551, -122.399010395827) | 10 | 3 | 8 | 28856 | 29 | |
24299 | 187821 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1100 26th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 7ft | 6015077.55547 | 2101606.98896 | 37.751459673338 | -122.390701131346 | (37.751459673338, -122.390701131346) | 10 | 3 | 8 | 28856 | 1 | |||
26751 | 175120 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 104 Burrows St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6011145.11517 | 2093506.87446 | 37.7289995314962 | -122.40373016652 | (37.7289995314962, -122.40373016652) | 10 | 3 | 7 | 309 | 28 | |||
27697 | 187836 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1350 Rankin St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6012791.1903 | 2096920.73953 | 37.7384651145639 | -122.398278948414 | (37.7384651145639, -122.398278948414) | 10 | 3 | 8 | 58 | 1 | |||
32421 | 187853 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013912.72569 | 2107421.82042 | 37.7673612420515 | -122.395136544518 | (37.7673612420515, -122.395136544518) | 14 | 3 | 9 | 310 | 20 | |||
38755 | 110656 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012024.49835 | 2106000.36066 | 37.7633530455212 | -122.40156778264 | (37.7633530455212, -122.40156778264) | 8 | 3 | 8 | 28856 | 29 | |
44089 | 187825 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 800 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6015084.69781 | 2105339.12004 | 37.761707704374 | -122.390937245672 | (37.761707704374, -122.390937245672) | 10 | 3 | 8 | 28856 | 29 | |||
44604 | 187820 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 566 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011198.96482 | 2105703.6137 | 37.7624921461136 | -122.404402160644 | (37.7624921461136, -122.404402160644) | 8 | 3 | 8 | 28856 | 29 | |||
46526 | 187849 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013975.69295 | 2107357.62002 | 37.7671884634053 | -122.394914250996 | (37.7671884634053, -122.394914250996) | 14 | 3 | 9 | 310 | 20 | |||
48357 | 187826 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 800 19th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6015000.54682 | 2105330.7692 | 37.761680105077 | -122.391227708704 | (37.761680105077, -122.391227708704) | 10 | 3 | 8 | 28856 | 29 | |||
56771 | 87398 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 668 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50369 | 6009215.73569 | 2091111.89123 | 37.7223154426943 | -122.410231178548 | (37.7223154426943, -122.410231178548) | 9 | 3 | 7 | 309 | 28 | |
56910 | 187832 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 848 Kansas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6011545.77845 | 2104374.67474 | 37.7588625506898 | -122.403109170265 | (37.7588625506898, -122.403109170265) | 10 | 3 | 8 | 28856 | 29 | |||
59429 | 187845 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6014068.65615 | 2107267.60612 | 37.7669464738232 | -122.394586398647 | (37.7669464738232, -122.394586398647) | 14 | 3 | 9 | 310 | 20 | |||
62890 | 187837 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Apparel Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011250.95199 | 2097877.37741 | 37.7410059214738 | -122.403671667433 | (37.7410059214738, -122.403671667433) | 10 | 3 | 8 | 58 | 1 | |||
63598 | 187854 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013896.55337 | 2107438.77334 | 37.7674068916492 | -122.395193670376 | (37.7674068916492, -122.395193670376) | 14 | 3 | 9 | 310 | 20 | |||
68191 | 187838 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Apparel Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011238.47382 | 2097885.30068 | 37.7410269800211 | -122.403715369982 | (37.7410269800211, -122.403715369982) | 10 | 3 | 8 | 58 | 1 | |||
71786 | 187848 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014022.62191 | 2107316.98369 | 37.7670794943594 | -122.394749083307 | (37.7670794943594, -122.394749083307) | 14 | 3 | 9 | 310 | 20 | |||
78356 | 175100 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012716.46972 | 2086677.83624 | 37.7103360215502 | -122.397819010859 | (37.7103360215502, -122.397819010859) | 10 | 3 | 8 | 309 | 1 | |||
85991 | 187822 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 651 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014933.77995 | 2105442.46468 | 37.7619830911575 | -122.391466439131 | (37.7619830911575, -122.391466439131) | 10 | 3 | 8 | 28856 | 29 | |||
87027 | 187827 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1776 18th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6012462.11 | 2105661.6775 | 37.7624475055702 | -122.400030431159 | (37.7624475055702, -122.400030431159) | 14 | 3 | 8 | 28856 | 29 | |||
92843 | 87388 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 2 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
92994 | 187830 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012020.68344 | 2105975.58069 | 37.7632847923835 | -122.40157923552 | (37.7632847923835, -122.40157923552) | 8 | 3 | 8 | 28856 | 29 | ||||
96211 | 51795 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1023 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52392 | 6011949.33293 | 2103395.35355 | 37.7561960787909 | -122.401644650401 | (37.7561960787909, -122.401644650401) | 10 | 3 | 8 | 28856 | 29 | |
98694 | 187833 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 848 Kansas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6011546.21827 | 2104357.82851 | 37.7588163192433 | -122.403106464191 | (37.7588163192433, -122.403106464191) | 10 | 3 | 8 | 28856 | 29 | |||
99740 | 187823 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 654 Minnesota St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6015142.96332 | 2105500.9712 | 37.7621553455266 | -122.390747038169 | (37.7621553455266, -122.390747038169) | 10 | 3 | 8 | 28856 | 29 | |||
103629 | 187835 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 514 Connecticut St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6013228.65478 | 2104513.98611 | 37.759338905384 | -122.397298730545 | (37.759338905384, -122.397298730545) | 10 | 3 | 8 | 28856 | 29 | |||
111957 | 80118 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 625 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52391 | 6012721.58801903 | 2104578.90179473 | 37.7594889059642 | -122.399056982327 | (37.7594889059642, -122.399056982327) | 10 | 3 | 8 | 28856 | 29 | ||
113467 | 175102 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012641.62535 | 2086702.75705 | 37.7104002808186 | -122.398079437443 | (37.7104002808186, -122.398079437443) | 10 | 3 | 8 | 309 | 1 | |||
113800 | 87387 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | ||||
119951 | 187851 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013943.13627 | 2107389.9206 | 37.7672753433109 | -122.395029123218 | (37.7672753433109, -122.395029123218) | 14 | 3 | 9 | 310 | 20 | |||
133016 | 87389 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 3 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
133543 | 98816 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 290 Napoleon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011832.99645 | 2099730.66022 | 37.7461271360771 | -122.401789397166 | (37.7461271360771, -122.401789397166) | 10 | 3 | 8 | 58 | 1 | |||
139958 | 187855 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013880.1945 | 2107455.37205 | 37.7674515582618 | -122.395251416746 | (37.7674515582618, -122.395251416746) | 14 | 3 | 9 | 310 | 20 | |||
143016 | 175101 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012687.11436 | 2086687.84114 | 37.7103618581922 | -122.397921171135 | (37.7103618581922, -122.397921171135) | 10 | 3 | 8 | 309 | 1 | |||
147734 | 187856 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013871.42116 | 2107465.38185 | 37.7674785550305 | -122.395282464041 | (37.7674785550305, -122.395282464041) | 14 | 3 | 9 | 310 | 20 | |||
149629 | 187850 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013958.61615 | 2107374.23355 | 37.7672331309277 | -122.3949744813 | (37.7672331309277, -122.3949744813) | 14 | 3 | 9 | 310 | 20 | |||
157003 | 61580 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 660 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 10 | Permit Number 31997 | 6012675.50782 | 2104387.47055 | 37.7589607098827 | -122.399202913691 | (37.7589607098827, -122.399202913691) | 10 | 3 | 8 | 28856 | 29 | |
165950 | 87397 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 668 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50369 | 6009213.07274 | 2091121.28635 | 37.722341090456 | -122.41024104678 | (37.722341090456, -122.41024104678) | 9 | 3 | 7 | 309 | 28 | |
169786 | 187829 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012022.35521 | 2105982.64886 | 37.7633042932852 | -122.401573950187 | (37.7633042932852, -122.401573950187) | 8 | 3 | 8 | 28856 | 29 | ||||
171406 | 187847 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014037.17214 | 2107299.70636 | 37.7670328636008 | -122.394697545853 | (37.7670328636008, -122.394697545853) | 14 | 3 | 9 | 310 | 20 |
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) );