trees
267 rows where qSpecies_id = 100 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | ||||||||||||||
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 | |||
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 | ||
93834 | 87762 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 747 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50415 | 6012202 | 2113577 | 37.7841666723804 | -122.401486377799 | (37.7841666723804, -122.401486377799) | 6 | 2 | 9 | 28853 | 34 | ||
137765 | 100745 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 760 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | ||||
162240 | 93928 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 3 | 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 | |||
167459 | 107680 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 330 Seacliff Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
177628 | 93925 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 3711 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 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 | |||||
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 | |||||
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 | ||
72516 | 258223 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 53 Starr King Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | Permit Number 782966 | 6005764 | 2113984 | 37.784922869937 | -122.423788535241 | (37.784922869937, -122.423788535241) | 13 | 9 | 11 | 28858 | 41 | |||
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 | ||||
103685 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824 | 2095658 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | 9 | 8 | 4 | 59 | 40 | ||
105498 | 93932 | 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 | |||||
113217 | 255048 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 45 Eagle St | 3 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575 | (37.7581277146448, -122.44262619575) | 2 | 4 | 5 | 28862 | 3 | ||||
171763 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4849X 19th St | Front Yard : Yard | Tree | Private 2 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
98050 | 110259 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 655 SANCHEZ ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003729.2 | 2104438 | 37.7585968119418 | -122.430147043342 | (37.7585968119418, -122.430147043342) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | ||
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 | ||||
125688 | 117419 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 452 OAK ST | 1 | Front Yard : Yard | Tree | Private 2 | 6004802 | 2110240 | 37.774588415373 | -122.426850015779 | (37.774588415373, -122.426850015779) | 7 | 9 | 11 | 28852 | 10 | |||||
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 | ||||
167631 | 112904 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 727 BURNETT AVE | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999303 | 2101616 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | 2 | 5 | 5 | 63 | 38 | |||||
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 | ||||
177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
182249 | 173897 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 90x Knollview Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997593 | 2101480 | 37.7501254274205 | -122.451155378281 | (37.7501254274205, -122.451155378281) | 1 | 5 | 4 | 63 | 38 | ||||
398 | 234490 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 4053 20th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6003306.74467 | 2104167.50736 | 37.7578301676468 | -122.43158877311 | (37.7578301676468, -122.43158877311) | 2 | 4 | 5 | 28862 | 3 | |||
668 | 19865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
798 | 19725 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
874 | 19715 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
1363 | 19612 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1707 | 262090 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1785 | 19984 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
2429 | 19676 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 75 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2687 | 19642 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
2883 | 19735 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
3041 | 19585 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY4 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
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 | |||
3211 | 19860 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
3233 | 245150 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6000845.3118 | 2109360.3422 | 37.7719485860085 | -122.440473841976 | (37.7719485860085, -122.440473841976) | 15 | 5 | 11 | 29492 | 9 | |||
3448 | 19730 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
3507 | 91430 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 4 | 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 | |||
3770 | 19669 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 68 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3883 | 19686 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 85 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
4043 | 19724 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
4365 | 19748 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
4379 | 19728 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
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 | |||
4582 | 19867 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
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 | |||
4763 | 19993 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
4839 | 19757 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
4845 | 20011 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
4956 | 19859 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
5085 | 19999 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
5089 | 262085 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
5469 | 19685 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 84 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5502 | 19723 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
5560 | 19687 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 86 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5857 | 19992 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
6036 | 19632 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
6212 | 19719 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
6279 | 19737 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
6354 | 19722 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
6570 | 19989 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
6577 | 19937 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY38 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
6893 | 19997 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
6896 | 19756 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
7006 | 19814 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY24 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
7083 | 19857 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
7118 | 19620 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30 | |||||||||||||
7129 | 19726 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
7444 | 19914 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY35 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
7456 | 19682 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 81 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60ST | |||||||||||||
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 | |||
7696 | 19727 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
7846 | 19732 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
7883 | 19613 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
7921 | 19736 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
8062 | 19638 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
8572 | 19744 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | -7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
8767 | 19662 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 61 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
8828 | 19606 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
8957 | 19624 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 23 | 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) );