trees
32 rows where Fire Prevention Districts = 7 and qSpecies_id = 95 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11806 | 233511 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782005 | 6004633.78606 | 2109456.48744 | 37.7724275683009 | -122.427376074351 | (37.7724275683009, -122.427376074351) | 7 | 9 | 11 | 28852 | 10 | |
15794 | 63736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 585 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24405 | 6003780.00958588 | 2109683.67127267 | 37.7730030357559 | -122.430345580362 | (37.7730030357559, -122.430345580362) | 7 | 9 | 11 | 29492 | 10 | ||
27505 | 233596 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 44 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006549.90248 | 2110330.35444 | 37.7749351803449 | -122.420810081832 | (37.7749351803449, -122.420810081832) | 7 | 9 | 11 | 28852 | 10 | |||
40120 | 66387 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 576 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29513 | 6003809.30522061 | 2109740.24975223 | 37.7731600457631 | -122.430248280428 | (37.7731600457631, -122.430248280428) | 7 | 9 | 11 | 29492 | 10 | ||
47550 | 63734 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 547 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24403 | 6003953.21225561 | 2109707.77705475 | 37.7730790336555 | -122.429748170749 | (37.7730790336555, -122.429748170749) | 7 | 9 | 11 | 29492 | 10 | ||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
49431 | 67556 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1995 12:00:00 AM | Permit Number 31105 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | ||
50956 | 63760 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 540 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24437 | 6003973.39193973 | 2109763.08680608 | 37.7732320433706 | -122.429682312236 | (37.7732320433706, -122.429682312236) | 7 | 9 | 11 | 29492 | 10 | ||
53952 | 233597 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 197 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006526.51025 | 2110764.29313 | 37.776125353047 | -122.420921816282 | (37.776125353047, -122.420921816282) | 7 | 9 | 11 | 28852 | 10 | |||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
77554 | 115072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 65 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006230 | 2110204 | 37.7745702053319 | -122.421907716929 | (37.7745702053319, -122.421907716929) | 7 | 9 | 11 | 28852 | 10 | ||||
77613 | 66110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29164 | 6005954.05152204 | 2110038.74835026 | 37.7741008978737 | -122.422850531283 | (37.7741008978737, -122.422850531283) | 7 | 9 | 11 | 28852 | 10 | ||
83304 | 63735 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 550 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24404 | 6003927.8122889 | 2109756.74317909 | 37.7732120443049 | -122.429839525756 | (37.7732120443049, -122.429839525756) | 7 | 9 | 11 | 29492 | 10 | ||
99802 | 62274 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 127 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22410 | 6004223.66496449 | 2109215.34758778 | 37.771742253448 | -122.428777529151 | (37.771742253448, -122.428777529151) | 7 | 9 | 11 | 29492 | 10 | ||
100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
104327 | 57698 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 112 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22413 | 6003845.29045586 | 2108813.17790583 | 37.770616571258 | -122.430057656537 | (37.770616571258, -122.430057656537) | 7 | 9 | 11 | 29492 | 10 | ||
113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
118036 | 7723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 175X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006514.1274 | 2110757.9768 | 37.7761073119325 | -122.420964203399 | (37.7761073119325, -122.420964203399) | 7 | 9 | 11 | 28852 | 10 | |||
121551 | 30727 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
121967 | 233509 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 599 Buchanan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6004544.20196 | 2110431.59381 | 37.7750999055671 | -122.427755444356 | (37.7750999055671, -122.427755444356) | 7 | 9 | 11 | 28852 | 10 | |||
126757 | 233595 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006199.44 | 2110210.42189 | 37.7745861147813 | -122.422013886425 | (37.7745861147813, -122.422013886425) | 7 | 9 | 11 | 28852 | 10 | |||
127438 | 6957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 627 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004338.3385 | 2110455.1046 | 37.7751528130593 | -122.428469247762 | (37.7751528130593, -122.428469247762) | 7 | 9 | 11 | 28852 | 10 | |||
128687 | 62278 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22416 | 6004275.31529715 | 2109405.62927883 | 37.7722676437754 | -122.428612433422 | (37.7722676437754, -122.428612433422) | 7 | 9 | 11 | 28852 | 10 | ||
130596 | 63731 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 510 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24400 | 6004110.13087942 | 2109782.11768526 | 37.7732920393038 | -122.429210671215 | (37.7732920393038, -122.429210671215) | 7 | 9 | 11 | 29492 | 10 | ||
147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
149176 | 63737 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 573 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24406 | 6003834.70515324 | 2109691.28362316 | 37.7730270354143 | -122.43015692487 | (37.7730270354143, -122.43015692487) | 7 | 9 | 11 | 29492 | 10 | ||
158702 | 16839 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1999 12:00:00 AM | 75 | 3X3 | 6006555.51402 | 2110416.39536 | 37.7751717443167 | -122.420796779971 | (37.7751717443167, -122.420796779971) | 7 | 9 | 11 | 28852 | 10 | ||
166941 | 66373 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 430 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29497 | 6003708.35294884 | 2109810.61822809 | 37.7733475417865 | -122.430602509574 | (37.7733475417865, -122.430602509574) | 7 | 9 | 11 | 29492 | 10 | ||
174388 | 63732 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 529 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24401 | 6004035.25561517 | 2109719.19558167 | 37.7731150315991 | -122.429465186856 | (37.7731150315991, -122.429465186856) | 7 | 9 | 11 | 29492 | 10 | ||
174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 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) );