trees

52 rows where SiteOrder = 3, qLegalStatus_id = 1 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

qLegalStatus_id ✖

  • DPW Maintained · 52 ✖

SiteOrder ✖

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)
15441 70583 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1801 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5989858.46515 2113331.71432 37.7822211492768 -122.478768239422 (37.7822211492768, -122.478768239422) 11 6 2 55 26
16687 74647 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004365.04367 2091463.54141 37.7230079026666 -122.42702391962 (37.7230079026666, -122.42702391962) 9 7 6 28861 5
64277 37529 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1244 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 21   Permit Number 39976 6007263.39142 2115650.05703 37.7895819825607 -122.418719304647 (37.7895819825607, -122.418719304647) 13 9 10 28858 21
121537 256166 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 200 Laguna St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF         6005182.68808 2109644.93499 37.772976028407 -122.425490781615 (37.772976028407, -122.425490781615) 7 9 11 28852 10
175001 124270 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2 03rd Ave 3 Front Yard : Yard Tree Private 2     14     5994893.51688 2115041.88961 37.78720789934 -122.461473360648 (37.78720789934, -122.461473360648) 11 6 1 54 11
193468 114082 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5997500.7704 2113521.7588 37.7831837426404 -122.452343137457 (37.7831837426404, -122.452343137457) 15 6 1 54 31
4034 158226 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 217 Whitney St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6004403.18115 2097173.01672 37.7386870025035 -122.427298598675 (37.7386870025035, -122.427298598675) 2 7 5 63 7
10290 90682 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3900 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983432.26602 2110389.71572 37.7737680483939 -122.500782026808 (37.7737680483939, -122.500782026808) 11 6 2 55 26
24090 90673 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3750x CABRILLO ST 3 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 3 3x3   5984009 2110380 37.7737752151611 -122.498786325695 (37.7737752151611, -122.498786325695) 11 6 2 55 26
43723 90660 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3500X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984694.72726 2110433.79882 37.7739631265543 -122.496418292329 (37.7739631265543, -122.496418292329) 11 6 2 55 26
51801 90784 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3701X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984081.19373 2110355.47188 37.7737121020185 -122.498534787816 (37.7737121020185, -122.498534787816) 11 6 2 55 26
67477 90697 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4100X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982827.55624 2110364.98681 37.7736646287423 -122.502871948318 (37.7736646287423, -122.502871948318) 11 6 2 55 26
79370 90796 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3549 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984574.63821 2110374.75064 37.7737939613496 -122.496829335351 (37.7737939613496, -122.496829335351) 11 6 2 55 26
92398 91464 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2009 12:00:00 AM 9 3x3 Permit Number 52106 6008023.92041 2119932.41057 37.8013830546338 -122.416391395149 (37.8013830546338, -122.416391395149) 5 1 1 308 32
106840 82673 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 67 Jennings Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 1 3x3 Permit Number 52499 6012920.29338 2089198.31583 37.7172681083272 -122.397291182543 (37.7172681083272, -122.397291182543) 10 3 8 58 1
114939 90793 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3601 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984413.80757 2110367.78962 37.7737654233107 -122.49738515175 (37.7737654233107, -122.49738515175) 11 6 2 55 26
117767 158241 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 225 Bemis St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 778932 6003145.71012 2096365.89505 37.7363996353363 -122.431588728148 (37.7363996353363, -122.431588728148) 2 7 5 63 7
121570 90766 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3951X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983343.71874 2110330.47884 37.7736002020107 -122.501083938875 (37.7736002020107, -122.501083938875) 11 6 2 55 26
151383 1266 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3995X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5992143.83128 2087204.78999 37.7106157610663 -122.46896001711 (37.7106157610663, -122.46896001711) 9 8 4 64 24
152099 90778 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3801X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983771.39601 2110344.03814 37.773662535505 -122.499605564361 (37.773662535505, -122.499605564361) 11 6 2 55 26
154640 90688 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4000X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983129.59902 2110378.53332 37.7737195704462 -122.501828155386 (37.7737195704462, -122.501828155386) 11 6 2 55 26
154869 90808 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3403 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5985025.16514 2110390.85068 37.7738645554816 -122.495272101296 (37.7738645554816, -122.495272101296) 11 6 2 55 26
156379 90787 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3651 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984249.69419 2110361.4466 37.7737383870444 -122.497952368705 (37.7737383870444, -122.497952368705) 11 6 2 55 26
164551 90753 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4139 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982725.59216 2110306.95683 37.7734993021465 -122.503220354519 (37.7734993021465, -122.503220354519) 11 6 2 55 26
175685 90772 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3899X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983556.085422 2110343.567935 37.7736486085903 -122.500350310129 (37.7736486085903, -122.500350310129) 11 6 2 55 26
187831 90759 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4101X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5982835.15592 2110311.87807 37.773519254193 -122.502841728095 (37.773519254193, -122.502841728095) 11 6 2 55 26
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
8169 160453 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
33220 139917 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1000 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004809.1682 2112368.8803 37.7804342038606 -122.426976875009 (37.7804342038606, -122.426976875009) 7 9 11 28852 41
92411 244965 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 250 Lily St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005276.5809 2110102.9361 37.7742388930949 -122.42519859053 (37.7742388930949, -122.42519859053) 7 9 11 28852 10
23153 125554 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 1ft   6010380.8435 2116036.16558 37.7908171708214 -122.40796043625 (37.7908171708214, -122.40796043625) 5 1 10 28857 21
2752 221825 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008302.15962 2096532.14097 37.7371470321954 -122.41377241466 (37.7371470321954, -122.41377241466) 2 7 7 28859 2
151528 175210 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6005427.44885 2093231.28592 37.7279217605751 -122.423477009653 (37.7279217605751, -122.423477009653) 9 7 6 28861 5
160387 203556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906 (37.7140014477822, -122.45920347906) 9 8 6 28861 24
183128 175208 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005371.81589 2093231.88981 37.727920278496 -122.423669377345 (37.727920278496, -122.423669377345) 9 7 6 28861 5
192333 221847 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004411.28278 2095593.12873 37.7343494454616 -122.427158084072 (37.7343494454616, -122.427158084072) 2 7 5 28861 25
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
40387 203586 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 77 Staples Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 3ft   5999493.48314 2093757.18666 37.7290290472426 -122.444028582376 (37.7290290472426, -122.444028582376) 9 7 4 63 40
79681 221871 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007314.53376 2097779.75076 37.7405171804218 -122.417275479073 (37.7405171804218, -122.417275479073) 2 7 7 28859 2
85330 221801 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 378 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003412.45231 2099242.88691 37.7443143087709 -122.430871746349 (37.7443143087709, -122.430871746349) 2 7 5 63 22
93237 203567 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Colon Ave 3 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5996068.02094 2094221.27645 37.7301073235953 -122.455904133578 (37.7301073235953, -122.455904133578) 9 7 4 28861 40
114883 221926 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.55536 2104400.84265 37.7584570634637 -122.432446488035 (37.7584570634637, -122.432446488035) 2 4 5 28862 3
139805 117947 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5983640.26853 2110338.90864 37.7736407564987 -122.500058768002 (37.7736407564987, -122.500058768002) 11 6 2 55 26
149081 221900 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004249.68912 2095508.61359 37.7341082463924 -122.427710746252 (37.7341082463924, -122.427710746252) 2 7 5 28861 25
188028 221867 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2825 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002454.8642 2095527.53959 37.7340585219649 -122.43391736341 (37.7340585219649, -122.43391736341) 2 7 5 63 7
189738 203583 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Gennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5997456.92965 2093746.95791 37.72888457474 -122.451068332359 (37.72888457474, -122.451068332359) 9 7 4 28861 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
65106 175181 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 690 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002921.15596 2089379.53862 37.7172039398928 -122.431866410902 (37.7172039398928, -122.431866410902) 9 7 6 28861 5
150779 125547 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6005968.56582 2119641.09275 37.8004673748183 -122.423483123267 (37.8004673748183, -122.423483123267) 13 9 1 28858 32
30130 221910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6003225.80615 2101486.76003 37.7504648828526 -122.431677300586 (37.7504648828526, -122.431677300586) 2 4 5 28862 22
92331 125545 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3211 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   5999423.84524 2115333.31799 37.7882677951647 -122.445820424872 (37.7882677951647, -122.445820424872) 13 6 1 29490 31
35544 221939 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 21 Harry St 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6003408.10773 2097774.81236 37.740283068906 -122.430782023672 (37.740283068906, -122.430782023672) 2 7 5 63 7

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