trees
204 rows where SiteOrder = 1 and qSpecies_id = 91
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54411 | 214169 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 266 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000318.85701 | 2094968.44865 | 37.7324019411004 | -122.441262082491 | (37.7324019411004, -122.441262082491) | 9 | 7 | 5 | 63 | 40 | |||
55243 | 239585 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 838 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998709.19727 | 2107219.09568 | 37.7659474025784 | -122.44770861806 | (37.7659474025784, -122.44770861806) | 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 | ||
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 | |||
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 | |||
59190 | 183549 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989226.3762 | 2097721.7265 | 37.7393236152619 | -122.479812344828 | (37.7393236152619, -122.479812344828) | 1 | 8 | 3 | 29491 | 35 | |||
59784 | 45068 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2227 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 4 | Permit Number 43949 | 5987902.9352 | 2100130.6194 | 37.7458608246267 | -122.4845648054 | (37.7458608246267, -122.4845648054) | 1 | 8 | 3 | 29491 | 35 | |
60322 | 49747 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1266 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46546 | 6011753.83246 | 2088984.50512 | 37.7166160162035 | -122.401308097113 | (37.7166160162035, -122.401308097113) | 10 | 7 | 8 | 309 | 39 | |
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 | |||
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 | ||
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 | |||
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 | |
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 | ||
65791 | 247660 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 117 Divisadero St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6001900.46366 | 2108395.08084 | 37.7693582424224 | -122.436754890829 | (37.7693582424224, -122.436754890829) | 15 | 5 | 5 | 29492 | 9 | |||
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 | ||
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 | |||
71330 | 42296 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 7 | 4x5 | Permit Number 42524 | 5999448.10009127 | 2093930.90110115 | 37.7295034375942 | -122.444197952384 | (37.7295034375942, -122.444197952384) | 9 | 7 | 4 | 63 | 40 |
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 | |||
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 | |||
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 | ||
76751 | 49937 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2591 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 4 | Permit Number 46696 | 5988296.2269 | 2097703.198 | 37.7392186595719 | -122.483026991295 | (37.7392186595719, -122.483026991295) | 1 | 8 | 3 | 29491 | 35 | |
76756 | 239659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 155 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001303.69127 | 2106216.90984 | 37.7633435891615 | -122.438662997693 | (37.7633435891615, -122.438662997693) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
77871 | 214162 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 56 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995350.86908 | 2090273.63849 | 37.7192268694992 | -122.458097813856 | (37.7192268694992, -122.458097813856) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
80743 | 247658 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001895.26535 | 2108435.04385 | 37.7694676755344 | -122.436775732636 | (37.7694676755344, -122.436775732636) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |
81568 | 239652 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 759 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002456.72459 | 2103769.12094 | 37.7566880780974 | -122.434500008993 | (37.7566880780974, -122.434500008993) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
82801 | 239584 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 863 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998665.55754 | 2107188.82134 | 37.7658617826328 | -122.447857378524 | (37.7658617826328, -122.447857378524) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
84224 | 239582 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 43 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5998416.52248 | 2107203.63932 | 37.765888231668 | -122.448719802287 | (37.765888231668, -122.448719802287) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||||
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 | ||||
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 | |||
87765 | 247489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 868 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002408.5917 | 2109542.1708 | 37.7725367328675 | -122.435079355167 | (37.7725367328675, -122.435079355167) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | |||
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 | |||
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 | |||
90678 | 112684 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
94390 | 100751 | Undocumented 4 | Schinus molle :: California Pepper 91 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002451 | 2103738 | 37.7566023024977 | -122.434517581577 | (37.7566023024977, -122.434517581577) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
98626 | 104776 | Undocumented 4 | Schinus molle :: California Pepper 91 | 767 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6002481.8 | 2103753.5 | 37.7566466101352 | -122.434412172394 | (37.7566466101352, -122.434412172394) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
99414 | 214166 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.454071648891 | (37.729086671304, -122.454071648891) | 9 | 7 | 4 | 28861 | 40 | |||
99586 | 117533 | Undocumented 4 | Schinus molle :: California Pepper 91 | 870 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002404 | 2109622 | 37.7727556633357 | -122.435100948925 | (37.7727556633357, -122.435100948925) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||||
100553 | 100750 | Undocumented 4 | Schinus molle :: California Pepper 91 | 757 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002448 | 2103795 | 37.7567586405263 | -122.434532032094 | (37.7567586405263, -122.434532032094) | 2 | 4 | 5 | 28862 | 3 | |||
101688 | 50158 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1863@ ORTEGA 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2003 12:00:00 AM | 4 | Permit Number 46871 | 5985958.4054 | 2102559.7986 | 37.7524172606528 | -122.491467392102 | (37.7524172606528, -122.491467392102) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
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 | |||
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 | |||
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 | |||
109460 | 122117 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 141 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990819.37104 | 2114444.89613 | 37.7853333844834 | -122.475525275427 | (37.7853333844834, -122.475525275427) | 11 | 6 | 2 | 54 | 26 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
117373 | 239600 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000853.41096 | 2102858.4973 | 37.754096582697 | -122.439979544931 | (37.754096582697, -122.439979544931) | 2 | 4 | 5 | 28862 | 22 | |||
117522 | 45371 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 165 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 49668 | 6001878.15662511 | 2108576.11606242 | 37.7698540525754 | -122.436845011254 | (37.7698540525754, -122.436845011254) | 15 | 5 | 5 | 29492 | 9 | |||
117755 | 35754 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985859.7786 | 2112565.45862 | 37.7798842387291 | -122.492545259885 | (37.7798842387291, -122.492545259885) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
119856 | 239663 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6002486.58464 | 2102202.41494 | 37.7523879724368 | -122.434284738254 | (37.7523879724368, -122.434284738254) | 2 | 4 | 5 | 28862 | 22 | |||
120428 | 239651 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002456.2179 | 2103744.61211 | 37.7566207539655 | -122.434500008976 | (37.7566207539655, -122.434500008976) | 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 | |||
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 | |||
122190 | 239601 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001018.49265 | 2103293.22516 | 37.7552996363918 | -122.439439814104 | (37.7552996363918, -122.439439814104) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | ||
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 | |||
125113 | 214170 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 158 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999431.23761 | 2093723.53638 | 37.7289331003841 | -122.444241352082 | (37.7289331003841, -122.444241352082) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
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 | |||
130978 | 20249 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1880 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2000 12:00:00 AM | 10 | 3X3 | 6002546.9119 | 2114591.5393 | 37.7864088846335 | -122.43496207541 | (37.7864088846335, -122.43496207541) | 13 | 9 | 11 | 29490 | 27 | ||
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 | ||
131779 | 4362 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001187.63557 | 2096055.63136 | 37.7354365441677 | -122.438336378342 | (37.7354365441677, -122.438336378342) | 2 | 7 | 5 | 63 | 7 | |||
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 | |
132442 | 239661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1128 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6002484.84221 | 2102239.39907 | 37.7524894231662 | -122.434293407712 | (37.7524894231662, -122.434293407712) | 2 | 4 | 5 | 28862 | 22 | |||
132503 | 239660 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002481.9632 | 2102282.2017 | 37.7526067855982 | -122.434306423626 | (37.7526067855982, -122.434306423626) | 2 | 4 | 5 | 28862 | 22 | |||
133494 | 136375 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999802.94718 | 2117441.8408 | 37.7940788832989 | -122.44466041095 | (37.7940788832989, -122.44466041095) | 13 | 9 | 1 | 57 | 27 | |||
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 |
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) );