trees
1,194 rows where qSpecies_id = 50 sorted by TreeID
This data as json, CSV (advanced)
These facets timed out: Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179824 | 100088 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003201.40964 | 2118956.65929 | 37.7984315255609 | -122.433009662373 | (37.7984315255609, -122.433009662373) | 13 | 9 | 1 | 57 | 17 | |||
159081 | 100089 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.433055234626 | (37.7984262977915, -122.433055234626) | 13 | 9 | 1 | 57 | 17 | |||
48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
543 | 100400 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x3 | 6008223 | 2099495 | 37.7452779444232 | -122.414255673266 | (37.7452779444232, -122.414255673266) | 2 | 7 | 7 | 28859 | 2 | |||
81761 | 10083 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | 2 | 4 | 5 | 28859 | 19 | ||
28580 | 10084 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | 2 | 4 | 5 | 28859 | 19 | ||
131668 | 101142 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x5 | 6013202.87541 | 2105008.80467 | 37.7606961334358 | -122.397422590588 | (37.7606961334358, -122.397422590588) | 10 | 3 | 8 | 28856 | 29 | |||
156800 | 10139 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.71608 | 37.7566603214356 | -122.42320418504 | (37.7566603214356, -122.42320418504) | 2 | 4 | 5 | 28859 | 19 | ||
73465 | 101797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 600X Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6012355.97365 | 2105123.66121 | 37.7609643139807 | -122.400359728744 | (37.7609643139807, -122.400359728744) | 10 | 3 | 8 | 28856 | 29 | |||
26703 | 101946 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.7564675147494 | -122.41647145397 | (37.7564675147494, -122.41647145397) | 2 | 4 | 7 | 28859 | 19 | |||
3571 | 102167 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) | 2 | 4 | 5 | 28862 | 3 |
93994 | 102177 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465364 | -122.436794111878 | (37.758153465364, -122.436794111878) | 2 | 4 | 5 | 28862 | 3 |
74807 | 10220 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |||
121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
29482 | 104712 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 303 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6012983 | 2105615 | 37.7623483675995 | -122.39822557732 | (37.7623483675995, -122.39822557732) | 10 | 3 | 8 | 28856 | 29 | |||
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
42902 | 104963 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3z3 | Permit Number 770948 | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
192179 | 105743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 410 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 4x4 | Permit Number 771648 | 6002709 | 2109944 | 37.7736571098162 | -122.434068943261 | (37.7736571098162, -122.434068943261) | 15 | 5 | 11 | 29492 | 10 | ||
153024 | 105745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771651 | 6002705 | 2109971 | 37.7737310181147 | -122.434084710333 | (37.7737310181147, -122.434084710333) | 15 | 5 | 11 | 29492 | 10 | |
27293 | 105894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013871.77748 | 2104094.24154 | 37.7582221623537 | -122.395045082568 | (37.7582221623537, -122.395045082568) | 10 | 3 | 8 | 28856 | 29 | |||
51950 | 105895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013871.69882 | 2104104.53276 | 37.7582504154377 | -122.395046075423 | (37.7582504154377, -122.395046075423) | 10 | 3 | 8 | 28856 | 29 | |||
96881 | 105896 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013869.96834 | 2104118.28699 | 37.7582880853408 | -122.395053023593 | (37.7582880853408, -122.395053023593) | 10 | 3 | 8 | 28856 | 29 | |||
78479 | 105897 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013869.92675 | 2104144.58378 | 37.7583602883087 | -122.395055009307 | (37.7583602883087, -122.395055009307) | 10 | 3 | 8 | 28856 | 29 | |||
24333 | 105898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013868.87409 | 2104163.4691 | 37.758412084763 | -122.395059972665 | (37.758412084763, -122.395059972665) | 10 | 3 | 8 | 28856 | 29 | |||
3860 | 106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 927 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | 15 | 5 | 5 | 28862 | 3 | |||
93499 | 106047 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 618- 622 Carolina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 6x7 | 6012364.1992 | 2105044.14437 | 37.7607464370199 | -122.400325694786 | (37.7607464370199, -122.400325694786) | 10 | 3 | 8 | 28856 | 29 | |||
33862 | 106166 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6012226.18355 | 2103510.52022 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | 10 | 3 | 8 | 28856 | 29 | ||||
65454 | 106484 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 758 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | 3x3 | Permit Number 771079 | 6013015.32424 | 2103511.36307 | 37.7565740422689 | -122.397966201986 | (37.7565740422689, -122.397966201986) | 10 | 3 | 8 | 28856 | 29 | |
186473 | 106865 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 580 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014062.5 | 2104405.5 | 37.7590874145177 | -122.394407269796 | (37.7590874145177, -122.394407269796) | 10 | 3 | 8 | 28856 | 29 | |||||
91260 | 107160 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6004955.04875 | 2120587.09696 | 37.8030076016857 | -122.427057718834 | (37.8030076016857, -122.427057718834) | 13 | 9 | 1 | 57 | 17 | ||||
91308 | 107509 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | 13 | 9 | 1 | 57 | 17 | ||||||
59850 | 107808 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 3979 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003121.6 | 2105304 | 37.7609402081383 | -122.432310246363 | (37.7609402081383, -122.432310246363) | 2 | 4 | 5 | 28862 | 3 | |||
50360 | 108394 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 737 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773728 | 6007947.99445 | 2103637.44207 | 37.7566367043842 | -122.41549982216 | (37.7566367043842, -122.41549982216) | 2 | 4 | 7 | 28859 | 19 |
852 | 108444 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877 | 2117007 | 37.7937335561349 | -122.392471758503 | (37.7937335561349, -122.392471758503) | 12 | 2 | 9 | 28855 | 6 | |
164964 | 108456 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | 10 | 3 | 8 | 28856 | 29 | ||||
99000 | 108469 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2560 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772730 | 6009727.83086 | 2102431.72737 | 37.7534259626799 | -122.409259396677 | (37.7534259626799, -122.409259396677) | 2 | 4 | 7 | 28859 | 19 |
41443 | 108489 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 131 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773695 | 6008906.91703 | 2111099.40816 | 37.7771793890601 | -122.412711016861 | (37.7771793890601, -122.412711016861) | 8 | 2 | 9 | 28853 | 34 |
133178 | 108708 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.85423 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | 2 | 4 | 5 | 63 | 22 | |
91033 | 108713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1101 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773108 | 6011675.24376 | 2103231.93963 | 37.7557320816825 | -122.402581058681 | (37.7557320816825, -122.402581058681) | 10 | 3 | 8 | 28856 | 29 |
109395 | 108714 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 443 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773096 | 6014377.05047 | 2105069.75693 | 37.7609288007542 | -122.393365881138 | (37.7609288007542, -122.393365881138) | 10 | 3 | 8 | 28856 | 29 |
39204 | 108736 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1351 Minna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | 8 | 4 | 7 | 28853 | 19 | ||
183431 | 10960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1430 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2018 12:00:00 AM | 3 | 3X4 | Permit Number 782059 | 6016587.34912 | 2096809.91728 | 37.7383715463994 | -122.385145824822 | (37.7383715463994, -122.385145824822) | 10 | 3 | 8 | 58 | 1 | |
147709 | 110368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | 8 | 4 | 8 | 28853 | 19 | |||
45167 | 110369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.407448516042 | (37.7683165361048, -122.407448516042) | 8 | 4 | 8 | 28853 | 19 | |||
171679 | 110370 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
70077 | 110371 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
105723 | 110372 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
9980 | 110373 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
99494 | 110374 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
52963 | 110460 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 250 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.7846732836557 | -122.488126031288 | (37.7846732836557, -122.488126031288) | 11 | 6 | 1 | 55 | 33 | |
120714 | 110461 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 250 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.7846732836557 | -122.488126031288 | (37.7846732836557, -122.488126031288) | 11 | 6 | 1 | 55 | 33 | |
51672 | 111057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
51327 | 111062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
172125 | 111063 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
157876 | 111096 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 15 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
117639 | 114960 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770791 | 6001920.2 | 2100491.9 | 37.7476591410723 | -122.436120992025 | (37.7476591410723, -122.436120992025) | 2 | 4 | 5 | 63 | 22 | |||
73107 | 115506 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
112368 | 115507 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
79540 | 115508 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
73796 | 115552 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 15x7 | 6015276.56251 | 2104229.20593 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | 10 | 3 | 8 | 28856 | 29 | ||
28655 | 116872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013499.86788 | 2106650.27714 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | 14 | 3 | 8 | 28856 | 20 | |||
32204 | 116873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013484.98836 | 2106649.50082 | 37.7652168275233 | -122.396561894417 | (37.7652168275233, -122.396561894417) | 14 | 3 | 8 | 28856 | 20 | |||
106092 | 117199 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 383 LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006585 | 2103883 | 37.7572342437784 | -122.42023098587 | (37.7572342437784, -122.42023098587) | 2 | 4 | 7 | 28859 | 19 | |||
154193 | 117396 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
95305 | 117397 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
187560 | 117555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007674.4763735 | 2101992.27281083 | 37.7521040666078 | -122.416329227522 | (37.7521040666078, -122.416329227522) | 2 | 4 | 7 | 28859 | 19 | |||
35715 | 117954 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.99018 | 2095538.96094 | 37.7347256767529 | -122.394787591666 | (37.7347256767529, -122.394787591666) | 10 | 3 | 8 | 58 | 1 | |||
169574 | 121581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 6013754.46885 | 2106222.83027 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | 14 | 3 | 8 | 28856 | 29 | ||
48539 | 121582 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6013716 | 2106401 | 37.7645473527506 | -122.395745461209 | (37.7645473527506, -122.395745461209) | 14 | 3 | 8 | 28856 | 29 | |||
77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
138812 | 121727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
152066 | 121728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
90226 | 121729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
31864 | 121730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
34391 | 121731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
104984 | 121733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
189598 | 121735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
142727 | 121739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
34062 | 121740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
138150 | 121741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
167786 | 121742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
110905 | 121743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
116126 | 121744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
157158 | 121746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 9 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
76026 | 121748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
174657 | 121750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 13 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
159876 | 121752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 15 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
157398 | 121753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 16 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
151786 | 121754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 17 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
74982 | 121755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 18 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
89672 | 121756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 19 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
193199 | 121757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 20 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 |
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) );