68 rows where Zip Codes = 29491 and qSpecies_id = 6

View and edit SQL

Zip Codes

  • 29491 · 68
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)
2908 93406 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1408 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/24/2015 11:15:00 AM 3 3x3   5988828.0589 2099030.2661 37.7428933746541 -122.48128533094 (37.7428933746541, -122.48128533094) 1 8 3 29491 35
9692 183446 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2511 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/08/2020 12:00:00 AM 3 Width 0ft   5988279.6214 2098205.3016 37.7405963382743 -122.483121197886 (37.7405963382743, -122.483121197886) 1 8 3 29491 35
10383 264872 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2426 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/2020 06:03:00 PM 3 4x6   5985846 2098694 37.7417962544182 -122.491571569344 (37.7417962544182, -122.491571569344) 1 8 3 29491 35
13074 264871 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2430 36th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/15/2020 12:00:00 AM 3 4x6   5985228 2098648 37.7416338152793 -122.493704989969 (37.7416338152793, -122.493704989969) 1 8 3 29491 35
13541 60816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2110 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1983 12:00:00 AM 4   Permit Number 20494 5989779.2235 2100978.3623 37.7482975910503 -122.478138904702 (37.7482975910503, -122.478138904702) 1 8 3 29491 35
13622 207003 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2380 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992355.41935 2099194.17897 37.7435478822362 -122.469100735806 (37.7435478822362, -122.469100735806) 1 8 4 29491 40
16581 258150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2485 23rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     5989205.22412 2098441.55094 37.7412988370865 -122.479938140892 (37.7412988370865, -122.479938140892) 1 8 3 29491 35
20319 106193 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983698.2 2098878.7 37.742177638004 -122.499011481047 (37.742177638004, -122.499011481047) 1 8 3 29491 35
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
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
27064 182564 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2122 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft Permit Number 783239 5989402.8067 2098365.7306 37.7411021315374 -122.479249432397 (37.7411021315374, -122.479249432397) 1 8 3 29491 35
30582 183121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2327 41st Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311) 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
32976 207036 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1645 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5990861.16949 2098351.90974 37.7411487751831 -122.474205983836 (37.7411487751831, -122.474205983836) 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
36793 95431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1938 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767296 5988810.2856 2102122.1786 37.7513819161329 -122.481573187512 (37.7513819161329, -122.481573187512) 1 8 3 29491 35
39271 37722 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 04:53:00 PM 3 3x3 Permit Number 774917 5983850.6165 2098795.1757 37.7419572424052 -122.498478312402 (37.7419572424052, -122.498478312402) 1 8 3 29491 35
41357 255423 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
41654 112585 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
41781 207002 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2380 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992354.33739 2099175.8386 37.7434974617379 -122.469103142406 (37.7434974617379, -122.469103142406) 1 8 4 29491 40
46414 112583 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 1 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
48766 207033 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Quintara St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993145.27059 2101214.49823 37.7491407714503 -122.466516461993 (37.7491407714503, -122.466516461993) 1 8 4 29491 12
52675 37717 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 04:45:00 PM 3 3x3 Permit Number 774917 5983817.4661 2098794.1609 37.7419525119456 -122.498592859082 (37.7419525119456, -122.498592859082) 1 8 3 29491 35
53815 207037 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2642 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990833.84583 2097410.6031 37.7385626055711 -122.474231788985 (37.7385626055711, -122.474231788985) 1 8 4 29491 40
56938 206999 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 404 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991570.38275 2099794.54343 37.7451509372588 -122.471858917877 (37.7451509372588, -122.471858917877) 1 8 4 29491 40
56985 255424 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
63550 93407 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1414 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/24/2015 11:09:00 AM 3 3x3   5988810.4689 2099030.2661 37.7428923519808 -122.481346151554 (37.7428923519808, -122.481346151554) 1 8 3 29491 35
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
85415 207038 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 270 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5994641.46146 2100307.89339 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602) 1 8 4 29491 40
87952 207035 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Quintara St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993108.07657 2101214.12996 37.7491376139164 -122.466645051533 (37.7491376139164, -122.466645051533) 1 8 4 29491 12
91141 37721 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 05:19:00 PM 3 3x3 Permit Number 774917 5983882.4138 2098796.867 37.7419637508928 -122.498368494175 (37.7419637508928, -122.498368494175) 1 8 3 29491 35
92547 106331 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1651 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/2015 05:38:00 PM 3 3x3   5988118.12003 2098953.52216 37.7426413556222 -122.483734446336 (37.7426413556222, -122.483734446336) 1 8 3 29491 35
93370 255421 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2727 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/21/2018 12:00:00 AM 3 10x10 Permit Number 780223 5985829 2096861 37.7367623321138 -122.491495459369 (37.7367623321138, -122.491495459369) 1 8 3 29491 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
98323 37723 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 05:05:00 PM 3 3x3 Permit Number 774917 5983867.1917 2098797.5436 37.7419647160194 -122.498421176446 (37.7419647160194, -122.498421176446) 1 8 3 29491 35
106816 181949 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2450 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986451.9754 2098568.253 37.7414863814969 -122.489467090095 (37.7414863814969, -122.489467090095) 1 8 3 29491 35
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
112687 207000 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 404 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991556.48203 2099793.0654 37.7451460746357 -122.471906875997 (37.7451460746357, -122.471906875997) 1 8 4 29491 40
116677 115268 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2275 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775658 5987276.1 2099806.2 37.7449335319328 -122.486708467871 (37.7449335319328, -122.486708467871) 1 8 3 29491 35
118421 183902 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101 22nd Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   5989433.6077 2100684.129 37.7474696361105 -122.479312499521 (37.7474696361105, -122.479312499521) 1 8 3 29491 35
124444 83491 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1966 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM 4 3x3 Permit Number 50181 5981376.6636 2101684.6102 37.7497454310313 -122.507246608859 (37.7497454310313, -122.507246608859) 1 8 3 29491 35
132551 112584 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 5 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 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
140348 183523 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2542 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986781.4828 2097933.2945 37.7397621847049 -122.488281131206 (37.7397621847049, -122.488281131206) 1 8 3 29491 35
140576 207034 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Quintara St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993127.03688 2101215.11136 37.7491414027515 -122.466579558421 (37.7491414027515, -122.466579558421) 1 8 4 29491 12
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
143169 97322 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1055 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 12:42:00 PM 3 3x3   5989910.3078 2099001.0945 37.7428761380219 -122.477541124233 (37.7428761380219, -122.477541124233) 1 8 3 29491 35
146019 207001 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 404 Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991538.30054 2099790.96979 37.7451392685705 -122.471969591123 (37.7451392685705, -122.471969591123) 1 8 4 29491 40
146786 97317 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 12:59:00 PM 3 3x3   5990071.4812 2099073.5168 37.7430843422325 -122.476989128346 (37.7430843422325, -122.476989128346) 1 8 3 29491 35
147556 112586 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 7 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 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
152996 93466 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1649 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/2015 05:27:00 PM 3 3x3   5988055.4179 2098939.1633 37.7425982798609 -122.483950196784 (37.7425982798609, -122.483950196784) 1 8 3 29491 35
154347 97319 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1038 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 12:52:00 PM 3 3x3   5989945.5882 2099070.048 37.7430675136338 -122.477424174253 (37.7430675136338, -122.477424174253) 1 8 3 29491 35
156906 46375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2214 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM 1 3x3 Permit Number 51267 5982984.1214 2100027.2965 37.745289455195 -122.501565454542 (37.745289455195, -122.501565454542) 1 8 3 29491 35
157697 97323 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1011 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 12:25:00 PM 3 3x3   5990005.0659 2099005.494 37.7428937161431 -122.477213802134 (37.7428937161431, -122.477213802134) 1 8 3 29491 35
159810 114206 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1030 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2016 01:19:00 PM 3 3x3   5989968.0933 2099069.2019 37.7430664963024 -122.477346296714 (37.7430664963024, -122.477346296714) 1 8 3 29491 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
166705 92392 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2506 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52796 5986151.5297 2098152.0694 37.7403261082431 -122.490475302823 (37.7403261082431, -122.490475302823) 1 8 3 29491 35
169615 109265 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1970 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773567 5983260 2101732.7 37.7499882212347 -122.500737615767 (37.7499882212347, -122.500737615767) 1 8 3 29491 35
170704 255422 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 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
174553 115183 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3610 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2016 12:00:00 AM     Permit Number 774488 5982230.3 2100857.8 37.7475254834273 -122.50423350924 (37.7475254834273, -122.50423350924) 1 8 3 29491 35
176832 207039 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 270 Magellan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994635.03268 2100302.9111 37.7467236374953 -122.461298810415 (37.7467236374953, -122.461298810415) 1 8 4 29491 40
177072 81730 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2346 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3 3x3 Permit Number 774950 5982707.54204511 2099147.52139682 37.7428575871403 -122.502456702486 (37.7428575871403, -122.502456702486) 1 8 3 29491 35
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
191846 182083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.7428580801695 -122.478007744126 (37.7428580801695, -122.478007744126) 1 8 3 29491 35
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

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