trees
412 rows where qSpecies_id = 216 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2115 | 125373 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2820 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005714.14628 | 2120095.1224 | 37.8016996609768 | -122.424395829926 | (37.8016996609768, -122.424395829926) | 5 | 9 | 1 | 28858 | 32 | |||
3925 | 96638 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 586 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767750 | 6001774.80022 | 2090099.6098 | 37.7191160424439 | -122.435880307331 | (37.7191160424439, -122.435880307331) | 9 | 7 | 6 | 28861 | 5 | |
5840 | 203318 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1515 16th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 5991179.11324 | 2105030.95188 | 37.7595060974465 | -122.473593745149 | (37.7595060974465, -122.473593745149) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
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 | |||
7970 | 203371 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 139 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6000497.81019 | 2095200.50866 | 37.7330493162673 | -122.440660040356 | (37.7330493162673, -122.440660040356) | 9 | 7 | 5 | 63 | 40 | |||
8208 | 84304 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3025 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986190.45674 | 2110423.46598 | 37.7740222651845 | -122.491243624376 | (37.7740222651845, -122.491243624376) | 11 | 6 | 2 | 55 | 26 | |||
8243 | 122060 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 20 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5990228.29156 | 2114901.44166 | 37.7865526483746 | -122.477603591625 | (37.7865526483746, -122.477603591625) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
8652 | 220362 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4385 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001398.03688 | 2101131.4744 | 37.7493855803788 | -122.437972403813 | (37.7493855803788, -122.437972403813) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
9039 | 203339 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 201 Montana St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5995007.64331 | 2089297.67598 | 37.7165273808053 | -122.459213572161 | (37.7165273808053, -122.459213572161) | 9 | 8 | 6 | 28861 | 24 | |||
9307 | 203358 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 22 Stanford Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997860.07979 | 2095706.7096 | 37.7342886603004 | -122.449815795282 | (37.7342886603004, -122.449815795282) | 9 | 7 | 4 | 59 | 40 | |||
9661 | 221676 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 302 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009690.29309 | 2099616.87031 | 37.7456948850248 | -122.409190595463 | (37.7456948850248, -122.409190595463) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
10707 | 220329 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4489 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 8ft | 6000090.03644 | 2101642.36493 | 37.7507138925428 | -122.442532162641 | (37.7507138925428, -122.442532162641) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||||||||||||
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 | |||
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 | ||
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 | |||
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 | |
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 | |||
15041 | 124271 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 03rd Ave | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 5994890.90692 | 2115030.17267 | 37.7871755775778 | -122.461481540713 | (37.7871755775778, -122.461481540713) | 11 | 6 | 1 | 54 | 11 | ||||
15482 | 220378 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 675 Sanchez St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003704.91651 | 2104432.52245 | 37.7585803964946 | -122.430230635836 | (37.7585803964946, -122.430230635836) | 2 | 4 | 5 | 28862 | 3 | |||
15873 | 203368 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 14 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994786.1509 | 2099056.80559 | 37.7433108398313 | -122.460685974586 | (37.7433108398313, -122.460685974586) | 1 | 8 | 4 | 59 | 40 | |||
16648 | 74277 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2695 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989249.6268 | 2097038.4901 | 37.737448975855 | -122.479681976341 | (37.737448975855, -122.479681976341) | 1 | 8 | 3 | 29491 | 35 | |||
17214 | 69804 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 510 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010631.84232 | 2105884.17134 | 37.7629562079975 | -122.406376362283 | (37.7629562079975, -122.406376362283) | 8 | 4 | 8 | 28859 | 19 | |||
17646 | 220388 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 5 Buena Vista Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001450.49728 | 2108237.48895 | 37.7688999515093 | -122.438300008844 | (37.7688999515093, -122.438300008844) | 15 | 5 | 5 | 29492 | 3 | |||
18155 | 220383 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4045 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003391.11263 | 2104163.98904 | 37.7578252888237 | -122.431296742546 | (37.7578252888237, -122.431296742546) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
18611 | 220353 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 469 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002156.61488 | 2103141.53357 | 37.7549478332987 | -122.435493001722 | (37.7549478332987, -122.435493001722) | 2 | 4 | 5 | 28862 | 22 | |||
20042 | 25164 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2710 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6001235.48665 | 2105625.73968 | 37.7617165006498 | -122.438856528211 | (37.7617165006498, -122.438856528211) | 15 | 4 | 5 | 28862 | 3 | |||
21963 | 124314 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 135 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5996194.40769 | 2113485.50312 | 37.7830092673371 | -122.456859975367 | (37.7830092673371, -122.456859975367) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
23981 | 124455 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 21 Willard St North | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996104.44232 | 2111613.72019 | 37.7778646812141 | -122.457035781061 | (37.7778646812141, -122.457035781061) | 11 | 6 | 2 | 54 | 16 | |||
23995 | 220324 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1422 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6001360.59513 | 2099533.85422 | 37.7449967655889 | -122.437987456654 | (37.7449967655889, -122.437987456654) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
24459 | 140930 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 118 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996567.4031 | 2113640.2065 | 37.7834554526548 | -122.455580757548 | (37.7834554526548, -122.455580757548) | 11 | 6 | 1 | 54 | 31 | |||
24661 | 220356 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1283 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 5997497.01628 | 2105060.24873 | 37.7599504011987 | -122.451745533534 | (37.7599504011987, -122.451745533534) | 15 | 5 | 11 | 29492 | 12 | |||
25406 | 220341 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2108 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6002638.72392 | 2099313.54816 | 37.7444644586719 | -122.433552181088 | (37.7444644586719, -122.433552181088) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
27154 | 220399 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 30 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6003251.88347 | 2097705.60279 | 37.7400841829489 | -122.431317245319 | (37.7400841829489, -122.431317245319) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
27738 | 220365 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3651 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004039.45464 | 2103618.55812 | 37.7563643860146 | -122.429015618497 | (37.7563643860146, -122.429015618497) | 2 | 4 | 5 | 28862 | 22 | |||
27959 | 220366 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4639 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000471.63845 | 2104630.9985 | 37.758941698227 | -122.441426983086 | (37.758941698227, -122.441426983086) | 2 | 4 | 5 | 28862 | 38 | |||
28439 | 175098 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 160 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001025.23158 | 2087672.68531 | 37.7124096414687 | -122.438297499729 | (37.7124096414687, -122.438297499729) | 9 | 7 | 6 | 28861 | 5 | |||
28680 | 125348 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2299 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5999263.33802 | 2120778.39927 | 37.8032093726819 | -122.446767698771 | (37.8032093726819, -122.446767698771) | 13 | 9 | 1 | 57 | 17 | |||
28685 | 203347 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1403 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5996798.38669 | 2106558.10503 | 37.7640230971055 | -122.454269934113 | (37.7640230971055, -122.454269934113) | 15 | 5 | 11 | 29492 | 12 | |||
30491 | 220367 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 95 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000655.01013 | 2104627.19452 | 37.7589416982231 | -122.440792526679 | (37.7589416982231, -122.440792526679) | 2 | 4 | 5 | 28862 | 38 | |||
30606 | 220386 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 94 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001958.7208 | 2108209.18797 | 37.7688511372057 | -122.436540075167 | (37.7688511372057, -122.436540075167) | 15 | 5 | 5 | 29492 | 3 | |||
30620 | 221701 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 130 Cuvier St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6004002.66039 | 2095058.43233 | 37.7328581734556 | -122.428532723922 | (37.7328581734556, -122.428532723922) | 9 | 7 | 5 | 28861 | 25 | |||
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 | |
32265 | 221667 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 513 Hickory St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6004344.86281 | 2110297.09117 | 37.7747193160817 | -122.428435413676 | (37.7747193160817, -122.428435413676) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 |
34521 | 245847 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 253 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005116.227 | 2109828.8135 | 37.7734771588527 | -122.425733769016 | (37.7734771588527, -122.425733769016) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
34805 | 125362 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2623 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6000629.88469 | 2117456.82449 | 37.7941671778206 | -122.441800204414 | (37.7941671778206, -122.441800204414) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
35453 | 220374 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 333 Liberty St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004121.1328 | 2103908.3922 | 37.7571648249261 | -122.428753807867 | (37.7571648249261, -122.428753807867) | 2 | 4 | 5 | 28862 | 3 | |||
36455 | 203370 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 425 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995469.36177 | 2098333.74303 | 37.7413647734529 | -122.458271300302 | (37.7413647734529, -122.458271300302) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
36979 | 175117 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 452 Pioche St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6005533.40431 | 2093235.27349 | 37.7279386894027 | -122.423111001793 | (37.7279386894027, -122.423111001793) | 9 | 7 | 7 | 309 | 5 | |||
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 | |||
37716 | 203313 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1443 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991120.78337 | 2105575.79934 | 37.7609987256329 | -122.473835225708 | (37.7609987256329, -122.473835225708) | 1 | 8 | 4 | 56 | 12 | |||
37988 | 203396 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 118 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999291.63523 | 2095542.51232 | 37.7339196162903 | -122.444854666332 | (37.7339196162903, -122.444854666332) | 9 | 7 | 4 | 59 | 40 | |||
38513 | 203331 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 750 Ulloa St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5993847.23995 | 2098153.58513 | 37.7407767589358 | -122.463866913539 | (37.7407767589358, -122.463866913539) | 1 | 8 | 4 | 59 | 40 | |||
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 | |
39007 | 220331 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000361.61941 | 2101560.0296 | 37.7505032964896 | -122.44158710019 | (37.7505032964896, -122.44158710019) | 2 | 4 | 5 | 28862 | 22 | |||
39357 | 246433 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 498 Duncan St | 3 | Front Yard : Yard | Tree | Private 2 | 2 | Width 6ft | 6003355.26988 | 2099829.27053 | 37.7459211418391 | -122.431111315848 | (37.7459211418391, -122.431111315848) | 2 | 7 | 5 | 63 | 22 | |||
40466 | 125356 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2298 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5999274.8339 | 2120845.46817 | 37.8033941824582 | -122.446732745722 | (37.8033941824582, -122.446732745722) | 13 | 9 | 1 | 57 | 17 | |||
41496 | 220395 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 334 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003664.8638 | 2108679.39994 | 37.7702390294466 | -122.430672206559 | (37.7702390294466, -122.430672206559) | 15 | 9 | 11 | 29492 | 10 | |||
41649 | 203363 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 300 Cresta Vista Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5996887.91783 | 2096184.01831 | 37.7355435643855 | -122.45321129988 | (37.7355435643855, -122.45321129988) | 9 | 7 | 4 | 59 | 40 | |||
42103 | 125366 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2675 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000289.81548 | 2117800.51566 | 37.7950914803362 | -122.443001570984 | (37.7950914803362, -122.443001570984) | 13 | 9 | 1 | 57 | 27 | |||
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 | |
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 | |||
43267 | 32318 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3337 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1996 12:00:00 AM | 3 | Permit Number 36887 | 6009065.50537 | 2099248.94213 | 37.7446496128893 | -122.411325040136 | (37.7446496128893, -122.411325040136) | 2 | 7 | 7 | 28859 | 2 | ||
43980 | 221690 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 272 Upper Ter | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 5999429.56264 | 2106111.66806 | 37.7629478281049 | -122.445137406888 | (37.7629478281049, -122.445137406888) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
45128 | 203346 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1266 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993956.53635 | 2106867.8687 | 37.7647102493132 | -122.46412146844 | (37.7647102493132, -122.46412146844) | 11 | 5 | 11 | 56 | 12 | |||
45800 | 203364 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 300 Cresta Vista Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5996883.01988 | 2096183.00006 | 37.7355404877898 | -122.453228160376 | (37.7355404877898, -122.453228160376) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
47485 | 220398 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 30 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6003262.10357 | 2097709.4316 | 37.7400952751738 | -122.431282181647 | (37.7400952751738, -122.431282181647) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
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 | ||||
48873 | 203338 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 247 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998510.07859 | 2093470.23079 | 37.7281849858352 | -122.447407627559 | (37.7281849858352, -122.447407627559) | 9 | 7 | 4 | 28861 | 40 | |||
50449 | 203315 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1335 14th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991744.93275 | 2106323.82139 | 37.7630887266775 | -122.471731099918 | (37.7630887266775, -122.471731099918) | 1 | 8 | 11 | 56 | 12 | |||
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 | ||||
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 | |
53436 | 220334 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 4496 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6000047.84821 | 2101692.19101 | 37.7508482980157 | -122.442681629955 | (37.7508482980157, -122.442681629955) | 2 | 4 | 5 | 28862 | 22 | |||
53549 | 203336 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 119 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 6001262.91876 | 2094603.70788 | 37.731454179756 | -122.437972130409 | (37.731454179756, -122.437972130409) | 9 | 7 | 4 | 63 | 40 | |||
53671 | 203326 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 135 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993391.47751 | 2094650.92205 | 37.7311330435596 | -122.465188404339 | (37.7311330435596, -122.465188404339) | 9 | 8 | 4 | 59 | 40 | |||
54890 | 175110 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 654 Brotherhood Way | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990029.878 | 2088691.22109 | 37.714574770977 | -122.47637473852 | (37.714574770977, -122.47637473852) | 1 | 8 | 4 | 64 | 14 | |||
56168 | 203387 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 262 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998346.86197 | 2093572.94917 | 37.7284576980424 | -122.447979263656 | (37.7284576980424, -122.447979263656) | 9 | 7 | 4 | 28861 | 40 |
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) );