trees
493 rows where qSpecies_id = 133 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167261 | 87776 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 333 Sussex St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129 | 2096659 | 37.737089918679 | -122.438582321394 | (37.737089918679, -122.438582321394) | 2 | 7 | 5 | 63 | 7 | |||
| 192031 | 87775 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 333 Sussex St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129 | 2096659 | 37.737089918679 | -122.438582321394 | (37.737089918679, -122.438582321394) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |
| 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 | ||
| 4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 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 | ||
| 5637 | 223045 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.7451501107949 | -122.413843827126 | (37.7451501107949, -122.413843827126) | 2 | 7 | 7 | 28859 | 2 | |||
| 7001 | 225622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 67 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997067.03037 | 2106173.30325 | 37.7629819312842 | -122.453312997018 | (37.7629819312842, -122.453312997018) | 15 | 5 | 11 | 29492 | 12 | |||
| 8549 | 206676 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | ||
| 10122 | 52665 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815 | 2109317 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | 15 | 5 | 11 | 29492 | 9 | |
| 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 | |||
| 12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
| 16376 | 190928 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1778 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.392882024183 | (37.73426491189, -122.392882024183) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 18421 | 122404 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
| 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 | |
| 24681 | 206641 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.7480798753848 | -122.462020618849 | (37.7480798753848, -122.462020618849) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 25370 | 28296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.422648971496 | (37.7482499542668, -122.422648971496) | 2 | 4 | 5 | 28859 | 19 | ||
| 25644 | 206545 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994446.42204 | 2100465.35227 | 37.747158803252 | -122.461962779858 | (37.747158803252, -122.461962779858) | 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 | ||
| 26895 | 24597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.416856984981 | (37.7391518611665, -122.416856984981) | 2 | 7 | 7 | 28859 | 2 | ||
| 27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 28113 | 206685 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.456081163331 | (37.734938180348, -122.456081163331) | 9 | 7 | 4 | 59 | 40 | |||
| 31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 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 | |
| 32772 | 255586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 39852 | 206617 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | 1 | 8 | 4 | 59 | 40 | |||
| 40090 | 206631 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994365.26522 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | 1 | 8 | 4 | 29491 | 40 | |||
| 40567 | 206697 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998934.95382 | 2095541.69667 | 37.7338970145182 | -122.446087759167 | (37.7338970145182, -122.446087759167) | 9 | 7 | 4 | 59 | 40 | |||
| 40601 | 223023 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006515.40022 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
| 45262 | 94075 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
| 45301 | 206523 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 46206 | 206638 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994538.83302 | 2100858.65401 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | 1 | 8 | 4 | 29491 | 40 | |||
| 47287 | 82780 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 3946 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50814 | 6003353.51076321 | 2104798.51931181 | 37.7595654262957 | -122.43147208276 | (37.7595654262957, -122.43147208276) | 2 | 4 | 5 | 28862 | 3 | ||
| 47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
| 47735 | 206689 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.455762520949 | (37.734869823774, -122.455762520949) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 49813 | 206568 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991380.56657 | 2098286.24678 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | 1 | 8 | 4 | 29491 | 40 | |||
| 50752 | 206547 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993889.30878 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | 1 | 8 | 4 | 29491 | 40 | |||
| 52294 | 28791 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.411895265148 | (37.7535963186214, -122.411895265148) | 2 | 4 | 7 | 28859 | 19 | |||
| 52405 | 223051 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 24 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001422.87059 | 2107990.68113 | 37.7682207070445 | -122.438377882942 | (37.7682207070445, -122.438377882942) | 15 | 5 | 5 | 29492 | 3 | |||
| 52410 | 206639 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994510.39425 | 2100823.87441 | 37.7481468973818 | -122.461767562235 | (37.7481468973818, -122.461767562235) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
| 54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
| 54867 | 206505 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993138.76599 | 2102124.24037 | 37.7516383146611 | -122.466605072187 | (37.7516383146611, -122.466605072187) | 1 | 8 | 4 | 29491 | 12 | |||
| 55272 | 95906 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) | 1 | 8 | 3 | 56 | 35 |
| 55830 | 41230 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41935 | 6002625.18254 | 2121047.68706 | 37.804140238442 | -122.435153221671 | (37.804140238442, -122.435153221671) | 13 | 9 | 1 | 57 | 17 |
| 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 | ||
| 56805 | 206593 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995062.08104 | 2100706.46988 | 37.7478562769412 | -122.459851357851 | (37.7478562769412, -122.459851357851) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 58588 | 206536 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 62155 | 206498 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | 1 | 8 | 4 | 56 | 12 | |||
| 62868 | 206543 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994159.12368 | 2101087.06957 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 63519 | 206524 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.7427160965819 | -122.467054169341 | (37.7427160965819, -122.467054169341) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||
| 64571 | 206665 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.7482853390143 | -122.463983980089 | (37.7482853390143, -122.463983980089) | 1 | 8 | 4 | 29491 | 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 | |
| 65411 | 82956 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
| 65845 | 223047 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||
| 68821 | 206588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | 1 | 8 | 4 | 29491 | 40 | |||
| 68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
| 70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
| 70335 | 206597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995049.66416 | 2100868.50319 | 37.7483004655893 | -122.459906030335 | (37.7483004655893, -122.459906030335) | 1 | 8 | 4 | 29491 | 40 | |||
| 70495 | 206635 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994551.94388 | 2100907.90537 | 37.7483800169362 | -122.461629977657 | (37.7483800169362, -122.461629977657) | 1 | 8 | 4 | 29491 | 40 | |||
| 70629 | 104352 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 304 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | Permit Number 770823 | 6001744.6 | 2103958.8 | 37.7571684409617 | -122.436976369496 | (37.7571684409617, -122.436976369496) | 2 | 4 | 5 | 28862 | 3 | |||
| 70967 | 28792 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008964.24348 | 2102548.86607 | 37.7537047894643 | -122.411908330514 | (37.7537047894643, -122.411908330514) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );