trees
49 rows where SiteOrder = 5 and qSpecies_id = 93
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
8307 | 141930 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004152.017 | 2111873.3634 | 37.7790364568014 | -122.429214926277 | (37.7790364568014, -122.429214926277) | 7 | 9 | 11 | 29490 | 41 | |||
13099 | 197577 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691 | (37.735854408739, -122.38427457691) | 10 | 3 | 8 | 58 | 1 | ||||
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
16140 | 75536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5984118.85326 | 2110953.37322 | 37.7753559754601 | -122.498448691476 | (37.7753559754601, -122.498448691476) | 11 | 6 | 2 | 55 | 26 | |||
18053 | 179450 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006580.77916 | 2087379.51909 | 37.7119190900695 | -122.419075015325 | (37.7119190900695, -122.419075015325) | 9 | 7 | 8 | 309 | 39 | |||
23209 | 240568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 250 Douglass St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001090.59678 | 2104810.17001 | 37.7594689014801 | -122.439299182613 | (37.7594689014801, -122.439299182613) | 2 | 4 | 5 | 28862 | 3 | |||
26984 | 113593 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013606.07873 | 2118153.06914 | 37.7968097322489 | -122.396949681183 | (37.7968097322489, -122.396949681183) | 3 | 1 | 10 | 28860 | 6 | |||
27804 | 239722 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 400 Clipper St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6002450.40135 | 2100940.81884 | 37.7489218746471 | -122.434319677816 | (37.7489218746471, -122.434319677816) | 2 | 4 | 5 | 28862 | 22 | |||
28758 | 140668 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 544 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996917.2741 | 2109577.8331 | 37.7723213107109 | -122.454076850691 | (37.7723213107109, -122.454076850691) | 15 | 5 | 11 | 29492 | 16 | |||
34991 | 197524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010641.49765 | 2106679.01368 | 37.7651392052289 | -122.406398976647 | (37.7651392052289, -122.406398976647) | 8 | 4 | 8 | 28853 | 19 | |||
38505 | 251188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
40555 | 118221 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5984455.23409 | 2111482.21189 | 37.7768277344481 | -122.497324138201 | (37.7768277344481, -122.497324138201) | 11 | 6 | 2 | 55 | 26 | |||
41322 | 21853 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 199X Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995153.19322 | 2110756.08274 | 37.7754551631243 | -122.460264307742 | (37.7754551631243, -122.460264307742) | 11 | 6 | 2 | 54 | 11 | |||
57291 | 197558 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6011389.0063 | 2107291.61952 | 37.7668630707131 | -122.403856622907 | (37.7668630707131, -122.403856622907) | 8 | 2 | 8 | 28853 | 20 | |||
57345 | 109300 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
58886 | 807 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983808.20604 | 2111664.13118 | 37.7772892893219 | -122.499575815745 | (37.7772892893219, -122.499575815745) | 11 | 6 | 2 | 55 | 26 | |||
59514 | 141904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.427190969626 | (37.7792912400822, -122.427190969626) | 7 | 9 | 11 | 29490 | 41 | |||
74893 | 179487 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.7286417658841 | -122.437257104634 | (37.7286417658841, -122.437257104634) | 9 | 7 | 6 | 28861 | 25 | |||
91581 | 179435 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006500.60842 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | 9 | 7 | 8 | 309 | 39 | |||
93529 | 40573 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
94986 | 197510 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009757.95432 | 2109468.49949 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | 14 | 2 | 9 | 28853 | 34 | ||||
96924 | 197573 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | 6 | 2 | 9 | 28853 | 34 | |||
98557 | 111030 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
108079 | 200675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | 10 | 3 | 8 | 58 | 1 | |||
112551 | 179428 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | 9 | 7 | 8 | 309 | 39 | |||
114285 | 247188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000957.54767 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | 15 | 5 | 11 | 29492 | 9 | |||
118823 | 9537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.7799603572012 | -122.429417251502 | (37.7799603572012, -122.429417251502) | 7 | 9 | 11 | 29490 | 41 | ||
119182 | 114771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
126736 | 123738 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Cabrillo St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5994608.02307 | 2110726.73042 | 37.7753431953613 | -122.462148037658 | (37.7753431953613, -122.462148037658) | 11 | 6 | 2 | 54 | 11 | |||
127594 | 98700 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2490X Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000865 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | 13 | 6 | 1 | 29490 | 27 | ||||
131936 | 34513 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
139502 | 138402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751 | (37.7871695157566, -122.43676243751) | 13 | 6 | 11 | 29490 | 27 | |||
139942 | 197547 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6011743.05813 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | 8 | 2 | 8 | 28853 | 20 | |||
143516 | 239710 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1132 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997732.52597 | 2106583.54789 | 37.7641464813941 | -122.451040872449 | (37.7641464813941, -122.451040872449) | 15 | 5 | 11 | 29492 | 9 | |||
144657 | 136389 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5998748.07929 | 2115242.80983 | 37.7879806758048 | -122.448151933487 | (37.7879806758048, -122.448151933487) | 13 | 6 | 1 | 54 | 31 | |||
145189 | 136407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6009007.21718 | 2119024.81228 | 37.7989462606223 | -122.412924532036 | (37.7989462606223, -122.412924532036) | 3 | 1 | 10 | 308 | 21 | |||
146428 | 102835 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
151617 | 30952 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
155354 | 101871 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.7828222383966 | -122.399991655868 | (37.7828222383966, -122.399991655868) | 6 | 2 | 9 | 28856 | 34 | |||
156764 | 40149 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
167893 | 179468 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001647.16213 | 2090105.12517 | 37.7191239348993 | -122.436321896962 | (37.7191239348993, -122.436321896962) | 9 | 7 | 6 | 28861 | 5 | |||
174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
178619 | 197564 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011853.28866 | 2107502.07899 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | 8 | 2 | 8 | 28853 | 20 | |||
179663 | 239731 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1709 Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6002630.21924 | 2100589.83491 | 37.7479683603545 | -122.433672786481 | (37.7479683603545, -122.433672786481) | 2 | 4 | 5 | 63 | 22 | |||
181408 | 197520 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Lafayette St | 5 | : | Tree | Private 2 | 22 | Width 3ft | 6007717.24028 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | 8 | 2 | 9 | 28853 | 19 | |||
181624 | 103006 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41X Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
190938 | 136420 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013531.80462 | 2118197.00986 | 37.7969262483997 | -122.397209771417 | (37.7969262483997, -122.397209771417) | 3 | 1 | 10 | 28860 | 6 |
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) );