trees
204 rows where SiteOrder = 1 and qSpecies_id = 91 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||||
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 | |
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 | |||
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 | |||
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 | |||||
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 | |||
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 | |||||
32623 | 138856 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004940.3956 | 2111052.9695 | 37.7768284552741 | -122.426429175067 | (37.7768284552741, -122.426429175067) | 7 | 9 | 11 | 28852 | 10 | |||
89257 | 33655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 542 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 22 | Permit Number 37744 | 6004783.29295 | 2110728.72543 | 37.775929278336 | -122.426949542114 | (37.775929278336, -122.426949542114) | 7 | 9 | 11 | 28852 | 10 | ||
89477 | 142226 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 542 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004780.8856 | 2110726.6251 | 37.7759233752217 | -122.426957720143 | (37.7759233752217, -122.426957720143) | 7 | 9 | 11 | 28852 | 10 | |||
104806 | 12260 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 611 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004921 | 2111005 | 37.7766956463335 | -122.426492853872 | (37.7766956463335, -122.426492853872) | 7 | 9 | 11 | 28852 | 10 | |||
108429 | 117357 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6004937.66325 | 2110937.75927 | 37.7765119617013 | -122.426430421921 | (37.7765119617013, -122.426430421921) | 7 | 9 | 11 | 28852 | 10 | |||
113901 | 12257 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004946.44345 | 2111002.77203 | 37.7766909671748 | -122.426404678747 | (37.7766909671748, -122.426404678747) | 7 | 9 | 11 | 28852 | 10 | |||
126077 | 138851 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004934.5518 | 2110939.3444 | 37.7765161381936 | -122.426441298216 | (37.7765161381936, -122.426441298216) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | ||
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 | |||
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 | |||
319 | 96811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 356 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996379.5 | 2106960.2 | 37.7651031164685 | -122.455747798641 | (37.7651031164685, -122.455747798641) | 15 | 5 | 11 | 29492 | 12 | ||||
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 | ||
61023 | 46902 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1416 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44958 | 5990552.94389775 | 2105736.96364621 | 37.7614083342209 | -122.47581088419 | (37.7614083342209, -122.47581088419) | 1 | 8 | 4 | 56 | 12 | ||
86676 | 214165 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 428 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5996451.80809 | 2106977.82649 | 37.7651556637169 | -122.455498978198 | (37.7651556637169, -122.455498978198) | 15 | 5 | 11 | 29492 | 12 | |||
92722 | 37473 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1453 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44951 | 5992709.117019 | 2105576.23529487 | 37.7610917906482 | -122.468341951453 | (37.7610917906482, -122.468341951453) | 1 | 8 | 4 | 56 | 12 | ||
97929 | 217735 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 723 Frederick St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5996116.65034 | 2107229.99676 | 37.7658288206775 | -122.456676438985 | (37.7658288206775, -122.456676438985) | 15 | 5 | 11 | 29492 | 12 | |||
119469 | 214167 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993435.67173 | 2102452.28847 | 37.7525561798324 | -122.465602172524 | (37.7525561798324, -122.465602172524) | 1 | 8 | 4 | 29491 | 12 | |||
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 | |||
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 | |||
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 | |||
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 | ||
31200 | 53044 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2006 12:00:00 AM | 11 | 3x3 | Permit Number 49022 | 6000981.43692 | 2118569.50402 | 37.797242328631 | -122.440663646636 | (37.797242328631, -122.440663646636) | 13 | 9 | 1 | 57 | 17 | |
98928 | 136366 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2323 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001763.72183 | 2119055.52403 | 37.7986213292711 | -122.437991580064 | (37.7986213292711, -122.437991580064) | 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 | |
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 | |
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 | |||
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 | |
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 | |||
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 | |||
60508 | 239566 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006878.39898 | 2100850.62787 | 37.748924571708 | -122.419001222341 | (37.748924571708, -122.419001222341) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
89962 | 239567 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3435 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006895.64188 | 2100851.73373 | 37.7489285791008 | -122.418941674643 | (37.7489285791008, -122.418941674643) | 2 | 4 | 7 | 28859 | 19 | |||
94142 | 46335 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44585 | 6006853.77058428 | 2100846.52070985 | 37.7489119074947 | -122.419086096292 | (37.7489119074947, -122.419086096292) | 2 | 4 | 7 | 28859 | 19 | ||
96303 | 110276 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3364 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2015 12:00:00 AM | 3 | 5x5 | Permit Number 775124 | 6007285 | 2101529 | 37.7508101157283 | -122.417643266234 | (37.7508101157283, -122.417643266234) | 2 | 4 | 7 | 28859 | 19 | |
164036 | 46334 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3776 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44584 | 6005338.11992395 | 2101398.90311865 | 37.7503431540329 | -122.424366507573 | (37.7503431540329, -122.424366507573) | 2 | 4 | 5 | 28859 | 19 | ||
166862 | 166073 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731 | 2102403 | 37.7532350085981 | -122.416162845847 | (37.7532350085981, -122.416162845847) | 2 | 4 | 7 | 28859 | 19 | |
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 |
27405 | 33584 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37692 | 6007187.40748461 | 2098136.50319387 | 37.7414895902405 | -122.417740314034 | (37.7414895902405, -122.417740314034) | 2 | 7 | 7 | 28859 | 2 | |||
81834 | 239609 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 98 Winfield St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 3ft | 6007121.02113 | 2098861.91271 | 37.7434776667546 | -122.41802126889 | (37.7434776667546, -122.41802126889) | 2 | 7 | 7 | 28859 | 2 | |||
98484 | 239610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6006341.94877 | 2097874.88988 | 37.7407236449682 | -122.420645058033 | (37.7407236449682, -122.420645058033) | 2 | 7 | 7 | 28859 | 2 | |||
109994 | 15661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005100.74203 | 2095958.24727 | 37.7353909444416 | -122.424800364285 | (37.7353909444416, -122.424800364285) | 2 | 7 | 5 | 28859 | 2 | |||
112033 | 239613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007098.78535 | 2096984.45251 | 37.7383213273752 | -122.417965090943 | (37.7383213273752, -122.417965090943) | 2 | 7 | 7 | 28859 | 2 | |||
124417 | 239608 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007254.62958 | 2098290.95874 | 37.7419174734269 | -122.417518826646 | (37.7419174734269, -122.417518826646) | 2 | 7 | 7 | 28859 | 2 | |||
134061 | 239607 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 189 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007238.5342 | 2097885.55109 | 37.7408034085529 | -122.417545753258 | (37.7408034085529, -122.417545753258) | 2 | 7 | 7 | 28859 | 2 | |||
137756 | 239587 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.417505004957 | (37.7430230396951, -122.417505004957) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 |
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 | ||
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 | ||||
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 | |
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
5132 | 239574 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 322 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 12x9 | 6003766 | 2099569 | 37.7452297653441 | -122.429672508032 | (37.7452297653441, -122.429672508032) | 2 | 7 | 5 | 63 | 22 | |||
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 | |
11918 | 239570 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x6 | 6003051.59742 | 2098931.52845 | 37.7434389383601 | -122.432097274966 | (37.7434389383601, -122.432097274966) | 2 | 7 | 5 | 63 | 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 | ||
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 | ||
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 | ||
58803 | 239578 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4092 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6003302.87663 | 2100696.16376 | 37.7482984592023 | -122.431354355844 | (37.7482984592023, -122.431354355844) | 2 | 4 | 5 | 28862 | 22 | |||
62623 | 239602 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 890 Castro St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002438.31508 | 2103064.33818 | 37.7547518683248 | -122.434513284763 | (37.7547518683248, -122.434513284763) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
70122 | 239595 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4131 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002300.0276 | 2102351.40526 | 37.7527864737179 | -122.434940536483 | (37.7527864737179, -122.434940536483) | 2 | 4 | 5 | 28862 | 22 | |||
70184 | 50941 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47603 | 6003770.24487259 | 2103216.54935313 | 37.7552453228177 | -122.429917964884 | (37.7552453228177, -122.429917964884) | 2 | 4 | 5 | 28862 | 22 | ||
73495 | 239599 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1627 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003378.62695 | 2098678.67199 | 37.7427631886738 | -122.430948447709 | (37.7427631886738, -122.430948447709) | 2 | 7 | 5 | 63 | 22 | |||
77030 | 239621 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 489 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 3ft | 6001854.41167 | 2103000.82295 | 37.7545443074853 | -122.436528033262 | (37.7545443074853, -122.436528033262) | 2 | 4 | 5 | 28862 | 22 | |||
78868 | 239576 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3971 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004073.25036 | 2100697.787 | 37.7483465459652 | -122.428690539642 | (37.7483465459652, -122.428690539642) | 2 | 4 | 5 | 63 | 22 | |||
79145 | 62516 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4239 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1986 12:00:00 AM | 3x3 | Permit Number 52133 | 6001380.62959357 | 2103332.31744832 | 37.7554275771996 | -122.438190239105 | (37.7554275771996, -122.438190239105) | 2 | 4 | 5 | 28862 | 22 | ||
83160 | 239664 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1140 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002488.98028 | 2102184.88968 | 37.7523399882133 | -122.434275200945 | (37.7523399882133, -122.434275200945) | 2 | 4 | 5 | 28862 | 22 | |||
85704 | 239634 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003772.61458 | 2103201.71767 | 37.7552047327212 | -122.429908711835 | (37.7552047327212, -122.429908711835) | 2 | 4 | 5 | 28862 | 22 | |||
89326 | 239635 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.429917553956 | (37.7562970969591, -122.429917553956) | 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 | ||
94236 | 239572 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 396 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003432.67407 | 2098660.37482 | 37.7427160111273 | -122.43076026277 | (37.7427160111273, -122.43076026277) | 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 | ||
95974 | 239591 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1436 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001977.64645 | 2099818.19455 | 37.7458125684911 | -122.435874148776 | (37.7458125684911, -122.435874148776) | 2 | 7 | 5 | 63 | 22 | |||
99964 | 97673 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003039 | 2098885 | 37.7433104678167 | -122.43213751159 | (37.7433104678167, -122.43213751159) | 2 | 7 | 5 | 63 | 22 | |||||
103494 | 239624 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 817 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002470.85858 | 2103435.32507 | 37.7557723569304 | -122.434427263721 | (37.7557723569304, -122.434427263721) | 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 | ||
105314 | 239626 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002499.39714 | 2103536.73091 | 37.7560524130043 | -122.434335817949 | (37.7560524130043, -122.434335817949) | 2 | 4 | 5 | 28862 | 22 | |||
112295 | 63956 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4232 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | 6002352.24062254 | 2101234.22323777 | 37.7497219215876 | -122.434680095003 | (37.7497219215876, -122.434680095003) | 2 | 4 | 5 | 28862 | 22 | |||
114455 | 239593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001191.36102 | 2102681.58859 | 37.7536300665832 | -122.438798157734 | (37.7536300665832, -122.438798157734) | 2 | 4 | 5 | 28862 | 22 | |||
116574 | 239573 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6004076.80225 | 2099571.54345 | 37.7452543431158 | -122.428597987734 | (37.7452543431158, -122.428597987734) | 2 | 7 | 5 | 63 | 22 |
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) );