183 rows where qLegalStatus_id = 7 and qSpecies_id = 6 sorted by Fire Prevention Districts

View and edit SQL

qLegalStatus_id

  • Permitted Site · 183
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)
15370 50774 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
18773 255529 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782018                    
20394 48661 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1300 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/2005 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.7638910715093 -122.468357408335 (37.7638910715093, -122.468357408335) 1 8 11 56 12
21675 50111 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 250 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46832 5992489.27392501 2099148.73533454 37.7434308389356 -122.468634598074 (37.7434308389356, -122.468634598074) 1 8 4 29491 40
23031 88096 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1795 40th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.499127022602 (37.7534794912156, -122.499127022602) 1 8 3 56 35
24639 43060 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 3054 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM     Permit Number 53563 5983697 2098912 37.7422690003261 -122.499018090006 (37.7422690003261, -122.499018090006) 1 8 3 29491 35
31883 84000 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 440X Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3 Permit Number 771053 5991504.89622125 2099785.75892313 37.7451230278663 -122.472084716598 (37.7451230278663, -122.472084716598) 1 8 4 29491 40
36596 50110 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 250 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46832 5992489.27392501 2099148.73533454 37.7434308389356 -122.468634598074 (37.7434308389356, -122.468634598074) 1 8 4 29491 40
49016 257890 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1266 40th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2019 12:00:00 AM 3 3x3 Permit Number 782773 5983690.81524 2106537.44734 37.7632059962022 -122.499602915235 (37.7632059962022, -122.499602915235) 1 8 3 56 35
60630 81333 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1607 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53535 5993364.90659405 2104537.49939321 37.7582775482109 -122.46599839572 (37.7582775482109, -122.46599839572) 1 8 4 56 12
64938 256897 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2051 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2018 12:00:00 AM 3 3x3 Permit Number 782737 5985693.46852 2101265.2111 37.7488471905551 -122.492288254945 (37.7488471905551, -122.492288254945) 1 8 3 29491 35
68875 88095 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1795 40th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.499127022602 (37.7534794912156, -122.499127022602) 1 8 3 56 35
78293 116736 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1799x 25TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988397 2103119 37.7540948807956 -122.483075414994 (37.7540948807956, -122.483075414994) 1 8 3 56 35
79116 58020 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 4020 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2016 11:16:00 AM 3   Permit Number 16987 5983299.23983496 2106318.86318391 37.7625828423592 -122.500941055889 (37.7625828423592, -122.500941055889) 1 8 3 56 35
88149 88094 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1474 40th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51098 5983765.2 2105129.7 37.7593450832678 -122.499241618892 (37.7593450832678, -122.499241618892) 1 8 3 56 35
97607 43061 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 3050 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2005 12:00:00 AM     Permit Number 53563 5983775.74745702 2098849.58098564 37.7421022336559 -122.498741199638 (37.7421022336559, -122.498741199638) 1 8 3 29491 35
99236 46892 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1383 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44948 5992692.47897134 2106059.86172468 37.7624187406256 -122.468434681685 (37.7624187406256, -122.468434681685) 1 8 11 56 12
108409 88108 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1935 47th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM   3x3 Permit Number 51112 5981615.2 2101901.1 37.7503538981052 -122.50643780728 (37.7503538981052, -122.50643780728) 1 8 3 29491 35
110666 254576 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2138 45th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2018 12:00:00 AM 3 3x3 Permit Number 781492 5982342.68444 2100548.37441 37.7466824957237 -122.50382198427 (37.7466824957237, -122.50382198427) 1 8 3 29491 35
117364 88527 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1501 06th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51477 5994255.6 2105256.2 37.7603022580943 -122.462970154312 (37.7603022580943, -122.462970154312) 1 5 4 56 12
119754 116735 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1799x 25TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988397 2103119 37.7540948807956 -122.483075414994 (37.7540948807956, -122.483075414994) 1 8 3 56 35
134165 258203 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2422 41st Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2019 12:00:00 AM 3 3x3 Permit Number 781120 5983650.02463 2098655.15546 37.741561019666 -122.499161539913 (37.741561019666, -122.499161539913) 1 8 3 29491 35
141188 83302 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2366 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50740 5982401.73888916 2099005.47811571 37.7424496018256 -122.503503550435 (37.7424496018256, -122.503503550435) 1 8 3 29491 35
149039 83301 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2194 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50729 5982670.93030487 2100194.17282904 37.7457292516177 -122.502660748962 (37.7457292516177, -122.502660748962) 1 8 3 29491 35
150135 50120 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 243 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/14/2012 12:00:00 AM     Permit Number 769150 5992346.75268289 2097836.73381964 37.7398201819052 -122.469031933295 (37.7398201819052, -122.469031933295) 1 8 4 59 40
152474 94162 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1750 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53533 5993469.4 2103573.4 37.7556364086322 -122.465566975178 (37.7556364086322, -122.465566975178) 1 8 4 56 12
152713 48663 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1300 11th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2002 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.7638910715093 -122.468357408335 (37.7638910715093, -122.468357408335) 1 8 11 56 12
165167 95901 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1700 23rd Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092 2103686.6 37.7556937768723 -122.480713514054 (37.7556937768723, -122.480713514054) 1 8 3 56 35
166701 254575 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2446 43rd Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2018 12:00:00 AM 3 3x3 Permit Number 781489 5983035.61421 2098477.14413 37.7410361869592 -122.501272763587 (37.7410361869592, -122.501272763587) 1 8 3 29491 35
167767 88087 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1254 38th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51087 5984334.6 2106629.9 37.7634975987144 -122.497383137852 (37.7634975987144, -122.497383137852) 1 8 3 56 35
171435 258215 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2400 43rd Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/2019 12:00:00 AM 3   Permit Number 783182 5983025.27936 2098776.48804 37.7418574964013 -122.501330634264 (37.7418574964013, -122.501330634264) 1 8 3 29491 35
178343 46893 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1383 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44948 5992692.47897134 2106059.86172468 37.7624187406256 -122.468434681685 (37.7624187406256, -122.468434681685) 1 8 11 56 12
179141 104731 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 440X Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3 Permit Number 771053 5991576.41061 2099773.54792 37.7450936377729 -122.471836544912 (37.7450936377729, -122.471836544912) 1 8 4 29491 40
184192 113139 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1799x 25TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988397 2103119 37.7540948807956 -122.483075414994 (37.7540948807956, -122.483075414994) 1 8 3 56 35
188586 69101 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1672 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/2014 12:00:00 AM 3 3x3 Permit Number 773502 5992502.12347703 2104077.04435662 37.7569634473758 -122.468948742276 (37.7569634473758, -122.468948742276) 1 8 4 56 12
192443 104730 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 440X Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3 Permit Number 771053 5991576.41061 2099773.54792 37.7450936377729 -122.471836544912 (37.7450936377729, -122.471836544912) 1 8 4 29491 40
193269 95900 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1700 23rd Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092 2103686.6 37.7556937768723 -122.480713514054 (37.7556937768723, -122.480713514054) 1 8 3 56 35
1417 88463 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
23895 92663 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 791 San Bruno Ave 1 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
29816 95998 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1682 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767649 6014786.9 2096088.7 37.7362914700729 -122.39132054684 (37.7362914700729, -122.39132054684) 10 3 8 58 1
31876 88495 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 27 Reddy St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51437 6013659 2094063 37.7306666521666 -122.395078350002 (37.7306666521666, -122.395078350002) 10 3 8 58 1
33564 27026 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2005 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
37255 108775 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
49657 46433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011103.47209 2089684.58226 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234) 10 7 8 309 28
50859 114691 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
54619 108768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
73269 92664 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 791 San Bruno Ave 2 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
94732 88465 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
108067 27003 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
108222 108764 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
111468 27168 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2070X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM 6 2X3   6012351.75792 2095958.07131 37.735797342091 -122.399730727068 (37.735797342091, -122.399730727068) 10 3 8 58 1
117513 88483 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014835.95113 2096251.52849 37.7367412859786 -122.391162333372 (37.7367412859786, -122.391162333372) 10 3 8 58 1
117917 108778 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
120971 95999 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1682 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767649 6014786.9 2096088.7 37.7362914700729 -122.39132054684 (37.7362914700729, -122.39132054684) 10 3 8 58 1
122415 92665 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 791 San Bruno Ave 3 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
122458 87640 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2300X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM   3x3   6012975.96285 2096322.27153 37.7368321371284 -122.397598127165 (37.7368321371284, -122.397598127165) 10 3 8 58 1
132281 254353 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2 Ankeny St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011131.69741 2089639.6721 37.7183802415409 -122.403504586485 (37.7183802415409, -122.403504586485) 10 7 8 309 28
134524 108772 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
137235 88480 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51432 6014837 2096254 37.7367481304458 -122.391158879645 (37.7367481304458, -122.391158879645) 10 3 8 58 1
138944 114692 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 2 Sidewalk: Curb side : Cutout Tree Port 6 Private 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
156212 27014 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1518 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 6 3X3   6010461.99919 2094665.45469 37.7321425639198 -122.40617335478 (37.7321425639198, -122.40617335478) 10 3 7 309 28
158730 27025 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 12 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
167406 176915 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 143 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 778564 6009701.03874 2093769.75693 37.7296405745301 -122.408741008189 (37.7296405745301, -122.408741008189) 10 3 7 309 28
171342 47598 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2003 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
174505 108825 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 146-150X Gillette Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773819 6013072.89275 2086799.91674 37.7106910734067 -122.39659568235 (37.7106910734067, -122.39659568235) 10 3 8 309 1
184322 47592 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
187907 44279 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1588 Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767652 6014189.45600011 2095460.4720274 37.7345333093335 -122.393342225003 (37.7345333093335, -122.393342225003) 10 3 8 58 1
24945 89565 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5001X Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2019 12:00:00 AM 3 3x3 Permit Number 782749 5983089.78021 2111680.23644 37.777291329944 -122.502062233879 (37.777291329944, -122.502062233879) 11 6 2 55 26
89162 88397 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 405 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51376 5987436.1 2113196.8 37.7817097621118 -122.487138517946 (37.7817097621118, -122.487138517946) 11 6 2 55 26
146035 84332 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 804 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51851 5986981.94009984 2110441.32651783 37.7741175201244 -122.488507097746 (37.7741175201244, -122.488507097746) 11 6 2 55 26
192907 255098 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 585 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       5x9   5987788 2112008 37.7784661663567 -122.485833843864 (37.7784661663567, -122.485833843864) 11 6 2 55 26
120895 88732 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1732 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51666 6003104.1 2114241.2 37.7854785624412 -122.433009307654 (37.7854785624412, -122.433009307654) 13 9 11 29490 13
148668 49802 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 101 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM     Permit Number 46598 6014071 2106574 37.765042114519 -122.394529717904 (37.765042114519, -122.394529717904) 14 3 8 28856 29
15444 89331 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 4658 18th St   Sidewalk: Curb side : Cutout Tree Private 2   12/31/2008 12:00:00 AM   3x3 Permit Number 51984 6000201 2105201 37.7604913603716 -122.4424038966 (37.7604913603716, -122.4424038966) 15 4 5 28862 3
19677 39613 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 577 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42206 5996839.91957309 2107330.11638831 37.7661452244472 -122.454182049235 (37.7661452244472, -122.454182049235) 15 5 11 29492 12
24082 88257 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 436 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51241 5998536 2106665 37.76441609532 -122.448267765661 (37.76441609532, -122.448267765661) 15 5 11 29492 9
29015 41825 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2511 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2000 12:00:00 AM     Permit Number 42211 5998436.39026341 2111725.32035622 37.7783047466177 -122.44897683474 (37.7783047466177, -122.44897683474) 15 6 2 54 16
32912 94410 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 63 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2010 12:00:00 AM   3x3 Permit Number 53650 6001682.9 2108449.6 37.7694955715896 -122.437511336741 (37.7694955715896, -122.437511336741) 15 5 5 29492 9
41094 51607 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 800 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2005 12:00:00 AM 5 3x3 Permit Number 47904 5997656.30420255 2107807.08178851 37.7675016300781 -122.45139275313 (37.7675016300781, -122.45139275313) 15 5 11 29492 9
47337 83396 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 4058 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50820 6002600.50899636 2105341.51117361 37.7610136443426 -122.43411515125 (37.7610136443426, -122.43411515125) 15 4 5 28862 3
58225 88206 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 187 Beaumont Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51211 5996832.5 2111680.5 37.7780898241501 -122.454522014682 (37.7780898241501, -122.454522014682) 15 6 2 54 16
63992 39614 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 577 Frederick St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42206 5996839.91957309 2107330.11638831 37.7661452244472 -122.454182049235 (37.7661452244472, -122.454182049235) 15 5 11 29492 12
77162 102385 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 33 Buena Vista Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.7684102241102 -122.438031497558 (37.7684102241102, -122.438031497558) 15 5 5 29492 3
87404 88256 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 436 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51241 5998536 2106665 37.76441609532 -122.448267765661 (37.76441609532, -122.448267765661) 15 5 11 29492 9
99415 51233 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1130 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.7637059584567 -122.452316160446 (37.7637059584567, -122.452316160446) 15 5 11 29492 9
103947 51230 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1130 Stanyan St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.7637059584567 -122.452316160446 (37.7637059584567, -122.452316160446) 15 5 11 29492 9
106631 51232 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1130 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.7637059584567 -122.452316160446 (37.7637059584567, -122.452316160446) 15 5 11 29492 9
108856 88244 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 4330 17th St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51231 6000585 2105809 37.7621826583789 -122.441119442302 (37.7621826583789, -122.441119442302) 15 5 5 28862 3
114382 102384 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 33 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.7684102241102 -122.438031497558 (37.7684102241102, -122.438031497558) 15 5 5 29492 3
116336 41826 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2517 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2000 12:00:00 AM     Permit Number 42212 5998421.57666404 2111723.27260806 37.7782982768263 -122.449027932684 (37.7782982768263, -122.449027932684) 15 6 2 54 16
116939 67239 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 115 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM   3x9 Permit Number 30703 6003792.49486353 2108815.33294247 37.770619498227 -122.430240430849 (37.770619498227, -122.430240430849) 15 9 11 29492 10
139732 88255 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 115 Belvedere St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51240 5998220 2108137 37.7684397634087 -122.44946678759 (37.7684397634087, -122.44946678759) 15 5 11 29492 9
142495 88724 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1009 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51659 6001742 2109408 37.7721304598957 -122.437375549988 (37.7721304598957, -122.437375549988) 15 5 11 29492 9
146709 254547 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2908 Bush St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 02/26/2018 12:00:00 AM 3 3x3 Permit Number 781446 5999588.42992 2114352.40043 37.7855838475934 -122.445180440387 (37.7855838475934, -122.445180440387) 15 6 1 29490 31
155024 83961 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 180 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50859 5997460.19616594 2106774.33360384 37.7646547355545 -122.451996543237 (37.7646547355545, -122.451996543237) 15 5 11 29492 9
164479 88270 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 288 States St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51256 6000346 2106829 37.7649697094425 -122.442019266807 (37.7649697094425, -122.442019266807) 15 5 5 28862 3
175230 59241 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 138 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2015 12:00:00 AM 3   Permit Number 18570 5998056.20401336 2105984.36092392 37.7625197907884 -122.449878183328 (37.7625197907884, -122.449878183328) 15 5 11 29492 9
175874 52129 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 220 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51660 6002806.0471416 2109304.34219127 37.7719062747483 -122.433687517115 (37.7719062747483, -122.433687517115) 15 5 11 29492 9
192746 88723 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1001 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51659 6001771 2109412 37.7721430915073 -122.437275523238 (37.7721430915073, -122.437275523238) 15 5 11 29492 9
193498 47037 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 714 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/2015 12:00:00 AM     Permit Number 776491 6002280.60768666 2108833.96933031 37.7705849188534 -122.435471392977 (37.7705849188534, -122.435471392977) 15 5 11 29492 9

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