54 rows where Zip Codes = 29491 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

SiteOrder

Zip Codes

  • 29491 · 54
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)
4566 65966 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2644 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM 23   Permit Number 28988 5989285.4992 2097339.4197 37.7382773344848 -122.479579961543 (37.7382773344848, -122.479579961543) 1 8 3 29491 35
13131 261138 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2600 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         5984799 2099596 37.7442116594147 -122.4952581999 (37.7442116594147, -122.4952581999) 1 8 3 29491 35
78891 115281 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2320 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 774954 5988790.4 2098360 37.7410508098993 -122.481366468975 (37.7410508098993, -122.481366468975) 1 8 3 29491 35
85940 65809 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2268 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28777 5991325.30735018 2099972.38049218 37.7456250483576 -122.472719302053 (37.7456250483576, -122.472719302053) 1 8 4 29491 40
90019 115171 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2218 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM     Permit Number 774487 5982698.2 2099998.9 37.7451946889287 -122.502552005341 (37.7451946889287, -122.502552005341) 1 8 3 29491 35
111638 115173 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2063 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM     Permit Number 775267 5982265.3 2101066.7 37.7481011229623 -122.504127955016 (37.7481011229623, -122.504127955016) 1 8 3 29491 35
135735 97220 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 120 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 776182 5993132 2101212 37.749133146159 -122.466562169914 (37.749133146159, -122.466562169914) 1 8 4 29491 12
172961 46374 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2135 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/2016 12:00:00 AM 3   Permit Number 778548 5982916.26389717 2100594.08542438 37.7468417151598 -122.50184201898 (37.7468417151598, -122.50184201898) 1 8 3 29491 35
174591 51092 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1962 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2004 12:00:00 AM 8   Permit Number 47549 5987266.4855 2101911.4788 37.7507135030867 -122.486896287824 (37.7507135030867, -122.486896287824) 1 8 3 29491 35
192251 44734 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1434 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 15   Permit Number 43849 5988947.4767 2101073.1476 37.7485095315689 -122.481021968545 (37.7485095315689, -122.481021968545) 1 8 3 29491 35
77808 104992 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2423 47TH AVE 1 Sidewalk: Curb side : Yard Tree Private 2   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.7412333126477 -122.505795454359 (37.7412333126477, -122.505795454359) 1 8 3 29491 35
1070 261149 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 322x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991839 2099782 37.7451320352893 -122.470929181064 (37.7451320352893, -122.470929181064) 1 8 4 29491 40
1599 110941 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2484 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7 3x3   5984310 2098290 37.7405970958294 -122.496852660576 (37.7405970958294, -122.496852660576) 1 8 3 29491 35
5467 261155 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2119 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF     3x3   5983519 2100707 37.7471871347586 -122.499766192027 (37.7471871347586, -122.499766192027) 1 8 3 29491 35
9568 261150 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
11799 261147 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 1 Sidewalk: Property side : Cutout Tree Private 2 DPW     3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
12483 261152 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2279 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5982935 2099631 37.7441984490884 -122.501705991239 (37.7441984490884, -122.501705991239) 1 8 3 29491 35
12905 261154 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2246 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5982704 2099822 37.7447093112365 -122.502518859637 (37.7447093112365, -122.502518859637) 1 8 3 29491 35
15772 261153 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2291 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5982938 2099557 37.7439954416833 -122.501690144388 (37.7439954416833, -122.501690144388) 1 8 3 29491 35
16950 261148 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
17368 261151 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2107 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   5982896 2100761 37.7472988260012 -122.501924436785 (37.7472988260012, -122.501924436785) 1 8 3 29491 35
48427 109287 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2646 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773636 5982487.2 2097095.3 37.7372098007713 -122.503066669454 (37.7372098007713, -122.503066669454) 1 8 3 29491 35
98528 87814 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2000 10th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
110235 87815 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2000 10th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
125569 109039 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2439 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 773557 5985453.6 2098605.4 37.7415300428197 -122.492921815189 (37.7415300428197, -122.492921815189) 1 8 3 29491 35
138216 121328 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2455 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5986403.9195 2098529.3345 37.7413767161187 -122.489630387324 (37.7413767161187, -122.489630387324) 1 8 3 29491 35
157166 106344 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2428 14th Ave 1 Median : Cutout Tree Private 2   04/18/2014 12:00:00 AM   3x3   5992079 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
185739 106345 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2428 14th Ave 2 Median : Cutout Tree Private 2   04/18/2014 12:00:00 AM   3x3   5992079 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
186665 87813 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2000 10th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
187229 83487 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2051 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 10 3x3 Permit Number 50156 5982589.2289 2101159.5488 37.7483751044578 -122.503014711943 (37.7483751044578, -122.503014711943) 1 8 3 29491 35
145605 183545 Planning Code 138.1 required 2 Agonis flexuosa :: Peppermint Willow 65 2580 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.7393773655768 -122.482876432223 (37.7393773655768, -122.482876432223) 1 8 3 29491 35
5407 43618 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1918 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/28/2020 12:00:00 AM 3 5x5 Permit Number 43270 5985398.78072313 2102143.2200772 37.7512407312978 -122.493371949534 (37.7512407312978, -122.493371949534) 1 8 3 29491 35
171554 21401 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2692X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
18907 184945 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2000 41st Ave 9 Sidewalk: Curb side : Yard Tree Private 2 FUF 12/14/2019 12:00:00 AM 3 Width 0ft   5983552 2101519 37.7494185989562 -122.499712087956 (37.7494185989562, -122.499712087956) 1 8 3 29491 35
27616 185641 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2100 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985060.0587 2100441.1859 37.7465475916098 -122.494417818871 (37.7465475916098, -122.494417818871) 1 8 3 29491 35
39337 185946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984833.7396 2101513.2963 37.7494780662031 -122.495279445201 (37.7494780662031, -122.495279445201) 1 8 3 29491 35
40098 182924 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2627 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5981795.9682 2097192.3992 37.7374357552632 -122.505463727969 (37.7374357552632, -122.505463727969) 1 8 3 29491 35
105717 185947 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984831.6161 2101506.0763 37.7494581177315 -122.495286255832 (37.7494581177315, -122.495286255832) 1 8 3 29491 35
107403 185945 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984839.2608 2101514.9951 37.7494830539023 -122.495260478283 (37.7494830539023, -122.495260478283) 1 8 3 29491 35
114225 185942 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984826.9443 2101536.2304 37.7495406390981 -122.495304634302 (37.7495406390981, -122.495304634302) 1 8 3 29491 35
156768 187082 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2600 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985191.6703 2096995.0278 37.737093071648 -122.493708827707 (37.737093071648, -122.493708827707) 1 8 3 29491 35
184312 183416 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2685 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5989557.6977 2097079.8204 37.7375803497092 -122.478619864368 (37.7375803497092, -122.478619864368) 1 8 3 29491 35
12846 203946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2467 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2020 10:17:00 AM 3 Width 3ft   5991366.65316 2098632.35377 37.7419480728373 -122.472478660456 (37.7419480728373, -122.472478660456) 1 8 4 29491 40
23352 203570 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993253.16761 2101842.90601 37.7508724439217 -122.466189017022 (37.7508724439217, -122.466189017022) 1 8 4 29491 40
54598 203572 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993278.30091 2101842.3779 37.7508724439154 -122.466102066078 (37.7508724439154, -122.466102066078) 1 8 4 29491 40
74291 164206 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2539 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   5991384.96424 2098131.18541 37.7405730525915 -122.472378820421 (37.7405730525915, -122.472378820421) 1 8 4 29491 40
88932 203571 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993265.94889 2101843.04784 37.7508735707655 -122.466144828838 (37.7508735707655, -122.466144828838) 1 8 4 29491 40
3963 203515 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 301 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5993048.57106 2102513.42561 37.7527017117304 -122.466945265911 (37.7527017117304, -122.466945265911) 1 8 4 29491 12
62410 203526 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2424 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992054.19197 2098908.13909 37.7427450799172 -122.470121471754 (37.7427450799172, -122.470121471754) 1 8 4 29491 40
73816 203517 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 301 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5993021.77901 2102511.9902 37.7526962240514 -122.467037812458 (37.7526962240514, -122.467037812458) 1 8 4 29491 12
115309 203525 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2428 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992054.69549 2098894.88306 37.74270871135 -122.470118765694 (37.74270871135, -122.470118765694) 1 8 4 29491 40
142588 203516 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 301 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5993037.18841 2102512.99868 37.7526998825032 -122.466984597774 (37.7526998825032, -122.466984597774) 1 8 4 29491 12
144334 203523 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2478 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5992065.08232 2098589.24151 37.7418700980333 -122.470060601112 (37.7418700980333, -122.470060601112) 1 8 4 29491 40
175320 203524 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2428 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992056.59882 2098873.80652 37.7426509505813 -122.470110650206 (37.7426509505813, -122.470110650206) 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)
);