trees
267 rows where qSpecies_id = 100 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
68559 | 91429 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
63239 | 93054 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 49 | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | ||
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 | ||||
61690 | 106324 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 800 INDIANA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | ||||
59834 | 253717 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4101 Balboa St | 1 | Back Yard : Yard | Tree | Private 2 | 01/08/2018 12:00:00 AM | 3 | Permit Number 780863 | 5982822 | 2110967 | 37.7753172554615 | -122.50293574331 | (37.7753172554615, -122.50293574331) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
57396 | 106550 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 81 MINERVA ST | Median : Cutout | Tree | DPW 1 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | 9 | 8 | 6 | 28861 | 24 | ||||||
56024 | 105231 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6000051 | 2106345 | 37.7636239504047 | -122.443004833609 | (37.7636239504047, -122.443004833609) | 15 | 5 | 5 | 29492 | 3 | ||||
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 | ||||
52821 | 91428 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 3 | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | ||
50522 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
37573 | 141619 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 31 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998404.7923 | 2110908.8953 | 37.7760612473543 | -122.449027315104 | (37.7760612473543, -122.449027315104) | 15 | 6 | 2 | 29492 | 16 | |||
35747 | 93927 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | |||
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 | |||||
35177 | 13405 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 362 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999656.8275613 | 2097385.3812268 | 37.7390005339934 | -122.443724438614 | (37.7390005339934, -122.443724438614) | 9 | 7 | 4 | 59 | 40 | |||
28928 | 116154 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 324 POPE ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000502 | 2087202 | 37.7110874704678 | -122.440072212787 | (37.7110874704678, -122.440072212787) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||||
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 | |||
25634 | 211049 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 50 Garcia Ave | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5994782.37935 | 2099248.26832 | 37.7438363316793 | -122.460712887715 | (37.7438363316793, -122.460712887715) | 1 | 8 | 4 | 59 | 40 | |||
25415 | 132165 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 3075 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000074.17402 | 2115752.57218 | 37.7894560684958 | -122.443600532065 | (37.7894560684958, -122.443600532065) | 13 | 6 | 1 | 29490 | 27 | |||
22262 | 23613 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 900X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 30X30PL | 6011293.8960822 | 2104150.9045186 | 37.7582340578883 | -122.40396455427 | (37.7582340578883, -122.40396455427) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | |||
19598 | 19633 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
19429 | 19994 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
19337 | 20012 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
19228 | 19750 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
19223 | 19615 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18925 | 19645 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
18853 | 262082 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
18817 | 19689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 88 | 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 | |||||||||||||
18738 | 19646 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18658 | 19704 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
18599 | 19604 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
18517 | 19608 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 7 | 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 | |||||||||||||
18475 | 19731 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
18118 | 19603 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17887 | 20041 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY51 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
17754 | 19655 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 54 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
17668 | 19627 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17616 | 19684 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 83 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
17497 | 19970 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY44 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
17410 | 19681 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 80 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16896 | 19981 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
16876 | 19738 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
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 | |||
16746 | 19862 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
16706 | 19652 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16655 | 19861 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
16380 | 19763 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY16 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
16278 | 19717 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
16250 | 19688 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 87 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16095 | 19616 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
16026 | 19673 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 72 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
15815 | 19739 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
15775 | 19733 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
15745 | 19847 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY26 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
15694 | 19654 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 53 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
15658 | 19658 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 57 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
15491 | 19647 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
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 | ||||
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 | |||
15362 | 20010 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
15132 | 19718 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
14796 | 19621 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
14700 | 19670 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 69 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
14227 | 19634 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
13846 | 262084 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
13544 | 19716 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
13490 | 19614 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
13154 | 19625 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
13138 | 19607 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
12562 | 262087 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
12300 | 93053 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | ||||||||||||||
11958 | 262083 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
11844 | 262089 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
11608 | 20009 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
11434 | 19648 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
11194 | 19644 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 43 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
11089 | 19690 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 89 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
10838 | 233336 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 5545 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6001777.47587 | 2097325.41548 | 37.7389566084644 | -122.436387932367 | (37.7389566084644, -122.436387932367) | 2 | 7 | 5 | 63 | 7 | |||
10714 | 19791 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY19 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 20ST | |||||||||||||
10472 | 19659 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 58 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
10384 | 19679 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 78 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
10352 | 19743 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | -8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
9917 | 19611 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 |
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) );