1,794 rows where qSpecies_id = 95 sorted by PermitNotes descending

View and edit SQL

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)
118199 66519 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 541 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29690 6001212.14254636 2103158.94045257 37.7549419418957 -122.438760494243 (37.7549419418957, -122.438760494243) 2 4 5 28862 22
186053 58261 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 284 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29595 6006300.27949858 2096057.24015103 37.7357304355186 -122.420660133777 (37.7357304355186, -122.420660133777) 2 7 7 28859 2
43647 66445 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 276 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29591 6006234.06842317 2096062.82287391 37.7357420325633 -122.420889447827 (37.7357420325633, -122.420889447827) 2 7 7 28859 2
186651 66444 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 273 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29590 6006205.33193134 2096117.4303664 37.7358903527924 -122.420992677212 (37.7358903527924, -122.420992677212) 2 7 7 28859 2
78134 66434 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 150 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29577 6005801.93494772 2096621.96113828 37.7372529340664 -122.422423220071 (37.7372529340664, -122.422423220071) 2 7 7 28859 2
105348 66432 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 107 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29575 6005403.67297656 2096707.579185 37.737465547355 -122.423806282291 (37.737465547355, -122.423806282291) 2 7 7 28859 2
1102 64618 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 355 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29568 6008648.33494852 2097105.55483154 37.7387409360622 -122.412616048547 (37.7387409360622, -122.412616048547) 10 7 7 28859 2
64470 66406 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 469 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/1994 12:00:00 AM     Permit Number 29533 6008066.29398858 2096676.66265185 37.7375306085819 -122.414598135932 (37.7375306085819, -122.414598135932) 2 7 7 28859 2
7453 66398 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29524 6007445.87739968 2096478.55020646 37.7369517596137 -122.41672918389 (37.7369517596137, -122.41672918389) 2 7 7 28859 2
28609 66395 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 506 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29521 6007446.79828476 2096488.59897918 37.7369794031279 -122.41672671165 (37.7369794031279, -122.41672671165) 2 7 7 28859 2
127118 66393 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 741 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29519 6007775.9235659 2095463.88536749 37.7341842695898 -122.415516248299 (37.7341842695898, -122.415516248299) 2 7 7 28859 2
61445 66389 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 711 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29515 6007791.32662379 2095624.44985276 37.7346260104333 -122.41547435861 (37.7346260104333, -122.41547435861) 2 7 7 28859 2
40120 66387 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 576 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29513 6003809.30522061 2109740.24975223 37.7731600457631 -122.430248280428 (37.7731600457631, -122.430248280428) 7 9 11 29492 10
166941 66373 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 430 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29497 6003708.35294884 2109810.61822809 37.7733475417865 -122.430602509574 (37.7733475417865, -122.430602509574) 7 9 11 29492 10
137438 66370 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 710 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29494 6007739.56425491 2095629.41545125 37.7346367352991 -122.415653670559 (37.7346367352991, -122.415653670559) 2 7 7 28859 2
74743 66336 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1375 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29457 5986460.37044852 2105898.71353348 37.7616143266352 -122.489977094753 (37.7616143266352, -122.489977094753) 1 8 3 56 35
4704 66332 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1281 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29451 5986438.31541273 2106539.79781677 37.7633732787357 -122.490100529708 (37.7633732787357, -122.490100529708) 1 8 3 56 35
87505 58249 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2936 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29323 6008661.6896202 2103338.05557277 37.7558547466953 -122.41301042999 (37.7558547466953, -122.41301042999) 2 4 7 28859 19
63081 66223 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 327 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29316 6002952.06445401 2106334.50861663 37.7637601214743 -122.432970220281 (37.7637601214743, -122.432970220281) 15 4 5 28862 3
77613 66110 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 124 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29164 6005954.05152204 2110038.74835026 37.7741008978737 -122.422850531283 (37.7741008978737, -122.422850531283) 7 9 11 28852 10
120043 66001 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 108 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/1990 12:00:00 AM     Permit Number 29035 5993679.00648095 2114788.42006519 37.7864419630214 -122.465656849013 (37.7864419630214, -122.465656849013) 11 6 2 54 11
131509 65878 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 105 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/04/1995 12:00:00 AM     Permit Number 28878 6006704.56280084 2099036.35030326 37.7439331851068 -122.419473653112 (37.7439331851068, -122.419473653112) 2 7 7 28859 2
110240 65871 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1752 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/1994 12:00:00 AM     Permit Number 28868 5990097.67417811 2113393.33539301 37.782404230168 -122.477945198533 (37.782404230168, -122.477945198533) 11 6 2 55 26
186398 65692 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3511 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1990 12:00:00 AM     Permit Number 28619 6006132.70987406 2102560.60291656 37.7535777519299 -122.42170125957 (37.7535777519299, -122.42170125957) 2 4 5 28859 19
45483 60173 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 34 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28606 6005972.95021061 2105301.90279734 37.7610957130227 -122.422448512825 (37.7610957130227, -122.422448512825) 2 4 5 28859 19
101738 65671 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28591 5999036.51165566 2095907.91255274 37.7349083558011 -122.445762972308 (37.7349083558011, -122.445762972308) 9 7 4 59 40
54084 65542 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2132 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/20/1990 12:00:00 AM     Permit Number 28439 6002392.00985574 2114400.8403139 37.7858764773821 -122.435484349614 (37.7858764773821, -122.435484349614) 13 6 1 29490 27
60495 65487 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1010 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1989 12:00:00 AM     Permit Number 28371 6008641.31301466 2115618.72283106 37.7895734304719 -122.413949606824 (37.7895734304719, -122.413949606824) 5 1 10 28858 21
116879 65462 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 901 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28340 5995002.55717105 2089937.23341469 37.7182831614911 -122.459277439941 (37.7182831614911, -122.459277439941) 9 8 6 28861 24
99260 65369 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 109 Roanoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28207 6003410.83232501 2096243.47479324 37.7360785209393 -122.430663356711 (37.7360785209393, -122.430663356711) 2 7 5 63 7
180278 65361 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 7 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28196 6002832.7941803 2095807.19286717 37.7348478258508 -122.432630712358 (37.7348478258508, -122.432630712358) 2 7 5 63 7
24315 65352 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 252 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28187 6001484.29754015 2096470.76224415 37.736593266506 -122.437340424735 (37.736593266506, -122.437340424735) 2 7 5 63 7
186096 65343 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 184 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28175 6001750.39660253 2095029.30684218 37.7326504865842 -122.436317277562 (37.7326504865842, -122.436317277562) 9 7 5 63 40
49102 65342 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 186 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28174 6001746.84094237 2095012.67377274 37.7326046139677 -122.436328380361 (37.7326046139677, -122.436328380361) 9 7 5 63 40
39199 65341 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 188 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28173 6001746.6239921 2095001.97603702 37.732575228117 -122.436328365067 (37.732575228117, -122.436328365067) 9 7 5 63 40
114509 65331 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 141 Brompton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28154 6002111.55813884 2095203.52869324 37.7331493741938 -122.435081111485 (37.7331493741938, -122.435081111485) 9 7 5 63 40
174834 65309 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 57 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28128 6006032.10149289 2105174.27390914 37.7607486106903 -122.422234865835 (37.7607486106903, -122.422234865835) 2 4 5 28859 19
38656 65308 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 64 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28127 6005982.44079017 2105130.61413387 37.7606259299013 -122.422403517998 (37.7606259299013, -122.422403517998) 2 4 5 28859 19
3135 65233 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4020 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM     Permit Number 28024 6003001.20160757 2102438.8847262 37.7530664584471 -122.432521998877 (37.7530664584471, -122.432521998877) 2 4 5 28862 22
42338 56192 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 268 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 27265 6003395.85932684 2101584.17918102 37.7507420106161 -122.431096196827 (37.7507420106161, -122.431096196827) 2 4 5 28862 22
69242 65098 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 238 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM     Permit Number 27063 5989343.04620868 2113752.02171468 37.7833452544598 -122.480582115258 (37.7833452544598, -122.480582115258) 11 6 2 55 26
118548 64949 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 855 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1992 12:00:00 AM     Permit Number 25980 6000877.59992491 2102564.82101666 37.7532915955721 -122.439874838937 (37.7532915955721, -122.439874838937) 2 4 5 28862 22
128955 64624 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 33 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1988 12:00:00 AM     Permit Number 25532 6006024.66397845 2105308.50827264 37.7611167672578 -122.422270126257 (37.7611167672578, -122.422270126257) 2 4 5 28859 19
79998 64527 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1411 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25409 6016035.70677774 2094698.28418833 37.7325428963772 -122.386905924583 (37.7325428963772, -122.386905924583) 10 3 8 58 1
20208 64478 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2463 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1988 12:00:00 AM 1   Permit Number 25351 5984544.9144 2098464.8556 37.7410909641146 -122.496053326033 (37.7410909641146, -122.496053326033) 1 8 3 29491 35
167021 60960 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 100 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1988 12:00:00 AM     Permit Number 25349 5994476.34646497 2090599.97936006 37.7200726359376 -122.461144327567 (37.7200726359376, -122.461144327567) 9 8 6 28861 24
41525 64413 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 125 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/1988 12:00:00 AM     Permit Number 25260 6003685.70575404 2097659.19041399 37.7399813214783 -122.429813955945 (37.7399813214783, -122.429813955945) 2 7 5 63 7
189339 64316 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 68 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/1988 12:00:00 AM     Permit Number 25133 6004266.78630985 2097807.98626151 37.740422769496 -122.427815418773 (37.740422769496, -122.427815418773) 2 7 5 63 7
104821 64268 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1988 12:00:00 AM     Permit Number 25071 6010264.47432516 2099824.85360013 37.7462981125223 -122.407219810784 (37.7462981125223, -122.407219810784) 2 7 7 28859 2
177279 64197 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2351 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1987 12:00:00 AM 5   Permit Number 24984 5983591.0003 2099130.015 37.7428613915447 -122.499400705995 (37.7428613915447, -122.499400705995) 1 8 3 29491 35
28451 64133 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 610 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24904 6002610.61709759 2098908.05619778 37.7433494776015 -122.433620394679 (37.7433494776015, -122.433620394679) 2 7 5 63 22
106788 64121 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 375 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24892 6003475.30119676 2099489.67816755 37.7449955011148 -122.430672035562 (37.7449955011148, -122.430672035562) 2 7 5 63 22
55063 64109 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1262 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1987 12:00:00 AM     Permit Number 24876 5992716.50604713 2106873.85756884 37.764655146266 -122.468410805367 (37.764655146266, -122.468410805367) 11 8 11 56 12
40029 64108 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1309 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1987 12:00:00 AM     Permit Number 24875 5992366.07339581 2106530.90838195 37.7636932511992 -122.469597880241 (37.7636932511992, -122.469597880241) 1 8 11 56 12
65078 64099 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1486 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1987 12:00:00 AM     Permit Number 24865 5992148.37568635 2105335.31486201 37.7603978830466 -122.470263751239 (37.7603978830466, -122.470263751239) 1 8 4 56 12
10572 64091 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1369 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1987 12:00:00 AM     Permit Number 24855 5992379.50854829 2106140.38206588 37.7626217456567 -122.469522982654 (37.7626217456567, -122.469522982654) 1 8 11 56 12
180759 64001 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 474 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24748 6002109.57147902 2100928.27320982 37.7488680757283 -122.435497369218 (37.7488680757283, -122.435497369218) 2 4 5 28862 22
112299 61371 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 666 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24723 6003005.23530154 2104469.02923152 37.7586409802374 -122.432653055314 (37.7586409802374, -122.432653055314) 2 4 5 28862 3
163763 63895 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4072 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24604 6003387.44157701 2101291.75530451 37.7499386063134 -122.431104436753 (37.7499386063134, -122.431104436753) 2 4 5 28862 22
6751 63860 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 30 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24561 6007749.20433051 2099287.05180109 37.7446803396676 -122.415879261586 (37.7446803396676, -122.415879261586) 2 7 7 28859 2
64222 63848 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1483 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24545 6002073.44175228 2111529.25048836 37.7779737208393 -122.436380911725 (37.7779737208393, -122.436380911725) 15 5 11 29492 41
109372 63789 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 4052 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24475 6003510.56398759 2101298.62763972 37.749964452248 -122.430679163861 (37.749964452248, -122.430679163861) 2 4 5 28862 22
66653 63766 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 401 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24444 6003192.52222029 2109638.52781799 37.7728457879591 -122.432374545195 (37.7728457879591, -122.432374545195) 15 9 11 29492 9
120630 63764 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 311 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24442 6003235.24732503 2109330.82245921 37.7720033272962 -122.4322047752 (37.7720033272962, -122.4322047752) 15 9 11 29492 9
168877 63763 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 326 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM   4x4 Permit Number 24441 6003279.4994369 2109390.21547957 37.7721689148553 -122.432055945851 (37.7721689148553, -122.432055945851) 15 9 11 29492 10
29218 63761 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 343 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24438 6003220.73981685 2109435.30524559 37.7722893887759 -122.43226242096 (37.7722893887759, -122.43226242096) 15 9 11 29492 9
50956 63760 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 540 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24437 6003973.39193973 2109763.08680608 37.7732320433706 -122.429682312236 (37.7732320433706, -122.429682312236) 7 9 11 29492 10
125737 63759 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 350 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24436 6003268.61880609 2109468.57756707 37.7723834610111 -122.432099179795 (37.7723834610111, -122.432099179795) 15 9 11 29492 10
108504 63758 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 425 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24434 6003181.69109256 2109716.53339488 37.7730593578892 -122.432417583748 (37.7730593578892, -122.432417583748) 15 9 11 29492 9
168128 63755 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 832 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24429 6002579.84478406 2109569.92728925 37.7726226680298 -122.434488959034 (37.7726226680298, -122.434488959034) 15 5 11 29492 9
119117 63752 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 722 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24425 6003101.35751437 2109641.71994707 37.772849383001 -122.432690122287 (37.772849383001, -122.432690122287) 15 5 11 29492 9
36368 63741 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 430 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24413 6003230.48917651 2109743.18641692 37.7731353074733 -122.432250688999 (37.7731353074733, -122.432250688999) 15 9 11 29492 10
149176 63737 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 573 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24406 6003834.70515324 2109691.28362316 37.7730270354143 -122.43015692487 (37.7730270354143, -122.43015692487) 7 9 11 29492 10
15794 63736 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 585 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24405 6003780.00958588 2109683.67127267 37.7730030357559 -122.430345580362 (37.7730030357559, -122.430345580362) 7 9 11 29492 10
83304 63735 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 550 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24404 6003927.8122889 2109756.74317909 37.7732120443049 -122.429839525756 (37.7732120443049, -122.429839525756) 7 9 11 29492 10
47550 63734 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 547 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24403 6003953.21225561 2109707.77705475 37.7730790336555 -122.429748170749 (37.7730790336555, -122.429748170749) 7 9 11 29492 10
174388 63732 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 529 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24401 6004035.25561517 2109719.19558167 37.7731150315991 -122.429465186856 (37.7731150315991, -122.429465186856) 7 9 11 29492 10
130596 63731 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24400 6004110.13087942 2109782.11768526 37.7732920393038 -122.429210671215 (37.7732920393038, -122.429210671215) 7 9 11 29492 10
120503 58678 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 596 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24398 6003287.0157035 2109320.57844586 37.7719781347946 -122.43202497289 (37.7719781347946, -122.43202497289) 15 9 11 29492 10
127902 63721 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1514 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1987 12:00:00 AM     Permit Number 24386 5994014.04224353 2105188.52907983 37.7601025343618 -122.463800671203 (37.7601025343618, -122.463800671203) 1 5 4 56 12
90215 63710 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 150 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1987 12:00:00 AM     Permit Number 24372 6007410.32173139 2100162.00836053 37.7470637164949 -122.417113040024 (37.7470637164949, -122.417113040024) 2 7 7 28859 2
46624 63704 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1525 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/1987 12:00:00 AM     Permit Number 24362 5993654.89413585 2105110.90329162 37.7598686915317 -122.465037145143 (37.7598686915317, -122.465037145143) 1 8 4 56 12
108298 63701 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1695 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/1987 12:00:00 AM     Permit Number 24359 5993694.00181738 2103975.33927352 37.7567529819836 -122.464819425397 (37.7567529819836, -122.464819425397) 1 8 4 56 12
115167 63674 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 911 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1987 12:00:00 AM     Permit Number 24326 5999505.51324752 2111590.21998339 37.7779948811468 -122.445268639971 (37.7779948811468, -122.445268639971) 15 5 11 54 16
160118 63660 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 423 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24308 6003762.6367623 2100089.82328361 37.7466596348506 -122.429721277679 (37.7466596348506, -122.429721277679) 2 7 5 63 22
151497 63643 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 615 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1987 12:00:00 AM     Permit Number 24290 6001076.3999006 2110778.3153622 37.7758551396753 -122.439776172675 (37.7758551396753, -122.439776172675) 15 5 11 29492 10
180393 63584 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2401 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/19/1992 12:00:00 AM     Permit Number 24210 6006688.3941557 2119426.77030347 37.7999195019292 -122.420976997553 (37.7999195019292, -122.420976997553) 5 9 1 28858 32
68535 63540 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 233 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 24155 6006519.70197429 2104750.62788328 37.7596128689136 -122.420518398132 (37.7596128689136, -122.420518398132) 2 4 7 28859 19
111224 63491 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 322 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/07/1987 12:00:00 AM     Permit Number 24088 6006678.91959152 2096025.3142964 37.7356641070309 -122.41934876099 (37.7356641070309, -122.41934876099) 2 7 7 28859 2
60553 63490 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 321 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/07/1987 12:00:00 AM     Permit Number 24087 6006664.43404789 2096078.72019387 37.7358099319641 -122.419402630752 (37.7358099319641, -122.419402630752) 2 7 7 28859 2
124918 63439 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 330 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/07/1987 12:00:00 AM     Permit Number 24082 6006754.33769911 2096018.95525185 37.7356508938671 -122.419087560051 (37.7356508938671, -122.419087560051) 2 7 7 28859 2
97839 63454 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 650 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1987 12:00:00 AM     Permit Number 24044 6007400.45392955 2095982.88563367 37.7355882186861 -122.416851127023 (37.7355882186861, -122.416851127023) 2 7 7 28859 2
63960 63440 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 312 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24027 6006584.64694822 2096033.26310282 37.735680622673 -122.419675262327 (37.735680622673, -122.419675262327) 2 7 7 28859 2
87480 63437 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 344 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24024 6006886.3193962 2096007.82692315 37.7356277694356 -122.418630458599 (37.7356277694356, -122.418630458599) 2 7 7 28859 2
117669 63436 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 345 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24023 6006890.68838828 2096059.64305875 37.7357702910917 -122.418619026584 (37.7357702910917, -122.418619026584) 2 7 7 28859 2
161771 63435 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 377 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/1992 12:00:00 AM     Permit Number 24021 6007192.36078339 2096034.20688354 37.7357174284993 -122.41757422253 (37.7357174284993, -122.41757422253) 2 7 7 28859 2
156480 63434 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 386 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1987 12:00:00 AM     Permit Number 24020 6007282.26446985 2095974.44193855 37.7355583855051 -122.417259156011 (37.7355583855051, -122.417259156011) 2 7 7 28859 2
133519 63420 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 331 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 24004 6006758.70669119 2096070.77138745 37.7357934155669 -122.419076128909 (37.7357934155669, -122.419076128909) 2 7 7 28859 2
34446 63419 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 360 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 24003 6007037.15561138 2095995.10883407 37.7356013393444 -122.418108057323 (37.7356013393444, -122.418108057323) 2 7 7 28859 2
31098 63328 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 75 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1987 12:00:00 AM     Permit Number 23901 6009622.07115368 2099898.67232456 37.7464648291666 -122.409446382283 (37.7464648291666, -122.409446382283) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);