trees
132 rows where Neighborhoods (old) = 2 and qSpecies_id = 50 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
6306 | 237343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
6465 | 261249 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007038 | 2095471 | 37.7341622992343 | -122.418067993983 | (37.7341622992343, -122.418067993983) | 2 | 7 | 7 | 28859 | 2 | ||||
6669 | 229888 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008255.19246 | 2099602.19695 | 37.7455740916772 | -122.414151939365 | (37.7455740916772, -122.414151939365) | 2 | 7 | 7 | 28859 | 2 | |||
6734 | 226402 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.7453883322157 | -122.414279508218 | (37.7453883322157, -122.414279508218) | 2 | 7 | 7 | 28859 | 2 | |||
7478 | 226407 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006002.53632 | 2097682.69863 | 37.7401767960293 | -122.421804971219 | (37.7401767960293, -122.421804971219) | 2 | 7 | 7 | 28859 | 2 | |||
9376 | 237344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
12676 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 50 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 782183 | 6009049 | 2099828 | 37.7462386522881 | -122.411423013741 | (37.7462386522881, -122.411423013741) | 2 | 7 | 7 | 28859 | 2 | |||
14521 | 259145 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007403 | 2097606 | 37.7400450761075 | -122.416957288885 | (37.7400450761075, -122.416957288885) | 2 | 7 | 7 | 28859 | 2 | ||||
18224 | 248227 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 38 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007014.76999 | 2099297.76945 | 37.7446684509831 | -122.418419557911 | (37.7446684509831, -122.418419557911) | 2 | 7 | 7 | 28859 | 2 | |||
18656 | 229861 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1509 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010132.55959 | 2100497.58386 | 37.7481378987515 | -122.407723384842 | (37.7481378987515, -122.407723384842) | 2 | 7 | 7 | 28859 | 2 | |||
20282 | 226409 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007041.57099 | 2096614.16719 | 37.7373013855609 | -122.418136666301 | (37.7373013855609, -122.418136666301) | 2 | 7 | 7 | 28859 | 2 | |||
21276 | 226310 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | 2 | 7 | 7 | 28859 | 2 | |||
24108 | 226363 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 178 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006046.41496 | 2096344.01449 | 37.7365035429963 | -122.421558204449 | (37.7365035429963, -122.421558204449) | 2 | 7 | 7 | 28859 | 2 | |||
28827 | 229891 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008240.95046 | 2099813.74948 | 37.7461541678773 | -122.414216150953 | (37.7461541678773, -122.414216150953) | 2 | 7 | 7 | 28859 | 2 | |||
29233 | 226388 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006749.9144 | 2099207.72209 | 37.7444062878286 | -122.41932899196 | (37.7444062878286, -122.41932899196) | 2 | 7 | 7 | 28859 | 2 | |||
29462 | 226390 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.7410547888452 | -122.419644136891 | (37.7410547888452, -122.419644136891) | 2 | 7 | 7 | 28859 | 2 | |||
32766 | 226392 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.7460275775108 | -122.414955412565 | (37.7460275775108, -122.414955412565) | 2 | 7 | 7 | 28859 | 2 | |||
33353 | 229895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1429 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008018.20821 | 2099852.67897 | 37.7462485454514 | -122.414989122751 | (37.7462485454514, -122.414989122751) | 2 | 7 | 7 | 28859 | 2 | |||
33380 | 226305 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006137.34667 | 2097561.46022 | 37.7398515040311 | -122.421330243406 | (37.7398515040311, -122.421330243406) | 2 | 7 | 7 | 28859 | 2 | |||
34325 | 248003 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009956.29023 | 2098510.13636 | 37.7426709335279 | -122.408192770677 | (37.7426709335279, -122.408192770677) | 10 | 7 | 7 | 28859 | 2 | |||
37653 | 248002 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.74271836107 | -122.408184696582 | (37.74271836107, -122.408184696582) | 10 | 7 | 7 | 28859 | 2 | |||
39052 | 229883 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008413.69404 | 2097282.59684 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | 2 | 7 | 7 | 28859 | 2 | |||
39438 | 229804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Crescent Ave | 7 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | 2 | 7 | 7 | 28859 | 2 | |||
40005 | 229894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | 2 | 7 | 7 | 28859 | 2 | |||
40026 | 229885 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007989.39364 | 2099739.34159 | 37.7459357270683 | -122.415080739378 | (37.7459357270683, -122.415080739378) | 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 | ||
44395 | 226394 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008031.02829 | 2099712.86133 | 37.7458653577975 | -122.414934898137 | (37.7458653577975, -122.414934898137) | 2 | 7 | 7 | 28859 | 2 | |||
46491 | 226357 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005980.00754 | 2099557.6277 | 37.7453236574624 | -122.422016025938 | (37.7453236574624, -122.422016025938) | 2 | 7 | 5 | 28859 | 2 | |||
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 | |||
51307 | 226395 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | 2 | 7 | 7 | 28859 | 2 | |||
51890 | 229889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008249.88149 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | 2 | 7 | 7 | 28859 | 2 | |||
58760 | 226396 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008038.28994 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | 2 | 7 | 7 | 28859 | 2 | |||
69053 | 226393 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.7459034791769 | -122.414943103567 | (37.7459034791769, -122.414943103567) | 2 | 7 | 7 | 28859 | 2 | |||
69326 | 229892 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008238.53675 | 2099832.54368 | 37.7462056369848 | -122.414225826762 | (37.7462056369848, -122.414225826762) | 2 | 7 | 7 | 28859 | 2 | |||
70019 | 229864 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
74771 | 226308 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007401.10475 | 2096768.52961 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | 2 | 7 | 7 | 28859 | 2 | |||
75930 | 226391 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.7460665100597 | -122.414972850429 | (37.7460665100597, -122.414972850429) | 2 | 7 | 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 | |||
83706 | 226401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.7452462375173 | -122.414263403134 | (37.7452462375173, -122.414263403134) | 2 | 7 | 7 | 28859 | 2 | |||
84496 | 226411 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383517 | -122.410548750743 | (37.741313383517, -122.410548750743) | 10 | 7 | 7 | 28859 | 2 | |||
86331 | 229860 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008991.73751 | 2099895.44974 | 37.7464206424026 | -122.411625786002 | (37.7464206424026, -122.411625786002) | 2 | 7 | 7 | 28859 | 2 | |||
97822 | 226404 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.7465441607 | -122.416469871814 | (37.7465441607, -122.416469871814) | 2 | 7 | 7 | 28859 | 2 | |||
99789 | 229862 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010167.1335 | 2100435.43231 | 37.747969179639 | -122.40759944746 | (37.747969179639, -122.40759944746) | 2 | 7 | 7 | 28859 | 2 | |||
100983 | 226403 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008209.69188 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | 2 | 7 | 7 | 28859 | 2 | |||
102856 | 226389 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | 2 | 7 | 7 | 28859 | 2 | |||
106174 | 248027 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009988.36995 | 2098561.68629 | 37.7428142746487 | -122.40808548247 | (37.7428142746487, -122.40808548247) | 10 | 7 | 7 | 28859 | 2 | |||
106216 | 226380 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6009262.96454 | 2097691.62969 | 37.7403846464258 | -122.410532314727 | (37.7403846464258, -122.410532314727) | 10 | 7 | 7 | 28859 | 2 | |||
106394 | 226408 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006517.91503 | 2097301.91264 | 37.739160293208 | -122.419995981327 | (37.739160293208, -122.419995981327) | 2 | 7 | 7 | 28859 | 2 | |||
108736 | 226399 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.7453608534324 | -122.41501490632 | (37.7453608534324, -122.41501490632) | 2 | 7 | 7 | 28859 | 2 | |||
110808 | 226410 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007045.3382 | 2096649.72314 | 37.7373992263821 | -122.418126161295 | (37.7373992263821, -122.418126161295) | 2 | 7 | 7 | 28859 | 2 | |||
112161 | 229887 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008255.99327 | 2099554.30466 | 37.745442635078 | -122.414145782603 | (37.745442635078, -122.414145782603) | 2 | 7 | 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 | |||
115180 | 226379 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 424 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008895.67252 | 2096317.34788 | 37.7365905694901 | -122.411705190752 | (37.7365905694901, -122.411705190752) | 10 | 7 | 7 | 28859 | 2 | |||
116554 | 232376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 50 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x9 | 6008171 | 2099926 | 37.746458453366 | -122.414465973024 | (37.746458453366, -122.414465973024) | 2 | 7 | 7 | 28859 | 2 | |||
117771 | 226385 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | 2 | 7 | 7 | 28859 | 2 | |||
120181 | 229745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.421916967417 | (37.7441939246187, -122.421916967417) | 2 | 7 | 5 | 28859 | 2 | |||
121675 | 226384 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007204.63358 | 2097592.37529 | 37.7399965053243 | -122.417642194748 | (37.7399965053243, -122.417642194748) | 2 | 7 | 7 | 28859 | 2 | |||
123700 | 248006 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009948.03902 | 2098416.30132 | 37.7424128208876 | -122.408214684483 | (37.7424128208876, -122.408214684483) | 10 | 7 | 7 | 28859 | 2 | |||
123784 | 226378 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008209.35637 | 2096429.78748 | 37.7368607798011 | -122.414086039755 | (37.7368607798011, -122.414086039755) | 2 | 7 | 7 | 28859 | 2 | |||
123971 | 229884 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 5ft | 6009563.00843 | 2097787.48407 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | 10 | 7 | 7 | 28859 | 2 | |||
126636 | 229890 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008246.22081 | 2099723.2099 | 37.7459058623841 | -122.414191522144 | (37.7459058623841, -122.414191522144) | 2 | 7 | 7 | 28859 | 2 | |||
128396 | 229882 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6008416.68038 | 2097349.45644 | 37.7393976324023 | -122.41343424801 | (37.7393976324023, -122.41343424801) | 2 | 7 | 7 | 28859 | 2 | |||
129802 | 226397 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | 2 | 7 | 7 | 28859 | 2 | |||
130148 | 226400 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008001.07248 | 2099553.66374 | 37.7454265533887 | -122.415027215335 | (37.7454265533887, -122.415027215335) | 2 | 7 | 7 | 28859 | 2 | |||
130952 | 226309 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007378.4424 | 2096771.82308 | 37.737753229234 | -122.416983110403 | (37.737753229234, -122.416983110403) | 2 | 7 | 7 | 28859 | 2 | |||
131818 | 226398 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.7453105651388 | -122.415010803607 | (37.7453105651388, -122.415010803607) | 2 | 7 | 7 | 28859 | 2 | |||
134714 | 248273 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 155 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006714.66464 | 2098690.19871 | 37.7429832995482 | -122.419414171229 | (37.7429832995482, -122.419414171229) | 2 | 7 | 7 | 28859 | 2 | |||
135298 | 226383 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007419.20582 | 2097997.75063 | 37.7411216480553 | -122.416929004483 | (37.7411216480553, -122.416929004483) | 2 | 7 | 7 | 28859 | 2 | |||
140846 | 229886 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646 | (37.7458924813579, -122.41507891646) | 2 | 7 | 7 | 28859 | 2 | |||
146308 | 226381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.7404227444144 | -122.410529710297 | (37.7404227444144, -122.410529710297) | 10 | 7 | 7 | 28859 | 2 | |||
146523 | 226382 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009331.97291 | 2097098.94639 | 37.7387611354248 | -122.410251874634 | (37.7387611354248, -122.410251874634) | 10 | 7 | 7 | 28859 | 2 | |||
148309 | 226304 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008016.14912 | 2099877.20359 | 37.7463157688762 | -122.414997978399 | (37.7463157688762, -122.414997978399) | 2 | 7 | 7 | 28859 | 2 | |||
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
157820 | 226386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | 2 | 7 | 7 | 28859 | 2 | |||
164689 | 229863 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010172.47865 | 2100425.75688 | 37.7479429122343 | -122.407580282 | (37.7479429122343, -122.407580282) | 2 | 7 | 7 | 28859 | 2 | |||
166585 | 226406 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008014.49827 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | 2 | 7 | 7 | 28859 | 2 | |||
166899 | 229893 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008237.21282 | 2099854.86207 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | 2 | 7 | 7 | 28859 | 2 | |||
168980 | 226358 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.421699497839 | (37.7462380152724, -122.421699497839) | 2 | 7 | 5 | 28859 | 2 | |||
171578 | 226306 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | 2 | 7 | 7 | 28859 | 2 | |||
174953 | 226307 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007092.99842 | 2096727.14909 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | 2 | 7 | 7 | 28859 | 2 | |||
179723 | 226405 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628925 | -122.415012541103 | (37.746498628925, -122.415012541103) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
102346 | 35943 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2016 12:00:00 AM | 3 | Permit Number 39390 | 6007111.66828124 | 2096780.53419663 | 37.7377621378422 | -122.417906096842 | (37.7377621378422, -122.417906096842) | 2 | 7 | 7 | 28859 | 2 | |
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
91115 | 239542 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.7394391055351 | -122.417688629421 | (37.7394391055351, -122.417688629421) | 2 | 7 | 7 | 28859 | 2 | |
109988 | 240741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.417694582949 | (37.739334592605, -122.417694582949) | 2 | 7 | 7 | 28859 | 2 | |
135033 | 239543 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.36237 | 2097372.94469 | 37.7393929694044 | -122.417689820148 | (37.7393929694044, -122.417689820148) | 2 | 7 | 7 | 28859 | 2 | |
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
24866 | 255162 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 598 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007652.9891 | 2096583.60222 | 37.7372518561065 | -122.416020541778 | (37.7372518561065, -122.416020541778) | 2 | 7 | 7 | 28859 | 2 | |
58969 | 255166 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Wool St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779581 | 6007398.90831 | 2097677.8344 | 37.7402420872899 | -122.416976524667 | (37.7402420872899, -122.416976524667) | 2 | 7 | 7 | 28859 | 2 | |
22460 | 65976 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 59 & 1/2 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 6x6 | Permit Number 31847 | 6008257.4720065 | 2099681.55363989 | 37.7457921155362 | -122.414149670347 | (37.7457921155362, -122.414149670347) | 2 | 7 | 7 | 28859 | 2 |
35946 | 68105 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.7454673885178 | -122.414298897694 | (37.7454673885178, -122.414298897694) | 2 | 7 | 7 | 28859 | 2 | ||
111960 | 68104 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) | 2 | 7 | 7 | 28859 | 2 |
170353 | 68103 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.7456638906333 | -122.414137374358 | (37.7456638906333, -122.414137374358) | 2 | 7 | 7 | 28859 | 2 |
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
21766 | 36029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39176 | 6008256.82211369 | 2099693.24167493 | 37.7458241717762 | -122.414152744353 | (37.7458241717762, -122.414152744353) | 2 | 7 | 7 | 28859 | 2 | ||
56577 | 35969 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 176 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.421637006977 | (37.7364952030819, -122.421637006977) | 2 | 7 | 7 | 28859 | 2 | ||
78208 | 36018 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 93 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39164 | 6006753.30500561 | 2099126.43768618 | 37.7441832900966 | -122.419311502826 | (37.7441832900966, -122.419311502826) | 2 | 7 | 7 | 28859 | 2 |
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) );