trees
81 rows where qSpecies_id = 302
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6659 | 50162 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 100@ GROVE Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2003 12:00:00 AM | 6 | Permit Number 46875 | 5997802.2799 | 2110209.3118 | 37.7741058948892 | -122.451061095191 | (37.7741058948892, -122.451061095191) | 15 | 5 | 11 | 29492 | 16 | ||
| 7809 | 258391 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 701 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002214.93495 | 2089702.35217 | 37.7180502540861 | -122.434330546175 | (37.7180502540861, -122.434330546175) | 9 | 7 | 6 | 28861 | 5 | |||
| 9189 | 160324 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 510X Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2017 02:10:00 PM | 3 | Width 0ft | 6001907.38785 | 2089113.43826 | 37.7164157659386 | -122.435351498769 | (37.7164157659386, -122.435351498769) | 9 | 7 | 6 | 28861 | 5 | |
| 9245 | 199639 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014470.70337 | 2111338.492 | 37.7781465631608 | -122.39348069927 | (37.7781465631608, -122.39348069927) | 6 | 2 | 9 | 28856 | 20 | |||
| 9848 | 258392 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 795 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6001897.562 | 2089198.5455 | 37.7166488934899 | -122.435391546182 | (37.7166488934899, -122.435391546182) | 9 | 7 | 6 | 28861 | 5 | |||
| 13117 | 258394 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 800 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002062.33239 | 2089029.17601 | 37.7161931987384 | -122.434809912883 | (37.7161931987384, -122.434809912883) | 9 | 7 | 6 | 28861 | 5 | |||
| 13448 | 199636 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014300.61194 | 2111177.2028 | 37.7776942473326 | -122.394057817637 | (37.7776942473326, -122.394057817637) | 6 | 2 | 9 | 28856 | 20 | |||
| 17781 | 258398 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 700 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x3 | 6002181.09052 | 2089723.67246 | 37.718106873757 | -122.434449055074 | (37.718106873757, -122.434449055074) | 9 | 7 | 6 | 28861 | 5 | |||
| 19430 | 258395 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 795 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6001897.562 | 2089198.5455 | 37.7166488934899 | -122.435391546182 | (37.7166488934899, -122.435391546182) | 9 | 7 | 6 | 28861 | 5 | |||
| 19576 | 258400 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 801 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6001867.54343 | 2089150.88395 | 37.7165163205942 | -122.435491897634 | (37.7165163205942, -122.435491897634) | 9 | 7 | 6 | 28861 | 5 | |||
| 20626 | 244020 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 261 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005465.54578 | 2102195.1354 | 37.7525366186718 | -122.423982474511 | (37.7525366186718, -122.423982474511) | 2 | 4 | 5 | 28859 | 19 | |||
| 22491 | 199632 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014144.2654 | 2111030.15409 | 37.7772817939643 | -122.394588378076 | (37.7772817939643, -122.394588378076) | 6 | 2 | 9 | 28856 | 20 | |||
| 22681 | 253059 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 23998 | 124470 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 349 Willard St North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5996263.14672 | 2110459.34102 | 37.7747041718012 | -122.456403276377 | (37.7747041718012, -122.456403276377) | 11 | 6 | 2 | 54 | 16 | |||
| 25463 | 201798 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 3 | : | Tree | Private 2 | 2 | Width 5ft | 6021088.33309 | 2092752.01283 | 37.7274772697451 | -122.369303133851 | (37.7274772697451, -122.369303133851) | 10 | 3 | 8 | 58 | 1 | |||
| 31894 | 160555 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:28:00 PM | 3 | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 | |
| 32615 | 201797 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 2 | : | Tree | Private 2 | 2 | Width 5ft | 6021117.27971 | 2092731.09266 | 37.7274214146518 | -122.369201619254 | (37.7274214146518, -122.369201619254) | 10 | 3 | 8 | 58 | 1 | |||
| 33136 | 199637 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014435.54732 | 2111305.41941 | 37.7780537998839 | -122.393600002432 | (37.7780537998839, -122.393600002432) | 6 | 2 | 9 | 28856 | 20 | |||
| 37953 | 201801 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 6 | : | Tree | Private 2 | 2 | Width 5ft | 6020978.95351 | 2092836.83628 | 37.7277041785835 | -122.369687123669 | (37.7277041785835, -122.369687123669) | 10 | 3 | 8 | 58 | 1 | |||
| 37980 | 160320 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 550X Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2017 02:08:00 PM | 3 | Width 0ft | 6001986.11056 | 2089065.71241 | 37.7162891917808 | -122.435075983386 | (37.7162891917808, -122.435075983386) | 9 | 7 | 6 | 28861 | 5 | |
| 38885 | 160530 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 420X France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 04:06:00 PM | 3 | Width 0ft | 6002060.62403 | 2089797.75117 | 37.7183034384358 | -122.434870749998 | (37.7183034384358, -122.434870749998) | 9 | 7 | 6 | 28861 | 5 | |
| 42434 | 199627 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 468 Mississippi St | 3 | : | Tree | Private 2 | 6 | Width 4ft | 6014047.47282 | 2104941.97523 | 37.7605596235572 | -122.394496806394 | (37.7605596235572, -122.394496806394) | 10 | 3 | 8 | 28856 | 29 | |||
| 42850 | 199626 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 468 Mississippi St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6014046.30923 | 2104968.95995 | 37.7606336530377 | -122.394502720319 | (37.7606336530377, -122.394502720319) | 10 | 3 | 8 | 28856 | 29 | |||
| 43169 | 137603 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1908 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003944.0414 | 2115071.5133 | 37.7878060009026 | -122.430162615236 | (37.7878060009026, -122.430162615236) | 13 | 9 | 11 | 29490 | 27 | |||
| 47376 | 233893 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | |||
| 55719 | 201804 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 9 | : | Tree | Private 2 | 2 | Width 5ft | 6020904.74927 | 2092892.98725 | 37.7278542871344 | -122.369947531359 | (37.7278542871344, -122.369947531359) | 10 | 3 | 8 | 58 | 1 | |||
| 56207 | 216177 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1228 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5992086.21496 | 2107042.53503 | 37.7650818635682 | -122.470603081182 | (37.7650818635682, -122.470603081182) | 11 | 8 | 11 | 56 | 12 | |||
| 56589 | 201805 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 10 | : | Tree | Private 2 | 2 | Width 5ft | 6020879.60636 | 2092912.55986 | 37.727906650163 | -122.370035804318 | (37.727906650163, -122.370035804318) | 10 | 3 | 8 | 58 | 1 | |||
| 57817 | 199640 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014488.14989 | 2111355.44955 | 37.7781940941182 | -122.393421531993 | (37.7781940941182, -122.393421531993) | 6 | 2 | 9 | 28856 | 20 | |||
| 58908 | 253061 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 60168 | 124468 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 349 Willard St North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 5996256.01193 | 2110505.30551 | 37.7748299686549 | -122.456431281339 | (37.7748299686549, -122.456431281339) | 11 | 6 | 2 | 54 | 16 | |||
| 62584 | 181312 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 430 Wayland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010327.71055 | 2092289.14682 | 37.7256102097169 | -122.406470238016 | (37.7256102097169, -122.406470238016) | 10 | 3 | 7 | 309 | 28 | |||
| 63743 | 254860 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 200 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 4x4 | 5996231 | 2111172 | 37.7766591008184 | -122.456566025052 | (37.7766591008184, -122.456566025052) | 11 | 6 | 2 | 54 | 16 | ||
| 64498 | 256120 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 66266 | 199642 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014522.76224 | 2111389.3707 | 37.7782891569603 | -122.393304168653 | (37.7782891569603, -122.393304168653) | 6 | 2 | 9 | 28856 | 20 | |||
| 69124 | 160323 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 510X Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2017 01:57:00 PM | 3 | Width 0ft | 6001921.46763 | 2089105.50941 | 37.7163947946735 | -122.43530226539 | (37.7163947946735, -122.43530226539) | 9 | 7 | 6 | 28861 | 5 | |
| 77011 | 253060 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 79118 | 181314 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 430 Wayland St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010227.97211 | 2092261.34234 | 37.7255282841828 | -122.406813068576 | (37.7255282841828, -122.406813068576) | 10 | 3 | 7 | 309 | 28 | |||
| 84182 | 199645 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014649.6787 | 2111509.37371 | 37.7786257084513 | -122.392873512101 | (37.7786257084513, -122.392873512101) | 6 | 2 | 9 | 28856 | 20 | |||
| 85018 | 233894 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | |||
| 87606 | 199635 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014283.99479 | 2111159.66981 | 37.7776451821203 | -122.394114074719 | (37.7776451821203, -122.394114074719) | 6 | 2 | 9 | 28856 | 20 | |||
| 89306 | 201799 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 4 | : | Tree | Private 2 | 2 | Width 5ft | 6021051.90692 | 2092781.98164 | 37.7275575603158 | -122.36943113075 | (37.7275575603158, -122.36943113075) | 10 | 3 | 8 | 58 | 1 | |||
| 91106 | 113282 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1972 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6003575.525 | 2118663.6131 | 37.79764810977 | -122.431694175277 | (37.79764810977, -122.431694175277) | 13 | 9 | 1 | 57 | 17 | |||
| 95903 | 199644 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014634.85643 | 2111497.38858 | 37.7785919766832 | -122.392923949697 | (37.7785919766832, -122.392923949697) | 6 | 2 | 9 | 28856 | 20 | |||
| 96198 | 199633 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014252.55524 | 2111130.1519 | 37.7775623851211 | -122.3942207685 | (37.7775623851211, -122.3942207685) | 6 | 2 | 9 | 28856 | 20 | |||
| 99082 | 201802 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 7 | : | Tree | Private 2 | 2 | Width 5ft | 6020947.47999 | 2092859.07822 | 37.7277635239432 | -122.369797465976 | (37.7277635239432, -122.369797465976) | 10 | 3 | 8 | 58 | 1 | |||
| 106628 | 199631 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014129.99187 | 2111017.59935 | 37.7772465279418 | -122.394636875801 | (37.7772465279418, -122.394636875801) | 6 | 2 | 9 | 28856 | 20 | |||
| 109358 | 254808 | Undocumented 4 | Zelkova serrata :: Sawleaf Zelkova 302 | 478 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992861 | 2112216 | 37.7793315841081 | -122.468299710441 | (37.7793315841081, -122.468299710441) | 11 | 6 | 2 | 54 | 11 | |||
| 112305 | 160554 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:23:00 PM | 3 | Width 0ft | 6002263.49591 | 2089671.42563 | 37.717968092931 | -122.434160482543 | (37.717968092931, -122.434160482543) | 9 | 7 | 6 | 28861 | 5 | |
| 112673 | 256121 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 115846 | 256122 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 120149 | 253062 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 120550 | 160322 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 510X Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:36:00 AM | 3 | Width 0ft | 6001932.58063 | 2089099.82424 | 37.7163798155563 | -122.435263447059 | (37.7163798155563, -122.435263447059) | 9 | 7 | 6 | 28861 | 5 | |
| 123668 | 145626 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 607 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 3ft | 5994685.74842 | 2111370.98002 | 37.7771166082836 | -122.461925896856 | (37.7771166082836, -122.461925896856) | 11 | 6 | 2 | 54 | 11 | ||
| 129023 | 199638 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014451.54729 | 2111320.17279 | 37.7780951983723 | -122.393545685179 | (37.7780951983723, -122.393545685179) | 6 | 2 | 9 | 28856 | 20 | |||
| 129483 | 201796 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 1 | : | Tree | Private 2 | 2 | Width 5ft | 6021152.60745 | 2092710.04539 | 37.7273655604624 | -122.369078036218 | (37.7273655604624, -122.369078036218) | 10 | 3 | 8 | 58 | 1 | |||
| 130134 | 232279 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | |||
| 131826 | 201800 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 5 | : | Tree | Private 2 | 2 | Width 5ft | 6021019.25883 | 2092809.33244 | 37.7276308694498 | -122.36954588606 | (37.7276308694498, -122.36954588606) | 10 | 3 | 8 | 58 | 1 | |||
| 132887 | 181311 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 430 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010368.97076 | 2092305.11557 | 37.7256563647345 | -122.406328728795 | (37.7256563647345, -122.406328728795) | 10 | 3 | 7 | 309 | 28 | |||
| 137517 | 256123 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 1250X Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 142368 | 199634 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014272.81594 | 2111147.61079 | 37.7776114494388 | -122.394151901995 | (37.7776114494388, -122.394151901995) | 6 | 2 | 9 | 28856 | 20 | |||
| 146248 | 201803 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 8 | : | Tree | Private 2 | 2 | Width 5ft | 6020924.86388 | 2092877.32885 | 37.7278123958223 | -122.369876912084 | (37.7278123958223, -122.369876912084) | 10 | 3 | 8 | 58 | 1 | |||
| 147667 | 253058 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 149584 | 181313 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 430 Wayland St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010292.07983 | 2092280.20746 | 37.7255836707225 | -122.406592781424 | (37.7255836707225, -122.406592781424) | 10 | 3 | 7 | 309 | 28 | |||
| 150993 | 253063 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 156656 | 201806 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 11 | : | Tree | Private 2 | 2 | Width 5ft | 6020862.09511 | 2092930.70884 | 37.7279555229066 | -122.37009759585 | (37.7279555229066, -122.37009759585) | 10 | 3 | 8 | 58 | 1 | |||
| 156691 | 199630 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014102.18422 | 2110987.44931 | 37.7771621967072 | -122.394730960159 | (37.7771621967072, -122.394730960159) | 6 | 2 | 9 | 28856 | 20 | |||
| 158145 | 124469 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 349 Willard St North | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5996258.69708 | 2110482.63653 | 37.7747678797243 | -122.456420353351 | (37.7747678797243, -122.456420353351) | 11 | 6 | 2 | 54 | 16 | |||
| 158453 | 148023 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 553X Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:52:00 AM | 3 | Width 3ft | 6001969.85247 | 2089122.81989 | 37.7164450730519 | -122.435136261339 | (37.7164450730519, -122.435136261339) | 9 | 7 | 6 | 28861 | 5 | |
| 163126 | 55863 | Permitted Site 7 | Zelkova serrata :: Sawleaf Zelkova 302 | 261 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/1973 12:00:00 AM | 12 | 3x3 | Permit Number 11916 | 6005472.95954935 | 2102197.84365155 | 37.7525444734617 | -122.423957028973 | (37.7525444734617, -122.423957028973) | 2 | 4 | 5 | 28859 | 19 | |
| 163897 | 244019 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 57 Webster St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004283.82971 | 2108814.32965 | 37.770644560714 | -122.428540825916 | (37.770644560714, -122.428540825916) | 7 | 9 | 11 | 29492 | 10 | |||
| 170612 | 108429 | Permitted Site 7 | Zelkova serrata :: Sawleaf Zelkova 302 | 3008 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770760 | 6008202.71085 | 2103306.38942 | 37.7557420230473 | -122.414595491952 | (37.7557420230473, -122.414595491952) | 2 | 4 | 7 | 28859 | 19 |
| 173485 | 253064 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 178987 | 199643 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014542.45615 | 2111406.5622 | 37.7783374550557 | -122.393237242906 | (37.7783374550557, -122.393237242906) | 6 | 2 | 9 | 28856 | 20 | |||
| 186376 | 199629 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 498 Mississippi St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014051.43024 | 2104855.90282 | 37.7603235074489 | -122.39447709236 | (37.7603235074489, -122.39447709236) | 10 | 3 | 8 | 28856 | 29 | |||
| 186810 | 199641 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 251 Townsend St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014508.15812 | 2111374.30998 | 37.7782469922495 | -122.393353635873 | (37.7782469922495, -122.393353635873) | 6 | 2 | 9 | 28856 | 20 | |||
| 187368 | 160319 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 550X Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:39:00 AM | 3 | Width 0ft | 6002000.46438 | 2089057.15529 | 37.7162665108705 | -122.435025758047 | (37.7162665108705, -122.435025758047) | 9 | 7 | 6 | 28861 | 5 | |
| 187979 | 199628 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 468 Mississippi St | 4 | : | Tree | Private 2 | 6 | Width 4ft | 6014050.14145 | 2104918.93295 | 37.7604965028256 | -122.394485963261 | (37.7604965028256, -122.394485963261) | 10 | 3 | 8 | 28856 | 29 | |||
| 194413 | 265067 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 | |||
| 194414 | 160553 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 490 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:20:00 PM | 3 | Width 0ft | 6002152 | 2089716 | 37.7180841555313 | -122.434549060041 | (37.7180841555313, -122.434549060041) | 9 | 7 | 6 | 28861 | 5 | |
| 194420 | 265068 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 |
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) );