trees
173 rows where Neighborhoods (old) = 29 and qSpecies_id = 50 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1622 | 78494 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012056.35315 | 2102319.00627 | 37.7532466361332 | -122.401198904113 | (37.7532466361332, -122.401198904113) | 10 | 3 | 8 | 28856 | 29 | |||
| 4309 | 69898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277 | -122.401657284058 | (37.756311243277, -122.401657284058) | 10 | 3 | 8 | 28856 | 29 | |||
| 10612 | 78436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1379 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6012015.72942 | 2101977.35144 | 37.7523062600388 | -122.401315382525 | (37.7523062600388, -122.401315382525) | 10 | 3 | 8 | 28856 | 29 | |||
| 10911 | 78495 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011953.72275 | 2102256.16538 | 37.7530683626141 | -122.401549406774 | (37.7530683626141, -122.401549406774) | 10 | 3 | 8 | 28856 | 29 | |||
| 11458 | 35362 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.43629 | 2103880.66513 | 37.75752713659 | -122.401771780343 | (37.75752713659, -122.401771780343) | 10 | 3 | 8 | 28856 | 29 | |
| 11826 | 43301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.66336 | 37.7598497302126 | -122.395201050183 | (37.7598497302126, -122.395201050183) | 10 | 3 | 8 | 28856 | 29 | |
| 13205 | 69888 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012175.72633 | 2103309.76161 | 37.7559736926594 | -122.400855686861 | (37.7559736926594, -122.400855686861) | 10 | 3 | 8 | 28856 | 29 | |||
| 13967 | 84622 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 382 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013742.24361 | 2105343.88141 | 37.761646197043 | -122.395580621644 | (37.761646197043, -122.395580621644) | 10 | 3 | 8 | 28856 | 29 | |||
| 14099 | 38381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1464 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/2005 12:00:00 AM | 5 | Permit Number 48279 | 6011990.10357 | 2101552.61207 | 37.7511385883967 | -122.401374155011 | (37.7511385883967, -122.401374155011) | 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 | ||||
| 17748 | 78435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2036 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011985.6646 | 2103761.39443 | 37.7572031738156 | -122.401544727608 | (37.7572031738156, -122.401544727608) | 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 | ||||
| 20229 | 37987 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | 10 | 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 | ||
| 21580 | 39574 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 863 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40991 | 6011617.31177 | 2104338.8923 | 37.7587682945481 | -122.402859256767 | (37.7587682945481, -122.402859256767) | 10 | 3 | 8 | 28856 | 29 | |
| 24397 | 47676 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 434 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45460 | 6014318.70228 | 2105083.22351 | 37.7609625351244 | -122.393568625994 | (37.7609625351244, -122.393568625994) | 10 | 3 | 8 | 28856 | 29 | |
| 24742 | 37969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40199 | 6013584.10507 | 2104296.87899 | 37.7587625595637 | -122.396054186654 | (37.7587625595637, -122.396054186654) | 10 | 3 | 8 | 28856 | 29 | |
| 24801 | 35349 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1162 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 12 | Permit Number 38812 | 6012188.57169 | 2103037.28239 | 37.7552262409021 | -122.400792120955 | (37.7552262409021, -122.400792120955) | 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 | ||||
| 26909 | 35338 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 738 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38803 | 6013013.2913 | 2103555.40384 | 37.7566948554054 | -122.397976322051 | (37.7566948554054, -122.397976322051) | 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 | ||||
| 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 | ||||
| 39242 | 49995 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46738 | 6011567.97706 | 2104146.58896 | 37.7582375173758 | -122.403016353927 | (37.7582375173758, -122.403016353927) | 10 | 3 | 8 | 28856 | 29 | |
| 40910 | 50150 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 541@ 20TH ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/07/2003 12:00:00 AM | 6 | Permit Number 46869 | 6014129.22762 | 2104572.8122 | 37.7595505266559 | -122.394188205843 | (37.7595505266559, -122.394188205843) | 10 | 3 | 8 | 28856 | 29 | |
| 42211 | 37964 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 422 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40195 | 6013476.64244 | 2105094.41315 | 37.760946434546 | -122.396481747729 | (37.760946434546, -122.396481747729) | 10 | 3 | 8 | 28856 | 29 | |
| 45524 | 67540 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 619 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 5 | Permit Number 31080 | 6012728.40675 | 2104463.00984 | 37.7591710721042 | -122.399025265205 | (37.7591710721042, -122.399025265205) | 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 | ||||
| 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 | ||||
| 57164 | 32969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.7591000562486 | -122.394355852944 | (37.7591000562486, -122.394355852944) | 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 | ||||
| 61281 | 58816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1939 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31012 | 6012209.88383 | 2104659.20803 | 37.7596808806999 | -122.400832361144 | (37.7596808806999, -122.400832361144) | 10 | 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 | ||
| 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 | ||
| 71137 | 37945 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.399882680666 | (37.7581101796629, -122.399882680666) | 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 | ||||
| 74946 | 35366 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.14467 | 37.756647404478 | -122.40189800919 | (37.756647404478, -122.40189800919) | 10 | 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 | ||
| 85089 | 37988 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.395072877032 | (37.7585156794839, -122.395072877032) | 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 | ||||
| 93777 | 32977 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.7607925173727 | -122.393553179256 | (37.7607925173727, -122.393553179256) | 10 | 3 | 8 | 28856 | 29 | |
| 97978 | 68129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301 | (37.7581797826985, -122.39503416301) | 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 | ||||
| 99584 | 39586 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.7566097291779 | -122.401682552328 | (37.7566097291779, -122.401682552328) | 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 | ||||
| 102215 | 67601 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 13 | Permit Number 31171 | 6013574.79686 | 2104468.1921 | 37.7592324301472 | -122.396098384735 | (37.7592324301472, -122.396098384735) | 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 | ||
| 103087 | 37937 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40182 | 6012230.73908 | 2105130.49486 | 37.7609760932842 | -122.400793343137 | (37.7609760932842, -122.400793343137) | 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 | ||||
| 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 | ||||
| 113140 | 39551 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 814 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 6 | Permit Number 40977 | 6012407.86986 | 2104192.73872 | 37.7584111000042 | -122.40011486132 | (37.7584111000042, -122.40011486132) | 10 | 3 | 8 | 28856 | 29 | |
| 113967 | 32967 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | 10 | 3 | 8 | 28856 | 29 | |
| 117756 | 35348 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.400804834673 | (37.7553687870439, -122.400804834673) | 10 | 3 | 8 | 28856 | 29 | |
| 118867 | 39570 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | 10 | 3 | 8 | 28856 | 29 | |
| 118901 | 37938 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.79932 | 2105128.09339 | 37.7609678851705 | -122.400893265015 | (37.7609678851705, -122.400893265015) | 10 | 3 | 8 | 28856 | 29 | |
| 119742 | 39569 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.77687 | 2104583.27285 | 37.7594352029858 | -122.403130765671 | (37.7594352029858, -122.403130765671) | 10 | 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 | ||||
| 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 | ||
| 130836 | 62086 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 4 | Permit Number 22172 | 6013224.51154 | 2104585.93548 | 37.7595362319382 | -122.397318105545 | (37.7595362319382, -122.397318105545) | 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 | ||||
| 140964 | 39588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.11928 | 37.7562633193119 | -122.401863767506 | (37.7562633193119, -122.401863767506) | 10 | 3 | 8 | 28856 | 29 | |
| 141895 | 67581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.36958 | 37.7622066365616 | -122.39736679307 | (37.7622066365616, -122.39736679307) | 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 | ||||
| 147463 | 49994 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 8 | Permit Number 46738 | 6011568.01566 | 2104131.09801 | 37.7581949848158 | -122.403015130859 | (37.7581949848158, -122.403015130859) | 10 | 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 | ||||
| 149126 | 38643 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.398977968961 | (37.7565441236392, -122.398977968961) | 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 | ||||
| 150369 | 37965 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40196 | 6013488.00942657 | 2104993.46196391 | 37.7606698772605 | -122.396435357808 | (37.7606698772605, -122.396435357808) | 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 | ||||
| 157884 | 32980 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.06137 | 37.7593873374867 | -122.395154932952 | (37.7593873374867, -122.395154932952) | 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 | ||||
| 161520 | 41430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.397296450777 | (37.7593731443828, -122.397296450777) | 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 | ||||
| 173427 | 68130 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 636 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31881 | 6013816.64959872 | 2104131.08746025 | 37.75832026754 | -122.395238321176 | (37.75832026754, -122.395238321176) | 10 | 3 | 8 | 28856 | 29 | ||
| 174641 | 67525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | 10 | 3 | 8 | 28856 | 29 | |
| 179728 | 34310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 20 | 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 | ||||
| 183793 | 58933 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.28777 | 37.7528410841477 | -122.401525896729 | (37.7528410841477, -122.401525896729) | 10 | 3 | 8 | 28856 | 29 | ||
| 184316 | 34332 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 | 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 | ||||
| 184669 | 39568 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963434 | (37.7594620297563, -122.40312963434) | 10 | 3 | 8 | 28856 | 29 | |
| 185009 | 39550 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 815 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40976 | 6012466.96888 | 2104165.36194 | 37.7583392243866 | -122.399908546943 | (37.7583392243866, -122.399908546943) | 10 | 3 | 8 | 28856 | 29 | |
| 185042 | 32948 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.7623103112918 | -122.398349060474 | (37.7623103112918, -122.398349060474) | 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) );