356 rows where qSpecies_id = 91 sorted by PermitNotes

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)
146475 239633 DPW Maintained 1 Schinus molle :: California Pepper 91 11 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6004102.43046 2102956.46643 37.7545500028912 -122.428750628764 (37.7545500028912, -122.428750628764) 2 4 5 28862 22
146750 239581 DPW Maintained 1 Schinus molle :: California Pepper 91 3537 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004768.88841 2103660.24792 37.756520118925 -122.426495949253 (37.756520118925, -122.426495949253) 2 4 5 28862 22
146935 239586 DPW Maintained 1 Schinus molle :: California Pepper 91 103 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007116.95324 2098786.33455 37.743269917082 -122.418029977927 (37.743269917082, -122.418029977927) 2 7 7 28859 2
147452 183550 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5989227.3726 2097702.4617 37.7392707770079 -122.479807490437 (37.7392707770079, -122.479807490437) 1 8 3 29491 35
148145 119668 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 9 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
149335 239579 DPW Maintained 1 Schinus molle :: California Pepper 91 4059 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6003506.87632 2100667.44546 37.7482311647378 -122.430646881656 (37.7482311647378, -122.430646881656) 2 4 5 63 22
150336 239629 DPW Maintained 1 Schinus molle :: California Pepper 91 430 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003569.47839 2102760.68831 37.753982264481 -122.430579748167 (37.753982264481, -122.430579748167) 2 4 5 28862 22
152333 239639 DPW Maintained 1 Schinus molle :: California Pepper 91 3615 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004229.58112 2103632.14382 37.7564124493922 -122.428359063024 (37.7564124493922, -122.428359063024) 2 4 5 28862 22
152697 244482 DPW Maintained 1 Schinus molle :: California Pepper 91 235 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6001259.6239 2109499.111 37.7723531930337 -122.43905065598 (37.7723531930337, -122.43905065598) 15 5 11 29492 9
153086 136379 DPW Maintained 1 Schinus molle :: California Pepper 91 1 Nob Hill Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft   6009499.81555 2116296.95751 37.7914838769232 -122.411027191854 (37.7914838769232, -122.411027191854) 5 1 10 28857 21
154950 214159 DPW Maintained 1 Schinus molle :: California Pepper 91 711 Joost Ave 5 Sidewalk: Property side : Yard Tree Private 2     17     5997419.66265 2094969.48638 37.7322392132651 -122.451285300082 (37.7322392132651, -122.451285300082) 9 7 4 59 40
155796 239653 DPW Maintained 1 Schinus molle :: California Pepper 91 3512 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004899.76423 2103707.095 37.7566561476773 -122.426046668635 (37.7566561476773, -122.426046668635) 2 4 5 28862 3
158396 115363 Undocumented 4 Schinus molle :: California Pepper 91 1709 REVERE AVE 1 Front Yard : Yard Tree Private 2           6014548 2094736 37.7325639703463 -122.392051962294 (37.7325639703463, -122.392051962294) 10 3 8 58 1
158509 136378 DPW Maintained 1 Schinus molle :: California Pepper 91 1 Nob Hill Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6009539.87257 2116302.4428 37.7915011843851 -122.410888982239 (37.7915011843851, -122.410888982239) 5 1 10 28857 21
158555 104220 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
158611 214152 DPW Maintained 1 Schinus molle :: California Pepper 91 1414 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5990551.39802 2105727.60563 37.7613825499841 -122.47581554727 (37.7613825499841, -122.47581554727) 1 8 4 56 12
158691 112685 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 2 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
158697 214158 DPW Maintained 1 Schinus molle :: California Pepper 91 675 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 1ft   5996963.77337 2094391.63977 37.7306264707198 -122.452819711683 (37.7306264707198, -122.452819711683) 9 7 4 28861 40
160098 247665 DPW Maintained 1 Schinus molle :: California Pepper 91 126 Divisadero St 1 : Tree Private 2     13 Width 3ft   6001954.04638 2108418.01268 37.7694242526446 -122.436571192619 (37.7694242526446, -122.436571192619) 15 5 5 29492 9
161220 244226 DPW Maintained 1 Schinus molle :: California Pepper 91 340 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003259.6765 2109534.4722 37.7725638844758 -122.432134818626 (37.7725638844758, -122.432134818626) 15 9 11 29492 10
161884 214154 DPW Maintained 1 Schinus molle :: California Pepper 91 495 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   5993534.5206 2101855.05369 37.750922027151 -122.46521696231 (37.750922027151, -122.46521696231) 1 8 4 29491 40
162055 99797 Undocumented 4 Schinus molle :: California Pepper 91 703-705 Elizabeth St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
162473 239604 DPW Maintained 1 Schinus molle :: California Pepper 91 3980 22nd St 1 : Tree Private 2     1     6001965.58933 2102953.14284 37.7544197064144 -122.436140140357 (37.7544197064144, -122.436140140357) 2 4 5 28862 22
164670 217740 DPW Maintained 1 Schinus molle :: California Pepper 91 689 Frederick St 1 : Tree Private 2     5 Width 3ft   5996243.38999 2107249.52604 37.7658897191639 -122.456239488074 (37.7658897191639, -122.456239488074) 15 5 11 29492 12
166727 239603 DPW Maintained 1 Schinus molle :: California Pepper 91 890 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002439.95737 2103017.51215 37.7546233884599 -122.434504257392 (37.7546233884599, -122.434504257392) 2 4 5 28862 22
167131 247586 DPW Maintained 1 Schinus molle :: California Pepper 91 800 Tompkins Ave 7 Front Yard : Yard Tree Private 2     21     6008976.64658 2096466.10816 37.7370035750634 -122.411435734088 (37.7370035750634, -122.411435734088) 10 7 7 28859 2
168249 239583 DPW Maintained 1 Schinus molle :: California Pepper 91 857 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5998663.26171 2107205.3997 37.7659071714014 -122.447866512943 (37.7659071714014, -122.447866512943) 15 5 11 29492 9
168964 29596 DPW Maintained 1 Schinus molle :: California Pepper 91 900X Junipero Serra Blvd 5 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991179.03639 2091124.89815 37.7213236289735 -122.472580148063 (37.7213236289735, -122.472580148063) 9 8 4 64 40
169066 239666 DPW Maintained 1 Schinus molle :: California Pepper 91 260 Beacon St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6002994.59568 2097812.95314 37.7403643577184 -122.432214505197 (37.7403643577184, -122.432214505197) 2 7 5 63 7
169069 112686 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 3 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
169330 239650 DPW Maintained 1 Schinus molle :: California Pepper 91 771 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002455.69585 2103719.36042 37.7565513892455 -122.434500008966 (37.7565513892455, -122.434500008966) 2 4 5 28862 3
169418 239623 DPW Maintained 1 Schinus molle :: California Pepper 91 514 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002886.08981 2103305.68045 37.7554399450095 -122.432982000136 (37.7554399450095, -122.432982000136) 2 4 5 28862 22
169751 249770 DPW Maintained 1 Schinus molle :: California Pepper 91 102 Pfeiffer St 1 Side Yard : Yard Tree Private 2     8 Width 0ft   6010494.56062 2121168.81632 37.8049165440205 -122.407929079557 (37.8049165440205, -122.407929079557) 3 1 10 308 23
172414 256223 Property Tree 8 Schinus molle :: California Pepper 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree Rec/Park 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
175035 239590 DPW Maintained 1 Schinus molle :: California Pepper 91 732 Duncan St 1 Sidewalk: Curb side : Pot Tree Private 2     9 Width 10ft   6001765.51317 2099741.92053 37.745591085263 -122.436602215635 (37.745591085263, -122.436602215635) 2 7 5 63 22
176454 103991 DPW Maintained 1 Schinus molle :: California Pepper 91 490 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6X9   5992225.21796 2112091.38371 37.7789526802379 -122.470490047579 (37.7789526802379, -122.470490047579) 11 6 2 54 11
176676 214164 DPW Maintained 1 Schinus molle :: California Pepper 91 900 Junipero Serra Blvd 99 : Tree Private 2     5 Width 0ft   5991142.14923 2090504.71444 37.7196186222819 -122.47266246032 (37.7196186222819, -122.47266246032) 9 8 4 64 40
177046 239605 DPW Maintained 1 Schinus molle :: California Pepper 91 217 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5997066.3771 2107014.18212 37.7652907329028 -122.453375969329 (37.7652907329028, -122.453375969329) 15 5 11 29492 12
179689 239646 DPW Maintained 1 Schinus molle :: California Pepper 91 211 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004207.2629 2104504.88213 37.7588075193625 -122.428498452559 (37.7588075193625, -122.428498452559) 2 4 5 28862 3
179865 214168 DPW Maintained 1 Schinus molle :: California Pepper 91 250 Maywood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5994367.37708 2095058.85535 37.7323093567717 -122.46184414221 (37.7323093567717, -122.46184414221) 9 8 4 59 40
179961 138858 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6004946.3367 2111001.3561 37.7766870733429 -122.426404947187 (37.7766870733429, -122.426404947187) 7 9 11 28852 10
180003 119664 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 5 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
181076 197484 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 3 : Tree Private 2     8 Width 3ft   6007489.31465 2109652.98843 37.7731281986314 -122.417512429769 (37.7731281986314, -122.417512429769) 8 2 9 28853 19
181859 239580 DPW Maintained 1 Schinus molle :: California Pepper 91 4019 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6003715.87137 2100677.69284 37.748271139596 -122.429924914027 (37.748271139596, -122.429924914027) 2 4 5 63 22
182586 138852 DPW Maintained 1 Schinus molle :: California Pepper 91 604 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004921.1795 2110937.9117 37.776511448416 -122.426487454824 (37.776511448416, -122.426487454824) 7 9 11 28852 10
184088 108112 Permitted Site 7 Schinus molle :: California Pepper 91 690 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003299.11292 2109682.74913 37.7729732522628 -122.432008994211 (37.7729732522628, -122.432008994211) 15 9 11 29492 10
184817 197500 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 25 Sidewalk: Property side : Yard Tree Private 2     16     6013593.70141 2104032.4139 37.7580369298728 -122.396002464843 (37.7580369298728, -122.396002464843) 10 3 8 28856 29
185270 239632 DPW Maintained 1 Schinus molle :: California Pepper 91 87 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6004121.65636 2102563.78903 37.7534728911634 -122.428656150459 (37.7534728911634, -122.428656150459) 2 4 5 28862 22
186484 109125 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
186600 29610 DPW Maintained 1 Schinus molle :: California Pepper 91 900X Junipero Serra Blvd 19 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991173.75038 2091017.49654 37.7210284247022 -122.472590593675 (37.7210284247022, -122.472590593675) 9 8 4 64 40
186857 239569 DPW Maintained 1 Schinus molle :: California Pepper 91 541 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6003070.35446 2098885.05634 37.7433124001545 -122.432029100079 (37.7433124001545, -122.432029100079) 2 7 5 63 22
187275 136365 DPW Maintained 1 Schinus molle :: California Pepper 91 2624 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6000330.31034 2118901.65056 37.7981172142989 -122.442940566381 (37.7981172142989, -122.442940566381) 13 9 1 57 17
187579 197499 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 23 Sidewalk: Property side : Yard Tree Private 2     18     6013595.97387 2103991.32166 37.7579242259433 -122.395991726059 (37.7579242259433, -122.395991726059) 10 3 8 28856 29
188324 197498 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 22 Sidewalk: Property side : Yard Tree Private 2     9     6013596.26371 2103973.99117 37.757876656309 -122.395989509211 (37.757876656309, -122.395989509211) 10 3 8 28856 29
188533 239615 DPW Maintained 1 Schinus molle :: California Pepper 91 249 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007977.56297 2100289.57669 37.7474458848375 -122.4151605902 (37.7474458848375, -122.4151605902) 2 7 7 28859 2
189202 239636 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003794.28038 2103601.33494 37.7563032141343 -122.429862287926 (37.7563032141343, -122.429862287926) 2 4 5 28862 22
189330 117358 DPW Maintained 1 Schinus molle :: California Pepper 91 602 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6004920.03397 2110936.25791 37.7765068427555 -122.426491299758 (37.7765068427555, -122.426491299758) 7 9 11 28852 10
190814 214161 DPW Maintained 1 Schinus molle :: California Pepper 91 112 Marston Ave 5 Sidewalk: Property side : Yard Tree Private 2     2     5998700.79375 2093221.28064 37.7275123235144 -122.446730415591 (37.7275123235144, -122.446730415591) 9 7 4 28861 40
193003 239631 DPW Maintained 1 Schinus molle :: California Pepper 91 3946 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003468.88792 2102461.3534 37.7531546624799 -122.430906252449 (37.7531546624799, -122.430906252449) 2 4 5 28862 22
193261 247657 DPW Maintained 1 Schinus molle :: California Pepper 91 165 Divisadero St 1 : Tree Private 2     8 Width 3ft   6001871.68544 2108600.41157 37.7699203942357 -122.436869134409 (37.7699203942357, -122.436869134409) 15 5 5 29492 9
194508 203796 DPW Maintained 1 Schinus molle :: California Pepper 91 460 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993728.30174 2101878.83793 37.7509985054805 -122.464548580761 (37.7509985054805, -122.464548580761) 1 8 4 29491 12
148800 84811 Permitted Site 7 Schinus molle :: California Pepper 91 654 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2007 12:00:00 AM     Permit No. 49280 5997579.9 2108309.3 37.7688762175244 -122.451693255762 (37.7688762175244, -122.451693255762) 15 5 11 29492 9
57476 55227 DPW Maintained 1 Schinus molle :: California Pepper 91 211 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1972 12:00:00 AM 13   Permit Number 11145 5988668.09914 2113889.94192 37.7836846949952 -122.48292724876 (37.7836846949952, -122.48292724876) 11 6 2 55 26
16131 55409 Permitted Site 7 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/27/1987 12:00:00 AM     Permit Number 11349 6003719.33886967 2103195.40450941 37.7551843810696 -122.430092504551 (37.7551843810696, -122.430092504551) 2 4 5 28862 22
33981 59467 Permitted Site 7 Schinus molle :: California Pepper 91 225 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1980 12:00:00 AM     Permit Number 18832 6003936.96875248 2095250.30733216 37.7333813011767 -122.428773510363 (37.7333813011767, -122.428773510363) 9 7 5 28861 25
47789 59597 Permitted Site 7 Schinus molle :: California Pepper 91 636 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1981 12:00:00 AM   6x25 Permit Number 18994 6001186.92515468 2102684.94576678 37.7536390322156 -122.438813738462 (37.7536390322156, -122.438813738462) 2 4 5 28862 22
81470 61782 Permitted Site 7 Schinus molle :: California Pepper 91 2107 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1985 12:00:00 AM 20   Permit Number 21804 6012179.15182 2102325.12749 37.7532702936903 -122.400774668711 (37.7532702936903, -122.400774668711) 10 3 8 28856 29
30132 62463 DPW Maintained 1 Schinus molle :: California Pepper 91 1906 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1985 12:00:00 AM 9   Permit Number 22631 5999997.0295 2111289.4853 37.7771971847485 -122.443546707231 (37.7771971847485, -122.443546707231) 15 5 11 29490 16
63611 62514 Permitted Site 7 Schinus molle :: California Pepper 91 4221 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22694 6001435.41662208 2103337.91403702 37.7554460598899 -122.438001170091 (37.7554460598899, -122.438001170091) 2 4 5 28862 22
67293 62515 Permitted Site 7 Schinus molle :: California Pepper 91 4229 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22695 6001411.06683037 2103335.42666413 37.7554378453979 -122.43808520078 (37.7554378453979, -122.43808520078) 2 4 5 28862 22
168602 62517 Permitted Site 7 Schinus molle :: California Pepper 91 4315 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22698 6001100.3292402 2103290.9987582 37.7552981802714 -122.439156639775 (37.7552981802714, -122.439156639775) 2 4 5 28862 22
103771 62518 Permitted Site 7 Schinus molle :: California Pepper 91 4367 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22700 6000826.50003313 2103245.32733573 37.7551571922749 -122.440100345908 (37.7551571922749, -122.440100345908) 2 4 5 28862 22
41914 62527 Permitted Site 7 Schinus molle :: California Pepper 91 4255 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22709 6000857.54483189 2102854.89709726 37.7540869327376 -122.439964990906 (37.7540869327376, -122.439964990906) 2 4 5 28862 22
156347 63010 Permitted Site 7 Schinus molle :: California Pepper 91 9 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1986 12:00:00 AM     Permit Number 23424 6007395.1381387 2098224.27155142 37.7417422703287 -122.417028268249 (37.7417422703287, -122.417028268249) 2 7 7 28859 2
189872 60508 Permitted Site 7 Schinus molle :: California Pepper 91 282 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM   3x3 Permit Number 24310 6004065.51901322 2099574.2006491 37.7452610006153 -122.428637192649 (37.7452610006153, -122.428637192649) 2 7 5 63 22
94363 63682 Permitted Site 7 Schinus molle :: California Pepper 91 1366 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 24337 6003879.47043965 2100314.74724677 37.7472838389262 -122.429333315407 (37.7472838389262, -122.429333315407) 2 7 5 63 22
151790 63720 Permitted Site 7 Schinus molle :: California Pepper 91 249 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1987 12:00:00 AM 12 3x3 Permit Number 24385 6008064.48787212 2100278.68429699 37.7474208614245 -122.41485923795 (37.7474208614245, -122.41485923795) 2 7 7 28859 2
156673 63979 Permitted Site 7 Schinus molle :: California Pepper 91 801 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24719 6003748.05431866 2103616.18796413 37.7563413791419 -122.430023213091 (37.7563413791419, -122.430023213091) 2 4 5 28862 22
93453 53873 Permitted Site 7 Schinus molle :: California Pepper 91 3669 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24724 6003927.57680575 2103608.86941248 37.7563314496504 -122.429401840118 (37.7563314496504, -122.429401840118) 2 4 5 28862 22
96475 63982 Permitted Site 7 Schinus molle :: California Pepper 91 744 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24725 6004289.96903589 2104522.67899109 37.7588610652906 -122.428213684799 (37.7588610652906, -122.428213684799) 2 4 5 28862 3
178192 64253 Permitted Site 7 Schinus molle :: California Pepper 91 238 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/1988 12:00:00 AM     Permit Number 25052 6004384.37597616 2098713.60490953 37.7429160426191 -122.427473340495 (37.7429160426191, -122.427473340495) 2 7 5 63 22
43893 66181 DPW Maintained 1 Schinus molle :: California Pepper 91 1705 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1990 12:00:00 AM 14   Permit Number 29258 6014623.91982 2096111.26058 37.7363443702049 -122.391885618526 (37.7363443702049, -122.391885618526) 10 3 8 58 1
148538 66525 Permitted Site 7 Schinus molle :: California Pepper 91 4121 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29699 6002362.5628629 2102351.70560046 37.7527908488566 -122.434724299907 (37.7527908488566, -122.434724299907) 2 4 5 28862 22
34168 68064 Permitted Site 7 Schinus molle :: California Pepper 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31801 5993434.8119843 2102472.74927138 37.7526123103472 -122.465606631992 (37.7526123103472, -122.465606631992) 1 8 4 29491 12
159362 68308 DPW Maintained 1 Schinus molle :: California Pepper 91 2178 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 0   Permit Number 32119 5981736.58109187 2100266.85539552 37.7458738657157 -122.505896923616 (37.7458738657157, -122.505896923616) 1 8 3 29491 35
131504 68701 DPW Maintained 1 Schinus molle :: California Pepper 91 174 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/1993 12:00:00 AM 8   Permit Number 32613 5991836.39041 2114296.24984 37.7849841461432 -122.471995891724 (37.7849841461432, -122.471995891724) 11 6 2 54 11
148920 69361 DPW Maintained 1 Schinus molle :: California Pepper 91 3518 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 8   Permit Number 33455 6002672.47282 2120707.16348 37.8032079355658 -122.4349652022 (37.8032079355658, -122.4349652022) 13 9 1 57 17
132367 69363 DPW Maintained 1 Schinus molle :: California Pepper 91 3524 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 12   Permit Number 33457 6002667.84891 2120741.39075 37.8033016521051 -122.434983652687 (37.8033016521051, -122.434983652687) 13 9 1 57 17
8068 32395 DPW Maintained 1 Schinus molle :: California Pepper 91 222 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 6 8x6 Permit Number 36936 6005810.68419 2096104.55108 37.735832735077 -122.42235621788 (37.735832735077, -122.42235621788) 2 7 7 28859 2
185878 32430 DPW Maintained 1 Schinus molle :: California Pepper 91 36 Tingley St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/1996 12:00:00 AM 16   Permit Number 36957 6002798.58811 2093563.75666 37.7286859198974 -122.432588778773 (37.7286859198974, -122.432588778773) 9 7 6 28861 25
26202 32764 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37139 5995268.23997636 2113729.87048347 37.7836270090334 -122.460081822154 (37.7836270090334, -122.460081822154) 11 6 2 54 11
159315 32765 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37139 5995268.23997636 2113729.87048347 37.7836270090334 -122.460081822154 (37.7836270090334, -122.460081822154) 11 6 2 54 11
9816 32952 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
49320 32953 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
75500 32955 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
132958 32950 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
172673 32951 Permitted Site 7 Schinus molle :: California Pepper 91 673X Missouri St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
9411 33144 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37370 6001375.34520428 2103384.04824408 37.7555693169237 -122.438212219782 (37.7555693169237, -122.438212219782) 2 4 5 28862 3
122621 33145 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/09/1996 12:00:00 AM     Permit Number 37370 6001375.34520428 2103384.04824408 37.7555693169237 -122.438212219782 (37.7555693169237, -122.438212219782) 2 4 5 28862 3
175778 33535 Permitted Site 7 Schinus molle :: California Pepper 91 189 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM 14 4x4 Permit Number 37645 6007254.14606577 2097898.03626592 37.7408385685157 -122.417492657782 (37.7408385685157, -122.417492657782) 2 7 7 28859 2

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