45 rows where Police Districts = 3 and qSpecies_id = 47

View and edit SQL

Police Districts

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)
2126 191407 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 7 Front Yard : Yard Tree Private 2     12     6016225.71134 2100306.15132 37.747951477381 -122.386639933312 (37.747951477381, -122.386639933312)   3 8 58 1
6812 191370 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 63 Median : Yard Tree DPW 1     15     6012517.15762 2102887.31193 37.7548327767283 -122.399645237162 (37.7548327767283, -122.399645237162) 10 3 8 28856 29
15284 191371 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 66 Median : Yard Tree DPW 1     13     6012518.79145 2102845.53786 37.7547181653131 -122.399636654017 (37.7547181653131, -122.399636654017) 10 3 8 28856 29
24972 191392 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 3 Sidewalk: Curb side : Yard Tree Private 2     13     6011311.05886 2104374.20224 37.7588481426559 -122.403920910926 (37.7588481426559, -122.403920910926) 10 3 8 28856 29
27885 200618 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 59 Median : Cutout Tree DPW 1     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.385517359434 (37.733637339432, -122.385517359434) 10 3 8 58 1
28693 191372 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2220 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011446.77315 2104664.66226 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161) 10 3 8 28856 29
31750 200604 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 61 Median : Cutout Tree DPW 1     8 Width 0ft   6016455.981 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084) 10 3 8 58 1
36662 121603 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 749 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6012453.25739 2104452.2107 37.7591260835233 -122.399976111225 (37.7591260835233, -122.399976111225) 10 3 8 28856 29
37104 191369 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 62 Median : Yard Tree DPW 1     15     6012514.91638 2102899.16549 37.7548651990855 -122.399653820263 (37.7548651990855, -122.399653820263) 10 3 8 28856 29
44818 191405 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 9 Front Yard : Yard Tree Private 2     8     6016216.75475 2100305.37684 37.7479488549636 -122.386670851103 (37.7479488549636, -122.386670851103)   3 8 58 1
45957 191393 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 4 Sidewalk: Curb side : Yard Tree Private 2     26     6011318.33835 2104379.19174 37.758862249405 -122.403896086039 (37.758862249405, -122.403896086039) 10 3 8 28856 29
46709 191390 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     26     6011298.55233 2104376.91383 37.7588548893488 -122.403964355369 (37.7588548893488, -122.403964355369) 10 3 8 28856 29
54525 191388 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 40 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6011282.56063 2104153.62595 37.7582408970175 -122.40400394893 (37.7582408970175, -122.40400394893) 10 3 8 28856 29
55583 191391 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6011306.2123 2104378.54497 37.7588597960547 -122.403937978273 (37.7588597960547, -122.403937978273) 10 3 8 28856 29
59598 191367 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 548 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6011194.69766 2105791.52689 37.7627332975312 -122.404423107658 (37.7627332975312, -122.404423107658) 8 3 8 28856 29
63156 191394 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 845 Vermont St 5 Sidewalk: Curb side : Yard Tree Private 2     15     6011327.58138 2104381.4608 37.7588689961229 -122.403864278838 (37.7588689961229, -122.403864278838) 10 3 8 28856 29
66800 49718 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1195 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2003 12:00:00 AM     Permit Number 46529 6014698.72785663 2090465.4227663 37.7208461876659 -122.391232442758 (37.7208461876659, -122.391232442758) 10 3 8 58 1
69496 191376 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 19 Sidewalk: Curb side : Yard Tree Private 2     7     6011285.44743 2104312.53247 37.7586773802801 -122.404005147727 (37.7586773802801, -122.404005147727) 10 3 8 28856 29
76430 30765 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1593 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34646 6014616.43299999 2093667.83534348 37.7296348056211 -122.391740711397 (37.7296348056211, -122.391740711397) 10 3 8 58 1
77789 201278 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 28 Lydia Ave 1 : Tree Private 2     6 Width 2ft   6012862.05555 2092837.94578 37.7272585546286 -122.397747632568 (37.7272585546286, -122.397747632568) 10 3 8 58 1
79037 200614 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 55 Median : Cutout Tree DPW 1     6 Width 0ft   6016432.4764 2095111.6325 37.7336998293082 -122.385562980445 (37.7336998293082, -122.385562980445) 10 3 8 58 1
95937 191368 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900x Carolina St 60 Median : Yard Tree DPW 1     25     6012502.16132 2102909.31056 37.7548923442165 -122.399698643387 (37.7548923442165, -122.399698643387) 10 3 8 28856 29
95984 191373 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 13 Sidewalk: Curb side : Yard Tree Private 2     10     6011285.49599 2104337.84522 37.7587468861739 -122.40400676112 (37.7587468861739, -122.40400676112) 10 3 8 28856 29
98199 191377 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 27 Sidewalk: Curb side : Yard Tree Private 2     16     6011285.82751 2104250.98235 37.7585083985743 -122.403999501776 (37.7585083985743, -122.403999501776) 10 3 8 28856 29
99467 191408 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 5 Front Yard : Yard Tree Private 2     3     6016232.34971 2100308.61772 37.7479586171136 -122.38661714986 (37.7479586171136, -122.38661714986)   3 8 58 1
102287 200612 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 53 Median : Cutout Tree DPW 1     4 Width 0ft   6016428.559 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213) 10 3 8 58 1
105958 191384 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 35 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143) 10 3 8 28856 29
108342 35388 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 753 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 7   Permit Number 38842 6011306.15832 2104840.46729 37.7601281288176 -122.403970671318 (37.7601281288176, -122.403970671318) 10 3 8 28856 29
112785 191378 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 28 Sidewalk: Curb side : Yard Tree Private 2     6     6011285.84337 2104240.29901 37.7584790653842 -122.40399869511 (37.7584790653842, -122.40399869511) 10 3 8 28856 29
113543 191379 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 29 Sidewalk: Curb side : Yard Tree Private 2     5     6011295.70989 2104243.81406 37.758489268176 -122.403964819445 (37.758489268176, -122.403964819445) 10 3 8 28856 29
113599 200616 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 57 Median : Cutout Tree DPW 1     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914) 10 3 8 58 1
122548 191380 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 30 Sidewalk: Curb side : Yard Tree Private 2     13     6011289.9844 2104226.04846 37.7584401679041 -122.403983370659 (37.7584401679041, -122.403983370659) 10 3 8 28856 29
123019 191383 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 34 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317) 10 3 8 28856 29
125224 200619 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 60 Median : Cutout Tree DPW 1     8 Width 0ft   6016453.0429 2095085.1899 37.7336283611401 -122.385490033201 (37.7336283611401, -122.385490033201) 10 3 8 58 1
133496 191385 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 37 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6011271.65755 2104161.44484 37.7582617567794 -122.404042206986 (37.7582617567794, -122.404042206986) 10 3 8 28856 29
135665 191404 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 14 Front Yard : Yard Tree Private 2     20     6016173.59275 2100299.3088 37.7479298037296 -122.3868196817 (37.7479298037296, -122.3868196817)   3 8 58 1
148288 30756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1547 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 1   Permit Number 34637 6015015.9888 2093715.5638 37.7297880302088 -122.390362726863 (37.7297880302088, -122.390362726863) 10 3 8 58 1
163899 191389 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 43 Sidewalk: Curb side : Yard Tree Private 2     8 Width 9ft   6011309.9548 2104119.65272 37.7581491445771 -122.403906816767 (37.7581491445771, -122.403906816767) 10 3 8 28856 29
165316 191374 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 15 Sidewalk: Curb side : Yard Tree Private 2     10     6011292.66605 2104334.91271 37.7587392347502 -122.403981757255 (37.7587392347502, -122.403981757255) 10 3 8 28856 29
167360 191381 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 32 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6011271.17001 2104191.36243 37.7583438765916 -122.404045998546 (37.7583438765916, -122.404045998546) 10 3 8 28856 29
173115 191406 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Tulare St 8 Front Yard : Yard Tree Private 2     5     6016222.17813 2100305.95006 37.7479507291578 -122.386652137081 (37.7479507291578, -122.386652137081)   3 8 58 1
179733 191387 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 39 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6011279.1597 2104155.21456 37.7582450689735 -122.404015822688 (37.7582450689735, -122.404015822688) 10 3 8 28856 29
181108 191382 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 33 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6011269.01089 2104184.59965 37.7583251868659 -122.404052989848 (37.7583251868659, -122.404052989848) 10 3 8 28856 29
182337 191386 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 38 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6011275.59142 2104157.94605 37.7582523696726 -122.404028355649 (37.7582523696726, -122.404028355649) 10 3 8 28856 29
192536 191375 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 800 Vermont St 16 Sidewalk: Curb side : Yard Tree Private 2     24     6011300.32576 2104333.131 37.7587347705187 -122.403955140934 (37.7587347705187, -122.403955140934) 10 3 8 28856 29

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);