trees
32 rows where Police Districts = 9 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 31200 | 53044 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2006 12:00:00 AM | 11 | 3x3 | Permit Number 49022 | 6000981.43692 | 2118569.50402 | 37.797242328631 | -122.440663646636 | (37.797242328631, -122.440663646636) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||
| 43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
| 46065 | 136368 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000986.41607 | 2118529.18744 | 37.797131913463 | -122.440643524276 | (37.797131913463, -122.440643524276) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 52524 | 136373 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999883.33678 | 2117451.31751 | 37.7941094908262 | -122.444382936819 | (37.7941094908262, -122.444382936819) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 61318 | 136374 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999876.11536 | 2117451.30478 | 37.7941090438496 | -122.444407922699 | (37.7941090438496, -122.444407922699) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
| 148920 | 69361 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33455 | 6002672.47282 | 2120707.16348 | 37.8032079355658 | -122.4349652022 | (37.8032079355658, -122.4349652022) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 187275 | 136365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2624 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000330.31034 | 2118901.65056 | 37.7981172142989 | -122.442940566381 | (37.7981172142989, -122.442940566381) | 13 | 9 | 1 | 57 | 17 | |||
| 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 |
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) );