trees
173 rows where Neighborhoods (old) = 29 and qSpecies_id = 50 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 3 | 8 | 28856 | 29 | |||
4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
9391 | 149875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015583.80084 | 2102690.13073 | 37.7544618261772 | -122.38902607571 | (37.7544618261772, -122.38902607571) | 10 | 3 | 8 | 28856 | 29 | |||
15582 | 34308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
15985 | 149873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.31236 | 2102734.10944 | 37.7545824999013 | -122.389034293714 | (37.7545824999013, -122.389034293714) | 10 | 3 | 8 | 28856 | 29 | |||
16486 | 150546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012204.80057 | 2103865.42291 | 37.7575010382506 | -122.400794174114 | (37.7575010382506, -122.400794174114) | 10 | 3 | 8 | 28856 | 29 | |||
18269 | 149874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.50669 | 2102715.11316 | 37.7545303509079 | -122.389032295422 | (37.7545303509079, -122.389032295422) | 10 | 3 | 8 | 28856 | 29 | |||
19118 | 34336 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
21056 | 38279 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.395028206788 | (37.7580416558018, -122.395028206788) | 10 | 3 | 8 | 28856 | 29 | ||
23234 | 48401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1170 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50635 | 6011912.33745 | 2102971.80272 | 37.7550310367587 | -122.401742823998 | (37.7550310367587, -122.401742823998) | 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 | |||
25134 | 34329 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | |||
29512 | 190708 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2033 22nd St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.401538231824 | (37.7570758846471, -122.401538231824) | 10 | 3 | 8 | 28856 | 29 | |||
31469 | 78725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53574 | 6011951.34663 | 2102291.29231 | 37.7531646809082 | -122.401560092537 | (37.7531646809082, -122.401560092537) | 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 | ||||
34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 10 | 3 | 8 | 28856 | 29 | |||
34493 | 34309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
41324 | 122711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.7632198451537 | -122.398435273093 | (37.7632198451537, -122.398435273093) | 14 | 3 | 8 | 28856 | 29 | |||
42631 | 89008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436 | 2104662 | 37.7597011565358 | -122.400050528825 | (37.7597011565358, -122.400050528825) | 10 | 3 | 8 | 28856 | 29 | |||
44753 | 78724 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53574 | 6011950.73154 | 2102276.22736 | 37.7531232815236 | -122.401561160927 | (37.7531232815236, -122.401561160927) | 10 | 3 | 8 | 28856 | 29 | |
45805 | 34314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
45918 | 190719 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6014091.45327 | 2104130.33792 | 37.7583334885189 | -122.39428786959 | (37.7583334885189, -122.39428786959) | 10 | 3 | 8 | 28856 | 29 | |||
47404 | 190692 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6015546.55953 | 2104430.75491 | 37.7592391453969 | -122.389276405591 | (37.7592391453969, -122.389276405591) | 10 | 3 | 8 | 28856 | 29 | |||
49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 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 | |||
52340 | 34319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
55836 | 46116 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 648 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44475 | 6012371.38389312 | 2104918.06745502 | 37.7604006583276 | -122.400291990633 | (37.7604006583276, -122.400291990633) | 10 | 3 | 8 | 28856 | 29 | |||
56528 | 34320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
57579 | 46098 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 624 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | 6 | Permit Number 44467 | 6012970.56549 | 2104146.6143 | 37.7583158105448 | -122.398165561015 | (37.7583158105448, -122.398165561015) | 10 | 3 | 8 | 28856 | 29 | ||
58181 | 34312 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
60736 | 34327 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
64645 | 190712 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Texas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013703.78505 | 2106091.36578 | 37.7636964858312 | -122.395766012395 | (37.7636964858312, -122.395766012395) | 14 | 3 | 8 | 28856 | 29 | |||
64830 | 40096 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | 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 | |
65837 | 190717 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1150 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.394222475384 | (37.7614940829991, -122.394222475384) | 10 | 3 | 8 | 28856 | 29 | |||
66331 | 94180 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 605 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53586 | 6010991.81939 | 2105452.40233 | 37.7617907981332 | -122.405100915002 | (37.7617907981332, -122.405100915002) | 10 | 3 | 8 | 28856 | 29 | |
67227 | 47749 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 10 | 3 | 8 | 28856 | 29 | |||
68716 | 50730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 725 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | 4 | Permit Number 47280 | 6012445.19576 | 2104545.72863 | 37.7593824136929 | -122.400010559737 | (37.7593824136929, -122.400010559737) | 10 | 3 | 8 | 28856 | 29 | ||
72353 | 190688 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015295.35609 | 2103854.98706 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | 10 | 3 | 8 | 28856 | 29 | |||
72978 | 34338 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
74250 | 190718 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 446 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.396453732953 | (37.7607162323997, -122.396453732953) | 10 | 3 | 8 | 28856 | 29 | |||
78094 | 190702 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 648 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012372.02643 | 2104905.99747 | 37.7603675526457 | -122.400288920619 | (37.7603675526457, -122.400288920619) | 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 | |||
80273 | 190705 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2207 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012167.67259 | 2101868.22715 | 37.7520151045386 | -122.400782269783 | (37.7520151045386, -122.400782269783) | 10 | 3 | 8 | 28856 | 29 | |||
80801 | 190684 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014721.7183 | 2106200.75287 | 37.7640534132442 | -122.392252919633 | (37.7640534132442, -122.392252919633) | 14 | 3 | 8 | 28856 | 29 | |||
81858 | 34307 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
84685 | 32944 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37262 | 6012923.17595221 | 2106002.78448692 | 37.7634098055879 | -122.398459699211 | (37.7634098055879, -122.398459699211) | 14 | 3 | 8 | 28856 | 29 | |||
85032 | 30882 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 6 | Permit Number 48128 | 6014140.03931 | 2104332.5507 | 37.7588914216105 | -122.394133992886 | (37.7588914216105, -122.394133992886) | 10 | 3 | 8 | 28856 | 29 | ||
88732 | 47750 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 10 | 3 | 8 | 28856 | 29 | |||
89178 | 34318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
89588 | 190720 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 315 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014070.97859 | 2105596.22306 | 37.7623573521408 | -122.394461321843 | (37.7623573521408, -122.394461321843) | 10 | 3 | 8 | 28856 | 29 | |||
90656 | 190704 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6011711.12531 | 2101607.11223 | 37.7512726647182 | -122.402342728461 | (37.7512726647182, -122.402342728461) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | |||
99407 | 34313 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
100567 | 34321 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
101836 | 190716 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 333 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6012961.26572 | 2105490.25457 | 37.7620046335244 | -122.398291995789 | (37.7620046335244, -122.398291995789) | 10 | 3 | 8 | 28856 | 29 | |||
102465 | 190690 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.7575419601034 | -122.390097725855 | (37.7575419601034, -122.390097725855) | 10 | 3 | 8 | 28856 | 29 | |||
102909 | 38277 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013910.55501 | 2103982.27082 | 37.7579168712948 | -122.394903129995 | (37.7579168712948, -122.394903129995) | 10 | 3 | 8 | 28856 | 29 | ||
106504 | 40804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 585 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 41753 | 6013297.80731 | 2104343.61694 | 37.7588749586426 | -122.397047620054 | (37.7588749586426, -122.397047620054) | 10 | 3 | 8 | 28856 | 29 | |||
107938 | 34311 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
108357 | 190715 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 350 Texas St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | 10 | 3 | 8 | 28856 | 29 | |||
110878 | 34326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
111213 | 34335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
119323 | 190685 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014780.75112 | 2106205.10487 | 37.7640686405785 | -122.392049045151 | (37.7640686405785, -122.392049045151) | 14 | 3 | 8 | 28856 | 29 | |||
121410 | 52722 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1115 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 5 | Permit Number 48775 | 6011675.49817 | 2103219.4484 | 37.7556977977188 | -122.402579300492 | (37.7556977977188, -122.402579300492) | 10 | 3 | 8 | 28856 | 29 | ||
123168 | 190683 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Minnesota St | 39 | Front Yard : Yard | Tree | Private 2 | 4 | 6015372.42654 | 2102509.76476 | 37.7539548603504 | -122.389744472134 | (37.7539548603504, -122.389744472134) | 10 | 3 | 8 | 28856 | 29 | ||||
124187 | 190700 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013754.83495 | 2106240.90179 | 37.7641099185662 | -122.395599922892 | (37.7641099185662, -122.395599922892) | 14 | 3 | 8 | 28856 | 29 | |||
129660 | 190687 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | 10 | 3 | 8 | 28856 | 29 | |||
130713 | 38280 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.99501 | 37.7581146430008 | -122.395027213942 | (37.7581146430008, -122.395027213942) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
136567 | 46565 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) | 10 | 3 | 8 | 28856 | 29 | ||
137130 | 38274 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 645 Texas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.7576604143577 | -122.394153206319 | (37.7576604143577, -122.394153206319) | 10 | 3 | 8 | 28856 | 29 | |||
139065 | 34317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
143485 | 190686 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014799.41703 | 2106205.91343 | 37.7640718970256 | -122.391984541257 | (37.7640718970256, -122.391984541257) | 14 | 3 | 8 | 28856 | 29 | |||
146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
147729 | 54450 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51720 | 6011224.5432 | 2106327.02843 | 37.7642053321404 | -122.40435757586 | (37.7642053321404, -122.40435757586) | 8 | 3 | 8 | 28856 | 29 | |
148478 | 34331 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
150302 | 34324 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
155492 | 38276 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.7578642888268 | -122.394852504434 | (37.7578642888268, -122.394852504434) | 10 | 3 | 8 | 28856 | 29 | ||
156109 | 34315 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
157772 | 34316 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
159008 | 190714 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Texas St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.7617293870175 | -122.395381240171 | (37.7617293870175, -122.395381240171) | 10 | 3 | 8 | 28856 | 29 | |||
160328 | 34333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
161547 | 68190 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1625 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31967 | 6012798.25639 | 2105161.94327 | 37.761094081638 | -122.398832742859 | (37.761094081638, -122.398832742859) | 10 | 3 | 8 | 28856 | 29 | ||
162785 | 34322 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
163887 | 34330 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
165341 | 34325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
167135 | 34334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
168986 | 190710 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012743.45877 | 2104190.05175 | 37.7584224278606 | -122.398954049707 | (37.7584224278606, -122.398954049707) | 10 | 3 | 8 | 28856 | 29 | |||
175462 | 196543 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 5 | Width 3ft | 6012204.60388 | 2103877.56611 | 37.7575343698359 | -122.400795707451 | (37.7575343698359, -122.400795707451) | 10 | 3 | 8 | 28856 | 29 | ||
175485 | 94191 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53584 | 6013839 | 2104639 | 37.7597161279512 | -122.395196600917 | (37.7597161279512, -122.395196600917) | 10 | 3 | 8 | 28856 | 29 | |||
179328 | 190713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013844.95879 | 2104593.96331 | 37.7595927983841 | -122.395172837551 | (37.7595927983841, -122.395172837551) | 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) );