trees
356 rows where qSpecies_id = 91 sorted by PermitNotes
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );