trees
356 rows where qSpecies_id = 91 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98903 | 239612 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007237.85888 | 2098768.99356 | 37.7432291067493 | -122.417610687906 | (37.7432291067493, -122.417610687906) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |||
23648 | 239611 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 230 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007188.60592 | 2098802.03139 | 37.7433170496408 | -122.417783333431 | (37.7433170496408, -122.417783333431) | 2 | 7 | 7 | 28859 | 2 | |||
59175 | 46762 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | 14 | 6x5 | Permit Number 44860 | 6007156.68652731 | 2098808.76351871 | 37.7433337382313 | -122.417894179823 | (37.7433337382313, -122.417894179823) | 2 | 7 | 7 | 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 | |||
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 | |||
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 | |||
63489 | 113030 | Undocumented 4 | Schinus molle :: California Pepper 91 | 200x ESMERALDA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 9x9 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | ||
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 | |||
112273 | 179424 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 367 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6005868 | 2092014 | 37.7246042151677 | -122.421867578972 | (37.7246042151677, -122.421867578972) | 9 | 7 | 7 | 309 | 5 | |||
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 |
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 | ||
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 | |||
36697 | 33682 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 417 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37761 | 6005332.3776 | 2111131.0936 | 37.7770651154691 | -122.425078750067 | (37.7770651154691, -122.425078750067) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
86523 | 179423 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6004767.82112 | 2092745.17359 | 37.7265497503523 | -122.425722776001 | (37.7265497503523, -122.425722776001) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
128342 | 239654 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | |||
51033 | 12258 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004950.99275 | 2110977.71573 | 37.7766224258639 | -122.426387156922 | (37.7766224258639, -122.426387156922) | 7 | 9 | 11 | 28852 | 10 | |||
70623 | 138859 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004948.1933 | 2110978.3343 | 37.7766239660594 | -122.426396885095 | (37.7766239660594, -122.426396885095) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
54807 | 136367 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 Hayes St | 5 | : | Tree | Private 2 | 16 | Width 3ft | 6004762.56149 | 2110859.02755 | 37.7762858838177 | -122.427030540428 | (37.7762858838177, -122.427030540428) | 7 | 9 | 11 | 28852 | 10 | |||
19961 | 142238 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004757.5201 | 2110863.998 | 37.776299246383 | -122.427048334097 | (37.776299246383, -122.427048334097) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
17752 | 70594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6004127.79616 | 2091299.57805 | 37.7225442769693 | -122.427832358882 | (37.7225442769693, -122.427832358882) | 9 | 7 | 6 | 28861 | 5 | |||
40288 | 239571 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 254 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 6004273.21361 | 2098704.8278 | 37.742885654747 | -122.427857083959 | (37.742885654747, -122.427857083959) | 2 | 7 | 5 | 63 | 22 | |||
47859 | 239656 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 701 Church St | 39 | Front Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6004336.93411 | 2104791.99581 | 37.759603202641 | -122.428070449907 | (37.759603202641, -122.428070449907) | 2 | 4 | 5 | 28862 | 3 | |||
98337 | 239657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 671 Church St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004329.6886 | 2104859.6882 | 37.7597886599416 | -122.428100332557 | (37.7597886599416, -122.428100332557) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
138709 | 52003 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 375 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | Permit Number 48220 | 6004122.23435698 | 2098354.44856915 | 37.7419150515767 | -122.428354161004 | (37.7419150515767, -122.428354161004) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||
114058 | 239648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004246.22251 | 2104509.47954 | 37.7588223473949 | -122.42836403987 | (37.7588223473949, -122.42836403987) | 2 | 4 | 5 | 28862 | 3 | |||
108016 | 239647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004225.35965 | 2104505.85925 | 37.7588112263749 | -122.428435935269 | (37.7588112263749, -122.428435935269) | 2 | 4 | 5 | 28862 | 3 | |||
51524 | 239649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3616 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004202.79012 | 2103671.51063 | 37.7565190253373 | -122.428454521557 | (37.7565190253373, -122.428454521557) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
120800 | 239577 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3961 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6004128.58692 | 2100700.88045 | 37.7483581715004 | -122.428499407621 | (37.7483581715004, -122.428499407621) | 2 | 4 | 5 | 63 | 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 | |||
128408 | 239640 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3627 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004151.81834 | 2103627.38126 | 37.756394971966 | -122.428627654542 | (37.756394971966, -122.428627654542) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
122194 | 239589 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003864.64018 | 2095248.99329 | 37.7333735991966 | -122.429023476774 | (37.7333735991966, -122.429023476774) | 9 | 7 | 5 | 28861 | 25 | |||
121655 | 239575 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1366 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6003880.55635 | 2100301.83973 | 37.7472484593616 | -122.42932864013 | (37.7472484593616, -122.42932864013) | 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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
131919 | 239655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 315 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003584.30488 | 2106480.06785 | 37.7641956329586 | -122.430793883956 | (37.7641956329586, -122.430793883956) | 8 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
112280 | 239644 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003494.59862 | 2105679.78343 | 37.7619931617634 | -122.431047029612 | (37.7619931617634, -122.431047029612) | 15 | 4 | 5 | 28862 | 3 | |||
82754 | 239645 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003486.01122 | 2105681.39131 | 37.7619970900117 | -122.431076844836 | (37.7619970900117, -122.431076844836) | 15 | 4 | 5 | 28862 | 3 | |||
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 | |||
136995 | 46069 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 2 | 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 | |||
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 | |||
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 | |||
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 | |||
63916 | 239643 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003364.63638 | 2105630.60252 | 37.7618507577208 | -122.431493007021 | (37.7618507577208, -122.431493007021) | 15 | 4 | 5 | 28862 | 3 | |||
71031 | 239642 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 37 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003350.6343 | 2105630.89155 | 37.7618507577148 | -122.431541455278 | (37.7618507577148, -122.431541455278) | 15 | 4 | 5 | 28862 | 3 | |||
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 | |||||
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 | |||
128413 | 244460 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003277.2679 | 2109662.4318 | 37.7729162274022 | -122.432083107592 | (37.7729162274022, -122.432083107592) | 15 | 9 | 11 | 29492 | 10 | |||
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 | |||
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 | |||
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 | |||||
135191 | 239568 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003022.32339 | 2098879.77623 | 37.7432951790362 | -122.432194801972 | (37.7432951790362, -122.432194801972) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
23853 | 35615 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
35370 | 35616 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
173467 | 35617 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 |
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) );