406 rows where qSpecies_id = 47 sorted by TreeID 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)
76135 98307 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05848 2110712.18551 37.7753089605415 -122.461804398804 (37.7753089605415, -122.461804398804) 11 6 2 54 11
48894 976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X4   6001942.44101 2093088.00211 37.7273310167784 -122.435514506557 (37.7273310167784, -122.435514506557) 9 7 6 28861 25
105561 973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     22 0   6001917.27172 2093023.46154 37.72715237348 -122.435596901293 (37.72715237348, -122.435596901293) 9 7 6 28861 25
99445 9277 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2161X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000049.09202 2089751.67924 37.7180625213905 -122.441820442737 (37.7180625213905, -122.441820442737) 9 7 6 28861 25
154538 926 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6002807.70183 2094157.47604 37.7303166558715 -122.432599664217 (37.7303166558715, -122.432599664217) 9 7 5 28861 25
56036 909 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1217 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   6003163.68633 2094174.89484 37.7303846655151 -122.431370220756 (37.7303846655151, -122.431370220756) 9 7 6 28861 25
182837 890 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1146 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 4X4   6003547.94647 2094400.70663 37.7310264639915 -122.430057882374 (37.7310264639915, -122.430057882374) 9 7 5 28861 25
174441 889 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1136X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6003353.03343 2094335.58352 37.7308366096666 -122.430727084074 (37.7308366096666, -122.430727084074) 9 7 5 28861 25
63526 882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1138X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.97393 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056) 9 7 5 28861 25
154772 85386 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1239 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49657 5981144.8 2106623.2 37.7632917298848 -122.508414943002 (37.7632917298848, -122.508414943002) 1 8 3 56 35
137363 84886 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3138 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM     Permit No. 49329 5983290 2099514 37.7438980447125 -122.500469849117 (37.7438980447125, -122.500469849117) 1 8 3 29491 35
107125 84447 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2266 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50738 5982378.18226568 2099687.61773546 37.7443211838051 -122.503635505549 (37.7443211838051, -122.503635505549) 1 8 3 29491 35
165906 84133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 23 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 5 3x3 Permit Number 50705 6011012.12355 2088466.51247 37.7151523039101 -122.403835398892 (37.7151523039101, -122.403835398892) 9 7 8 309 39
9451 84120 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 336 Campbell Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011186.92342 2088226.0732 37.7145018701492 -122.403214308206 (37.7145018701492, -122.403214308206) 10 7 8 309 39
103582 83279 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2147 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50736 5982298.4490102 2100494.71161235 37.7465325514695 -122.503970969286 (37.7465325514695, -122.503970969286) 1 8 3 29491 35
123946 83251 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2210 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50737 5982365.40001882 2100051.8832382 37.7453206044327 -122.503706674483 (37.7453206044327, -122.503706674483) 1 8 3 29491 35
50593 83239 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4332 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50745 5981564.36989544 2101497.47247657 37.7492426575827 -122.50658364702 (37.7492426575827, -122.50658364702) 1 8 3 29491 35
165308 83228 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4234 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50748 5982916.47531802 2098139.9083931 37.7401032328077 -122.50165975231 (37.7401032328077, -122.50165975231) 1 8 3 29491 35
97332 83208 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3634 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 7 3x3 Permit Number 50746 5981914.57527844 2100148.1004138 37.7455582728462 -122.505272655065 (37.7455582728462, -122.505272655065) 1 8 3 29491 35
171915 82814 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2724 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50727 5983103.67908303 2096652.63979189 37.7360305919754 -122.500902526777 (37.7360305919754, -122.500902526777) 1 8 3 29491 35
128606 82810 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2730 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50728 5983104.2980141 2096628.76061893 37.7359650625832 -122.500898621502 (37.7359650625832, -122.500898621502) 1 8 3 29491 35
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
87369 81868 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3012-3014 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52207 6009486.0303434 2101043.89087343 37.749601722793 -122.409997630916 (37.749601722793, -122.409997630916) 2 4 7 28859 19
4229 80358 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 336 Campbell Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6011201.39619 2088230.44969 37.7145146953757 -122.403164591892 (37.7145146953757, -122.403164591892) 10 7 8 309 39
133839 79951 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4332 Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50745 5981564.36989544 2101497.47247657 37.7492426575827 -122.50658364702 (37.7492426575827, -122.50658364702) 1 8 3 29491 35
18160 79486 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2323 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 0 3x3 Permit Number 50743 5981719.67239804 2099271.03998771 37.7431386384508 -122.505881575612 (37.7431386384508, -122.505881575612) 1 8 3 29491 35
166199 79279 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2706 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50726 5983101.82229012 2096724.27729962 37.7362271801162 -122.50091424264 (37.7362271801162, -122.50091424264) 1 8 3 29491 35
80463 79056 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1862 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50038 5983215.17096299 2102463.12302331 37.7519911277095 -122.500946646871 (37.7519911277095, -122.500946646871) 1 8 3 56 35
100650 78557 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2234 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2016 12:00:00 AM 3   Permit Number 771299 5981748.2661 2099861.5988 37.7447618317919 -122.505826480334 (37.7447618317919, -122.505826480334) 1 8 3 29491 35
34167 69291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 830 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33363 5991479.92264349 2102518.55863113 37.7526251419757 -122.472370253301 (37.7526251419757, -122.472370253301) 1 8 4 56 12
83616 68575 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 7633 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32467 5983299.26193695 2112364.72668983 37.7791830450299 -122.501388226383 (37.7791830450299, -122.501388226383) 11 6 2 55 26
193986 68368 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 194 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1993 12:00:00 AM     Permit Number 32189 6002712.41508002 2094283.54436078 37.730657406687 -122.432938086411 (37.730657406687, -122.432938086411) 9 7 5 28861 25
193603 68315 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3820 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32128 5981623.22584135 2100818.01716678 37.7473805290726 -122.506329747472 (37.7473805290726, -122.506329747472) 1 8 3 29491 35
134216 68097 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 49 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.7468442446896 -122.414234251858 (37.7468442446896, -122.414234251858) 2 7 7 28859 2
13174 68069 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 239 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1993 12:00:00 AM     Permit Number 31806 5993313.66059206 2103207.09024288 37.7546216328473 -122.466078949095 (37.7546216328473, -122.466078949095) 1 8 4 56 12
99619 67131 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1439 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM     Permit Number 30551 5994253.6761319 2105720.38065143 37.7615766669983 -122.463010486718 (37.7615766669983, -122.463010486718) 1 5 11 56 12
185212 63714 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.415573763175 (37.7473672046192, -122.415573763175) 2 7 7 28859 2
32588 63441 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 299 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1997 12:00:00 AM     Permit Number 24028 6008993.82853707 2096920.83270323 37.738253113659 -122.411408443517 (37.738253113659, -122.411408443517) 10 7 7 28859 2
99585 59481 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 701 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2019 12:00:00 AM 3   Permit Number 768498 5994707.05513 2110730.54303 37.7753593652253 -122.461805741777 (37.7753593652253, -122.461805741777) 11 6 2 54 11
178843 58925 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3925 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1994 12:00:00 AM     Permit Number 18201 5982715.08927534 2104886.86517056 37.7586166666309 -122.502855377053 (37.7586166666309, -122.502855377053) 1 8 3 56 35
47586 57377 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3505 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006157.87748572 2102561.9990288 37.7535830045092 -122.421614323469 (37.7535830045092, -122.421614323469) 2 4 5 28859 19
79169 56335 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 354 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777757 5987487.44856113 2113581.55129815 37.7827691737362 -122.486989143207 (37.7827691737362, -122.486989143207) 11 6 2 55 26
107383 54526 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4530 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777496 5981479.33824 2110998.92324 37.7753259029383 -122.507582607669 (37.7753259029383, -122.507582607669) 11 6 2 55 26
109823 52980 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 531 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2006 12:00:00 AM     Permit Number 49067 5992711.66457877 2090721.03501475 37.7203033137371 -122.467252978798 (37.7203033137371, -122.467252978798) 9 8 6 64 24
128532 52554 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1719 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 8   Permit Number 48649 5984370.92860727 2103469.2332855 37.754821420905 -122.497024185091 (37.754821420905, -122.497024185091) 1 8 3 56 35
129532 52497 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 371 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48606 6007135.79724675 2096038.97616324 37.7357273409345 -122.417770123047 (37.7357273409345, -122.417770123047) 2 7 7 28859 2
71117 52492 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 390ON GATES Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48601 6008184.68107457 2096494.82661811 37.7370379770988 -122.414175953506 (37.7370379770988, -122.414175953506) 2 7 7 28859 2
42446 52384 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 36TA MARINA Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM     Permit Number 48509 6005730.58900637 2097520.8738626 37.7397171218166 -122.422733759035 (37.7397171218166, -122.422733759035) 2 7 7 28859 2
54078 52269 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48434 6005520.49766263 2101354.49181367 37.7502315077339 -122.423732674774 (37.7502315077339, -122.423732674774) 2 4 5 28859 19
59472 52106 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 727 Rockdale Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM     Permit Number 48298 5997405.05193713 2098248.96190456 37.741243026323 -122.451572279627 (37.741243026323, -122.451572279627) 9 7 4 59 40
86130 52103 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 641 Rockdale Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM     Permit Number 48295 5997742.5728031 2098061.02519693 37.7407463206184 -122.450391713191 (37.7407463206184, -122.450391713191) 9 7 4 59 40
139775 51442 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 775 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.416865768693 (37.7334476580973, -122.416865768693) 2 7 7 28859 2
21677 51414 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1531 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM 0   Permit Number 47738 5988357.88494646 2104888.81015522 37.7589520258954 -122.48334041038 (37.7589520258954, -122.48334041038) 1 8 3 56 35
68109 50881 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2040 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47391 5991642.80129947 2101534.85210656 37.7499335653235 -122.471735313093 (37.7499335653235, -122.471735313093) 1 8 4 29491 12
158626 50817 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47   1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2004 12:00:00 AM     Permit Number 47340 5995605.94135709 2094497.43585496 37.7308390591092 -122.457521563876 (37.7308390591092, -122.457521563876) 9 7 4 28861 40
8913 50707 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1658 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2004 12:00:00 AM 5   Permit Number 47266 5983788.66504778 2103867.70402192 37.75588137239 -122.499067221884 (37.75588137239, -122.499067221884) 1 8 3 56 35
2561 50575 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1347 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM 0   Permit Number 47190 5983353.97136461 2105974.76120709 37.7616412492229 -122.50072631562 (37.7616412492229, -122.50072631562) 1 8 3 56 35
108126 50490 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2003 12:00:00 AM     Permit Number 47126 5995378.87438655 2091597.86421043 37.722864487352 -122.458096796728 (37.722864487352, -122.458096796728) 9 8 4 28861 24
121895 50489 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 242 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2003 12:00:00 AM     Permit Number 47126 5995378.87438655 2091597.86421043 37.722864487352 -122.458096796728 (37.722864487352, -122.458096796728) 9 8 4 28861 24
81378 50428 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 11 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47081 5996479.47890892 2089951.8399169 37.7184080697361 -122.454173429085 (37.7184080697361, -122.454173429085) 9 8 6 28861 24
137534 50423 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 75 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47076 5995600.08487961 2090390.5729412 37.7195622602365 -122.457244829317 (37.7195622602365, -122.457244829317) 9 8 6 28861 24
84280 50293 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113972 50292 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
193338 50291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
112832 50290 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
22890 50289 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
89527 50288 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113945 50219 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2726 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2004 12:00:00 AM 8 3x3 Permit Number 46926 5987073.25597 2111201.47184 37.776209992885 -122.488247096133 (37.776209992885, -122.488247096133) 11 6 2 55 26
28788 50114 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1252 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46839 5992244.12505327 2098460.15223335 37.7415260004029 -122.469432140867 (37.7415260004029, -122.469432140867) 1 8 4 29491 40
66800 49718 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1195 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2003 12:00:00 AM     Permit Number 46529 6014698.72785663 2090465.4227663 37.7208461876659 -122.391232442758 (37.7208461876659, -122.391232442758) 10 3 8 58 1
75050 49654 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 81 Alpha St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM     Permit Number 46507 6011171.19956943 2088331.01703059 37.7147891465513 -122.403276034448 (37.7147891465513, -122.403276034448) 10 7 8 309 39
192707 49012 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2002 12:00:00 AM     Permit Number 46198 6003561.60300767 2099494.42119752 37.7450134133041 -122.430373957908 (37.7450134133041, -122.430373957908) 2 7 5 63 22
187678 48774 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 629 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684) 2 7 7 28859 2
13168 48530 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2251 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM 6   Permit Number 45852 5988214.95937948 2099991.18132471 37.7454961303111 -122.483475662249 (37.7454961303111, -122.483475662249) 1 8 3 29491 35
184865 47963 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 558 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45693 5996827.75466141 2095403.22069376 37.7333962339357 -122.453362951949 (37.7333962339357, -122.453362951949) 9 7 4 59 40
119732 47881 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1454 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50547 5982810.24276317 2105223.95269531 37.759547805419 -122.502551248021 (37.759547805419, -122.502551248021) 1 8 3 56 35
19390 47850 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1342 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.500551730195 (37.7617206013965, -122.500551730195) 1 8 3 56 35
104777 47604 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 645 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45440 6008713.69382569 2095849.48701302 37.7352957148385 -122.412301312985 (37.7352957148385, -122.412301312985) 10 7 7 28859 2
92382 47550 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1681 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787) 2 7 5 63 22
118845 47453 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
73341 47451 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 5049 Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782) 11 6 2 55 26
113634 47351 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 246 Monticello St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45277 5991716.56988019 2090163.16086716 37.7187140338834 -122.470652049529 (37.7187140338834, -122.470652049529) 9 8 6 64 24
148994 47225 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1643 Felton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM     Permit Number 45170 6006193.94874397 2092417.83045771 37.7257314225765 -122.420769469994 (37.7257314225765, -122.420769469994) 9 7 7 309 5
25754 47111 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.7409195061747 -122.418109646545 (37.7409195061747, -122.418109646545) 2 7 7 28859 2
61805 47082 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 5   Permit Number 45068 5996827.60082146 2111762.20695793 37.7783138890322 -122.45454486672 (37.7783138890322, -122.45454486672) 15 6 2 54 16
122107 46973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1783 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 7   Permit Number 44992 5982214.0178657 2102979.50871383 37.7533501437558 -122.504446973742 (37.7533501437558, -122.504446973742) 1 8 3 56 35
172448 46969 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1658 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 7   Permit Number 44989 5982547.49278996 2103828.23178681 37.7557001072445 -122.503356606053 (37.7557001072445, -122.503356606053) 1 8 3 56 35
111648 46761 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 343 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44859 6006106.65621717 2092210.20384218 37.7251564045519 -122.421056498489 (37.7251564045519, -122.421056498489) 9 7 7 309 5
37486 46399 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2110 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 5   Permit Number 44629 5981721.80383178 2100709.75793181 37.7470890826019 -122.505980852245 (37.7470890826019, -122.505980852245) 1 8 3 29491 35
89095 46395 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2091 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 9   Permit Number 44627 5981974.76389525 2100876.77542895 37.7475625528023 -122.505118527994 (37.7475625528023, -122.505118527994) 1 8 3 29491 35
63902 46390 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2447 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 7   Permit Number 44623 5982678.99712077 2098464.70885711 37.7409810943186 -122.502504874921 (37.7409810943186, -122.502504874921) 1 8 3 29491 35
157838 46382 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2495 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.7401721103617 -122.501371213543 (37.7401721103617, -122.501371213543) 1 8 3 29491 35
165329 46381 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2495 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.7401721103617 -122.501371213543 (37.7401721103617, -122.501371213543) 1 8 3 29491 35
57475 45437 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 50 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44224 5993813.83621392 2092411.23769418 37.7250077648019 -122.463565764966 (37.7250077648019, -122.463565764966) 9 8 4 59 40
116625 45431 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.7227220958318 -122.463136201451 (37.7227220958318, -122.463136201451) 9 8 4 59 40
13250 45430 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.7227220958318 -122.463136201451 (37.7227220958318, -122.463136201451) 9 8 4 59 40
129636 45429 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 851 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.7227220958318 -122.463136201451 (37.7227220958318, -122.463136201451) 9 8 4 59 40
123096 45360 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 458 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46747 5993277.37926203 2090218.01876098 37.7189547935486 -122.46526098645 (37.7189547935486, -122.46526098645) 9 8 6 64 24
3158 44124 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 751 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/29/2000 12:00:00 AM     Permit Number 43628 5981028.36208653 2110606.15983469 37.774220913121 -122.509113438342 (37.774220913121, -122.509113438342) 11 6 2 55 26
105029 43632 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50556 5996213.47474732 2098545.79305022 37.7419897418411 -122.455713757113 (37.7419897418411, -122.455713757113) 9 7 4 59 40

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