trees
1,794 rows where qSpecies_id = 95 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28558 | 45475 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1355 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44760 | 5999364.2117528 | 2089872.65901255 | 37.7183556553422 | -122.444196457807 | (37.7183556553422, -122.444196457807) | 9 | 7 | 6 | 28861 | 25 | ||
88673 | 46386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2151 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 4 | Permit Number 44621 | 5982613.7645 | 2100468.6607 | 37.7464795596965 | -122.502878732612 | (37.7464795596965, -122.502878732612) | 1 | 8 | 3 | 29491 | 35 | |
83787 | 44436 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 445 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43769 | 6002209.45256 | 2087683.95984 | 37.7125078834094 | -122.434205282273 | (37.7125078834094, -122.434205282273) | 9 | 7 | 6 | 28861 | 5 | |
22975 | 44428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | |
29456 | 44432 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
41816 | 44422 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
53065 | 44430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002242.73231 | 2086958.14042 | 37.7105168311469 | -122.434038405862 | (37.7105168311469, -122.434038405862) | 9 | 7 | 6 | 28861 | 5 | |
57997 | 44419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002078.76238 | 2086879.79851 | 37.7102924143218 | -122.434599522549 | (37.7102924143218, -122.434599522549) | 9 | 7 | 6 | 28861 | 5 | |
82780 | 44427 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
85575 | 44435 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
92641 | 44418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002034.50312 | 2086862.32419 | 37.7102419210068 | -122.434751242692 | (37.7102419210068, -122.434751242692) | 9 | 7 | 6 | 28861 | 5 | |
121881 | 44429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002292.23602 | 2086990.00901 | 37.7106071446722 | -122.433869586918 | (37.7106071446722, -122.433869586918) | 9 | 7 | 6 | 28861 | 5 | |
144843 | 44434 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002147.41851 | 2086908.48033 | 37.7103750656342 | -122.434364282404 | (37.7103750656342, -122.434364282404) | 9 | 7 | 6 | 28861 | 5 | |
150367 | 44421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002090.25454 | 2086883.74706 | 37.7103039085691 | -122.434560085477 | (37.7103039085691, -122.434560085477) | 9 | 7 | 6 | 28861 | 5 | |
160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
186446 | 44425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.41887 | 2086971.04816 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | 9 | 7 | 6 | 28861 | 5 | |
187397 | 44423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.44633 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | 9 | 7 | 6 | 28861 | 5 | |
191044 | 44433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.7103892965003 | -122.434330380639 | (37.7103892965003, -122.434330380639) | 9 | 7 | 6 | 28861 | 5 | |
116419 | 44362 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 122 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2001 12:00:00 AM | Permit Number 43732 | 6004263.48669743 | 2097466.09211909 | 37.7394838194805 | -122.427802472727 | (37.7394838194805, -122.427802472727) | 2 | 7 | 5 | 63 | 7 | ||
177076 | 42697 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2502 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42714 | 6007504.11437077 | 2120942.44037002 | 37.8041270967963 | -122.41826181189 | (37.8041270967963, -122.41826181189) | 5 | 1 | 1 | 308 | 32 | ||
16873 | 42653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2535 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3 | Permit Number 42692 | 5983938.8438 | 2098078.9039 | 37.7399957282306 | -122.498120370006 | (37.7399957282306, -122.498120370006) | 1 | 8 | 3 | 29491 | 35 | |
118149 | 42658 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2535 40th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 2 | Permit Number 42692 | 5983941.4429 | 2097950.2495 | 37.7396426305337 | -122.498101884746 | (37.7396426305337, -122.498101884746) | 1 | 8 | 3 | 29491 | 35 | |
22936 | 42216 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 202X Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | 3X3 | Permit Number 42481 | 6009500.82528 | 2109156.27117 | 37.7718773055291 | -122.410519244875 | (37.7718773055291, -122.410519244875) | 8 | 2 | 9 | 28853 | 34 |
48213 | 38489 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1055 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1998 12:00:00 AM | 13 | Permit Number 40486 | 6007984.75241 | 2118886.10151 | 37.7985079490502 | -122.416452778391 | (37.7985079490502, -122.416452778391) | 5 | 1 | 10 | 28858 | 21 | |
162707 | 37343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 517 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 4 | Permit Number 39851 | 5999456.75939 | 2086965.30426 | 37.7103779965068 | -122.443667813037 | (37.7103779965068, -122.443667813037) | 9 | 7 | 6 | 28861 | 5 | |
77888 | 33924 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1515 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1997 12:00:00 AM | Permit Number 37890 | 6013177.07893091 | 2105178.79303275 | 37.761161447817 | -122.39752373182 | (37.761161447817, -122.39752373182) | 10 | 3 | 8 | 28856 | 29 | ||
181601 | 32299 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2367 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 4 | Permit Number 36876 | 5986385.1371 | 2099149.8309 | 37.7430793369104 | -122.489740950968 | (37.7430793369104, -122.489740950968) | 1 | 8 | 3 | 29491 | 35 | ||
120412 | 30883 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 349 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 6 | Permit Number 34716 | 6003375.91635 | 2104458.66105 | 37.7586335266217 | -122.431370332299 | (37.7586335266217, -122.431370332299) | 2 | 4 | 5 | 28862 | 3 | ||
121551 | 30727 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Rose St | 3 | 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 | ||
15446 | 69493 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 328 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33616 | 5999811.39724946 | 2091920.22474562 | 37.7240033047922 | -122.44279767888 | (37.7240033047922, -122.44279767888) | 9 | 7 | 6 | 28861 | 25 | ||
66310 | 69429 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 600 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1994 12:00:00 AM | Permit Number 33535 | 6010075.47588455 | 2105486.09758826 | 37.7618320485731 | -122.408272572771 | (37.7618320485731, -122.408272572771) | 2 | 4 | 8 | 28859 | 19 | ||
142369 | 69300 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1680 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33375 | 5999724.98067163 | 2110906.29768043 | 37.7761295304752 | -122.444460261753 | (37.7761295304752, -122.444460261753) | 15 | 5 | 11 | 29492 | 16 | ||
40097 | 69202 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2834 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33250 | 6008944.32524952 | 2101948.50839104 | 37.7520552245421 | -122.411934790422 | (37.7520552245421, -122.411934790422) | 2 | 4 | 7 | 28859 | 19 | ||
20886 | 69078 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1230 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33086 | 5992088.88490345 | 2107064.56024544 | 37.7651424933412 | -122.470595450908 | (37.7651424933412, -122.470595450908) | 11 | 8 | 11 | 56 | 12 | ||
79755 | 69070 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1418 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33078 | 5991822.68540229 | 2105767.59730493 | 37.7615659811295 | -122.471421651008 | (37.7615659811295, -122.471421651008) | 1 | 8 | 4 | 56 | 12 | ||
139928 | 68917 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1918 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32897 | 6007769.38511 | 2118997.74512 | 37.79880238078 | -122.417205933618 | (37.79880238078, -122.417205933618) | 5 | 1 | 10 | 308 | 32 | |
78067 | 68914 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1535 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32893 | 6005691.62707628 | 2118555.83678979 | 37.7974719031724 | -122.424364211095 | (37.7974719031724, -122.424364211095) | 13 | 9 | 1 | 57 | 17 | ||
33800 | 56191 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 261 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32887 | 6003447.98693949 | 2101534.97756971 | 37.7506098682705 | -122.430912424073 | (37.7506098682705, -122.430912424073) | 2 | 4 | 5 | 28862 | 22 | ||
153567 | 68793 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2646 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32732 | 5991785.3639189 | 2097418.62404016 | 37.7386397061499 | -122.470942510825 | (37.7386397061499, -122.470942510825) | 1 | 8 | 4 | 29491 | 40 | ||
68096 | 68705 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3725 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32713 | 6004069.33935091 | 2105955.57435513 | 37.7627829682463 | -122.429078889929 | (37.7627829682463, -122.429078889929) | 8 | 4 | 5 | 28862 | 3 | ||
110357 | 68762 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 93 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32685 | 6003698.93163887 | 2105058.11986312 | 37.7602977987445 | -122.430295967154 | (37.7602977987445, -122.430295967154) | 2 | 4 | 5 | 28862 | 3 | ||
145710 | 68754 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4027 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32675 | 6002837.14243413 | 2104717.78949819 | 37.7593144819421 | -122.43325217118 | (37.7593144819421, -122.43325217118) | 2 | 4 | 5 | 28862 | 3 | ||
119875 | 68377 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32201 | 5998862.2729582 | 2105376.5533863 | 37.7608969909824 | -122.447046553817 | (37.7608969909824, -122.447046553817) | 15 | 5 | 11 | 29492 | 12 | ||
91249 | 68114 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 9 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31860 | 6006758.25542917 | 2099860.24648368 | 37.7461984425313 | -122.419346431514 | (37.7461984425313, -122.419346431514) | 2 | 7 | 7 | 28859 | 2 | ||
105592 | 67940 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31654 | 6004325.71338197 | 2095631.509904 | 37.7344499921484 | -122.427456658692 | (37.7344499921484, -122.427456658692) | 2 | 7 | 5 | 28861 | 25 | ||
56599 | 61202 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Augusta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31589 | 6011219.14011918 | 2095497.57320599 | 37.734469707782 | -122.403614262052 | (37.734469707782, -122.403614262052) | 10 | 3 | 8 | 58 | 1 | ||
186777 | 67811 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 463 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31464 | 6002153.43837175 | 2101463.35632849 | 37.7503397784586 | -122.435383948576 | (37.7503397784586, -122.435383948576) | 2 | 4 | 5 | 28862 | 22 | ||
45327 | 67805 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 315 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31455 | 6003122.14394995 | 2100931.82111177 | 37.7489352745962 | -122.43199614953 | (37.7489352745962, -122.43199614953) | 2 | 4 | 5 | 28862 | 22 | ||
106473 | 67781 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 79 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31415 | 6003192.55557478 | 2107842.98857257 | 37.7679156790923 | -122.432246173934 | (37.7679156790923, -122.432246173934) | 15 | 5 | 5 | 28862 | 3 | ||
61779 | 67779 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 408 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31413 | 6003736.32174931 | 2109035.86372191 | 37.771221840054 | -122.430450471743 | (37.771221840054, -122.430450471743) | 15 | 9 | 11 | 29492 | 10 | ||
43959 | 67770 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3674 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31400 | 6002444.03832554 | 2106508.42696552 | 37.764208830163 | -122.434739761942 | (37.764208830163, -122.434739761942) | 15 | 5 | 5 | 28862 | 3 | ||
133959 | 67749 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1278 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31373 | 5994888.54131742 | 2106834.07089825 | 37.7646711211609 | -122.460895481422 | (37.7646711211609, -122.460895481422) | 15 | 5 | 11 | 56 | 12 | ||
23273 | 54625 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1477 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31366 | 5994572.27016889 | 2105483.42771481 | 37.7609444021205 | -122.461891425583 | (37.7609444021205, -122.461891425583) | 1 | 5 | 11 | 56 | 12 | ||
194210 | 67740 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1412 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31359 | 5993990.22084457 | 2105880.95703345 | 37.7620023888233 | -122.463933320103 | (37.7620023888233, -122.463933320103) | 1 | 5 | 11 | 56 | 12 | ||
2246 | 67733 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1373 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1992 12:00:00 AM | Permit Number 31352 | 5992380.40422552 | 2106114.34696678 | 37.7625503119139 | -122.469517989556 | (37.7625503119139, -122.469517989556) | 1 | 8 | 11 | 56 | 12 | ||
62472 | 67728 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 516 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31347 | 5997107.4486428 | 2107419.61483204 | 37.7664063016043 | -122.453263185466 | (37.7664063016043, -122.453263185466) | 15 | 5 | 11 | 29492 | 8 | ||
82948 | 67722 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31340 | 5994188.99575396 | 2106012.43408376 | 37.7623748438685 | -122.463255380988 | (37.7623748438685, -122.463255380988) | 1 | 5 | 11 | 56 | 12 | ||
184207 | 67721 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31339 | 5994171.17810275 | 2106011.82451063 | 37.7623721436591 | -122.463316960916 | (37.7623721436591, -122.463316960916) | 1 | 5 | 11 | 56 | 12 | ||
96275 | 67696 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1802 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2002 12:00:00 AM | Permit Number 31305 | 6004401.173369 | 2118429.46678994 | 37.7970519696736 | -122.428820506832 | (37.7970519696736, -122.428820506832) | 13 | 9 | 1 | 57 | 17 | ||
45005 | 67586 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 320 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31151 | 6014299.12968665 | 2105631.25303268 | 37.7624662173131 | -122.393674678003 | (37.7624662173131, -122.393674678003) | 10 | 3 | 8 | 28856 | 29 | ||
179896 | 63641 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 701 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31106 | 6001035.54169923 | 2111072.80974441 | 37.7766614211292 | -122.43993863172 | (37.7766614211292, -122.43993863172) | 15 | 5 | 11 | 29492 | 41 | ||
49431 | 67556 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1995 12:00:00 AM | Permit Number 31105 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | ||
180526 | 67545 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1015 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 3x3 | Permit Number 31091 | 6012211.61416229 | 2103662.25645514 | 37.7569435678624 | -122.400756337014 | (37.7569435678624, -122.400756337014) | 10 | 3 | 8 | 28856 | 29 | |
141432 | 66260 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31088 | 5996714.47770615 | 2098535.27666339 | 37.7419896054085 | -122.453980699646 | (37.7419896054085, -122.453980699646) | 9 | 7 | 4 | 59 | 40 | ||
139809 | 67527 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1190 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31065 | 6014447.49903376 | 2104834.36670867 | 37.7602863840457 | -122.393105757767 | (37.7602863840457, -122.393105757767) | 10 | 3 | 8 | 28856 | 29 | ||
184533 | 67508 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31038 | 5997945.14259478 | 2094073.25690369 | 37.7298084538174 | -122.449404054305 | (37.7298084538174, -122.449404054305) | 9 | 7 | 4 | 28861 | 40 | ||
168535 | 67507 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 427 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31037 | 5997919.84331621 | 2094073.6426889 | 37.7298080658571 | -122.449491544159 | (37.7298080658571, -122.449491544159) | 9 | 7 | 4 | 28861 | 40 | ||
119091 | 67481 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1598 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 31004 | 6001509.57860385 | 2111503.53144301 | 37.777871047567 | -122.438329667297 | (37.777871047567, -122.438329667297) | 15 | 5 | 11 | 29490 | 41 | ||
63369 | 67474 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1658 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30996 | 6001647.35172607 | 2111869.10246706 | 37.778882648645 | -122.437879253527 | (37.778882648645, -122.437879253527) | 15 | 5 | 11 | 29490 | 41 | ||
159191 | 67468 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30989 | 5996784.33302359 | 2098587.30616541 | 37.7421364707665 | -122.453742919924 | (37.7421364707665, -122.453742919924) | 9 | 7 | 4 | 59 | 40 | ||
13164 | 55911 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 116 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30988 | 5996731.08358072 | 2098564.41624229 | 37.7420705676821 | -122.453925386093 | (37.7420705676821, -122.453925386093) | 9 | 7 | 4 | 59 | 40 | ||
167246 | 56610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 117 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 30987 | 5996756.33540734 | 2098503.70250218 | 37.7419053104165 | -122.453833690323 | (37.7419053104165, -122.453833690323) | 9 | 7 | 4 | 59 | 40 | ||
40649 | 67453 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1088 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2010 12:00:00 AM | Permit Number 30960 | 6007819.98571592 | 2118911.65470292 | 37.7985688445608 | -122.417024735457 | (37.7985688445608, -122.417024735457) | 5 | 1 | 10 | 308 | 32 | |||
91757 | 56888 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 379 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30734 | 6003470.66871359 | 2108600.18569561 | 37.7700105227729 | -122.431338270509 | (37.7700105227729, -122.431338270509) | 15 | 9 | 5 | 29492 | 10 | ||
70078 | 67220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 367 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30679 | 6003525.51133161 | 2108607.7820018 | 37.7700344883116 | -122.431149113146 | (37.7700344883116, -122.431149113146) | 15 | 9 | 5 | 29492 | 10 | ||
4011 | 62663 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 210 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 30678 | 6003703.58181069 | 2109204.83752166 | 37.7716839461227 | -122.43057577962 | (37.7716839461227, -122.43057577962) | 15 | 9 | 11 | 29492 | 10 | ||
123195 | 67196 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 635 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30648 | 5998644.57725532 | 2105576.2122968 | 37.7614327642251 | -122.447813838506 | (37.7614327642251, -122.447813838506) | 15 | 5 | 11 | 29492 | 12 | ||
69686 | 253094 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1360 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1992 12:00:00 AM | 3x3 | Permit Number 30561 | 5994899.98504 | 2106326.93315 | 37.7632793109173 | -122.460819144348 | (37.7632793109173, -122.460819144348) | 15 | 5 | 11 | 56 | 12 | ||
129098 | 54345 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1360 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30561 | 5994905.98112793 | 2106327.13892445 | 37.7632802209212 | -122.460798420916 | (37.7632802209212, -122.460798420916) | 15 | 5 | 11 | 56 | 12 | ||
149896 | 67108 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1285 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30525 | 5995458.01605947 | 2106809.73569122 | 37.7646370541731 | -122.458924070061 | (37.7646370541731, -122.458924070061) | 15 | 5 | 11 | 56 | 12 | ||
30636 | 54337 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1339 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30524 | 5994849.66135414 | 2106451.80947328 | 37.7636192932804 | -122.461002247672 | (37.7636192932804, -122.461002247672) | 15 | 5 | 11 | 56 | 12 | ||
185926 | 54350 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1382 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30523 | 5994910.33164599 | 2106200.68051144 | 37.7629332491802 | -122.460774208888 | (37.7629332491802, -122.460774208888) | 15 | 5 | 11 | 56 | 12 | ||
108825 | 54385 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 315 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30514 | 5994805.67004934 | 2107003.00943685 | 37.7651302136835 | -122.461194355893 | (37.7651302136835, -122.461194355893) | 15 | 5 | 11 | 56 | 12 | ||
54726 | 58595 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30451 | 5998119.2058649 | 2105940.33836746 | 37.762402520504 | -122.449657111476 | (37.762402520504, -122.449657111476) | 15 | 5 | 11 | 29492 | 9 | ||
182456 | 55778 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 690 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30413 | 6004270.54633332 | 2104877.95135901 | 37.7598354599097 | -122.428306178244 | (37.7598354599097, -122.428306178244) | 2 | 4 | 5 | 28862 | 3 | ||
150267 | 67037 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 620 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30412 | 6004248.3695844 | 2105283.39712956 | 37.7609474626645 | -122.428411775349 | (37.7609474626645, -122.428411775349) | 2 | 4 | 5 | 28862 | 3 | ||
124337 | 67013 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1345 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30368 | 5995769.70652962 | 2091972.54890953 | 37.7239157311453 | -122.456772865671 | (37.7239157311453, -122.456772865671) | 9 | 8 | 4 | 28861 | 24 | ||
79650 | 66965 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2240 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | Permit Number 30304 | 5998818.1489721 | 2111475.13282444 | 37.7776396217275 | -122.447638180901 | (37.7776396217275, -122.447638180901) | 15 | 6 | 2 | 54 | 16 | ||
40458 | 63931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1992 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/1993 12:00:00 AM | Permit Number 30124 | 5998289.10511777 | 2110360.37733799 | 37.7745485414266 | -122.449387975942 | (37.7745485414266, -122.449387975942) | 15 | 5 | 11 | 29492 | 16 | ||
124483 | 66821 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1950 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1991 12:00:00 AM | 3 | Permit Number 30113 | 5987263.7591 | 2101982.3656 | 37.7509079801912 | -122.486910920968 | (37.7509079801912, -122.486910920968) | 1 | 8 | 3 | 29491 | 35 | ||
22030 | 66798 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2727 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30077 | 6006105.82573514 | 2120126.22393826 | 37.8018071677784 | -122.423042648938 | (37.8018071677784, -122.423042648938) | 5 | 9 | 1 | 28858 | 32 | ||
102386 | 66753 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1077 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30005 | 5998848.66336844 | 2106157.27951902 | 37.7630398921609 | -122.447149811738 | (37.7630398921609, -122.447149811738) | 15 | 5 | 11 | 29492 | 9 | ||
155735 | 66750 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1142 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30002 | 5998925.54623856 | 2105975.96738823 | 37.7625464469733 | -122.446870853669 | (37.7625464469733, -122.446870853669) | 15 | 5 | 5 | 29492 | 9 | ||
108709 | 66739 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 180 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1991 12:00:00 AM | Permit Number 29989 | 5999953.27743663 | 2106249.40353064 | 37.7633558940904 | -122.443335957433 | (37.7633558940904, -122.443335957433) | 15 | 5 | 5 | 29492 | 3 | ||
184927 | 60429 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 435 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1991 12:00:00 AM | Permit Number 29958 | 6003754.61017147 | 2098919.66624389 | 37.743446200008 | -122.429665589175 | (37.743446200008, -122.429665589175) | 2 | 7 | 5 | 63 | 22 | ||
158705 | 66004 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 180 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1991 12:00:00 AM | Permit Number 29893 | 6005395.81468194 | 2102664.85986255 | 37.7538224360036 | -122.424257021497 | (37.7538224360036, -122.424257021497) | 2 | 4 | 5 | 28859 | 19 | ||
170039 | 66650 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 987 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1991 12:00:00 AM | Permit Number 29864 | 6009988.37334471 | 2103470.11092484 | 37.756291725608 | -122.408431620376 | (37.756291725608, -122.408431620376) | 2 | 4 | 7 | 28859 | 19 | ||
167823 | 62961 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Glover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1991 12:00:00 AM | Permit Number 29804 | 6008099.43910832 | 2118378.4690573 | 37.7971205654778 | -122.416019957286 | (37.7971205654778, -122.416019957286) | 5 | 1 | 10 | 28858 | 21 | ||
87362 | 66554 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1991 12:00:00 AM | Permit Number 29738 | 6005486.42020055 | 2104039.1051428 | 37.7576009089514 | -122.424041407354 | (37.7576009089514, -122.424041407354) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );