trees
43 rows where Supervisor Districts = 9 and qSpecies_id = 123 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7907 | 91707 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
15597 | 91581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
22375 | 87991 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 222 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51029 | 6008096 | 2113166 | 37.7828082078679 | -122.41566260373 | (37.7828082078679, -122.41566260373) | 7 | 10 | 9 | 28852 | 36 | ||
24904 | 91704 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
31101 | 88015 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
46855 | 91705 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
49759 | 88162 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 365 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190845 | (37.7810391100489, -122.40303190845) | 6 | 2 | 9 | 28853 | 34 | |||
55308 | 88011 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51041 | 6008609 | 2112967 | 37.7822906254359 | -122.413873752004 | (37.7822906254359, -122.413873752004) | 7 | 10 | 9 | 28852 | 36 | ||
58857 | 197005 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015945.83282 | 2113971.21012 | 37.7854572671771 | -122.388561464349 | (37.7854572671771, -122.388561464349) | 6 | 2 | 9 | 28856 | 6 | |||
61643 | 88017 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 601 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51044 | 6008420 | 2114150 | 37.7855282422492 | -122.414611351671 | (37.7855282422492, -122.414611351671) | 7 | 10 | 9 | 28852 | 36 | ||
65987 | 87988 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
66669 | 88027 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 121 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51050 | 6008492.3 | 2112899.8 | 37.7820995557553 | -122.414272727386 | (37.7820995557553, -122.414272727386) | 7 | 10 | 9 | 28852 | 36 | ||
74482 | 91579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.782992 | 37.7706855226421 | -122.418025303656 | (37.7706855226421, -122.418025303656) | 8 | 2 | 9 | 28853 | 19 | |||
74677 | 197008 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015819.96471 | 2114109.17282 | 37.7858291053701 | -122.389006570307 | (37.7858291053701, -122.389006570307) | 6 | 2 | 9 | 28856 | 6 | |||
87499 | 197007 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015822.85417 | 2114091.9182 | 37.7857818882589 | -122.388995368366 | (37.7857818882589, -122.388995368366) | 6 | 2 | 9 | 28856 | 6 | |||
87658 | 87989 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
88344 | 87993 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 248 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | 7 | 10 | 9 | 28852 | 36 | ||
88350 | 91701 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648 | (37.7722235898389, -122.41825140648) | 8 | 2 | 9 | 28853 | 19 | |||
92525 | 88014 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
95941 | 91580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
99310 | 87994 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 248 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | 7 | 10 | 9 | 28852 | 36 | ||
106489 | 91706 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
110478 | 88010 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 301 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51039 | 6008988 | 2113534 | 37.7838687491965 | -122.412602670053 | (37.7838687491965, -122.412602670053) | 7 | 10 | 9 | 28852 | 36 | ||
119219 | 88203 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 436 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51208 | 6011221 | 2112104 | 37.7800673738175 | -122.40477656867 | (37.7800673738175, -122.40477656867) | 14 | 2 | 9 | 28853 | 34 | ||
119445 | 87990 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
120740 | 88157 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
132824 | 88009 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51038 | 6008030 | 2113635 | 37.7840922583142 | -122.415924158968 | (37.7840922583142, -122.415924158968) | 7 | 10 | 9 | 28858 | 36 | ||
134217 | 91699 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
135225 | 197004 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6015943.64363 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | 6 | 2 | 9 | 28856 | 6 | |||
143430 | 91578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:03:00 PM | 4 | 3x3 | 6007300.496664 | 2108846.846012 | 37.7709040967706 | -122.418108415168 | (37.7709040967706, -122.418108415168) | 8 | 2 | 9 | 28853 | 19 | ||
144571 | 91703 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
146243 | 88019 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 926 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51046 | 6007429 | 2114473 | 37.7863593952456 | -122.418062835651 | (37.7863593952456, -122.418062835651) | 13 | 9 | 9 | 28858 | 36 | ||
149145 | 197006 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6015876.10983 | 2114035.38454 | 37.7856296114719 | -122.388807169036 | (37.7856296114719, -122.388807169036) | 6 | 2 | 9 | 28856 | 6 | |||
149728 | 91698 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
150797 | 88158 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
155593 | 87995 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 120 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51032 | 6009094.1 | 2112956.3 | 37.7822884772374 | -122.412194758861 | (37.7822884772374, -122.412194758861) | 14 | 10 | 9 | 28852 | 36 | ||
161656 | 88185 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 493 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51192 | 6010910.3 | 2111721.3 | 37.7789991980081 | -122.405824460674 | (37.7789991980081, -122.405824460674) | 14 | 2 | 9 | 28853 | 34 | |||
174823 | 88016 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
176344 | 88191 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 355 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51196 | 6011553 | 2112651 | 37.7815878594503 | -122.403666522452 | (37.7815878594503, -122.403666522452) | 6 | 2 | 9 | 28853 | 34 | |||
176816 | 91702 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
184093 | 197003 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6015964.6605 | 2113962.87673 | 37.7854354289412 | -122.38849574371 | (37.7854354289412, -122.38849574371) | 6 | 2 | 9 | 28856 | 6 | |||
185524 | 91700 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 |
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) );