356 rows where qSpecies_id = 91 sorted by Police Districts

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)
6247 20077 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY55 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
8265 19714 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY13 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
15670 19820 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY25 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 10ST                      
16158 19973 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
18879 19971 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
3391 122720 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.413960264957 (37.796903132994, -122.413960264957) 5 1 10 308 21
23970 136382 DPW Maintained 1 Schinus molle :: California Pepper 91 1015 Vallejo St 1 Front Yard : Yard Tree Private 2     14     6008613.87178 2118642.82165 37.7978753218528 -122.414258600758 (37.7978753218528, -122.414258600758) 5 1 10 308 21
40901 122721 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.413960264957 (37.796903132994, -122.413960264957) 5 1 10 308 21
48994 249781 DPW Maintained 1 Schinus molle :: California Pepper 91 119 Pfeiffer St 1 Back Yard : Yard Tree Private 2     9 Width 0ft   6010443.51385 2121141.6092 37.8048389819848 -122.408103813361 (37.8048389819848, -122.408103813361) 3 1 10 308 23
73636 136377 DPW Maintained 1 Schinus molle :: California Pepper 91 633 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009222.09013 2115205.65792 37.7884718549403 -122.41191097002 (37.7884718549403, -122.41191097002) 5 1 10 28852 21
81419 136381 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   6008695.6423 2118278.07408 37.7968784080765 -122.413949834731 (37.7968784080765, -122.413949834731) 5 1 10 308 21
141132 136380 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 1 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6008680.39017 2118276.96424 37.7968745041214 -122.414002532311 (37.7968745041214, -122.414002532311) 5 1 10 308 21
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
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
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
4861 40879 Permitted Site 7 Schinus molle :: California Pepper 91 38 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM     Permit Number 41789 6008346.99191908 2110451.53839796 37.775369049965 -122.414602124139 (37.775369049965, -122.414602124139) 8 2 9 28853 34
17498 49624 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 8   Permit Number 46480 6007909.99126 2109730.21129 37.7733638956484 -122.416062720842 (37.7733638956484, -122.416062720842) 8 2 9 28853 19
36540 49625 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM 6   Permit Number 768701 6007969.67353 2109667.22612 37.773194308705 -122.415851810006 (37.773194308705, -122.415851810006) 8 2 9 28853 19
38542 197482 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 1 : Tree Private 2     10 Width 3ft   6007465.83226 2109669.87011 37.7731732303985 -122.417594855315 (37.7731732303985, -122.417594855315) 8 2 9 28853 19
44107 111384 DPW Maintained 1 Schinus molle :: California Pepper 91 340 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6014593.21542 2112428.75748 37.7811469919725 -122.393133189548 (37.7811469919725, -122.393133189548) 6 2 9 28856 6
59453 49620 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/30/2008 12:00:00 AM 5 3x3 Permit Number 768701 6007925.38179 2109711.75094 37.7733140732115 -122.416008175135 (37.7733140732115, -122.416008175135) 8 2 9 28853 19
63478 42173 DPW Maintained 1 Schinus molle :: California Pepper 91 466 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM 11   Permit Number 42461 6010347.47254 2109513.35928 37.7729052153318 -122.407615799844 (37.7729052153318, -122.407615799844) 14 2 9 28853 34
75526 108931 Undocumented 4 Schinus molle :: California Pepper 91 1099x NATOMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2 Permit Number 774500 6007500 2109279 37.772101916333 -122.417448958018 (37.772101916333, -122.417448958018) 8 2 9 28853 19
78357 197485 DPW Maintained 1 Schinus molle :: California Pepper 91 15 Lafayette St 2 : Tree Private 2     13 Width 3ft   6007471.02195 2109700.81958 37.773258502312 -122.417579097413 (37.773258502312, -122.417579097413) 8 2 9 28853 19
90218 197483 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 2 : Tree Private 2     7 Width 3ft   6007475.11808 2109661.30518 37.7731502356402 -122.417562127216 (37.7731502356402, -122.417562127216) 8 2 9 28853 19
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
3344 197494 DPW Maintained 1 Schinus molle :: California Pepper 91 401 Texas St 3 : Tree Private 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
3568 197493 DPW Maintained 1 Schinus molle :: California Pepper 91 950x Kansas St 7 Median : Yard Tree DPW 1     25     6011595.70122 2103803.27065 37.7572963894245 -122.402896325021 (37.7572963894245, -122.402896325021) 10 3 8 28856 29
6035 264650 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
6293 97158 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.397943616401 (37.7189762599209, -122.397943616401) 10 3 8 58 1
6990 97154 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174) 10 3 8 58 1
7042 264648 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
7939 264649 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
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
12625 97159 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.60574 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286) 10 3 8 58 1
12626 97156 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
16110 173720 DPW Maintained 1 Schinus molle :: California Pepper 91 1799x 25th St 1 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
17499 264647 DPW Maintained 1 Schinus molle :: California Pepper 91 2400 Keith St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
18330 97157 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771) 10 3 8 58 1
18353 97155 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.95173 37.7190672497343 -122.398087681509 (37.7190672497343, -122.398087681509) 10 3 8 58 1
20260 197489 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 42 Front Yard : Yard Tree Private 2     8     6015361.30396 2102471.04633 37.753847930956 -122.389780232768 (37.753847930956, -122.389780232768) 10 3 8 28856 29
25942 197503 DPW Maintained 1 Schinus molle :: California Pepper 91 1799 25th St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6013488.947 2101929.32561 37.7522564753565 -122.396217358746 (37.7522564753565, -122.396217358746) 10 3 8 28856 1
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
44499 197504 DPW Maintained 1 Schinus molle :: California Pepper 91 1798 Revere Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12     6014086.53204 2095170.83461 37.733732305508 -122.393677804596 (37.733732305508, -122.393677804596) 10 3 8 58 1
46169 197497 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 18 Sidewalk: Property side : Yard Tree Private 2     14     6013599.16401 2103957.68535 37.7578320454303 -122.395978336045 (37.7578320454303, -122.395978336045) 10 3 8 28856 29
48059 202092 DPW Maintained 1 Schinus molle :: California Pepper 91 29 Carr St 1 : Tree Private 2     20 Width 3ft   6013102.77465 2090939.87812 37.7220602474585 -122.396782452268 (37.7220602474585, -122.396782452268) 10 3 8 58 1
48977 173723 DPW Maintained 1 Schinus molle :: California Pepper 91 1799x 25th St 2 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
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
56212 197490 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 43 Front Yard : Yard Tree Private 2     13     6015358.4418 2102466.66646 37.7538357460423 -122.38978982496 (37.7538357460423, -122.38978982496) 10 3 8 28856 29
58030 197487 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 28 Front Yard : Yard Tree Private 2     11     6015378.84744 2102468.94598 37.7538431366753 -122.389719416144 (37.7538431366753, -122.389719416144) 10 3 8 28856 29
58835 197505 DPW Maintained 1 Schinus molle :: California Pepper 91 1705 Newcomb Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6014625.38984 2096105.59346 37.7363288910633 -122.391880139859 (37.7363288910633, -122.391880139859) 10 3 8 58 1
60629 106612 Significant Tree 6 Schinus molle :: California Pepper 91 1189 TENNESSEE ST   Front Yard : Yard Tree Private 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
65868 197492 DPW Maintained 1 Schinus molle :: California Pepper 91 1501 25th St 20 Sidewalk: Curb side : Yard Tree Private 2     7     6014180.0421 2101964.05724 37.7523902711102 -122.393829855665 (37.7523902711102, -122.393829855665) 10 3 8 28856 1
67494 197496 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 17 Sidewalk: Property side : Yard Tree Private 2     11     6013599.60524 2103941.4739 37.7577875568584 -122.395975674052 (37.7577875568584, -122.395975674052) 10 3 8 28856 29
68839 119665 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 6 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 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
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
82256 197486 DPW Maintained 1 Schinus molle :: California Pepper 91 1112 Tennessee St 2 Sidewalk: Curb side : Pot Tree Private 2     19 Width 6ft   6015516.35006 2103817.53146 37.7575536899561 -122.389338063096 (37.7575536899561, -122.389338063096) 10 3 8 28856 29
86380 173724 DPW Maintained 1 Schinus molle :: California Pepper 91 1101 Connecticut St 1 Sidewalk: Property side : Cutout Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
91095 197506 DPW Maintained 1 Schinus molle :: California Pepper 91 1079 Le Conte Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012767.16405 2089807.75284 37.7189329737454 -122.397863208018 (37.7189329737454, -122.397863208018) 10 3 8 58 1
116094 197488 DPW Maintained 1 Schinus molle :: California Pepper 91 1301 Minnesota St 29 Front Yard : Yard Tree Private 2     9     6015374.95978 2102473.44448 37.753855273025 -122.389733174866 (37.753855273025, -122.389733174866) 10 3 8 28856 29
120041 197495 DPW Maintained 1 Schinus molle :: California Pepper 91 651 Missouri St 15 Sidewalk: Property side : Yard Tree Private 2     9     6013600.82032 2103923.07952 37.757737117488 -122.39597018278 (37.757737117488, -122.39597018278) 10 3 8 28856 29
125492 119663 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 4 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
128125 197491 DPW Maintained 1 Schinus molle :: California Pepper 91 900x Carolina St 23 Median : Yard Tree DPW 1     1     6012477.42612 2103497.47149 37.7565059267156 -122.399825482885 (37.7565059267156, -122.399825482885) 10 3 8 28856 29
129925 200733 DPW Maintained 1 Schinus molle :: California Pepper 91 1462 Oakdale Ave 3 unknown : Yard Tree Private 2     14 Width 0ft   6015790.512 2094948.0194 37.7332150397253 -122.387771048105 (37.7332150397253, -122.387771048105) 10 3 8 58 1
132843 119662 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 3 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 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
140313 197502 DPW Maintained 1 Schinus molle :: California Pepper 91 1799 25th St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 8ft   6013459.53083 2101928.68892 37.752253090306 -122.396319040597 (37.752253090306, -122.396319040597) 10 3 8 28856 1
141927 197501 DPW Maintained 1 Schinus molle :: California Pepper 91 1101 Connecticut St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 8ft   6013434.27998 2101904.95506 37.752186517095 -122.396404699215 (37.752186517095, -122.396404699215) 10 3 8 28856 1
145663 119666 Undocumented 4 Schinus molle :: California Pepper 91 699x Missouri St 7 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
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
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
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
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
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
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
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
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
10299 239628 DPW Maintained 1 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003717.59485 2103189.68577 37.7551685799882 -122.430098127942 (37.7551685799882, -122.430098127942) 2 4 5 28862 22
11330 166753 Planning Code 138.1 required 2 Schinus molle :: California Pepper 91 350 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2019 12:00:00 AM 3 4x4 Permit Number 781737 6002856.72425 2101550.76622 37.7506197011549 -122.43295818429 (37.7506197011549, -122.43295818429) 2 4 5 28862 22
12994 239597 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 6ft   6003266.18046 2100734.45358 37.7484015143127 -122.431483983218 (37.7484015143127, -122.431483983218) 2 4 5 28862 22
13603 239638 DPW Maintained 1 Schinus molle :: California Pepper 91 3689 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003857.31467 2103604.80906 37.7563163226577 -122.429644541356 (37.7563163226577, -122.429644541356) 2 4 5 28862 22
15530 239630 DPW Maintained 1 Schinus molle :: California Pepper 91 431 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 3ft   6003562.89343 2102710.70444 37.7538446475336 -122.430598954102 (37.7538446475336, -122.430598954102) 2 4 5 28862 22
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
17171 239598 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 6ft   6003265.33612 2100745.73511 37.7484324428976 -122.431487708187 (37.7484324428976, -122.431487708187) 2 4 5 28862 22
20090 104219 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
23040 239637 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003808.38299 2103603.27195 37.7563093313217 -122.429813654389 (37.7563093313217, -122.429813654389) 2 4 5 28862 22
23225 239627 DPW Maintained 1 Schinus molle :: California Pepper 91 3885 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002571.81479 2103540.6818 37.7560673714328 -122.434085656222 (37.7560673714328, -122.434085656222) 2 4 5 28862 22
33437 239641 DPW Maintained 1 Schinus molle :: California Pepper 91 3637 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004113.74882 2103625.61972 37.7563879806327 -122.428759186701 (37.7563879806327, -122.428759186701) 2 4 5 28862 22
33717 99818 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
33743 5505 DPW Maintained 1 Schinus molle :: California Pepper 91 785 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 6X8   6005062.26258 2103781.17825 37.756868745618 -122.425489962193 (37.756868745618, -122.425489962193) 2 4 5 28859 19
35105 46070 Permitted Site 7 Schinus molle :: California Pepper 91 3746 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44454 6003440.19743527 2103634.04731282 37.7563729765603 -122.431089163341 (37.7563729765603, -122.431089163341) 2 4 5 28862 3
35161 239594 DPW Maintained 1 Schinus molle :: California Pepper 91 636 Douglass St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6001191.4238 2102669.11785 37.7535958285084 -122.43879704705 (37.7535958285084, -122.43879704705) 2 4 5 28862 22
36387 251333 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007705.96721 2102462.31706 37.7533964721949 -122.416253615419 (37.7533964721949, -122.416253615419) 2 4 7 28859 19
39126 52643 Permitted Site 7 Schinus molle :: California Pepper 91 4264REVISED 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/2006 12:00:00 AM     Permit Number 48726 6000793.82011207 2102903.5552845 37.7542169085305 -122.440188854974 (37.7542169085305, -122.440188854974) 2 4 5 28862 22
40104 156622 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007708.67537 2102405.47581 37.7532405513196 -122.416240224501 (37.7532405513196, -122.416240224501) 2 4 7 28859 19
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
47659 53355 Permitted Site 7 Schinus molle :: California Pepper 91 4131 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1969 12:00:00 AM     Permit Number 6248 6002301.07087845 2102348.37639489 37.752778216412 -122.434936712045 (37.752778216412, -122.434936712045) 2 4 5 28862 22
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

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