trees
1,650 rows where qSpecies_id = 64 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7959 | 205335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 134 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5991702.38493 | 2089452.42364 | 37.7167617027762 | -122.470649341406 | (37.7167617027762, -122.470649341406) | 9 | 8 | 6 | 64 | 24 | |||
32942 | 175920 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3014 22nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5989746.7412 | 2095193.88172 | 37.7324130198412 | -122.477828433236 | (37.7324130198412, -122.477828433236) | 1 | 8 | 4 | 64 | 35 | |||
39300 | 205340 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 494 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993277.92087 | 2090411.70077 | 37.719486628792 | -122.465273175336 | (37.719486628792, -122.465273175336) | 9 | 8 | 6 | 64 | 24 | |||
43673 | 50397 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 126 Springfield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 3 | Permit Number 47048 | 5986815.96523 | 2095005.27155 | 37.7317246157805 | -122.487946825187 | (37.7317246157805, -122.487946825187) | 1 | 8 | 4 | 64 | 35 | |
45696 | 24382 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1450 Holloway Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5X5 | 5990869.8996566 | 2091172.9547398 | 37.7214376817414 | -122.473652239882 | (37.7214376817414, -122.473652239882) | 9 | 8 | 4 | 64 | 40 | |||
75895 | 217790 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 151 Sloat Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5990892.29341 | 2095922.4867 | 37.7344800027407 | -122.473921168543 | (37.7344800027407, -122.473921168543) | 1 | 8 | 4 | 64 | 40 | ||||
79966 | 205336 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992219.92484 | 2089237.66093 | 37.7162019305526 | -122.468844858021 | (37.7162019305526, -122.468844858021) | 9 | 8 | 6 | 64 | 24 | |||
84130 | 109272 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 93X Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769587 | 5988310.67762 | 2095565.25326 | 37.7333492603097 | -122.482820388184 | (37.7333492603097, -122.482820388184) | 1 | 8 | 4 | 64 | 35 |
100632 | 205337 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992219.91923 | 2089255.52232 | 37.7162509732747 | -122.468846176429 | (37.7162509732747, -122.468846176429) | 9 | 8 | 6 | 64 | 24 | |||
106240 | 122625 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222 | 2094938 | 37.7313882480876 | -122.496909587532 | (37.7313882480876, -122.496909587532) | 1 | 8 | 4 | 64 | 35 | |
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
125522 | 205339 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992450.82232 | 2090054.78249 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | 9 | 8 | 6 | 64 | 24 | |||
129431 | 205342 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Junipero Serra Blvd | 16 | : | Tree | Private 2 | 3 | Width 0ft | 5991388.30508 | 2094512.69184 | 37.7306377788136 | -122.47210358291 | (37.7306377788136, -122.47210358291) | 9 | 8 | 4 | 64 | 40 | |||
136799 | 102061 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 5992454 | 2090050 | 37.7184459373178 | -122.468094845853 | (37.7184459373178, -122.468094845853) | 9 | 8 | 6 | 64 | 24 | |||
145937 | 205338 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Ralston St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992219.15057 | 2089273.39944 | 37.7163000151028 | -122.468850133429 | (37.7163000151028, -122.468850133429) | 9 | 8 | 6 | 64 | 24 | |||
157471 | 205341 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1400 Holloway Ave | 5 | : | Tree | Private 2 | 3 | Width 0ft | 5990799.69787 | 2091134.9811 | 37.7213293495637 | -122.47389213663 | (37.7213293495637, -122.47389213663) | 9 | 8 | 4 | 64 | 40 | |||
173517 | 205343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Junipero Serra Blvd | 33 | : | Tree | Private 2 | 9 | Width 0ft | 5991382.87064 | 2094419.86575 | 37.7303825871646 | -122.472115606868 | (37.7303825871646, -122.472115606868) | 9 | 8 | 4 | 64 | 40 | |||
175475 | 175921 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3014 22nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5989750.67751 | 2095205.86942 | 37.7324461634578 | -122.477815700639 | (37.7324461634578, -122.477815700639) | 1 | 8 | 4 | 64 | 35 | |||
178269 | 122626 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613 | 2095517 | 37.7330009316807 | -122.495600537949 | (37.7330009316807, -122.495600537949) | 1 | 8 | 4 | 64 | 35 | |
2481 | 245485 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1300 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 4 | Width 5ft | 6003516.63487 | 2095667.30987 | 37.7345024965788 | -122.430256461687 | (37.7345024965788, -122.430256461687) | 2 | 7 | 5 | 63 | 7 | |||
2492 | 205476 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999461.7393 | 2093534.48294 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | 9 | 7 | 4 | 63 | 40 | ||||
4511 | 245571 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4220 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6002399.35344 | 2100348.21593 | 37.7472918291588 | -122.43445383688 | (37.7472918291588, -122.43445383688) | 2 | 4 | 5 | 63 | 22 | ||||
7266 | 245758 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 220 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 2ft | 6004895.76368 | 2096843.93184 | 37.7378112552963 | -122.425572065806 | (37.7378112552963, -122.425572065806) | 2 | 7 | 5 | 63 | 7 | |||
8032 | 245760 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 127 Farnum St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002444.1806 | 2097361.0891 | 37.7390924204823 | -122.43408532709 | (37.7390924204823, -122.43408532709) | 2 | 7 | 5 | 63 | 7 | |||
10829 | 245757 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1884 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004576.62382 | 2097711.65254 | 37.7401757815964 | -122.426737263435 | (37.7401757815964, -122.426737263435) | 2 | 7 | 5 | 63 | 7 | |||
11153 | 205453 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 142 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6001121.86387 | 2094702.03359 | 37.7317161369712 | -122.438466824999 | (37.7317161369712, -122.438466824999) | 9 | 7 | 4 | 63 | 40 | |||
11234 | 205417 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000139.85205 | 2095251.72944 | 37.7331695655238 | -122.441901267552 | (37.7331695655238, -122.441901267552) | 9 | 7 | 5 | 63 | 40 | ||||
13700 | 104171 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6002306 | 2096613 | 37.7370304975493 | -122.434509617625 | (37.7370304975493, -122.434509617625) | 2 | 7 | 5 | 63 | 7 | |||
14709 | 5008 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 25 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
15107 | 245765 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 205 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6003079.9408 | 2097633.46199 | 37.7398763550104 | -122.431906602506 | (37.7398763550104, -122.431906602506) | 2 | 7 | 5 | 63 | 7 | |||
16372 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
18575 | 245781 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 6 | Back Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.430095602638 | (37.7377545179491, -122.430095602638) | 2 | 7 | 5 | 63 | 7 | |||
20448 | 245794 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6002837.91517 | 2098354.25557 | 37.7418417639992 | -122.432794903371 | (37.7418417639992, -122.432794903371) | 2 | 7 | 5 | 63 | 7 | ||||
20608 | 205456 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 265 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6000331.96286 | 2094928.67856 | 37.7322934882457 | -122.441213920209 | (37.7322934882457, -122.441213920209) | 9 | 7 | 4 | 63 | 40 | ||||
20997 | 245569 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 661 27th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 5ft | 6002237.36498 | 2100017.36446 | 37.7463741924229 | -122.434990322071 | (37.7463741924229, -122.434990322071) | 2 | 7 | 5 | 63 | 22 | |||
21169 | 247802 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 464 30th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6003596.41299 | 2098374.599 | 37.7419406120734 | -122.43017371776 | (37.7419406120734, -122.43017371776) | 2 | 7 | 5 | 63 | 22 | |||
22602 | 205411 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001323.45002 | 2094964.81551 | 37.7324491402005 | -122.43778871637 | (37.7324491402005, -122.43778871637) | 9 | 7 | 5 | 63 | 40 | |||
24800 | 245572 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 560 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 2ft | 6002734.90719 | 2100089.37623 | 37.74660015789 | -122.43327502534 | (37.74660015789, -122.43327502534) | 2 | 7 | 5 | 63 | 22 | |||
25452 | 205454 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 90 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6001505.95732 | 2094694.47331 | 37.7317172188577 | -122.437138397743 | (37.7317172188577, -122.437138397743) | 9 | 7 | 4 | 63 | 40 | |||
26166 | 245779 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 4 | Back Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6003578.06847 | 2096849.22804 | 37.73775125431 | -122.430128354157 | (37.73775125431, -122.430128354157) | 2 | 7 | 5 | 63 | 7 | |||
28221 | 205479 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 442 Circular Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 1ft | 5999762.58283 | 2093713.70132 | 37.7289249938854 | -122.443095165226 | (37.7289249938854, -122.443095165226) | 9 | 7 | 4 | 63 | 40 | |||
29943 | 245759 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 95 Thor Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002384.19841 | 2095793.19336 | 37.7347839358309 | -122.43418066153 | (37.7347839358309, -122.43418066153) | 2 | 7 | 5 | 63 | 7 | |||
30038 | 245598 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 205 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001673.40182 | 2096391.59136 | 37.7363866302454 | -122.436680945886 | (37.7363866302454, -122.436680945886) | 2 | 7 | 5 | 63 | 7 | |||
32663 | 111520 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800x BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 7 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
35773 | 205424 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 60 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999723.88526 | 2095534.65896 | 37.7339227117545 | -122.443359687323 | (37.7339227117545, -122.443359687323) | 9 | 7 | 4 | 63 | 40 | ||||
37010 | 5006 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 23 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
37258 | 205471 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999482.0353 | 2093535.39464 | 37.7284194049318 | -122.444052228249 | (37.7284194049318, -122.444052228249) | 9 | 7 | 4 | 63 | 40 | ||||
40396 | 205472 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999475.13727 | 2093536.59194 | 37.7284222989294 | -122.444076160988 | (37.7284222989294, -122.444076160988) | 9 | 7 | 4 | 63 | 40 | ||||
43426 | 245762 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 159 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004015.75468 | 2097400.41053 | 37.7392894556549 | -122.428654341035 | (37.7392894556549, -122.428654341035) | 2 | 7 | 5 | 63 | 7 | |||
44149 | 245786 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 13 | Back Yard : Yard | Tree | Private 2 | 2 | Width 3ft | 6003641.81586 | 2096850.294 | 37.7377577914922 | -122.429908024732 | (37.7377577914922, -122.429908024732) | 2 | 7 | 5 | 63 | 7 | |||
44248 | 205475 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | 9 | 7 | 4 | 63 | 40 | ||||
45288 | 205291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999811.4073 | 2095793.29434 | 37.7346378544461 | -122.44307566613 | (37.7346378544461, -122.44307566613) | 9 | 7 | 4 | 63 | 40 | ||||
47263 | 205314 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 181 Flood Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999549.00405 | 2094056.66941 | 37.7298545241666 | -122.443858150951 | (37.7298545241666, -122.443858150951) | 9 | 7 | 4 | 63 | 40 | |||
47516 | 205406 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 32 Malta Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999669.04162 | 2095969.46691 | 37.735113464498 | -122.443580522123 | (37.735113464498, -122.443580522123) | 9 | 7 | 4 | 63 | 40 | |||
47730 | 245507 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 107 Valley St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6005153.22882 | 2099293.31694 | 37.7445512558411 | -122.424856092128 | (37.7445512558411, -122.424856092128) | 2 | 7 | 5 | 63 | 22 | |||
48128 | 205293 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999807.52736 | 2095794.02146 | 37.7346396297213 | -122.443089132554 | (37.7346396297213, -122.443089132554) | 9 | 7 | 4 | 63 | 40 | ||||
48459 | 245795 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6002841.82377 | 2098354.17483 | 37.7418417639849 | -122.432781382956 | (37.7418417639849, -122.432781382956) | 2 | 7 | 5 | 63 | 7 | ||||
50552 | 205436 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 374 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999594.80251 | 2094992.93753 | 37.7324279099011 | -122.443767058604 | (37.7324279099011, -122.443767058604) | 9 | 7 | 4 | 63 | 40 | ||||
51371 | 205474 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999468.48436 | 2093527.67559 | 37.7283974371761 | -122.444098519924 | (37.7283974371761, -122.444098519924) | 9 | 7 | 4 | 63 | 40 | ||||
52136 | 245772 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 395 Addison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002120.14451 | 2097689.53055 | 37.7399758488049 | -122.435229181078 | (37.7399758488049, -122.435229181078) | 2 | 7 | 5 | 63 | 7 | ||||
54827 | 205439 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 378 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999592.52385 | 2094994.83149 | 37.7324329803013 | -122.44377507246 | (37.7324329803013, -122.44377507246) | 9 | 7 | 4 | 63 | 40 | ||||
55718 | 245784 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 11 | Back Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6003626.79774 | 2096849.74169 | 37.7377554244689 | -122.429959910226 | (37.7377554244689, -122.429959910226) | 2 | 7 | 5 | 63 | 7 | |||
56221 | 245789 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 13 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 23 | Width 2ft | 6002510.68516 | 2096313.64967 | 37.7362201675144 | -122.433780540537 | (37.7362201675144, -122.433780540537) | 2 | 7 | 5 | 63 | 7 | |||
58430 | 205422 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 60 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999723.9083 | 2095525.77356 | 37.7338983158454 | -122.443358969664 | (37.7338983158454, -122.443358969664) | 9 | 7 | 4 | 63 | 40 | ||||
58954 | 205415 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 123 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6000595.31695 | 2095195.58235 | 37.7330413419753 | -122.440322581444 | (37.7330413419753, -122.440322581444) | 9 | 7 | 5 | 63 | 40 | |||
59295 | 246506 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Duncan St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6004876.60593 | 2099863.49377 | 37.7461012023225 | -122.425853176806 | (37.7461012023225, -122.425853176806) | 2 | 7 | 5 | 63 | 22 | |||
59902 | 205290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999811.98894 | 2095790.05019 | 37.7346289799358 | -122.443073422301 | (37.7346289799358, -122.443073422301) | 9 | 7 | 4 | 63 | 40 | ||||
61124 | 245787 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 26 Harry St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 61 | 6003360.59602 | 2097764.52803 | 37.7402521385234 | -122.430945566306 | (37.7402521385234, -122.430945566306) | 2 | 7 | 5 | 63 | 7 | ||||
61327 | 245790 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 6002818.16213 | 2098366.55064 | 37.7418744030785 | -122.432864081016 | (37.7418744030785, -122.432864081016) | 2 | 7 | 5 | 63 | 7 | ||||
65170 | 205312 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 181 Flood Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999534.41289 | 2094056.98006 | 37.7298545448397 | -122.443908616415 | (37.7298545448397, -122.443908616415) | 9 | 7 | 4 | 63 | 40 | |||
66664 | 205420 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 714 Detroit St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 5999461.80443 | 2095388.23948 | 37.7335057294051 | -122.444255259197 | (37.7335057294051, -122.444255259197) | 9 | 7 | 4 | 63 | 40 | ||||
67072 | 205440 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 379 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999567.52836 | 2094943.67919 | 37.7322911023429 | -122.443857813682 | (37.7322911023429, -122.443857813682) | 9 | 7 | 4 | 63 | 40 | |||
68010 | 112569 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | |||
68809 | 205409 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 47 Chilton Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001682.76522 | 2095616.45632 | 37.7342588207884 | -122.436593107305 | (37.7342588207884, -122.436593107305) | 2 | 7 | 5 | 63 | 7 | ||||
69417 | 245573 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4185 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002743.42438 | 2100624.89778 | 37.7480710575441 | -122.433283833306 | (37.7480710575441, -122.433283833306) | 2 | 4 | 5 | 63 | 22 | |||
69856 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
70082 | 4979 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5200X Diamond Heights Blvd | 15 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | 2 | 7 | 5 | 63 | 7 | |||
71187 | 34375 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38127 | 6003918.97921609 | 2097483.80532691 | 37.7395129612854 | -122.428994891637 | (37.7395129612854, -122.428994891637) | 2 | 7 | 5 | 63 | 7 | ||
71216 | 205463 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 15 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5999770.24312 | 2093744.34025 | 37.7290095580429 | -122.443070882641 | (37.7290095580429, -122.443070882641) | 9 | 7 | 4 | 63 | 40 | |||
71889 | 205313 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 181 Flood Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999537.95675 | 2094057.33092 | 37.729855710368 | -122.443896390122 | (37.729855710368, -122.443896390122) | 9 | 7 | 4 | 63 | 40 | |||
72217 | 205421 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 282 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 5999548.9945 | 2095253.80985 | 37.7331415912064 | -122.443944163916 | (37.7331415912064, -122.443944163916) | 9 | 7 | 4 | 63 | 40 | |||
74512 | 245780 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 8ft | 6003583.61188 | 2096848.84807 | 37.7377505249636 | -122.430109160821 | (37.7377505249636, -122.430109160821) | 2 | 7 | 5 | 63 | 7 | |||
74625 | 205455 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 289 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6000185.64088 | 2094930.36706 | 37.7322897884487 | -122.441719908454 | (37.7322897884487, -122.441719908454) | 9 | 7 | 4 | 63 | 40 | |||
75047 | 205428 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 814 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 8ft | 5999472.09449 | 2095611.63443 | 37.7341197064634 | -122.444235731314 | (37.7341197064634, -122.444235731314) | 9 | 7 | 4 | 63 | 40 | |||
75297 | 205298 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Malta Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999812.06698 | 2095809.44133 | 37.7346822279016 | -122.443074544651 | (37.7346822279016, -122.443074544651) | 9 | 7 | 4 | 63 | 40 | |||
75790 | 205296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Malta Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999813.31551 | 2095822.66696 | 37.7347186135631 | -122.443071177587 | (37.7347186135631, -122.443071177587) | 9 | 7 | 4 | 63 | 40 | |||
77020 | 205307 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Hearst Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5999754.48593 | 2094339.62957 | 37.7306431855247 | -122.443168093056 | (37.7306431855247, -122.443168093056) | 9 | 7 | 4 | 63 | 40 | |||
77967 | 205292 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999809.50087 | 2095795.27324 | 37.7346431793405 | -122.443082399355 | (37.7346431793405, -122.443082399355) | 9 | 7 | 4 | 63 | 40 | ||||
78629 | 245570 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 635 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002354.60495 | 2100026.86043 | 37.7464069223436 | -122.434585599273 | (37.7464069223436, -122.434585599273) | 2 | 7 | 5 | 63 | 22 | |||
80080 | 205478 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 442 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999784.33637 | 2093736.40435 | 37.7289885714569 | -122.44302159167 | (37.7289885714569, -122.44302159167) | 9 | 7 | 4 | 63 | 40 | ||||
80647 | 245776 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 339 Addison St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6002249.41782 | 2097701.04161 | 37.7400147957413 | -122.434783031019 | (37.7400147957413, -122.434783031019) | 2 | 7 | 5 | 63 | 7 | |||
80966 | 203654 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 42 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001070.39767 | 2095226.13763 | 37.7331522778487 | -122.438682294452 | (37.7331522778487, -122.438682294452) | 9 | 7 | 5 | 63 | 40 | ||
82571 | 245770 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 50 Digby St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002871.37625 | 2097642.58356 | 37.7398895750355 | -122.43262838222 | (37.7398895750355, -122.43262838222) | 2 | 7 | 5 | 63 | 7 | |||
82618 | 245769 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 50 Digby St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002874.10892 | 2097638.15263 | 37.739877563697 | -122.432618617374 | (37.739877563697, -122.432618617374) | 2 | 7 | 5 | 63 | 7 | |||
82699 | 205426 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 90 Melrose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 5999557.07896 | 2095525.51979 | 37.7338881040446 | -122.443935729149 | (37.7338881040446, -122.443935729149) | 9 | 7 | 4 | 63 | 40 | |||
82783 | 245785 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 12 | Back Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6003634.59217 | 2096849.86817 | 37.7377562131711 | -122.429932970144 | (37.7377562131711, -122.429932970144) | 2 | 7 | 5 | 63 | 7 | |||
84091 | 245792 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6002825.04242 | 2098363.5292 | 37.7418664971384 | -122.432840075435 | (37.7418664971384, -122.432840075435) | 2 | 7 | 5 | 63 | 7 | ||||
84971 | 245778 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Width 8ft | 6003567.00592 | 2096851.64348 | 37.7377572599929 | -122.430166774989 | (37.7377572599929, -122.430166774989) | 2 | 7 | 5 | 63 | 7 | |||
85225 | 208852 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.01163 | 37.7331461732542 | -122.438531429591 | (37.7331461732542, -122.438531429591) | 9 | 7 | 5 | 63 | 40 | ||
85495 | 245788 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 59 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 8 | Width 2ft | 6002650.36065 | 2096519.59952 | 37.7367935833586 | -122.433312337306 | (37.7367935833586, -122.433312337306) | 2 | 7 | 5 | 63 | 7 |
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) );