trees
267 rows where qSpecies_id = 100 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17754 | 19655 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 54 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18118 | 19603 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18480 | 19609 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
18517 | 19608 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18599 | 19604 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18738 | 19646 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18793 | 19631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18817 | 19689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 88 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18925 | 19645 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
19223 | 19615 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
19598 | 19633 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
17887 | 20041 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY51 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
176168 | 3760 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1062X Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 20 | 6012453.5755993 | 2103020.9691678 | 37.7551962258659 | -122.399874507795 | (37.7551962258659, -122.399874507795) | 10 | 3 | 8 | 28856 | 29 | ||||
112548 | 3763 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
167995 | 3761 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012458 | 2102979 | 37.7550812343514 | -122.399856259894 | (37.7550812343514, -122.399856259894) | 10 | 3 | 8 | 28856 | 29 | |||
173188 | 29631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1110X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | |||
134476 | 245149 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1192 Page St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000871.2374 | 2109327.7689 | 37.7718606240856 | -122.440381827143 | (37.7718606240856, -122.440381827143) | 15 | 5 | 11 | 29492 | 9 | |||
20775 | 186778 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5984835.1586 | 2106804.893 | 37.7640074057024 | -122.495664799754 | (37.7640074057024, -122.495664799754) | 1 | 8 | 3 | 56 | 35 | |||
60998 | 186736 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984872.7556 | 2106587.8007 | 37.76341353282 | -122.495518752014 | (37.76341353282, -122.495518752014) | 1 | 8 | 3 | 56 | 35 | |||
68327 | 186829 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 94 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984823.8588 | 2106586.1554 | 37.763406151967 | -122.495687746344 | (37.763406151967, -122.495687746344) | 1 | 8 | 3 | 56 | 35 | |||
85558 | 186783 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984862.3254 | 2106838.1239 | 37.7641002392741 | -122.49557329041 | (37.7641002392741, -122.49557329041) | 1 | 8 | 3 | 56 | 35 | |||
57780 | 12503 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
174020 | 12499 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
7553 | 20501 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1204 Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
64164 | 251362 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1300X Stanyan St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | ||||
93621 | 20546 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1303X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
151364 | 20534 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1303X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
169637 | 20525 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1303X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
9159 | 182059 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1358 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5986815.973 | 2106006.8659 | 37.7619320416514 | -122.48875517676 | (37.7619320416514, -122.48875517676) | 1 | 8 | 3 | 56 | 35 | |||
70928 | 182054 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1358 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 5986815.973 | 2106023.5284 | 37.7619777922823 | -122.48875640159 | (37.7619777922823, -122.48875640159) | 1 | 8 | 3 | 56 | 35 | |||
136225 | 186490 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Lower Great Hwy | 36 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5980883.265 | 2105397.7493 | 37.7599115788226 | -122.509228480711 | (37.7599115788226, -122.509228480711) | 1 | 8 | 3 | 56 | 35 | |||
38345 | 181498 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.653 | 2105433.8466 | 37.7602444476946 | -122.495472038545 | (37.7602444476946, -122.495472038545) | 1 | 8 | 3 | 56 | 35 | |||
130013 | 181474 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.5262 | 2105276.2272 | 37.7598138863622 | -122.495329430578 | (37.7598138863622, -122.495329430578) | 1 | 8 | 3 | 56 | 35 | |||
167992 | 181494 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984852.1847 | 2105397.6443 | 37.7601444918652 | -122.495502114318 | (37.7601444918652, -122.495502114318) | 1 | 8 | 3 | 56 | 35 | |||
16767 | 181422 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984930.7159 | 2104775.5208 | 37.758440912105 | -122.495184638383 | (37.758440912105, -122.495184638383) | 1 | 8 | 3 | 56 | 35 | |||
84766 | 181408 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984930.7159 | 2104693.9263 | 37.7582168762917 | -122.495178621433 | (37.7582168762917, -122.495178621433) | 1 | 8 | 3 | 56 | 35 | |||
148969 | 23882 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500X Webster St | 5 | Median : Cutout | Tree | DPW 1 | 20 | 12 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
154492 | 20647 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1501X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
26457 | 194520 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Bay Shore Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012006.62045 | 2091255.62525 | 37.7228661524341 | -122.400593779099 | (37.7228661524341, -122.400593779099) | 10 | 3 | 7 | 309 | 28 | |||
4432 | 181365 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Sunset Blvd | 92 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984912.4611 | 2104151.8757 | 37.7567274870678 | -122.495201781242 | (37.7567274870678, -122.495201781242) | 1 | 8 | 3 | 56 | 35 | |||
28797 | 106211 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1646 35TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 773238 | 5985355 | 2103995.9 | 37.7563251201532 | -122.493659849192 | (37.7563251201532, -122.493659849192) | 1 | 8 | 3 | 56 | 35 | ||||
48449 | 186134 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984955.6705 | 2103171.5067 | 37.754038194553 | -122.49498006395 | (37.754038194553, -122.49498006395) | 1 | 8 | 3 | 56 | 35 | |||
70195 | 186133 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984952.5547 | 2103165.275 | 37.7540209016237 | -122.494990379508 | (37.7540209016237, -122.494990379508) | 1 | 8 | 3 | 56 | 35 | |||
90455 | 186135 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984963.2871 | 2103177.7384 | 37.7540557509571 | -122.494954183766 | (37.7540557509571, -122.494954183766) | 1 | 8 | 3 | 56 | 35 | |||
139990 | 186132 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984975.4043 | 2103142.7715 | 37.753960450821 | -122.494909702152 | (37.753960450821, -122.494909702152) | 1 | 8 | 3 | 56 | 35 | |||
152496 | 186156 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984977.8278 | 2103337.3397 | 37.7544948232836 | -122.49491566635 | (37.7544948232836, -122.49491566635) | 1 | 8 | 3 | 56 | 35 | |||
15419 | 23925 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700X Webster St | 7 | Median : Cutout | Tree | DPW 1 | 60 | 12x1 | 6003454.8844904 | 2114845.825423 | 37.7871586020093 | -122.431838884639 | (37.7871586020093, -122.431838884639) | 13 | 9 | 11 | 29490 | 27 | |||
40408 | 20784 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1701X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
99835 | 20781 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1701X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
113538 | 11196 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
151588 | 11197 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
35285 | 110616 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 182X LOWER TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999820 | 2106230 | 37.7632950157782 | -122.44379552503 | (37.7632950157782, -122.44379552503) | 15 | 5 | 5 | 29492 | 3 | |||||
97021 | 105907 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 1837 30TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 5986904 | 2102674 | 37.7527860393128 | -122.488205804709 | (37.7527860393128, -122.488205804709) | 1 | 8 | 3 | 56 | 35 | ||||
96144 | 186012 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1900 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985010.9219 | 2101736.8552 | 37.750102270029 | -122.494683232466 | (37.750102270029, -122.494683232466) | 1 | 8 | 3 | 29491 | 35 | |||
15464 | 262332 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1X Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999654 | 2101769 | 37.7510367373071 | -122.444049107076 | (37.7510367373071, -122.444049107076) | 2 | 5 | 5 | 63 | 38 | ||||
130182 | 185865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2000 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985059.0462 | 2100990.2907 | 37.7480552245721 | -122.494461791049 | (37.7480552245721, -122.494461791049) | 1 | 8 | 3 | 29491 | 35 | |||
21989 | 187401 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2100 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985066.4729 | 2100733.1142 | 37.747349522643 | -122.494417155333 | (37.747349522643, -122.494417155333) | 1 | 8 | 3 | 29491 | 35 | |||
84533 | 185510 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2200 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985082.4009 | 2099946.5475 | 37.7451907564521 | -122.494304109241 | (37.7451907564521, -122.494304109241) | 1 | 8 | 3 | 29491 | 35 | |||
168059 | 187335 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2200 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985078.6769 | 2099672.3252 | 37.744437598438 | -122.49429677682 | (37.744437598438, -122.49429677682) | 1 | 8 | 3 | 29491 | 35 | |||
129083 | 185537 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2201 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984862.7264 | 2100065.7068 | 37.7455050775816 | -122.495072479787 | (37.7455050775816, -122.495072479787) | 1 | 8 | 3 | 29491 | 35 | |||
90517 | 249887 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 230 Greenwich St | 23 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011491.95227 | 2120439.55706 | 37.8029699659421 | -122.404426114084 | (37.8029699659421, -122.404426114084) | 3 | 1 | 10 | 28860 | 6 | |||
91858 | 234491 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 24 Saturn St | 5 | Side Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6000385.28479 | 2106021.72649 | 37.7627553749804 | -122.44182544749 | (37.7627553749804, -122.44182544749) | 15 | 5 | 5 | 28862 | 3 | |||
45981 | 185462 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985138.3382 | 2098374.943 | 37.740878828405 | -122.493994886454 | (37.740878828405, -122.493994886454) | 1 | 8 | 3 | 29491 | 35 | |||
183847 | 185496 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 50 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985141.6583 | 2098649.8553 | 37.7416338578085 | -122.494003662835 | (37.7416338578085, -122.494003662835) | 1 | 8 | 3 | 29491 | 35 | |||
130886 | 187232 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984921.2891 | 2098611.514 | 37.7415156862998 | -122.494762787921 | (37.7415156862998, -122.494762787921) | 1 | 8 | 3 | 29491 | 35 | |||
151873 | 187220 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5984921.2891 | 2098780.6261 | 37.7419800224632 | -122.494775253241 | (37.7419800224632, -122.494775253241) | 1 | 8 | 3 | 29491 | 35 | |||
169924 | 187279 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 62 | Median : Yard | Tree | DPW 1 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | 1 | 8 | 3 | 29491 | 35 | |||
43322 | 21267 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2492X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
135364 | 185161 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985124.0613 | 2097656.7845 | 37.7389061227579 | -122.493991335448 | (37.7389061227579, -122.493991335448) | 1 | 8 | 3 | 29491 | 35 | |||
161472 | 185163 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985155.9352 | 2097682.682 | 37.7389790952829 | -122.493883039881 | (37.7389790952829, -122.493883039881) | 1 | 8 | 3 | 29491 | 35 | |||
185727 | 185166 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985143.9825 | 2097713.2278 | 37.7390622665176 | -122.493926616722 | (37.7390622665176, -122.493926616722) | 1 | 8 | 3 | 29491 | 35 | |||
193255 | 185171 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985156.5992 | 2097759.0465 | 37.7391888105651 | -122.493886370266 | (37.7391888105651, -122.493886370266) | 1 | 8 | 3 | 29491 | 35 | |||
97619 | 187039 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2501 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.4301 | 2097783.6094 | 37.7392440133349 | -122.494611382457 | (37.7392440133349, -122.494611382457) | 1 | 8 | 3 | 29491 | 35 | |||
193841 | 211046 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 251 Wildwood Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5995705.57302 | 2093291.07499 | 37.7275324053909 | -122.457089894179 | (37.7275324053909, -122.457089894179) | 9 | 7 | 4 | 28861 | 40 | |||
175429 | 187119 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2600 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985168.1593 | 2097316.6584 | 37.7379748077492 | -122.493813809362 | (37.7379748077492, -122.493813809362) | 1 | 8 | 3 | 29491 | 35 | |||
985 | 262391 | Private 9 | Pinus Spp :: Pine Spp 100 | 2646 38th Ave | 1 | Back Yard : Yard | Tree | Private 2 | Width 0ft | 5984657 | 2097167 | 37.7375339667511 | -122.495570077384 | (37.7375339667511, -122.495570077384) | 1 | 8 | 3 | 29491 | 35 | ||||
45445 | 21490 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2792X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
3185 | 141534 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996778.1712 | 2111479.8816 | 37.7775358625794 | -122.454695458772 | (37.7775358625794, -122.454695458772) | 15 | 6 | 2 | 54 | 16 | |||
4649 | 141530 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996711.9256 | 2111472.0638 | 37.7775105970069 | -122.454924058113 | (37.7775105970069, -122.454924058113) | 15 | 6 | 2 | 54 | 16 | |||
70203 | 141487 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5996890.9122 | 2111495.5172 | 37.7775852598057 | -122.45430658183 | (37.7775852598057, -122.45430658183) | 15 | 6 | 2 | 54 | 16 | |||
83939 | 141495 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5996998.9899 | 2111511.9757 | 37.7776366478442 | -122.45393389566 | (37.7776366478442, -122.45393389566) | 15 | 6 | 2 | 54 | 16 | |||
85674 | 141489 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 5996912.3083 | 2111498.8089 | 37.777595524924 | -122.45423280375 | (37.777595524924, -122.45423280375) | 15 | 6 | 2 | 54 | 16 | |||
113118 | 141491 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5996944.1281 | 2111502.1006 | 37.7776063877102 | -122.454122966753 | (37.7776063877102, -122.454122966753) | 15 | 6 | 2 | 54 | 16 | |||
133753 | 141484 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996823.7065 | 2111503.4721 | 37.7776032476224 | -122.454539642462 | (37.7776032476224, -122.454539642462) | 15 | 6 | 2 | 54 | 16 | |||
135916 | 141536 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996809.4424 | 2111483.7219 | 37.7775482006436 | -122.454587559354 | (37.7775482006436, -122.454587559354) | 15 | 6 | 2 | 54 | 16 | |||
144141 | 141485 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996846.7484 | 2111491.4026 | 37.7775714294456 | -122.454459061112 | (37.7775714294456, -122.454459061112) | 15 | 6 | 2 | 54 | 16 | |||
193417 | 141493 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996968.2673 | 2111507.0382 | 37.7776213292106 | -122.45403981827 | (37.7776213292106, -122.45403981827) | 15 | 6 | 2 | 54 | 16 | |||
175590 | 110271 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 298X 28TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004269 | 2099559 | 37.7452307768148 | -122.427932506483 | (37.7452307768148, -122.427932506483) | 2 | 7 | 5 | 63 | 22 | ||||
54825 | 110699 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
60871 | 110703 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
61835 | 110697 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
80145 | 110707 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
93191 | 110709 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
99587 | 110713 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
116302 | 110705 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
154648 | 110701 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
165349 | 110711 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
107393 | 98343 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999x Turk St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/01/2012 12:00:00 AM | 5x3 | Permit Number 768613 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||
101304 | 24281 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 19 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
192604 | 24284 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 22 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 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) );