trees
47 rows where qSpecies_id = 346
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11931 | 202097 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2650 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012483.7562 | 2092985.14235 | 37.7276416523229 | -122.399065747292 | (37.7276416523229, -122.399065747292) | 10 | 3 | 8 | 58 | 1 | |||
14845 | 202098 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2650 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012472.96174 | 2092946.2226 | 37.7275341851331 | -122.399100333411 | (37.7275341851331, -122.399100333411) | 10 | 3 | 8 | 58 | 1 | |||
17339 | 166211 | Planning Code 138.1 required 2 | Cercis canadensis :: Eastern Redbud 346 | 3140 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6008730.35876 | 2101584.0935 | 37.7510426163255 | -122.412648961786 | (37.7510426163255, -122.412648961786) | 2 | 4 | 7 | 28859 | 19 | |||
20693 | 189967 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 700 Rhode Island St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011788.75839 | 2105053.1014 | 37.7607389258834 | -122.402316528482 | (37.7607389258834, -122.402316528482) | 10 | 3 | 8 | 28856 | 29 | |||
22281 | 225105 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 588 Ogden Ave | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6007741.08263 | 2096149.39256 | 37.7360645641242 | -122.415685225898 | (37.7360645641242, -122.415685225898) | 2 | 7 | 7 | 28859 | 2 | |||
25965 | 225108 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 3100 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008737.01671 | 2101541.61705 | 37.7509263591809 | -122.412622935426 | (37.7509263591809, -122.412622935426) | 2 | 4 | 7 | 28859 | 19 | |||
33813 | 189966 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 900x Carolina St | 73 | Median : Yard | Tree | DPW 1 | 1 | 6012515.82864 | 2102790.51721 | 37.7545669254428 | -122.399643037392 | (37.7545669254428, -122.399643037392) | 10 | 3 | 8 | 28856 | 29 | ||||
34863 | 46888 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1625 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | 2 | Permit Number 44944 | 6008341.9988 | 2118053.01531 | 37.7962405845984 | -122.415157589166 | (37.7962405845984, -122.415157589166) | 5 | 1 | 10 | 28858 | 21 | |
35769 | 97545 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 2001 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
37153 | 97544 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 2001 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
37375 | 225121 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2423 Market St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 6002148.73038 | 2105776.59081 | 37.7621826165465 | -122.435708783236 | (37.7621826165465, -122.435708783236) | 15 | 4 | 5 | 28862 | 3 | |||
47918 | 189971 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1740 Bancroft Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6013744.47243 | 2092648.01041 | 37.72678613085 | -122.39468380422 | (37.72678613085, -122.39468380422) | 10 | 3 | 8 | 58 | 1 | |||
57409 | 256506 | Planning Code 138.1 required 2 | Cercis canadensis :: Eastern Redbud 346 | 978 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2018 12:00:00 AM | 3 | 3x3 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | ||
58957 | 225113 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 126 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005705.88547 | 2096373.33008 | 37.7365648299905 | -122.422737643746 | (37.7365648299905, -122.422737643746) | 2 | 7 | 7 | 28859 | 2 | |||
68549 | 32390 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 141 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/2006 12:00:00 AM | 2 | Permit Number 48963 | 6005463.84551 | 2096189.8666 | 37.7360474212554 | -122.423561440719 | (37.7360474212554, -122.423561440719) | 2 | 7 | 7 | 28859 | 2 | |
71733 | 225111 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 3100 25th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008868.90674 | 2101550.06308 | 37.7509569513993 | -122.412167442281 | (37.7509569513993, -122.412167442281) | 2 | 4 | 7 | 28859 | 19 | |||
73704 | 225110 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 3100 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008787.94991 | 2101545.38709 | 37.7509395693085 | -122.412447069374 | (37.7509395693085, -122.412447069374) | 2 | 4 | 7 | 28859 | 19 | |||
77664 | 122320 | Undocumented 4 | Cercis canadensis :: Eastern Redbud 346 | 501x Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009016 | 2105739 | 37.7624670771257 | -122.411954765605 | (37.7624670771257, -122.411954765605) | 8 | 4 | 7 | 28859 | 19 | ||||
79930 | 189969 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1780 Bancroft Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6013444.67207 | 2092873.3532 | 37.7273882035995 | -122.395735995744 | (37.7273882035995, -122.395735995744) | 10 | 3 | 8 | 58 | 1 | |||
80285 | 225122 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 704 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002310.72702 | 2108836.43193 | 37.7705933910996 | -122.435367386213 | (37.7705933910996, -122.435367386213) | 15 | 5 | 11 | 29492 | 9 | |||
84566 | 225104 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 588 Ogden Ave | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6007748.01333 | 2096149.69578 | 37.7360657862995 | -122.415661285061 | (37.7360657862995, -122.415661285061) | 2 | 7 | 7 | 28859 | 2 | |||
89756 | 225119 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2423 Market St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 6002125.89977 | 2105776.44015 | 37.7621809060385 | -122.435787734729 | (37.7621809060385, -122.435787734729) | 15 | 4 | 5 | 28862 | 3 | |||
94968 | 189968 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 700 Rhode Island St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011790.28559 | 2105051.18608 | 37.760733752091 | -122.40231111188 | (37.760733752091, -122.40231111188) | 10 | 3 | 8 | 28856 | 29 | |||
95817 | 225114 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 751 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001916.96401 | 2101815.40269 | 37.7512929812995 | -122.436226882681 | (37.7512929812995, -122.436226882681) | 2 | 4 | 5 | 28862 | 22 | |||
98335 | 225103 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 588 Ogden Ave | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007752.02338 | 2096149.16857 | 37.7360645641134 | -122.41564738334 | (37.7360645641134, -122.41564738334) | 2 | 7 | 7 | 28859 | 2 | |||
114495 | 225102 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 335 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008832.4263 | 2097264.88962 | 37.7391887648519 | -122.411990801947 | (37.7391887648519, -122.411990801947) | 10 | 7 | 7 | 28859 | 2 | |||
117261 | 225115 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 521 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6003112.45738 | 2100062.25503 | 37.7465471005779 | -122.431967561278 | (37.7465471005779, -122.431967561278) | 2 | 7 | 5 | 63 | 22 | ||||
118955 | 206022 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 694 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5996946.94672 | 2094427.17204 | 37.7307230695983 | -122.452880447369 | (37.7307230695983, -122.452880447369) | 9 | 7 | 4 | 59 | 40 | |||
120519 | 225120 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2423 Market St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6002140.56146 | 2105789.83814 | 37.762218526485 | -122.435737984214 | (37.762218526485, -122.435737984214) | 15 | 4 | 5 | 28862 | 3 | |||
134734 | 225107 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1455 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009326.96574 | 2100755.53408 | 37.7488010426517 | -122.410527324376 | (37.7488010426517, -122.410527324376) | 2 | 4 | 7 | 28859 | 19 | |||
145013 | 189972 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1780 Bancroft Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6013451.12416 | 2092868.56407 | 37.7273754125406 | -122.395713355287 | (37.7273754125406, -122.395713355287) | 10 | 3 | 8 | 58 | 1 | |||
146612 | 225112 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 3100 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008903.79057 | 2101552.38874 | 37.7509652944327 | -122.412046974505 | (37.7509652944327, -122.412046974505) | 2 | 4 | 7 | 28859 | 19 | |||
151629 | 37122 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 4200 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 1 | Permit Number 39711 | 5981765.1911 | 2104906.5938 | 37.7586149633215 | -122.506141961535 | (37.7586149633215, -122.506141961535) | 1 | 8 | 3 | 56 | 35 | |
152533 | 32331 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 184 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52576 | 6008091.63747 | 2097762.09968 | 37.7405124041122 | -122.414587299367 | (37.7405124041122, -122.414587299367) | 2 | 7 | 7 | 28859 | 2 | |
153286 | 225116 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1519 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003339.76023 | 2099386.57347 | 37.7447047197513 | -122.431133353743 | (37.7447047197513, -122.431133353743) | 2 | 7 | 5 | 63 | 22 | |||
155935 | 122321 | Undocumented 4 | Cercis canadensis :: Eastern Redbud 346 | 501x Alabama St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6009016 | 2105739 | 37.7624670771257 | -122.411954765605 | (37.7624670771257, -122.411954765605) | 8 | 4 | 7 | 28859 | 19 | ||||
158463 | 189970 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1700 Bancroft Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6013811.69516 | 2092601.47687 | 37.7266620963616 | -122.39444815847 | (37.7266620963616, -122.39444815847) | 10 | 3 | 8 | 58 | 1 | |||
168337 | 106201 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 524 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2014 12:00:00 AM | 1 | Permit Number 770224 | 6003241.916 | 2090399.98112 | 37.7200240285581 | -122.430830478245 | (37.7200240285581, -122.430830478245) | 9 | 7 | 6 | 28861 | 5 | ||
172471 | 225118 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 50 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006870.31696 | 2099444.82405 | 37.7450640969282 | -122.418929477138 | (37.7450640969282, -122.418929477138) | 2 | 7 | 7 | 28859 | 2 | |||
175072 | 225109 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 3100 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008753.33037 | 2101543.56255 | 37.7509326166621 | -122.41256665854 | (37.7509326166621, -122.41256665854) | 2 | 4 | 7 | 28859 | 19 | |||
179193 | 97543 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 2001 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
182128 | 225106 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 1051 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007645.25447 | 2103554.03482 | 37.7563906660135 | -122.416540901147 | (37.7563906660135, -122.416540901147) | 2 | 4 | 7 | 28859 | 19 | |||
182270 | 107121 | Significant Tree 6 | Cercis canadensis :: Eastern Redbud 346 | 1054 GUERRERO ST | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6005686.8 | 2102852.5 | 37.7543540785936 | -122.423264063467 | (37.7543540785936, -122.423264063467) | 2 | 4 | 5 | 28859 | 19 | ||||
182291 | 225117 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 50 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006856.83382 | 2099417.47215 | 37.7449882355335 | -122.418974159937 | (37.7449882355335, -122.418974159937) | 2 | 7 | 7 | 28859 | 2 | |||
186429 | 91166 | - 12 | Cercis canadensis :: Eastern Redbud 346 | 1548x Quesada Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/31/2009 12:00:00 AM | 3 | 6015526.48125 | 2094420.051093 | 37.7317507154659 | -122.388647039673 | (37.7317507154659, -122.388647039673) | 10 | 3 | 8 | 58 | 1 | |||
187811 | 35410 | Permitted Site 7 | Cercis canadensis :: Eastern Redbud 346 | 1519 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774062 | 6003338.81887618 | 2099398.17538671 | 37.7447365225765 | -122.431137436699 | (37.7447365225765, -122.431137436699) | 2 | 7 | 5 | 63 | 22 | |
189635 | 202099 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2650 Newhall St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6012460.47635 | 2092906.1512 | 37.7274234615036 | -122.399140684214 | (37.7274234615036, -122.399140684214) | 10 | 3 | 8 | 58 | 1 |
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) );