trees
6,714 rows where qSpecies_id = 7 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
1550 | 201970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 21 | : | Tree | Private 2 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.7255753034535 | -122.39458193082 | (37.7255753034535, -122.39458193082) | 10 | 3 | 8 | 58 | 1 | |||
3087 | 201271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013058.71274 | 2092794.89099 | 37.7271512843849 | -122.397064767443 | (37.7271512843849, -122.397064767443) | 10 | 3 | 8 | 58 | 1 | |||
3643 | 202263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 Orsi Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013104.38405 | 2093156.20787 | 37.7281459291672 | -122.396932202872 | (37.7281459291672, -122.396932202872) | 10 | 3 | 8 | 58 | 1 | |||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
4448 | 202285 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Issleib Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012731.44947 | 2093293.25918 | 37.7285014779546 | -122.398231071208 | (37.7285014779546, -122.398231071208) | 10 | 3 | 8 | 58 | 1 | |||
6039 | 60368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | 10 | 3 | 8 | 58 | 1 | |
6629 | 61206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 154 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 18 | Permit Number 21074 | 6011186.84016 | 2095845.15313 | 37.735422284496 | -122.403750383288 | (37.735422284496, -122.403750383288) | 10 | 3 | 8 | 58 | 1 | |
6715 | 67660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 37 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 6 | Permit Number 31261 | 6014167.43331 | 2093890.78969 | 37.7302220581813 | -122.393308558267 | (37.7302220581813, -122.393308558267) | 10 | 3 | 8 | 58 | 1 | |
7792 | 81654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014140.03196 | 2096118.29222 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | 10 | 3 | 8 | 58 | 1 | |||
7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
10588 | 82677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1627 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014950.6191 | 2094457.8846 | 37.7318226671335 | -122.390640571691 | (37.7318226671335, -122.390640571691) | 10 | 3 | 8 | 58 | 1 | |||
11912 | 38551 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1843 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40519 | 6015881.5256 | 2093201.6545 | 37.7284249117339 | -122.387334607185 | (37.7284249117339, -122.387334607185) | 10 | 3 | 8 | 58 | 1 | |
12073 | 201265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013080.9244 | 2093125.28837 | 37.728059724652 | -122.397011137269 | (37.728059724652, -122.397011137269) | 10 | 3 | 8 | 58 | 1 | |||
12409 | 60388 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1454 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 1 | Permit Number 19968 | 6015694.2103 | 2094682.8814 | 37.7324816889757 | -122.388085495957 | (37.7324816889757, -122.388085495957) | 10 | 3 | 8 | 58 | 1 | |
12620 | 83942 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015103.3012 | 2090231.7832 | 37.7202271035042 | -122.389817632552 | (37.7202271035042, -122.389817632552) | 10 | 3 | 8 | 58 | 1 | |||
13104 | 88055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498 | 2095923.9 | 37.7357116661186 | -122.399222709682 | (37.7357116661186, -122.399222709682) | 10 | 3 | 8 | 58 | 1 | |||
13333 | 196273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.7299348462003 | -122.377699306103 | (37.7299348462003, -122.377699306103) | 10 | 3 | 8 | 58 | 1 | |||
13712 | 202138 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2639 Newhall St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012756.67365 | 2093454.87992 | 37.728946660355 | -122.398155203507 | (37.728946660355, -122.398155203507) | 10 | 3 | 8 | 58 | 1 | |||
15961 | 38550 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1843 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 4 | Permit Number 40519 | 6015868.3053 | 2093186.7815 | 37.7283833412514 | -122.387379273723 | (37.7283833412514, -122.387379273723) | 10 | 3 | 8 | 58 | 1 | |
16650 | 40009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.40419 | 37.7325888031102 | -122.377001897143 | (37.7325888031102, -122.377001897143) | 10 | 3 | 8 | 58 | 1 | |
17001 | 25978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2027 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/1997 12:00:00 AM | 8 | 6x9 | 6012757.29387 | 2097148.77262 | 37.7390893573798 | -122.398412142527 | (37.7390893573798, -122.398412142527) | 10 | 3 | 8 | 58 | 1 | ||
18855 | 201262 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 31 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013038.33649 | 2093158.36768 | 37.728148182884 | -122.397160684615 | (37.728148182884, -122.397160684615) | 10 | 3 | 8 | 58 | 1 | |||
19870 | 196269 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.384189093646 | (37.7366779736991, -122.384189093646) | 10 | 3 | 8 | 58 | 1 | ||||
20173 | 202278 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Issleib Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012794.62426 | 2093266.55306 | 37.7284316671769 | -122.398010798468 | (37.7284316671769, -122.398010798468) | 10 | 3 | 8 | 58 | 1 | |||
20174 | 49363 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1875@ EVANS Marin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | Permit Number 46338 | 6014150.89902 | 2100527.87809 | 37.748445208788 | -122.39383011827 | (37.748445208788, -122.39383011827) | 10 | 3 | 8 | 58 | 1 | ||
20295 | 202167 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013164.54762 | 2093230.83795 | 37.7283541968866 | -122.396729443526 | (37.7283541968866, -122.396729443526) | 10 | 3 | 8 | 58 | 1 | |||
20946 | 61220 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 183 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21089 | 6011247.61241309 | 2095606.91351198 | 37.7347715236074 | -122.403523513548 | (37.7347715236074, -122.403523513548) | 10 | 3 | 8 | 58 | 1 | ||
23709 | 196266 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1121 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013242.63936 | 2090155.46784 | 37.71991419797 | -122.39624402185 | (37.71991419797, -122.39624402185) | 10 | 3 | 8 | 58 | 1 | ||||
23941 | 202290 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 21 Issleib Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6012710.5854 | 2093261.62049 | 37.7284134424104 | -122.398300980932 | (37.7284134424104, -122.398300980932) | 10 | 3 | 8 | 58 | 1 | |||
24125 | 201244 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 105 Orsi Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012833.80846 | 2093200.62135 | 37.7282528145083 | -122.397870712864 | (37.7282528145083, -122.397870712864) | 10 | 3 | 8 | 58 | 1 | |||
24366 | 202304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 152 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012919.13392 | 2092996.02429 | 37.7276957843337 | -122.397561393738 | (37.7276957843337, -122.397561393738) | 10 | 3 | 8 | 58 | 1 | |||
24708 | 200494 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3239 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6013526.9457 | 2090055.2492 | 37.7196548333297 | -122.395254249665 | (37.7196548333297, -122.395254249665) | 10 | 3 | 8 | 58 | 1 | |||
25437 | 196192 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2198 Revere Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011951.07495 | 2096769.01879 | 37.7380016885201 | -122.40117301982 | (37.7380016885201, -122.40117301982) | 10 | 3 | 8 | 58 | 1 | ||||
25551 | 49513 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.7313926432313 | -122.391199634158 | (37.7313926432313, -122.391199634158) | 10 | 3 | 8 | 58 | 1 | |||
26360 | 102164 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 152 Venus St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012823.11721 | 2094145.77539 | 37.730847417966 | -122.397973948736 | (37.730847417966, -122.397973948736) | 10 | 3 | 8 | 58 | 1 | |||
27740 | 201904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1797 Yosemite Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013567.70299 | 2093393.69523 | 37.7288238003734 | -122.395347110876 | (37.7288238003734, -122.395347110876) | 10 | 3 | 8 | 58 | 1 | |||
28216 | 30766 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.7296430696457 | -122.391775180038 | (37.7296430696457, -122.391775180038) | 10 | 3 | 8 | 58 | 1 | |
28429 | 67658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 49 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31259 | 6014158.60184 | 2093846.43818 | 37.7300997872766 | -122.39333598759 | (37.7300997872766, -122.39333598759) | 10 | 3 | 8 | 58 | 1 | |
28872 | 61221 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 187 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21090 | 6011249.15974517 | 2095578.53600395 | 37.7346936913888 | -122.403516168003 | (37.7346936913888, -122.403516168003) | 10 | 3 | 8 | 58 | 1 | ||
29530 | 201971 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013754.58016 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | 10 | 3 | 8 | 58 | 1 | ||||
29885 | 201246 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6012841.59753 | 2093210.95668 | 37.7282816269891 | -122.397844510228 | (37.7282816269891, -122.397844510228) | 10 | 3 | 8 | 58 | 1 | |||
32833 | 201250 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012872.65843 | 2093256.71698 | 37.7284090051552 | -122.397740339042 | (37.7284090051552, -122.397740339042) | 10 | 3 | 8 | 58 | 1 | |||
33841 | 38588 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40543 | 6015225.14493834 | 2094611.56119995 | 37.7322598587405 | -122.389702200572 | (37.7322598587405, -122.389702200572) | 10 | 3 | 8 | 58 | 1 | ||
33967 | 202280 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Issleib Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012765.10374 | 2093281.55159 | 37.7284712058626 | -122.398113904838 | (37.7284712058626, -122.398113904838) | 10 | 3 | 8 | 58 | 1 | |||
35691 | 196180 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 Phelps St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012050.36585 | 2093618.49269 | 37.7293565407635 | -122.400608465023 | (37.7293565407635, -122.400608465023) | 10 | 3 | 8 | 58 | 1 | |||
36325 | 196175 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Loomis St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010680.80162 | 2097387.89186 | 37.7396300334118 | -122.40560858139 | (37.7396300334118, -122.40560858139) | 10 | 3 | 8 | 58 | 1 | |||
38834 | 38585 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40543 | 6015181.5104 | 2094639.0656 | 37.7323329605685 | -122.389854976867 | (37.7323329605685, -122.389854976867) | 10 | 3 | 8 | 58 | 1 | |
39721 | 38587 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015156.0012 | 2094654.7636 | 37.7323746494327 | -122.38994426497 | (37.7323746494327, -122.38994426497) | 10 | 3 | 8 | 58 | 1 | |
39737 | 201947 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 16 | : | Tree | Private 2 | 2 | Width 3ft | 6013508.30345 | 2092417.86904 | 37.7261410759436 | -122.395484123498 | (37.7261410759436, -122.395484123498) | 10 | 3 | 8 | 58 | 1 | |||
40089 | 202283 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Issleib Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012747.30589 | 2093289.67502 | 37.7284925198065 | -122.398176003013 | (37.7284925198065, -122.398176003013) | 10 | 3 | 8 | 58 | 1 | |||
41547 | 87176 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1784 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50145 | 6014123.92226 | 2095138.61734 | 37.7336459211168 | -122.393546280538 | (37.7336459211168, -122.393546280538) | 10 | 3 | 8 | 58 | 1 | |
42107 | 196183 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012510.53762 | 2095915.58622 | 37.7356895369409 | -122.399178778585 | (37.7356895369409, -122.399178778585) | 10 | 3 | 8 | 58 | 1 | |||
43474 | 202271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 46 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012970.02613 | 2093256.16358 | 37.7284129073171 | -122.397403693121 | (37.7284129073171, -122.397403693121) | 10 | 3 | 8 | 58 | 1 | |||
45203 | 196177 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Loomis St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010674.89584 | 2097305.58115 | 37.7394036956138 | -122.405623205253 | (37.7394036956138, -122.405623205253) | 10 | 3 | 8 | 58 | 1 | |||
45317 | 66153 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 242 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | Permit Number 29224 | 6012823.28895075 | 2093870.94233966 | 37.7300927925387 | -122.397954082844 | (37.7300927925387, -122.397954082844) | 10 | 3 | 8 | 58 | 1 | ||
46741 | 202281 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Issleib Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012758.71023 | 2093283.81873 | 37.7284770748534 | -122.398136166665 | (37.7284770748534, -122.398136166665) | 10 | 3 | 8 | 58 | 1 | |||
46839 | 40018 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014428.09341 | 2094657.08868 | 37.7323406379015 | -122.392460993976 | (37.7323406379015, -122.392460993976) | 10 | 3 | 8 | 58 | 1 | |
47225 | 202262 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 Orsi Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013109.49623 | 2093152.37862 | 37.7281356993906 | -122.396914261397 | (37.7281356993906, -122.396914261397) | 10 | 3 | 8 | 58 | 1 | |||
47570 | 196181 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2545 Phelps St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012082.65235 | 2093663.02061 | 37.7294806058403 | -122.400499973489 | (37.7294806058403, -122.400499973489) | 10 | 3 | 8 | 58 | 1 | |||
48070 | 67680 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1523 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31284 | 6014960.4779 | 2093407.781 | 37.7289398410715 | -122.390533137865 | (37.7289398410715, -122.390533137865) | 10 | 3 | 8 | 58 | 1 | |
48143 | 201248 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012850.34034 | 2093222.7449 | 37.7283144819158 | -122.397815112298 | (37.7283144819158, -122.397815112298) | 10 | 3 | 8 | 58 | 1 | |||
48179 | 38589 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1606 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40544 | 6015214.8687 | 2094687.4678 | 37.7324677131079 | -122.389743028049 | (37.7324677131079, -122.389743028049) | 10 | 3 | 8 | 58 | 1 | |
48375 | 201251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6012888.05364 | 2093268.37063 | 37.7284418610013 | -122.397687933748 | (37.7284418610013, -122.397687933748) | 10 | 3 | 8 | 58 | 1 | |||
48600 | 202291 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012719.32075 | 2093257.8431 | 37.7284035570619 | -122.398270517286 | (37.7284035570619, -122.398270517286) | 10 | 3 | 8 | 58 | 1 | |||
48744 | 88051 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1351 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51061 | 6016378.6669 | 2093395.5533 | 37.7289848397566 | -122.385629457357 | (37.7289848397566, -122.385629457357) | 10 | 3 | 8 | 58 | 1 | |
50144 | 196277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015638.97442 | 2096745.3057 | 37.7381416284363 | -122.388420361625 | (37.7381416284363, -122.388420361625) | 10 | 3 | 8 | 58 | 1 | |||
50673 | 201945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 12 | : | Tree | Private 2 | 2 | Width 3ft | 6013588.62557 | 2092382.18651 | 37.7260475662288 | -122.395203954116 | (37.7260475662288, -122.395203954116) | 10 | 3 | 8 | 58 | 1 | |||
50728 | 196276 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.7386027405173 | -122.387223765075 | (37.7386027405173, -122.387223765075) | 10 | 3 | 8 | 58 | 1 | |||
51966 | 40016 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25X Bay View St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50722 | 6014347.1001 | 2094717.00207 | 37.7325006497719 | -122.392745198625 | (37.7325006497719, -122.392745198625) | 10 | 3 | 8 | 58 | 1 | |
52341 | 196169 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Loomis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010702.39769 | 2097617.59529 | 37.7402619573204 | -122.405550084975 | (37.7402619573204, -122.405550084975) | 10 | 3 | 8 | 58 | 1 | |||
52876 | 201991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1751 Carroll Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6013485.64387 | 2092346.48409 | 37.7259438069368 | -122.395557457834 | (37.7259438069368, -122.395557457834) | 10 | 3 | 8 | 58 | 1 | |||
53147 | 201984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6013594.77768 | 2092310.70039 | 37.7258516219291 | -122.395177681321 | (37.7258516219291, -122.395177681321) | 10 | 3 | 8 | 58 | 1 | |||
54193 | 201266 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013111.33657 | 2093102.58113 | 37.7279990680861 | -122.396904409335 | (37.7279990680861, -122.396904409335) | 10 | 3 | 8 | 58 | 1 | |||
54282 | 200053 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1555 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015307.2832 | 2094192.9021 | 37.7311148594787 | -122.38938900173 | (37.7311148594787, -122.38938900173) | 10 | 3 | 8 | 58 | 1 | |||
54448 | 201247 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012845.77859 | 2093216.57871 | 37.7282972967771 | -122.397830450224 | (37.7282972967771, -122.397830450224) | 10 | 3 | 8 | 58 | 1 | |||
54953 | 201270 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013065.62044 | 2092803.81329 | 37.7271761677359 | -122.397041512758 | (37.7271761677359, -122.397041512758) | 10 | 3 | 8 | 58 | 1 | |||
55214 | 196270 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 3 | Median : Yard | Tree | DPW 1 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | 10 | 3 | 8 | 58 | 1 | ||||
55341 | 202294 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012769.01912 | 2093237.37262 | 37.7283501175462 | -122.398097270977 | (37.7283501175462, -122.398097270977) | 10 | 3 | 8 | 58 | 1 | |||
55418 | 46463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 31 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 8 | Permit Number 44667 | 6013974.32308 | 2095449.03509 | 37.7344899510581 | -122.394085216368 | (37.7344899510581, -122.394085216368) | 10 | 3 | 8 | 58 | 1 | ||
55481 | 201976 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 15 | : | Tree | Private 2 | 5 | Width 3ft | 6013710.28394 | 2092247.91618 | 37.7256856520577 | -122.394773986446 | (37.7256856520577, -122.394773986446) | 10 | 3 | 8 | 58 | 1 | |||
57963 | 202273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012938.89237 | 2093280.23143 | 37.7284772592045 | -122.397513012032 | (37.7284772592045, -122.397513012032) | 10 | 3 | 8 | 58 | 1 | |||
58026 | 202139 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2635 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012761.28148 | 2093461.72838 | 37.7289657214742 | -122.398139754066 | (37.7289657214742, -122.398139754066) | 10 | 3 | 8 | 58 | 1 |
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) );