trees
412 rows where qSpecies_id = 216 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
7310 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 185 Chilton Ave | Front Yard : Yard | Tree | Private 2 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
16337 | 96163 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 195 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767795 | 6009794.5 | 2099949.7 | 37.7466145997749 | -122.408853739556 | (37.7466145997749, -122.408853739556) | 2 | 7 | 7 | 28859 | 2 | |
24162 | 99513 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 154 Miraloma Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2012 12:00:00 AM | Permit Number 768163 | 5994585.5 | 2096588.5 | 37.7365219395083 | -122.461200886189 | (37.7365219395083, -122.461200886189) | 9 | 7 | 4 | 59 | 40 | |||
24408 | 112743 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 568 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774177 | 5992782.4 | 2090984.4 | 37.7210305330099 | -122.467027609071 | (37.7210305330099, -122.467027609071) | 9 | 8 | 6 | 64 | 24 | ||
36409 | 54922 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 367 San Benito Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992758.47184875 | 2094166.59026038 | 37.7297666650173 | -122.467341592307 | (37.7297666650173, -122.467341592307) | 9 | 8 | 4 | 59 | 40 | |||
39013 | 85236 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 40 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | Permit Number 49540 | 6000828 | 2106121 | 37.7630531718404 | -122.440301375814 | (37.7630531718404, -122.440301375814) | 15 | 5 | 5 | 28862 | 3 | |||
59106 | 101227 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 367 San Benito Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992771 | 2094160.5 | 37.7297506659069 | -122.467297838803 | (37.7297506659069, -122.467297838803) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||||
69564 | 85237 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 42 Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | Permit Number 49540 | 6000808.1 | 2106104.4 | 37.7630064592859 | -122.440369012404 | (37.7630064592859, -122.440369012404) | 15 | 5 | 5 | 28862 | 3 | |||
70234 | 64432 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 540 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 3x3 | Permit Number 25284 | 6002797.48235451 | 2103888.92827158 | 37.7570363778593 | -122.433330106661 | (37.7570363778593, -122.433330106661) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
97868 | 121588 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 4485 24th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000127 | 2101626 | 37.7506710653117 | -122.442403165119 | (37.7506710653117, -122.442403165119) | 2 | 4 | 5 | 28862 | 22 | ||||
100324 | 63668 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 4047 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24318 | 6003600.24394191 | 2100374.40031768 | 37.7474318202009 | -122.430303114981 | (37.7474318202009, -122.430303114981) | 2 | 4 | 5 | 63 | 22 | ||
109045 | 62541 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 683 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/17/1986 12:00:00 AM | Permit Number 22731 | 5991602.26359667 | 2110780.44793607 | 37.775317168638 | -122.472549473895 | (37.775317168638, -122.472549473895) | 11 | 6 | 2 | 54 | 26 | ||
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 | ||
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 | ||||
119246 | 95315 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 4385 25th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 4.5 x5 | 6001393 | 2101138 | 37.7494032116825 | -122.437990288793 | (37.7494032116825, -122.437990288793) | 2 | 4 | 5 | 28862 | 22 | ||||
120915 | 101226 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 367 San Benito Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992771 | 2094160.5 | 37.7297506659069 | -122.467297838803 | (37.7297506659069, -122.467297838803) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
138203 | 63958 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 1606 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2012 12:00:00 AM | Permit Number 769285 | 6002561.24986049 | 2100901.48579997 | 37.7488201665964 | -122.43393355272 | (37.7488201665964, -122.43393355272) | 2 | 4 | 5 | 28862 | 22 | ||
143704 | 68852 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 270 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/1999 12:00:00 AM | Permit Number 32815 | 5998962.64613301 | 2094109.16076165 | 37.7299651894667 | -122.445889023969 | (37.7299651894667, -122.445889023969) | 9 | 7 | 4 | 28861 | 40 | ||
147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||||
153408 | 63250 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 341 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1987 12:00:00 AM | Permit Number 23802 | 6006556.22504592 | 2104122.60651516 | 37.7578905263243 | -122.420347507255 | (37.7578905263243, -122.420347507255) | 2 | 4 | 7 | 28859 | 19 | ||
162706 | 94228 | Property Tree 8 | Acer palmatum :: Japanese Maple 216 | 1097 Church St | Front Yard : Yard | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455 | 2102510 | 37.7533440588084 | -122.427499544702 | (37.7533440588084, -122.427499544702) | 2 | 4 | 5 | 28862 | 22 | ||||
165686 | 253986 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 455X Detroit St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5999323 | 2094622 | 37.7313938956762 | -122.444680088302 | (37.7313938956762, -122.444680088302) | 9 | 7 | 4 | 59 | 40 | ||||
171052 | 67167 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 92 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2008 12:00:00 AM | 3x3 | Permit Number 51915 | 6009125.10748473 | 2096937.35188264 | 37.7383058340982 | -122.410955710423 | (37.7383058340982, -122.410955710423) | 10 | 7 | 7 | 28859 | 2 | ||
177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
183955 | 89330 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 846 Junipero Serra Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2008 12:00:00 AM | 3x3 | Permit Number 51923 | 5991242.2 | 2091754 | 37.723054643014 | -122.472407650365 | (37.723054643014, -122.472407650365) | 9 | 8 | 4 | 64 | 40 | |||
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 | ||||
11553 | 221666 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 599 Buchanan St | 5 | : | Tree | Private 2 | 1 | Width 6ft | 6004540.01666 | 2110455.77622 | 37.7751660677958 | -122.427771645646 | (37.7751660677958, -122.427771645646) | 7 | 9 | 11 | 28852 | 10 | |||
13997 | 203337 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 737 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5997193.84044 | 2094974.44377 | 37.7322398922466 | -122.452066372065 | (37.7322398922466, -122.452066372065) | 9 | 7 | 4 | 59 | 40 | |||
14014 | 79549 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 206 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6005878.19097 | 2092769.79945 | 37.7266800504424 | -122.421886012749 | (37.7266800504424, -122.421886012749) | 9 | 7 | 7 | 309 | 5 | |||
18322 | 203323 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 145 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992709.91789 | 2098242.86933 | 37.7409563040799 | -122.467805802899 | (37.7409563040799, -122.467805802899) | 1 | 8 | 4 | 59 | 40 | |||
33089 | 92287 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1855 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52735 | 5989674.9136 | 2102746.3552 | 37.7531459773203 | -122.47862887811 | (37.7531459773203, -122.47862887811) | 1 | 8 | 3 | 56 | 35 |
34701 | 203340 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 458 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 6ft | 5994050.25067 | 2089476.74481 | 37.7169639728763 | -122.462535752332 | (37.7169639728763, -122.462535752332) | 9 | 8 | 6 | 28861 | 24 | |||
35118 | 221681 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1495 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004584.24332 | 2100224.42026 | 37.7470756968823 | -122.426889829827 | (37.7470756968823, -122.426889829827) | 2 | 7 | 5 | 63 | 22 | |||
36733 | 221665 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 415 Buchanan St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6004608.71317 | 2109961.56798 | 37.7738129784269 | -122.427498793141 | (37.7738129784269, -122.427498793141) | 7 | 9 | 11 | 28852 | 10 | |||
36846 | 203322 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 145 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992707.99091 | 2098236.29435 | 37.7409381395776 | -122.467811987538 | (37.7409381395776, -122.467811987538) | 1 | 8 | 4 | 59 | 40 | |||
37068 | 203379 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 623 Gennessee St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997445.47833 | 2095480.16412 | 37.7336428903891 | -122.451232866 | (37.7336428903891, -122.451232866) | 9 | 7 | 4 | 59 | 40 | |||
42750 | 220396 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 18 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003652.84121 | 2098131.69729 | 37.7412768557411 | -122.429961284404 | (37.7412768557411, -122.429961284404) | 2 | 7 | 5 | 63 | 7 | |||
50583 | 220400 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 30 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6003253.97405 | 2097694.59557 | 37.7400540781348 | -122.431309231431 | (37.7400540781348, -122.431309231431) | 2 | 7 | 5 | 63 | 7 | |||
50670 | 220397 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 26 Harry St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6003351.87742 | 2097763.26551 | 37.7402481779198 | -122.43097562163 | (37.7402481779198, -122.43097562163) | 2 | 7 | 5 | 63 | 7 | ||||
56190 | 175103 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 56 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009154.75517 | 2086318.89701 | 37.709151452539 | -122.410103762579 | (37.709151452539, -122.410103762579) | 9 | 7 | 8 | 309 | 39 | |||
57510 | 220348 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3931 21st St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6002260.23374 | 2103523.23567 | 37.7560017802648 | -122.435161958553 | (37.7560017802648, -122.435161958553) | 2 | 4 | 5 | 28862 | 22 | ||||
58193 | 175096 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 56 Tomaso Ct | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6009154.58159 | 2086320.62957 | 37.7091562000666 | -122.410104484734 | (37.7091562000666, -122.410104484734) | 9 | 7 | 8 | 309 | 39 | |||
60544 | 57670 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2617 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1976 12:00:00 AM | 1 | Permit Number 16572 | 5999913.602 | 2114001.1268 | 37.784637896408 | -122.444030194405 | (37.784637896408, -122.444030194405) | 15 | 6 | 11 | 29490 | 31 | ||
62079 | 84123 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50684 | 6010955.75977 | 2089742.14973 | 37.7186517953192 | -122.404119940781 | (37.7186517953192, -122.404119940781) | 10 | 7 | 8 | 309 | 39 | |
63893 | 141261 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 53 PARKER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996809.8823 | 2114238.367 | 37.7851117539965 | -122.454785110153 | (37.7851117539965, -122.454785110153) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
66290 | 221674 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1101 San Jose Ave | 63 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 6005018.97642 | 2096583.24508 | 37.7371024294214 | -122.425127515618 | (37.7371024294214, -122.425127515618) | 2 | 7 | 5 | 28859 | 2 | |||
72335 | 221671 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6011148.99057 | 2102603.41855 | 37.7539769072094 | -122.404356782652 | (37.7539769072094, -122.404356782652) | 10 | 4 | 8 | 28859 | 19 | |||
73730 | 94570 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 376 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53748 | 5986249.73354 | 2113372.20578 | 37.7821221276999 | -122.491255642952 | (37.7821221276999, -122.491255642952) | 11 | 6 | 2 | 55 | 26 | |
73771 | 203378 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 545 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5996909.28044 | 2095401.70048 | 37.7333967324689 | -122.453080986318 | (37.7333967324689, -122.453080986318) | 9 | 7 | 4 | 59 | 40 | |||
83531 | 203351 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 164 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992620.06578 | 2098094.05274 | 37.7405425026236 | -122.468105653075 | (37.7405425026236, -122.468105653075) | 1 | 8 | 4 | 59 | 40 | |||
84818 | 220349 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3931 21st St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6002264.17759 | 2103521.03564 | 37.7559959634618 | -122.435148162081 | (37.7559959634618, -122.435148162081) | 2 | 4 | 5 | 28862 | 22 | ||||
89506 | 221688 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 106 Chattanooga St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6004702.30219 | 2102996.64608 | 37.7546942595564 | -122.426678973882 | (37.7546942595564, -122.426678973882) | 2 | 4 | 5 | 28862 | 22 | |||
89971 | 94042 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 641 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53452 | 6001625.67321 | 2089781.77052 | 37.7182348543375 | -122.436373045876 | (37.7182348543375, -122.436373045876) | 9 | 7 | 6 | 28861 | 5 | |
90862 | 221673 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006500.29072 | 2108193.70634 | 37.7690656587778 | -122.420829975738 | (37.7690656587778, -122.420829975738) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
95295 | 31014 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1200 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 1 | Permit Number 43760 | 6001111.96152 | 2087453.85636 | 37.7118137183117 | -122.437982070624 | (37.7118137183117, -122.437982070624) | 9 | 7 | 6 | 28861 | 5 | |
97232 | 220333 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4281 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002064.07132 | 2101172.17372 | 37.7495351844225 | -122.435672155661 | (37.7495351844225, -122.435672155661) | 2 | 4 | 5 | 28862 | 22 | |||
97805 | 122192 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 39 14th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 5991443.22738 | 2114949.06596 | 37.7867538394049 | -122.473403728742 | (37.7867538394049, -122.473403728742) | 11 | 6 | 1 | 54 | 33 | |||
99057 | 175118 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 206 Gambier St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005880.2838 | 2092762.94452 | 37.7266613463289 | -122.421878291172 | (37.7266613463289, -122.421878291172) | 9 | 7 | 7 | 309 | 5 | |||
103513 | 221680 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 482 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004683.99616 | 2110372.61321 | 37.7749458660929 | -122.427267662885 | (37.7749458660929, -122.427267662885) | 7 | 9 | 11 | 28852 | 10 | |||
106112 | 221668 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 112 27th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 6005711.74645 | 2100245.88519 | 37.747198322139 | -122.422992538592 | (37.747198322139, -122.422992538592) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
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 | |||
115422 | 203350 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 164 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992616.11685 | 2098085.14568 | 37.7405178180304 | -122.468118659063 | (37.7405178180304, -122.468118659063) | 1 | 8 | 4 | 59 | 40 | |||
116131 | 60015 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1766 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 1 | Permit Number 767848 | 5999440.6776 | 2110175.348 | 37.7741063034637 | -122.445391169516 | (37.7741063034637, -122.445391169516) | 15 | 5 | 11 | 29492 | 16 | ||
118212 | 125357 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2298 Beach St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999256.08424 | 2120843.17837 | 37.803386824209 | -122.446797464535 | (37.803386824209, -122.446797464535) | 13 | 9 | 1 | 57 | 17 | |||
126977 | 220332 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 449 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002213.85017 | 2100885.61616 | 37.7487568715287 | -122.435133723449 | (37.7487568715287, -122.435133723449) | 2 | 4 | 5 | 28862 | 22 | |||
128745 | 94571 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 376 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53748 | 5986248.68172 | 2113393.08736 | 37.7821794010656 | -122.491260819041 | (37.7821794010656, -122.491260819041) | 11 | 6 | 2 | 55 | 26 | |
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 | ||||
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 | |||
134356 | 203320 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 175 Lomita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991326.1382 | 2104286.13359 | 37.7574695368147 | -122.473030949437 | (37.7574695368147, -122.473030949437) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
140258 | 221686 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1409 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003947.98738 | 2100019.65715 | 37.7464774687749 | -122.429075352355 | (37.7464774687749, -122.429075352355) | 2 | 7 | 5 | 63 | 22 | |||
140783 | 203321 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 145 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992706.31414 | 2098229.45962 | 37.7409192763152 | -122.46781728816 | (37.7409192763152, -122.46781728816) | 1 | 8 | 4 | 59 | 40 | |||
141381 | 203327 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 145 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993434.99156 | 2093968.51772 | 37.7292618385466 | -122.464988427495 | (37.7292618385466, -122.464988427495) | 9 | 8 | 4 | 59 | 40 | |||
143254 | 203397 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 497 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5998794.93094 | 2094954.71553 | 37.7322773058584 | -122.446529642844 | (37.7322773058584, -122.446529642844) | 9 | 7 | 4 | 59 | 40 | |||
145963 | 57696 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 896 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1976 12:00:00 AM | 1 | Permit Number 16600 | 5988547.94234 | 2109942.18348 | 37.7728382639909 | -122.483053495279 | (37.7728382639909, -122.483053495279) | 11 | 6 | 2 | 55 | 26 | ||
148084 | 203334 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 379 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5998906.46695 | 2094352.08101 | 37.7306289834441 | -122.446100707607 | (37.7306289834441, -122.446100707607) | 9 | 7 | 4 | 28861 | 40 | |||
150656 | 203341 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 247 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991927.69835 | 2090159.32965 | 37.718715720927 | -122.469921991331 | (37.718715720927, -122.469921991331) | 9 | 8 | 6 | 64 | 24 | |||
161670 | 220347 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3931 21st St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6002257.17808 | 2103516.9428 | 37.7559843280368 | -122.435172075945 | (37.7559843280368, -122.435172075945) | 2 | 4 | 5 | 28862 | 22 | ||||
168299 | 203366 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 32 Malta Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5999734.80282 | 2095934.78629 | 37.7350219899734 | -122.443350672502 | (37.7350219899734, -122.443350672502) | 9 | 7 | 4 | 63 | 40 | |||
171961 | 175099 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 246 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012405.6069 | 2087718.72316 | 37.7131767739728 | -122.398966433363 | (37.7131767739728, -122.398966433363) | 10 | 3 | 8 | 309 | 1 | |||
172643 | 68957 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 896 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 1 | Permit Number 32946 | 5988548.10153 | 2109960.29491 | 37.7728880022167 | -122.483054272347 | (37.7728880022167, -122.483054272347) | 11 | 6 | 2 | 55 | 26 | |
180315 | 125355 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2298 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999283.74107 | 2120846.75644 | 37.8033982285105 | -122.446702014982 | (37.8033982285105, -122.446702014982) | 13 | 9 | 1 | 57 | 17 | |||
184160 | 221669 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 120 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 6005709.14561 | 2100246.00775 | 37.7471985118996 | -122.423001540815 | (37.7471985118996, -122.423001540815) | 2 | 7 | 5 | 28859 | 22 | |||
191234 | 221672 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1209 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6011147.34779 | 2102647.41029 | 37.7540976070279 | -122.404365560027 | (37.7540976070279, -122.404365560027) | 10 | 4 | 8 | 28859 | 19 | |||
193905 | 203332 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 754 Ulloa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993838.4118 | 2098152.73836 | 37.7407739251688 | -122.46389737627 | (37.7407739251688, -122.46389737627) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
86726 | 52708 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1@ JACKSON Cherry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2006 12:00:00 AM | 10 | Permit Number 48766 | 5996048.76083 | 2115908.96957 | 37.7896550918848 | -122.457539249047 | (37.7896550918848, -122.457539249047) | 11 | 6 | 1 | 54 | 31 | ||
87722 | 35142 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 918 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 10 | Permit Number 38672 | 6001814.33321 | 2088634.2488 | 37.7150947329125 | -122.435638878045 | (37.7150947329125, -122.435638878045) | 9 | 7 | 6 | 28861 | 5 | |
98524 | 220344 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 12 Worth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6000853.3695 | 2103209.2326 | 37.7550596145267 | -122.440004835668 | (37.7550596145267, -122.440004835668) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
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 | |||
68087 | 187819 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 530 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010638.06608 | 2105759.62754 | 37.7626145870019 | -122.406346060533 | (37.7626145870019, -122.406346060533) | 8 | 4 | 8 | 28859 | 19 | |||
75432 | 220328 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 601 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000057.68196 | 2101564.65606 | 37.7504986784797 | -122.442638467911 | (37.7504986784797, -122.442638467911) | 2 | 4 | 5 | 28862 | 22 |
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) );