trees
1,985 rows where qSpecies_id = 83 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49154 | 87400 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
168120 | 87401 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 11 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3450 | 52146 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2005 12:00:00 AM | Permit Number 48337 | |||||||||||||
3492 | 30592 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | ||
4690 | 66408 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | 2 | 7 | 7 | 28859 | 2 | ||
6409 | 61556 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360 | 2102825 | 37.7546529200548 | -122.400184359163 | (37.7546529200548, -122.400184359163) | 10 | 3 | 8 | 28856 | 29 | ||
7523 | 254506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | 6004702.10653 | 2115410.06007 | 37.7887784716518 | -122.427563979846 | (37.7887784716518, -122.427563979846) | 13 | 9 | 11 | 28858 | 27 | |
8584 | 21731 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.5114044 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | 13 | 9 | 11 | 29490 | 13 | ||
8679 | 63303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3270 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23869 | 6008997.33415907 | 2099641.55348585 | 37.7457238133599 | -122.411588497717 | (37.7457238133599, -122.411588497717) | 2 | 7 | 7 | 28859 | 2 | ||
8966 | 38869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | 1 | 8 | 3 | 29491 | 35 | ||
9184 | 88476 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51429 | 6015551.7 | 2096433.9 | 37.7372817351758 | -122.388700383218 | (37.7372817351758, -122.388700383218) | 10 | 3 | 8 | 58 | 1 | ||
9712 | 63295 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.7468255141172 | -122.414535115214 | (37.7468255141172, -122.414535115214) | 2 | 7 | 7 | 28859 | 2 | ||
9907 | 30593 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
10522 | 31312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.7763910940647 | -122.428032671161 | (37.7763910940647, -122.428032671161) | 7 | 9 | 11 | 28852 | 10 | |||
10528 | 96053 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | 2 | 7 | 7 | 28859 | 2 | |
11012 | 7356 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.7907946063198 | -122.434307574482 | (37.7907946063198, -122.434307574482) | 13 | 9 | 1 | 29490 | 27 | ||
11605 | 213995 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 6 | Width 3ft | Permit Number 32783 | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.443073900754 | (37.729960150431, -122.443073900754) | 9 | 7 | 4 | 63 | 40 | |
11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
12071 | 81939 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 28858 | 32 | ||
13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
14032 | 49886 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
14223 | 34240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
14546 | 63665 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.7475274359015 | -122.428684519984 | (37.7475274359015, -122.428684519984) | 2 | 4 | 5 | 63 | 22 | ||
15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
16573 | 33529 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.417175357737 | (37.7413321670111, -122.417175357737) | 2 | 7 | 7 | 28859 | 2 | |||
17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
18235 | 42453 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | 9 | 7 | 4 | 59 | 40 | ||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19630 | 69390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | 9 | 7 | 6 | 28861 | 5 | ||
20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
21156 | 16551 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
21197 | 63882 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3533 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24589 | 6004803.22751205 | 2103657.20146126 | 37.7565136952268 | -122.426376975449 | (37.7565136952268, -122.426376975449) | 2 | 4 | 5 | 28862 | 22 | ||
21709 | 47740 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.423713989591 | (37.7392981824927, -122.423713989591) | 2 | 7 | 7 | 28859 | 2 | |
22264 | 60143 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | 1 | 8 | 4 | 56 | 12 | ||
22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
22517 | 41240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
22548 | 10416 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.445280397708 | (37.7701488573322, -122.445280397708) | 15 | 5 | 11 | 29492 | 9 | |||
22631 | 52058 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | 2 | 7 | 7 | 28859 | 2 | |||
22986 | 93972 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3425X 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.7489504900318 | -122.418720633691 | (37.7489504900318, -122.418720633691) | 2 | 4 | 7 | 28859 | 19 | |
23197 | 95639 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
23281 | 43506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43184 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | |||
23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
23859 | 55920 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2480 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2006 12:00:00 AM | 3x3 | Permit Number 50600 | 6006935.48968262 | 2103919.31295705 | 37.7573536936319 | -122.419021429077 | (37.7573536936319, -122.419021429077) | 2 | 4 | 7 | 28859 | 19 | ||
24442 | 24127 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
25132 | 63326 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23899 | 6008102.76980253 | 2100057.0858479 | 37.746814552568 | -122.41471118136 | (37.746814552568, -122.41471118136) | 2 | 7 | 7 | 28859 | 2 | ||
25420 | 30655 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.7731639163293 | -122.417349579607 | (37.7731639163293, -122.417349579607) | 8 | 2 | 9 | 28853 | 19 |
25494 | 48801 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
25796 | 95782 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487 | 2104873 | 37.7598906214089 | -122.424098704222 | (37.7598906214089, -122.424098704222) | 2 | 4 | 5 | 28859 | 19 | |
26224 | 111868 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
26416 | 48800 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
26731 | 88124 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51128 | 6006494 | 2104554 | 37.7590715260193 | -122.42059333056 | (37.7590715260193, -122.42059333056) | 2 | 4 | 7 | 28859 | 19 | |||
26993 | 34292 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2758 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46984 | 6010209.51678065 | 2102837.66319596 | 37.7545675469901 | -122.407622236094 | (37.7545675469901, -122.407622236094) | 2 | 4 | 7 | 28859 | 19 | ||
27684 | 24086 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 141X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.385758322913 | (37.7360921261264, -122.385758322913) | 10 | 3 | 8 | 58 | 1 | ||
27967 | 30728 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
28462 | 7316 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002972.25432 | 2115230.97031 | 37.7881887410682 | -122.433536213059 | (37.7881887410682, -122.433536213059) | 13 | 9 | 1 | 29490 | 27 | |||
28645 | 111869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
28751 | 18256 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 12 | 4X4 | 6003320.917844 | 2114181.6927542 | 37.7853274664658 | -122.432254931219 | (37.7853274664658, -122.432254931219) | 13 | 9 | 11 | 29490 | 13 | ||
28895 | 115389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 378 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776292 | 6007259.3 | 2096222.3 | 37.7362376572368 | -122.417356112468 | (37.7362376572368, -122.417356112468) | 2 | 7 | 7 | 28859 | 2 | ||
29084 | 95303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
29106 | 47638 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
30035 | 53150 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1499@ LANE Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | 10 | 3 | 8 | 58 | 1 | |||
30163 | 96054 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524 | 2101832 | 37.7517678233481 | -122.409921957152 | (37.7517678233481, -122.409921957152) | 2 | 4 | 7 | 28859 | 19 | |
30900 | 59896 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 906 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | 2 | 4 | 7 | 28859 | 19 | ||
30981 | 69392 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.7124713889678 | -122.435199299374 | (37.7124713889678, -122.435199299374) | 9 | 7 | 6 | 28861 | 5 | ||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
32162 | 107809 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 174 14TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773719 | 6007550.6 | 2107982.4 | 37.7685446055333 | -122.417182034417 | (37.7685446055333, -122.417182034417) | 8 | 4 | 7 | 28853 | 19 | ||
32777 | 68466 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | 9 | 7 | 5 | 28861 | 25 | ||
33924 | 67694 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3330 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | Permit Number 31302 | 5998887.34453115 | 2115637.9553757 | 37.7890736016783 | -122.447698559552 | (37.7890736016783, -122.447698559552) | 13 | 6 | 1 | 54 | 31 | |
34051 | 52167 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48360 | 6009265.56204047 | 2099978.30779957 | 37.7466635086597 | -122.410684778697 | (37.7466635086597, -122.410684778697) | 2 | 7 | 7 | 28859 | 2 | ||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
34605 | 10379 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635 | (37.7705521343685, -122.44395792635) | 15 | 5 | 11 | 29492 | 9 | ||
34803 | 47635 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
35054 | 69098 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33113 | 5992499.06205436 | 2104168.35309074 | 37.757213980438 | -122.468965974451 | (37.757213980438, -122.468965974451) | 1 | 8 | 4 | 56 | 12 | ||
35078 | 39115 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 501 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50596 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | 2 | 4 | 7 | 28859 | 19 | ||
35148 | 69289 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1900 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33361 | 5990665.04614057 | 2102443.50433652 | 37.7523718663796 | -122.475182730707 | (37.7523718663796, -122.475182730707) | 1 | 8 | 4 | 29491 | 12 | ||
35271 | 111866 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | |||
35311 | 63346 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 149 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1987 12:00:00 AM | Permit Number 23920 | 6009928.22027252 | 2099880.94738001 | 37.746433309385 | -122.408386498152 | (37.746433309385, -122.408386498152) | 2 | 7 | 7 | 28859 | 2 | ||
35410 | 87680 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
35480 | 81725 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833 | 2102945.53994176 | 37.7551316851739 | -122.391004420622 | (37.7551316851739, -122.391004420622) | 10 | 3 | 8 | 28856 | 29 |
35647 | 34349 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51609 | 6004013.55416632 | 2096149.85411864 | 37.7358555876111 | -122.428572831878 | (37.7358555876111, -122.428572831878) | 2 | 7 | 5 | 63 | 7 | ||
35936 | 63312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23878 | 6010125.57376989 | 2099924.9230182 | 37.7465651066228 | -122.407707169195 | (37.7465651066228, -122.407707169195) | 2 | 7 | 7 | 28859 | 2 | ||
36501 | 8119 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | ||
36675 | 59905 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 925 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.2907688 | 2103816.25695251 | 37.7572410963252 | -122.40852203114 | (37.7572410963252, -122.40852203114) | 2 | 4 | 7 | 28859 | 19 | ||
37453 | 16492 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016524.6681965 | 2098330.497802 | 37.7425432844059 | -122.385468484111 | (37.7425432844059, -122.385468484111) | 10 | 3 | 8 | 58 | 1 | ||
37742 | 7193 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.55797 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | 7 | 9 | 11 | 29492 | 10 | ||
38546 | 63256 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 317 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1987 12:00:00 AM | 3x3 | Permit Number 23809 | 6006547.75913435 | 2104256.57264854 | 37.7582578891884 | -122.420386294584 | (37.7582578891884, -122.420386294584) | 2 | 4 | 7 | 28859 | 19 | |
39181 | 67145 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.407735447457 | (37.7448433809463, -122.407735447457) | 2 | 7 | 7 | 28859 | 2 | ||
39596 | 47559 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 309 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45421 | 6004167.03194558 | 2101865.16274932 | 37.7515571949372 | -122.428449439906 | (37.7515571949372, -122.428449439906) | 2 | 4 | 5 | 28862 | 22 |
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) );