trees
493 rows where qSpecies_id = 133 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 701 | 52560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.7543488257224 | -122.497901608629 | (37.7543488257224, -122.497901608629) | 1 | 8 | 3 | 56 | 35 | |
| 1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
| 1328 | 65972 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1990 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.7486477564753 | -122.480306841406 | (37.7486477564753, -122.480306841406) | 1 | 8 | 3 | 29491 | 35 | |
| 1435 | 68125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.7444006509706 | -122.421806351312 | (37.7444006509706, -122.421806351312) | 2 | 7 | 5 | 28859 | 2 | ||
| 4849 | 43803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.482009746097 | (37.7733720498685, -122.482009746097) | 11 | 6 | 2 | 55 | 26 | ||
| 6774 | 249677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 9 | Front Yard : Yard | Tree | Private 2 | 9 | 5999741.70445 | 2117184.69909 | 37.7933693451834 | -122.444853823654 | (37.7933693451834, -122.444853823654) | 13 | 9 | 1 | 57 | 27 | ||||
| 9241 | 65804 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.473841275381 | (37.7459566686168, -122.473841275381) | 1 | 8 | 4 | 29491 | 40 | ||
| 10338 | 31751 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | 1 | 8 | 3 | 29491 | 35 | |
| 10533 | 71420 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | 3 | 1 | 10 | 308 | 23 | |||
| 13396 | 42456 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.7331328776169 | -122.450478486701 | (37.7331328776169, -122.450478486701) | 9 | 7 | 4 | 59 | 40 | ||
| 13518 | 31915 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | 1 | 8 | 4 | 29491 | 40 | |
| 14716 | 39658 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
| 18339 | 70315 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 226 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997860.8667 | 2109778.6627 | 37.7729267975155 | -122.450827376517 | (37.7729267975155, -122.450827376517) | 15 | 5 | 11 | 29492 | 16 | |||
| 18348 | 98409 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 55 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||||
| 18410 | 68121 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.7451912827439 | -122.421094842871 | (37.7451912827439, -122.421094842871) | 2 | 7 | 7 | 28859 | 2 | ||
| 22790 | 63803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.410751365299 | (37.7385764323817, -122.410751365299) | 10 | 7 | 7 | 28859 | 2 | ||
| 23516 | 50918 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | 1 | 8 | 3 | 29491 | 35 | |
| 25175 | 65811 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | 1 | 8 | 4 | 29491 | 40 | ||
| 26466 | 34431 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38175 | 6002613.57489862 | 2096408.07550267 | 37.7364852770817 | -122.433431554421 | (37.7364852770817, -122.433431554421) | 2 | 7 | 5 | 63 | 7 | ||
| 27571 | 69506 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.411531974789 | (37.7369238689745, -122.411531974789) | 10 | 7 | 7 | 28859 | 2 | ||
| 27614 | 65799 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.7467507369343 | -122.473717291816 | (37.7467507369343, -122.473717291816) | 1 | 8 | 4 | 29491 | 40 | ||
| 31240 | 47741 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1384 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.407999079784 | (37.7499146097647, -122.407999079784) | 2 | 4 | 7 | 28859 | 19 | ||
| 32620 | 31228 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.7385237494811 | -122.47111005511 | (37.7385237494811, -122.47111005511) | 1 | 8 | 4 | 29491 | 40 | |
| 32898 | 51448 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | 2 | 7 | 7 | 28859 | 2 | |||
| 33319 | 54717 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | 2 | 4 | 5 | 28862 | 22 | ||
| 33731 | 67340 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.7519606958911 | -122.403505842523 | (37.7519606958911, -122.403505842523) | 10 | 4 | 8 | 28859 | 19 | ||
| 34205 | 45120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 34239 | 46345 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | 2 | 4 | 5 | 28859 | 19 | ||
| 34434 | 38590 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.7325603247077 | -122.389906003807 | (37.7325603247077, -122.389906003807) | 10 | 3 | 8 | 58 | 1 | |
| 34836 | 58683 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | 2 | 7 | 7 | 28859 | 2 | ||
| 34876 | 45122 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 36175 | 68120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.7453405673201 | -122.421200665955 | (37.7453405673201, -122.421200665955) | 2 | 7 | 5 | 28859 | 2 | ||
| 37816 | 62939 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.419076042669 | (37.7386903299864, -122.419076042669) | 2 | 7 | 7 | 28859 | 2 | ||
| 38562 | 66726 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 416 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31446 | 6003651.13955938 | 2102766.75784402 | 37.7540035558201 | -122.430297777513 | (37.7540035558201, -122.430297777513) | 2 | 4 | 5 | 28862 | 22 | ||
| 38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 42279 | 126381 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1022 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6008596.52569 | 2118672.84077 | 37.7979567725457 | -122.414320748412 | (37.7979567725457, -122.414320748412) | 5 | 1 | 10 | 308 | 21 | ||||
| 42534 | 66157 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1765 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | Permit Number 29228 | 6013882.21689766 | 2094959.68148484 | 37.7331411667579 | -122.394369408432 | (37.7331411667579, -122.394369408432) | 10 | 3 | 8 | 58 | 1 | ||
| 42650 | 68124 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31872 | 6006189.84017158 | 2099400.84484915 | 37.7449049995041 | -122.421279326768 | (37.7449049995041, -122.421279326768) | 2 | 7 | 7 | 28859 | 2 | ||
| 44899 | 51539 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
| 45934 | 69199 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | 2 | 4 | 7 | 28859 | 19 | ||
| 47893 | 62968 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1136 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23354 | 6007556.73602589 | 2118875.23289672 | 37.7984540273893 | -122.417933081039 | (37.7984540273893, -122.417933081039) | 5 | 1 | 10 | 28858 | 32 | ||
| 47942 | 48500 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1584(REVISED) Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46340 | 5998006.8549345 | 2108237.90665559 | 37.7687046321234 | -122.450211308243 | (37.7687046321234, -122.450211308243) | 15 | 5 | 11 | 29492 | 9 | |||
| 48275 | 41698 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
| 48670 | 249686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 18 | Front Yard : Yard | Tree | Private 2 | 4 | 5999708.23219 | 2117360.34158 | 37.7938497027636 | -122.444982272037 | (37.7938497027636, -122.444982272037) | 13 | 9 | 1 | 57 | 27 | ||||
| 48817 | 41708 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.435194188204 | (37.7355450223799, -122.435194188204) | 2 | 7 | 5 | 63 | 7 | ||
| 52088 | 126383 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1116 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | 5 | 1 | 1 | 28858 | 32 | ||||
| 52691 | 63792 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4094 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24478 | 6003252.0069668 | 2101284.19573809 | 37.7499101740217 | -122.431572236451 | (37.7499101740217, -122.431572236451) | 2 | 4 | 5 | 28862 | 22 | ||
| 54361 | 62908 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.417497229597 | (37.7390843209207, -122.417497229597) | 2 | 7 | 7 | 28859 | 2 | ||
| 55106 | 102412 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
| 56077 | 51543 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | 2 | 4 | 7 | 28859 | 19 | ||
| 57352 | 68501 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.7515356020282 | -122.466420909066 | (37.7515356020282, -122.466420909066) | 1 | 8 | 4 | 29491 | 12 | ||
| 57524 | 47492 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.436445238065 | (37.7277113821718, -122.436445238065) | 9 | 7 | 6 | 28861 | 25 | |
| 58439 | 39660 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | 9 | 8 | 6 | 28861 | 24 | ||
| 61766 | 35377 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | 10 | 3 | 7 | 309 | 28 | ||
| 63437 | 60436 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 474 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.7435369501722 | -122.430530149996 | (37.7435369501722, -122.430530149996) | 2 | 7 | 5 | 63 | 22 | ||
| 64516 | 40751 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 65048 | 30759 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1563 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48354 | 6014932.9973 | 2093776.0212 | 37.7299494300904 | -122.390653863275 | (37.7299494300904, -122.390653863275) | 10 | 3 | 8 | 58 | 1 | |
| 66516 | 53193 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.7459214666672 | -122.419059278748 | (37.7459214666672, -122.419059278748) | 2 | 7 | 7 | 28859 | 2 | ||
| 72234 | 43002 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
| 73339 | 51538 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
| 78140 | 53145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1498@ KEITH Underwood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
| 80974 | 62145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.423928154749 | (37.7454017512266, -122.423928154749) | 2 | 7 | 5 | 28859 | 22 | ||
| 82530 | 68702 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | 11 | 6 | 2 | 54 | 11 | ||
| 85017 | 51537 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
| 85025 | 48468 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.7464863595987 | -122.431306366847 | (37.7464863595987, -122.431306366847) | 2 | 7 | 5 | 63 | 22 | ||
| 86127 | 32398 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.59209 | 37.7358062077876 | -122.421800215602 | (37.7358062077876, -122.421800215602) | 2 | 7 | 7 | 28859 | 2 | |
| 87754 | 43489 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.7344536647683 | -122.413002801242 | (37.7344536647683, -122.413002801242) | 10 | 7 | 7 | 28859 | 2 | ||
| 89550 | 65967 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | 1 | 8 | 3 | 29491 | 35 | |
| 89950 | 63825 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.7386885782033 | -122.411368915099 | (37.7386885782033, -122.411368915099) | 10 | 7 | 7 | 28859 | 2 | ||
| 90444 | 45125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 215 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2001 12:00:00 AM | Permit Number 43982 | 6001423.51922816 | 2108204.04749997 | 37.7688065951097 | -122.438390927701 | (37.7688065951097, -122.438390927701) | 15 | 5 | 5 | 29492 | 3 | ||
| 91240 | 51948 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48172 | 5996897.19536074 | 2106034.05471344 | 37.7625898542367 | -122.453890338129 | (37.7625898542367, -122.453890338129) | 15 | 5 | 11 | 29492 | 12 | ||||
| 91882 | 121558 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
| 92863 | 47756 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | 1 | 8 | 4 | 29491 | 40 | |||
| 94644 | 45119 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 95062 | 62709 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.7982515357622 | -122.418390975112 | (37.7982515357622, -122.418390975112) | 5 | 1 | 10 | 28858 | 32 | ||
| 96900 | 62944 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.7385700935458 | -122.41866583942 | (37.7385700935458, -122.41866583942) | 2 | 7 | 7 | 28859 | 2 | ||
| 99436 | 47077 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | Permit Number 45064 | 5996788.5617 | 2112098.8644 | 37.7792360227866 | -122.454704245524 | (37.7792360227866, -122.454704245524) | 15 | 6 | 2 | 54 | 16 | |
| 99489 | 68122 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31870 | 6006226.82006776 | 2099469.59440232 | 37.7450958550009 | -122.42115633768 | (37.7450958550009, -122.42115633768) | 2 | 7 | 7 | 28859 | 2 | ||
| 100325 | 33392 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | 9 | 8 | 4 | 59 | 40 | ||
| 101641 | 35101 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | 9 | 7 | 6 | 28861 | 5 | ||
| 101700 | 247588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6 | 6008943.01163 | 2096440.06729 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | 10 | 7 | 7 | 28859 | 2 | ||||
| 104910 | 31750 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | 1 | 8 | 3 | 29491 | 35 | |
| 105415 | 54097 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.7595947080418 | -122.441471294748 | (37.7595947080418, -122.441471294748) | 2 | 4 | 5 | 28862 | 3 | ||
| 106219 | 34302 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | 10 | 4 | 7 | 28859 | 19 | ||
| 109592 | 60142 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | 1 | 8 | 4 | 56 | 12 | ||
| 110106 | 63000 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.7632845753318 | -122.501897691969 | (37.7632845753318, -122.501897691969) | 1 | 8 | 3 | 56 | 35 | ||
| 110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
| 111443 | 62943 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | 2 | 7 | 7 | 28859 | 2 | ||
| 111603 | 62913 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | 2 | 7 | 7 | 28859 | 2 | ||
| 112602 | 63806 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.410835957293 | (37.7396522194543, -122.410835957293) | 10 | 7 | 7 | 28859 | 2 | ||
| 115399 | 61289 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | 2 | 7 | 7 | 28859 | 2 | ||
| 115810 | 63593 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24225 | 6005185.44614551 | 2109584.80310454 | 37.7728110766439 | -122.425476960922 | (37.7728110766439, -122.425476960922) | 7 | 9 | 11 | 28852 | 10 | ||
| 117813 | 39659 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
| 119747 | 38530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | 1 | 8 | 3 | 29491 | 35 | ||
| 123013 | 31753 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | 1 | 8 | 3 | 29491 | 35 | |
| 123118 | 67138 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | 2 | 7 | 7 | 28859 | 2 | ||
| 123517 | 49836 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 572 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/2005 12:00:00 AM | Permit Number 46619 | 6011764.04798466 | 2105724.17808831 | 37.7625801734793 | -122.402449179614 | (37.7625801734793, -122.402449179614) | 8 | 3 | 8 | 28856 | 29 | ||
| 126854 | 47123 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.7538871618551 | -122.472003987589 | (37.7538871618551, -122.472003987589) | 1 | 8 | 4 | 56 | 12 | ||
| 126897 | 45118 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 126962 | 62916 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.7379096064175 | -122.415800456905 | (37.7379096064175, -122.415800456905) | 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) );