trees
180 rows where qSpecies_id = 150 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60011 | 85505 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
61467 | 188560 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013253.43645 | 2102897.8837 | 37.7549028195293 | -122.397099704282 | (37.7549028195293, -122.397099704282) | 10 | 3 | 8 | 28856 | 29 | ||||
62078 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
63539 | 188544 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1501 22nd St | 15 | Front Yard : Yard | Tree | Private 2 | 12 | 6013369.71631 | 2103799.38115 | 37.757384608426 | -122.396760769601 | (37.757384608426, -122.396760769601) | 10 | 3 | 8 | 28856 | 29 | ||||
64708 | 188554 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013414.60293 | 2102900.51315 | 37.7549190100055 | -122.396542525734 | (37.7549190100055, -122.396542525734) | 10 | 3 | 8 | 28856 | 29 | ||||
64792 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
69552 | 19347 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992459.1729484 | 2089876.0608299 | 37.7179686413438 | -122.468064319729 | (37.7179686413438, -122.468064319729) | 9 | 8 | 6 | 64 | 24 | |||
70471 | 247305 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002334.5255 | 2109487.5806 | 37.7723826357595 | -122.435331651709 | (37.7723826357595, -122.435331651709) | 15 | 5 | 11 | 29492 | 9 | |||
71222 | 2429 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 319X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004581.20934 | 2109449.43359 | 37.7724052264427 | -122.427557439719 | (37.7724052264427, -122.427557439719) | 7 | 9 | 11 | 28852 | 10 | |||
71879 | 120392 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 735 24th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5988458.4501 | 2110868.62788 | 37.7753768145809 | -122.483430984429 | (37.7753768145809, -122.483430984429) | 11 | 6 | 2 | 55 | 26 | ||||
72951 | 23661 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 308 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006889.9376932 | 2098288.2721449 | 37.7418895695178 | -122.418779625482 | (37.7418895695178, -122.418779625482) | 2 | 7 | 7 | 28859 | 2 | |||
74203 | 1916 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 11 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016651.8152009 | 2095266.4928857 | 37.734137178639 | -122.384815438972 | (37.734137178639, -122.384815438972) | 10 | 3 | 8 | 58 | 1 | |||
77670 | 106400 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 5989617.86074 | 2114578.87225 | 37.7856315213945 | -122.479691897092 | (37.7856315213945, -122.479691897092) | 11 | 6 | 2 | 55 | 26 | |||
78456 | 124766 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 138 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997561.15086 | 2115901.77792 | 37.7897221032522 | -122.452306040493 | (37.7897221032522, -122.452306040493) | 11 | 6 | 1 | 54 | 31 | |||
87585 | 10279 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 321 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004595.17399 | 2109451.15702 | 37.7724107484201 | -122.42750925745 | (37.7724107484201, -122.42750925745) | 7 | 9 | 11 | 28852 | 10 | |||
88192 | 1711 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 5 Bass Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016572.54474 | 2095129.81679 | 37.7337575087508 | -122.385079984921 | (37.7337575087508, -122.385079984921) | 10 | 3 | 8 | 58 | 1 | |||
88490 | 188557 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013310.23031 | 2102900.17201 | 37.7549122641975 | -122.39690345423 | (37.7549122641975, -122.39690345423) | 10 | 3 | 8 | 28856 | 29 | ||||
94332 | 29878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1500X La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 14 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | |||
98334 | 20270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2290 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
98863 | 100365 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 450X Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769344 | 6000745 | 2110655 | 37.7754976778855 | -122.44091371844 | (37.7754976778855, -122.44091371844) | 15 | 5 | 11 | 29492 | 10 | ||||
103757 | 99113 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2105 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | 6000888.78727 | 2115636.76287 | 37.7891845118984 | -122.440773756903 | (37.7891845118984, -122.440773756903) | 13 | 6 | 1 | 29490 | 27 | ||||
109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
110526 | 99111 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2105 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 6000887.06837 | 2115666.65288 | 37.7892664842201 | -122.440781849024 | (37.7892664842201, -122.440781849024) | 13 | 6 | 1 | 29490 | 27 | ||||
110890 | 122957 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 178 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993071.35373 | 2114313.86484 | 37.7851038966064 | -122.467724630713 | (37.7851038966064, -122.467724630713) | 11 | 6 | 2 | 54 | 11 | |||
115625 | 188542 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 900x Carolina St | 54 | Median : Yard | Tree | DPW 1 | 16 | 6012509.86374 | 2102962.70315 | 37.75503937799 | -122.399675754754 | (37.75503937799, -122.399675754754) | 10 | 3 | 8 | 28856 | 29 | ||||
119879 | 120360 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2420 Lake St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5987898.73747 | 2114688.56086 | 37.7858326787598 | -122.48564754506 | (37.7858326787598, -122.48564754506) | 11 | 6 | 1 | 55 | 33 | |||
119931 | 188543 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1501 22nd St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 6013381.40306 | 2103831.17556 | 37.7574725594206 | -122.396722580779 | (37.7574725594206, -122.396722580779) | 10 | 3 | 8 | 28856 | 29 | ||||
122765 | 188562 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 36 03rd St | 11 | : | Tree | Private 2 | 12 | Width 3ft | 6015968.54272 | 2098749.82191 | 37.7436638776954 | -122.387420665355 | (37.7436638776954, -122.387420665355) | 10 | 3 | 8 | 58 | 1 | |||
123498 | 250152 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2501 Lyon St | 7 | Front Yard : Yard | Tree | Private 2 | 9 | 5999205.94297 | 2117400.85973 | 37.7939322749156 | -122.44672314997 | (37.7939322749156, -122.44672314997) | 11 | 1 | 57 | 30 | |||||
124064 | 220119 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 6 | 6005096.05499 | 2097092.98426 | 37.7385064123255 | -122.42489727481 | (37.7385064123255, -122.42489727481) | 2 | 7 | 5 | 63 | 7 | ||||
127396 | 98197 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 830 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x24 | 5996641.8 | 2095053.2 | 37.7324245008062 | -122.45398057585 | (37.7324245008062, -122.45398057585) | 9 | 7 | 4 | 59 | 40 | ||||
128045 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
128049 | 200915 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015749.7726 | 2098032.6644 | 37.7416825916515 | -122.388127088521 | (37.7416825916515, -122.388127088521) | 10 | 3 | 8 | 58 | 1 | |||
128926 | 20260 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
130684 | 18906 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2603 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6002313.43773 | 2115715.13601 | 37.7894807345857 | -122.435850259079 | (37.7894807345857, -122.435850259079) | 13 | 6 | 1 | 29490 | 27 | |||
132091 | 1912 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 8 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016615.0158523 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | 10 | 3 | 8 | 58 | 1 | |||
136142 | 185643 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2100 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985040.1399 | 2100443.7841 | 37.7465535598153 | -122.494486886414 | (37.7465535598153, -122.494486886414) | 1 | 8 | 3 | 29491 | 35 | |||
138971 | 21436 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2692X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
139515 | 21403 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2692X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
141272 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
143241 | 23685 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 330 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006867.2134351 | 2098039.8280465 | 37.7412061180035 | -122.418840582769 | (37.7412061180035, -122.418840582769) | 2 | 7 | 7 | 28859 | 2 | |||
144258 | 6728 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Fairfax Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
144780 | 188549 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013485.70626 | 2102911.99671 | 37.7549544981753 | -122.396297433481 | (37.7549544981753, -122.396297433481) | 10 | 3 | 8 | 28856 | 29 | ||||
145654 | 188546 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 651 Missouri St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6013632.14132 | 2103889.75102 | 37.757647347167 | -122.395859525694 | (37.757647347167, -122.395859525694) | 10 | 3 | 8 | 28856 | 29 | ||||
145751 | 30311 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 860 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9 | 5983275.48572939 | 2109941.19024403 | 37.7725273211727 | -122.501291162566 | (37.7725273211727, -122.501291162566) | 11 | 6 | 2 | 55 | 26 | ||||
145781 | 124767 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3045 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005087.0459 | 2120451.7007 | 37.8026433016029 | -122.426591292679 | (37.8026433016029, -122.426591292679) | 13 | 9 | 1 | 57 | 17 | |||
146056 | 120393 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 735 24th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5988458.36945 | 2110846.11582 | 37.7753149980476 | -122.483429612725 | (37.7753149980476, -122.483429612725) | 11 | 6 | 2 | 55 | 26 | ||||
146942 | 188553 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013421.85474 | 2102905.28008 | 37.7549325025407 | -122.396517780884 | (37.7549325025407, -122.396517780884) | 10 | 3 | 8 | 28856 | 29 | ||||
149260 | 185019 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2701 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985029.339 | 2096373.556 | 37.7353771778975 | -122.494224278603 | (37.7353771778975, -122.494224278603) | 1 | 8 | 3 | 29491 | 35 | |||
154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
157656 | 142164 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 490 Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000672.4904 | 2110619.9435 | 37.7753972916401 | -122.44116203009 | (37.7753972916401, -122.44116203009) | 15 | 5 | 11 | 29492 | 10 | |||
158251 | 188550 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6013235.33415 | 2102896.38806 | 37.7548977050817 | -122.397162202681 | (37.7548977050817, -122.397162202681) | 10 | 3 | 8 | 28856 | 29 | ||||
159120 | 12858 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2455 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5987787.46088 | 2114620.72752 | 37.7856399434951 | -122.486027545007 | (37.7856399434951, -122.486027545007) | 11 | 6 | 2 | 55 | 26 | |||
162939 | 116890 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 799X Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999183.52163 | 2121463.27937 | 37.8050853080999 | -122.447093221893 | (37.8050853080999, -122.447093221893) | 13 | 9 | 1 | 57 | 17 | |||
165218 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
165268 | 188545 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 651 Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013660.85413 | 2103803.37059 | 37.75741176256 | -122.395754171925 | (37.75741176256, -122.395754171925) | 10 | 3 | 8 | 28856 | 29 | ||||
170130 | 186367 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984825.2316 | 2102541.2113 | 37.7522999403759 | -122.495384664955 | (37.7522999403759, -122.495384664955) | 1 | 8 | 3 | 56 | 35 | |||
170265 | 220120 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 15 | 6005087.11734 | 2097092.81243 | 37.738505435679 | -122.424928164698 | (37.738505435679, -122.424928164698) | 2 | 7 | 5 | 63 | 7 | ||||
170310 | 188563 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1 Waterville St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6011470.31075 | 2096143.82241 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | 10 | 3 | 8 | 58 | 1 | ||||
170593 | 142166 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1477 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000715.4928 | 2110652.1954 | 37.7754882965725 | -122.441015589387 | (37.7754882965725, -122.441015589387) | 15 | 5 | 11 | 29492 | 10 | |||
171557 | 6704 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
172468 | 141736 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1420 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003702.0095 | 2113653.0853 | 37.7838976435553 | -122.430898731444 | (37.7838976435553, -122.430898731444) | 13 | 9 | 11 | 29490 | 41 | |||
173199 | 186270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1800 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984992.9477 | 2102426.3669 | 37.7519944279313 | -122.49479621795 | (37.7519944279313, -122.49479621795) | 1 | 8 | 3 | 56 | 35 | |||
173327 | 97334 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 211 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987387.3 | 2114536.2 | 37.7853845267129 | -122.487405756991 | (37.7853845267129, -122.487405756991) | 11 | 6 | 1 | 55 | 33 | ||||
173340 | 22130 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
175670 | 21440 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2692X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
175920 | 188561 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2230 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6012197.23492 | 2099395.45129 | 37.7452270442016 | -122.400506356909 | (37.7452270442016, -122.400506356909) | 10 | 3 | 8 | 58 | 1 | |||
178060 | 120395 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 735 24th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5988459.66888 | 2110795.13561 | 37.7751750962322 | -122.483421379665 | (37.7751750962322, -122.483421379665) | 11 | 6 | 2 | 55 | 26 | ||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
180735 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
181814 | 247417 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 981 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001920.2327 | 2109431.4693 | 37.7722050316748 | -122.436760709737 | (37.7722050316748, -122.436760709737) | 15 | 5 | 11 | 29492 | 9 | |||
184496 | 101135 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1477 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
184558 | 186118 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1700 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984966.576 | 2103035.9667 | 37.7536666774921 | -122.49493235749 | (37.7536666774921, -122.49493235749) | 1 | 8 | 3 | 56 | 35 | |||
185709 | 26889 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1601 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6015842.1307553 | 2097647.0535434 | 37.7406288998504 | -122.387780842816 | (37.7406288998504, -122.387780842816) | 10 | 3 | 8 | 58 | 1 | |||
185977 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
187481 | 22125 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
189813 | 185642 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2100 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985069.1522 | 2100447.6812 | 37.7465659581193 | -122.494386853704 | (37.7465659581193, -122.494386853704) | 1 | 8 | 3 | 29491 | 35 | |||
190012 | 6427 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1100X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018163.14059 | 2096688.19053 | 37.7381243524454 | -122.379688994958 | (37.7381243524454, -122.379688994958) | 10 | 3 | 8 | 58 | 1 | |||
191870 | 188555 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013407.82956 | 2102894.99959 | 37.7549034940071 | -122.396565563648 | (37.7549034940071, -122.396565563648) | 10 | 3 | 8 | 28856 | 29 |
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) );